{"id":8829,"date":"2023-08-18T11:44:16","date_gmt":"2023-08-18T03:44:16","guid":{"rendered":"\/?p=8829"},"modified":"2023-08-18T11:44:16","modified_gmt":"2023-08-18T03:44:16","slug":"peewee%e5%bf%ab%e9%80%9f%e5%ba%94%e7%94%a8","status":"publish","type":"post","link":"\/?p=8829","title":{"rendered":"peewee\u5feb\u901f\u5e94\u7528"},"content":{"rendered":"<h3>model<\/h3>\n<p><code>model.py<\/code>\u6587\u4ef6<\/p>\n<pre><code class=\"language-python\">from config.config import PG_CONN\nfrom peewee import *\nfrom datetime import datetime\nfrom peewee import SqliteDatabase\ndatabase = PostgresqlDatabase(&#039;lxc&#039;, **PG_CONN)\n# database = SqliteDatabase(&#039;db.db&#039;)\n&quot;&quot;&quot;\n# \u6570\u636e\u5e93\u914d\u7f6e\u4fe1\u606f\nPG_CONN = {\n    &#039;user&#039;: &#039;rhino&#039;,\n    &#039;password&#039;: &#039;pg$#aHTF&#039;,\n    &#039;host&#039;: &#039;192.168.0.14&#039;,\n    &#039;port&#039;: &quot;35432&quot;\n}\n&quot;&quot;&quot;\nclass UnknownField(object):\n    def __init__(self, *_, **__): pass\n\nclass BaseModel(Model):\n    class Meta:\n        database = database\n\nclass FabaoLawsFile(BaseModel):\n    query_string = TextField(null=True, verbose_name=&quot;\u67e5\u8be2\u5173\u952e\u8bcd&quot;)\n    result_name = TextField(null=True, verbose_name=&#039;\u7ed3\u679c\u540d\u79f0&#039;)\n    file_path = TextField(null=True, verbose_name=&#039;\u6587\u4ef6\u8def\u5f84&#039;)\n    created_time = DateTimeField(default=datetime.now, verbose_name=&quot;\u6dfb\u52a0\u65f6\u95f4&quot;)\n    update_time = DateTimeField(verbose_name=&quot;\u66f4\u65b0\u65f6\u95f4&quot;, default=datetime.now)\n\n    class Meta:\n        table_name = &#039;public.fabao_laws_file&#039;<\/code><\/pre>\n<h3>\u8c03\u7528<\/h3>\n<p><strong>\u8868\u5c42\u9762<\/strong><\/p>\n<pre><code class=\"language-python\"># \u5bfc\u5165\u8868\u6a21\u578b\nfrom utils.models import TbMeetingSummary\n# \u5220\u9664\u8868\nTbMeetingSummary.drop_table()\n# \u521b\u5efa\u8868\nTbMeetingSummary.create_table()\n# \u63d2\u5165\u6570\u636e\nTbMeetingSummary.create(major_audit_items=level1_mulu,\n                                            audit_item=level2_mulu,\n                                            audit_issues=level3_mulu,\n                                            dxyj=dxyj,\n                                            cfyj=cfyj,\n                                            xgyj=xgyj)<\/code><\/pre>\n<p>\u5176\u4ed6\u589e\u5220\u6539\u67e5\u64cd\u4f5c\u518d\u641c\u5427<\/p>\n<p><img src=\"\/wp-content\/uploads\/2023\/05\/313D0246-815D-491A-90E7-D6D36E559E11-300x300.jpeg\" alt=\"\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>model model.py\u6587\u4ef6 from config.config import PG_CONN from peewee impor   \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":[186],"tags":[135],"_links":{"self":[{"href":"\/index.php?rest_route=\/wp\/v2\/posts\/8829"}],"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=8829"}],"version-history":[{"count":1,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/8829\/revisions"}],"predecessor-version":[{"id":8830,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/8829\/revisions\/8830"}],"wp:attachment":[{"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8829"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8829"},{"taxonomy":"post_tag","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}