{"id":1162,"date":"2022-07-06T14:37:10","date_gmt":"2022-07-06T06:37:10","guid":{"rendered":"http:\/\/175.24.184.226\/?p=1162"},"modified":"2022-07-06T14:37:10","modified_gmt":"2022-07-06T06:37:10","slug":"python-%e6%95%b0%e6%8d%ae%e5%ba%93%e8%bf%94%e5%9b%9e%e5%ad%97%e5%85%b8%e6%a0%bc%e5%bc%8f%e6%95%b0%e6%8d%ae","status":"publish","type":"post","link":"\/?p=1162","title":{"rendered":"python \u6570\u636e\u5e93\u8fd4\u56de\u5b57\u5178\u683c\u5f0f\u6570\u636e"},"content":{"rendered":"<p><code>mysql:<\/code><\/p>\n<pre><code class=\"language-python\">for _ in range(10):\n    try:\n\n        conn = pymysql.connect(**self.base_info)\n        # \u8fd4\u56de\u5b57\u5178\u683c\u5f0f\u7684\u6570\u636e\n        cursor = conn.cursor(pymysql.cursors.DictCursor)\n        return conn, cursor\n    except Exception as err:\n        logger.exception(&quot;\u6570\u636e\u5e93\u8fde\u63a5\u5931\u8d25,  %s&quot; % err)\n    return None, None<\/code><\/pre>\n<p><code>pgsql:<\/code><\/p>\n<pre><code class=\"language-python\">def connectPostgreSQL(self):\n    &quot;&quot;&quot;\n    PG\u5e93\u8fde\u63a5\n    &quot;&quot;&quot;\n    for _ in range(10):\n        try:\n            conn = psycopg2.connect(**PG_SQL_LOCAL)\n            cursor = conn.cursor(cursor_factory=psycopg2.extras.RealDictCursor)\n            return conn, cursor\n        except Exception as err:\n            logger.exception(&quot;\u6570\u636e\u5e93\u8fde\u63a5\u5931\u8d25,  %s&quot; % err)\n    return None, None<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>mysql: for _ in range(10): try: conn = pymysql.connect(**self.base_i   \u2026 &#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0},"categories":[33],"tags":[],"_links":{"self":[{"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1162"}],"collection":[{"href":"\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1162"}],"version-history":[{"count":1,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1162\/revisions"}],"predecessor-version":[{"id":1164,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1162\/revisions\/1164"}],"wp:attachment":[{"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1162"},{"taxonomy":"post_tag","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}