{"id":42226,"date":"2022-07-10T08:11:57","date_gmt":"2023-01-25T12:17:37","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-python3-%e8%bf%9b%e8%a1%8c-postgresql-%e7%9a%84%e5%88%9b%e5%bb%ba%e3%80%81%e8%af%bb%e5%8f%96%e3%80%81%e6%9b%b4%e6%96%b0%e5%92%8c%e5%88%a0%e9%99%a4%e6%93%8d%e4%bd%9c%e3%80%82\/"},"modified":"2024-01-15T11:20:14","modified_gmt":"2024-01-15T03:20:14","slug":"%e4%bd%bf%e7%94%a8-python3-%e8%bf%9b%e8%a1%8c-postgresql-%e7%9a%84%e5%88%9b%e5%bb%ba%e3%80%81%e8%af%bb%e5%8f%96%e3%80%81%e6%9b%b4%e6%96%b0%e5%92%8c%e5%88%a0%e9%99%a4%e6%93%8d%e4%bd%9c%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-python3-%e8%bf%9b%e8%a1%8c-postgresql-%e7%9a%84%e5%88%9b%e5%bb%ba%e3%80%81%e8%af%bb%e5%8f%96%e3%80%81%e6%9b%b4%e6%96%b0%e5%92%8c%e5%88%a0%e9%99%a4%e6%93%8d%e4%bd%9c%e3%80%82\/","title":{"rendered":"\u4f7f\u7528 Python3 \u8fdb\u884c PostgreSQL \u7684\u521b\u5efa\u3001\u8bfb\u53d6\u3001\u66f4\u65b0\u548c\u5220\u9664\u64cd\u4f5c"},"content":{"rendered":"

\u6211\u7528Python3\u6267\u884c\u4e86\u4e0e\u8fd9\u4e2a\u9875\u9762\u76f8\u540c\u7684\u64cd\u4f5c\u3002\u7528Ruby\u8fdb\u884cPostgreSQL\u7684CRUD\u64cd\u4f5c\u3002<\/p>\n

\u8fde\u7ebf\u4fe1\u606f<\/p>\n

user='****'\r\npassword='*****'\r\ndata_base='city'\r\n<\/code><\/pre>\n
    \u4ee5\u4e0b\u662f\u68c0\u67e5 PostgreSQL \u7248\u672c\u7684\u65b9\u6cd5\u3002<\/ol>\n
    #! \/usr\/bin\/python\r\n# -*- coding: utf-8 -*-\r\n#\r\n#\tversion_check.py\r\n#\t\t\t\t\tNov\/17\/2019\r\n#\r\n# --------------------------------------------------------\r\n<\/span>import<\/span> os<\/span>\r\nimport<\/span> sys<\/span>\r\nimport<\/span> psycopg2<\/span>\r\nimport<\/span> psycopg2.extras<\/span>\r\nfrom<\/span> dotenv<\/span> import<\/span> load_dotenv<\/span>\r\n#\r\n<\/span>sys<\/span>.<\/span>stderr<\/span>.<\/span>write <\/span>(<\/span>\"<\/span>*** \u958b\u59cb ***<\/span>\\n<\/span>\"<\/span>)<\/span>\r\ndotenv_path<\/span> =<\/span> '<\/span>.env<\/span>'<\/span>\r\nload_dotenv<\/span>(<\/span>dotenv_path<\/span>)<\/span>\r\nUSER<\/span>=<\/span>os<\/span>.<\/span>environ<\/span>.<\/span>get<\/span>(<\/span>\"<\/span>user<\/span>\"<\/span>)<\/span>\r\nPASSWORD<\/span>=<\/span>os<\/span>.<\/span>environ<\/span>.<\/span>get<\/span>(<\/span>\"<\/span>password<\/span>\"<\/span>)<\/span>\r\nDATA_BASE<\/span>=<\/span>os<\/span>.<\/span>environ<\/span>.<\/span>get<\/span>(<\/span>\"<\/span>data_base<\/span>\"<\/span>)<\/span>\r\n#\r\n<\/span>conn<\/span> =<\/span> psycopg2<\/span>.<\/span>connect<\/span>(<\/span>\"<\/span>dbname=<\/span>\"<\/span> +<\/span> DATA_BASE<\/span> +<\/span> \"<\/span> user=<\/span>\"<\/span> +<\/span> USER<\/span> +<\/span> \"<\/span> password=<\/span>\"<\/span> +<\/span> PASSWORD<\/span>)<\/span>\r\ncur<\/span> =<\/span> conn<\/span>.<\/span>cursor<\/span>(<\/span>cursor_factory<\/span>=<\/span>psycopg2<\/span>.<\/span>extras<\/span>.<\/span>DictCursor<\/span>)<\/span>\r\n#\r\n<\/span>sql_str<\/span> =<\/span> \"<\/span>SELECT VERSION()<\/span>\"<\/span>\r\ncur<\/span>.<\/span>execute<\/span>(<\/span>sql_str<\/span>)<\/span>\r\n#rows = cur.fetchall()\r\n<\/span>rows<\/span> =<\/span> cur<\/span>.<\/span>fetchone<\/span>()<\/span>\r\nprint<\/span>(<\/span>rows<\/span>[<\/span>0<\/span>])<\/span>\r\n#\r\n<\/span>cur<\/span>.<\/span>close<\/span>()<\/span>\r\nconn<\/span>.<\/span>close<\/span>()<\/span>\r\n#\r\n<\/span>sys<\/span>.<\/span>stderr<\/span>.<\/span>write <\/span>(<\/span>\"<\/span>*** \u7d42\u4e86 ***<\/span>\\n<\/span>\"<\/span>)<\/span>\r\n#\r\n# --------------------------------------------------------\r\n<\/span><\/code><\/pre>\n
      \u521b\u9020<\/ol>\n
      #! \/usr\/bin\/python3\r\n# -*- coding: utf-8 -*-\r\n#\r\n#\tpostgre_create.py\r\n#\r\n#\t\t\t\t\tMay\/19\/2019\r\n#\r\n# --------------------------------------------------------\r\n<\/span>import<\/span>\tos<\/span>\r\nimport<\/span>\tsys<\/span>\r\nimport<\/span>\tpsycopg2<\/span>\r\nfrom<\/span> dotenv<\/span> import<\/span> load_dotenv<\/span>\r\n#\r\n# --------------------------------------------------------\r\n<\/span>def<\/span> dict_append_proc<\/span>(<\/span>dict_aa<\/span>,<\/span>key<\/span>,<\/span>name<\/span>,<\/span>population<\/span>,<\/span>date_mod<\/span>):<\/span>\r\n\tdict_aa<\/span>[<\/span>key<\/span>]<\/span> =<\/span> {<\/span>'<\/span>name<\/span>'<\/span>:<\/span>name<\/span>,<\/span>'<\/span>population<\/span>'<\/span>:<\/span>population<\/span>,<\/span>'<\/span>date_mod<\/span>'<\/span>:<\/span>date_mod<\/span>}<\/span>\r\n#\r\n<\/span>\treturn<\/span> dict_aa<\/span>\r\n#\r\n# --------------------------------------------------------\r\n<\/span>def<\/span>\tdata_prepare_proc<\/span> ():<\/span>\r\n#\r\n<\/span>\tdict_aa<\/span> =<\/span> {}<\/span> \r\n#\r\n<\/span>\tdict_aa<\/span> =<\/span> dict_append_proc <\/span>(<\/span>dict_aa<\/span>,<\/span>'<\/span>t3461<\/span>'<\/span>,<\/span>'<\/span>\u5e83\u5cf6<\/span>'<\/span>,<\/span>25176<\/span>,<\/span>'<\/span>2003-9-24<\/span>'<\/span>)<\/span>\r\n\tdict_aa<\/span> =<\/span> dict_append_proc <\/span>(<\/span>dict_aa<\/span>,<\/span>'<\/span>t3462<\/span>'<\/span>,<\/span>'<\/span>\u798f\u5c71<\/span>'<\/span>,<\/span>47935<\/span>,<\/span>'<\/span>2003-5-15<\/span>'<\/span>)<\/span>\r\n\tdict_aa<\/span> =<\/span> dict_append_proc <\/span>(<\/span>dict_aa<\/span>,<\/span>'<\/span>t3463<\/span>'<\/span>,<\/span>'<\/span>\u6771\u5e83\u5cf6<\/span>'<\/span>,<\/span>28654<\/span>,<\/span>'<\/span>2003-2-8<\/span>'<\/span>)<\/span>\r\n\tdict_aa<\/span> =<\/span> dict_append_proc <\/span>(<\/span>dict_aa<\/span>,<\/span>'<\/span>t3464<\/span>'<\/span>,<\/span>'<\/span>\u5449<\/span>'<\/span>,<\/span>83152<\/span>,<\/span>'<\/span>2003-10-9<\/span>'<\/span>)<\/span>\r\n\tdict_aa<\/span> =<\/span> dict_append_proc <\/span>(<\/span>dict_aa<\/span>,<\/span>'<\/span>t3465<\/span>'<\/span>,<\/span>'<\/span>\u5c3e\u9053<\/span>'<\/span>,<\/span>42791<\/span>,<\/span>'<\/span>2003-8-4<\/span>'<\/span>)<\/span>\r\n\tdict_aa<\/span> =<\/span> dict_append_proc <\/span>(<\/span>dict_aa<\/span>,<\/span>'<\/span>t3466<\/span>'<\/span>,<\/span>'<\/span>\u7af9\u539f<\/span>'<\/span>,<\/span>35687<\/span>,<\/span>'<\/span>2003-1-21<\/span>'<\/span>)<\/span>\r\n\tdict_aa<\/span> =<\/span> dict_append_proc <\/span>(<\/span>dict_aa<\/span>,<\/span>'<\/span>t3467<\/span>'<\/span>,<\/span>'<\/span>\u4e09\u6b21<\/span>'<\/span>,<\/span>81296<\/span>,<\/span>'<\/span>2003-7-23<\/span>'<\/span>)<\/span>\r\n\tdict_aa<\/span> =<\/span> dict_append_proc <\/span>(<\/span>dict_aa<\/span>,<\/span>'<\/span>t3468<\/span>'<\/span>,<\/span>'<\/span>\u5927\u7af9<\/span>'<\/span>,<\/span>21764<\/span>,<\/span>'<\/span>2003-10-26<\/span>'<\/span>)<\/span>\r\n\tdict_aa<\/span> =<\/span> dict_append_proc <\/span>(<\/span>dict_aa<\/span>,<\/span>'<\/span>t3469<\/span>'<\/span>,<\/span>'<\/span>\u5e9c\u4e2d<\/span>'<\/span>,<\/span>75428<\/span>,<\/span>'<\/span>2003-12-15<\/span>'<\/span>)<\/span>\r\n#\r\n<\/span>\treturn<\/span>\tdict_aa<\/span>\r\n#\r\n# --------------------------------------------------------\r\n<\/span>def<\/span>\tcreate_table_proc<\/span> (<\/span>cursor_aa<\/span>):<\/span>\r\n\tsql_str<\/span>=<\/span>\"<\/span>create table cities (id varchar(10) primary key, name varchar(20),<\/span>\"<\/span> \\\r\n\t\t+<\/span> \"<\/span> population int, date_mod date)<\/span>\"<\/span>\r\n#\r\n<\/span>\ttry<\/span>:<\/span>\r\n\t\tcursor_aa<\/span>.<\/span>execute <\/span>(<\/span>sql_str<\/span>)<\/span>\r\n\texcept<\/span> Exception<\/span> as<\/span> ee<\/span>:<\/span>\r\n\t\tsys<\/span>.<\/span>stderr<\/span>.<\/span>write <\/span>(<\/span>\"<\/span>*** error *** create_table_proc ***<\/span>\\n<\/span>\"<\/span>)<\/span>\r\n\t\tsys<\/span>.<\/span>stderr<\/span>.<\/span>write <\/span>(<\/span>str <\/span>(<\/span>ee<\/span>)<\/span> +<\/span> \"<\/span>\\n<\/span>\"<\/span>)<\/span>\r\n#\r\n# --------------------------------------------------------\r\n<\/span>def<\/span>\tdrop_table_proc<\/span> (<\/span>cursor_aa<\/span>):<\/span>\r\n\tsql_str<\/span>=<\/span>u<\/span>\"<\/span>drop table cities<\/span>\"<\/span>\r\n\ttry<\/span>:<\/span>\r\n\t\tcursor_aa<\/span>.<\/span>execute <\/span>(<\/span>sql_str<\/span>)<\/span>\r\n\texcept<\/span> Exception<\/span> as<\/span> ee<\/span>:<\/span>\r\n\t\tsys<\/span>.<\/span>stderr<\/span>.<\/span>write <\/span>(<\/span>\"<\/span>*** error *** drop_table_proc ***<\/span>\\n<\/span>\"<\/span>)<\/span>\r\n\t\tsys<\/span>.<\/span>stderr<\/span>.<\/span>write <\/span>(<\/span>str <\/span>(<\/span>ee<\/span>)<\/span> +<\/span> \"<\/span>\\n<\/span>\"<\/span>)<\/span>\r\n#\r\n# --------------------------------------------------------\r\n<\/span>def<\/span>\tsql_insert_proc<\/span>\t(<\/span>cursor_aa<\/span>,<\/span>id_in<\/span>,<\/span>name_in<\/span>,<\/span>ipop_in<\/span>,<\/span>date_mod_in<\/span>):<\/span>\r\n#\r\n<\/span>\tft_aa<\/span>=<\/span>\"<\/span>insert into cities (id,name,population,date_mod) values (<\/span>\"<\/span>\r\n\tft_bb<\/span> =<\/span>\"'<\/span>%s<\/span>'<\/span>,<\/span>'<\/span>%s<\/span>'<\/span>,%d,<\/span>'<\/span>%s<\/span>'<\/span>)<\/span>\"<\/span> %<\/span> (<\/span>id_in<\/span>,<\/span>name_in<\/span>,<\/span>ipop_in<\/span>,<\/span>date_mod_in<\/span>)<\/span>\r\n\tsql_str<\/span>=<\/span>ft_aa<\/span> +<\/span> ft_bb<\/span>\r\n\tcursor_aa<\/span>.<\/span>execute <\/span>(<\/span>sql_str<\/span>)<\/span>\r\n#\r\n# --------------------------------------------------------\r\n<\/span>def<\/span>\ttable_insert_proc<\/span>\t(<\/span>cursor<\/span>,<\/span>dict_aa<\/span>):<\/span>\r\n\tfor<\/span> key<\/span> in<\/span> dict_aa<\/span>:<\/span>\r\n\t\tunit<\/span> =<\/span> dict_aa<\/span>[<\/span>key<\/span>]<\/span>\r\n\t\ttry<\/span>:<\/span>\r\n\t\t\tsql_insert_proc\t<\/span>(<\/span>cursor<\/span>,<\/span>key<\/span>,<\/span>unit<\/span>[<\/span>'<\/span>name<\/span>'<\/span>],<\/span> \\\r\n\t\t\t\tunit<\/span>[<\/span>'<\/span>population<\/span>'<\/span>],<\/span>unit<\/span>[<\/span>'<\/span>date_mod<\/span>'<\/span>])<\/span>\r\n\t\texcept<\/span> Exception<\/span> as<\/span> ee<\/span>:<\/span>\r\n\t\t\tsys<\/span>.<\/span>stderr<\/span>.<\/span>write <\/span>(<\/span>\"<\/span>*** error *** table_insert_proc ***<\/span>\\n<\/span>\"<\/span>)<\/span>\r\n\t\t\tsys<\/span>.<\/span>stderr<\/span>.<\/span>write <\/span>(<\/span>str <\/span>(<\/span>ee<\/span>)<\/span> +<\/span> \"<\/span>\\n<\/span>\"<\/span>)<\/span>\r\n\t\t\tsys<\/span>.<\/span>stderr<\/span>.<\/span>write <\/span>(<\/span>key<\/span> +<\/span> \"<\/span>\\n<\/span>\"<\/span>)<\/span>\r\n# --------------------------------------------------------\r\n<\/span>sys<\/span>.<\/span>stderr<\/span>.<\/span>write <\/span>(<\/span>\"<\/span>*** \u958b\u59cb ***<\/span>\\n<\/span>\"<\/span>)<\/span>\r\n#\r\n#\r\n<\/span>dict_aa<\/span> =<\/span> data_prepare_proc <\/span>()<\/span>\r\n#\r\n<\/span>dotenv_path<\/span> =<\/span> '<\/span>.env<\/span>'<\/span>\r\nload_dotenv<\/span>(<\/span>dotenv_path<\/span>)<\/span>\r\nUSER<\/span>=<\/span>os<\/span>.<\/span>environ<\/span>.<\/span>get<\/span>(<\/span>\"<\/span>user<\/span>\"<\/span>)<\/span>\r\nPASSWORD<\/span>=<\/span>os<\/span>.<\/span>environ<\/span>.<\/span>get<\/span>(<\/span>\"<\/span>password<\/span>\"<\/span>)<\/span>\r\nDATA_BASE<\/span>=<\/span>os<\/span>.<\/span>environ<\/span>.<\/span>get<\/span>(<\/span>\"<\/span>data_base<\/span>\"<\/span>)<\/span>\r\n#\r\n<\/span>conn<\/span> =<\/span> psycopg2<\/span>.<\/span>connect<\/span>(<\/span>\"<\/span>dbname=<\/span>\"<\/span> +<\/span> DATA_BASE<\/span> +<\/span> \"<\/span> user=<\/span>\"<\/span> +<\/span> USER<\/span> +<\/span> \"<\/span> password=<\/span>\"<\/span> +<\/span> PASSWORD<\/span>)<\/span>\r\ncur<\/span> =<\/span> conn<\/span>.<\/span>cursor<\/span>()<\/span>\r\ndrop_table_proc <\/span>(<\/span>cur<\/span>)<\/span>\r\ncreate_table_proc <\/span>(<\/span>cur<\/span>)<\/span>\r\ntable_insert_proc <\/span>(<\/span>cur<\/span>,<\/span>dict_aa<\/span>)<\/span>\r\n#\r\n<\/span>conn<\/span>.<\/span>commit <\/span>()<\/span>\r\n#\r\n#\r\n<\/span>cur<\/span>.<\/span>close <\/span>()<\/span>\r\nconn<\/span>.<\/span>close <\/span>()<\/span>\r\n#\r\n<\/span>sys<\/span>.<\/span>stderr<\/span>.<\/span>write <\/span>(<\/span>\"<\/span>*** \u7d42\u4e86 ***<\/span>\\n<\/span>\"<\/span>)<\/span>\r\n#\r\n# --------------------------------------------------------\r\n<\/span><\/code><\/pre>\n
        \u9605\u8bfb<\/ol>\n
        #! \/usr\/bin\/python\r\n# -*- coding: utf-8 -*-\r\n#\r\n#\tpostgre_read.py\r\n#\t\t\t\t\tMay\/19\/2019\r\n#\r\n# --------------------------------------------------------\r\n<\/span>import<\/span> os<\/span>\r\nimport<\/span> sys<\/span>\r\nimport<\/span> psycopg2<\/span>\r\nimport<\/span> psycopg2.extras<\/span>\r\nfrom<\/span> dotenv<\/span> import<\/span> load_dotenv<\/span>\r\n#\r\n<\/span>sys<\/span>.<\/span>stderr<\/span>.<\/span>write <\/span>(<\/span>\"<\/span>*** \u958b\u59cb ***<\/span>\\n<\/span>\"<\/span>)<\/span>\r\ndotenv_path<\/span> =<\/span> '<\/span>.env<\/span>'<\/span>\r\nload_dotenv<\/span>(<\/span>dotenv_path<\/span>)<\/span>\r\nUSER<\/span>=<\/span>os<\/span>.<\/span>environ<\/span>.<\/span>get<\/span>(<\/span>\"<\/span>user<\/span>\"<\/span>)<\/span>\r\nPASSWORD<\/span>=<\/span>os<\/span>.<\/span>environ<\/span>.<\/span>get<\/span>(<\/span>\"<\/span>password<\/span>\"<\/span>)<\/span>\r\nDATA_BASE<\/span>=<\/span>os<\/span>.<\/span>environ<\/span>.<\/span>get<\/span>(<\/span>\"<\/span>data_base<\/span>\"<\/span>)<\/span>\r\n#\r\n<\/span>conn<\/span> =<\/span> psycopg2<\/span>.<\/span>connect<\/span>(<\/span>\"<\/span>dbname=<\/span>\"<\/span> +<\/span> DATA_BASE<\/span> +<\/span> \"<\/span> user=<\/span>\"<\/span> +<\/span> USER<\/span> +<\/span> \"<\/span> password=<\/span>\"<\/span> +<\/span> PASSWORD<\/span>)<\/span>\r\ncur<\/span> =<\/span> conn<\/span>.<\/span>cursor<\/span>(<\/span>cursor_factory<\/span>=<\/span>psycopg2<\/span>.<\/span>extras<\/span>.<\/span>DictCursor<\/span>)<\/span>\r\n#\r\n<\/span>sql_str<\/span> =<\/span> \"<\/span>select * from cities order by ID<\/span>\"<\/span>\r\ncur<\/span>.<\/span>execute<\/span>(<\/span>sql_str<\/span>)<\/span>\r\nrows<\/span> =<\/span> cur<\/span>.<\/span>fetchall<\/span>()<\/span>\r\nfor<\/span> row<\/span> in<\/span> rows<\/span>:<\/span>\r\n\tprint<\/span>(<\/span>row<\/span>[<\/span>'<\/span>id<\/span>'<\/span>],<\/span>row<\/span>[<\/span>'<\/span>name<\/span>'<\/span>],<\/span>row<\/span>[<\/span>'<\/span>population<\/span>'<\/span>],<\/span>row<\/span>[<\/span>'<\/span>date_mod<\/span>'<\/span>])<\/span>\r\n#\r\n<\/span>cur<\/span>.<\/span>close<\/span>()<\/span>\r\nconn<\/span>.<\/span>close<\/span>()<\/span>\r\n#\r\n<\/span>sys<\/span>.<\/span>stderr<\/span>.<\/span>write <\/span>(<\/span>\"<\/span>*** \u7d42\u4e86 ***<\/span>\\n<\/span>\"<\/span>)<\/span>\r\n#\r\n# --------------------------------------------------------\r\n<\/span><\/code><\/pre>\n
          \u66f4\u65b0<\/ol>\n
          #! \/usr\/bin\/python3\r\n# -*- coding: utf-8 -*-\r\n#\r\n#\tpostgre_update.py\r\n#\r\n#\t\t\t\tMay\/19\/2019\r\n#\r\n# --------------------------------------------------------\r\n<\/span>import<\/span> os<\/span>\r\nimport<\/span> sys<\/span>\r\nimport<\/span> string<\/span>\r\nimport<\/span>\tdatetime<\/span>\r\nfrom<\/span> time<\/span> import<\/span> localtime<\/span>,<\/span>strftime<\/span>\r\nimport<\/span> psycopg2<\/span>\r\nfrom<\/span> dotenv<\/span> import<\/span> load_dotenv<\/span>\r\n#\r\n#\r\n# --------------------------------------------------------\r\n<\/span>def<\/span>\tsql_update_string_gen_proc<\/span>\t(<\/span>id_in<\/span>,<\/span>ipop_in<\/span>):<\/span>\r\n\tdate_mod<\/span> =<\/span> strftime <\/span>(<\/span>\"<\/span>%Y-%m-%d<\/span>\"<\/span>,<\/span>localtime <\/span>())<\/span>\r\n\tft_aa<\/span>=<\/span>u<\/span>\"<\/span>update cities set population = %d, <\/span>\"<\/span> %<\/span> ipop_in<\/span>\r\n\tft_bb<\/span>=<\/span>u<\/span>\"<\/span>date_mod=<\/span>'<\/span>%s<\/span>'<\/span> \"<\/span> %<\/span> date_mod<\/span>\r\n\tft_cc<\/span>=<\/span>u<\/span>\"<\/span>where id = <\/span>'<\/span>%s<\/span>'\"<\/span> %<\/span> id_in<\/span>\r\n\tsql_str<\/span>=<\/span>ft_aa<\/span> +<\/span> ft_bb<\/span> +<\/span> ft_cc<\/span>\r\n\tprint <\/span>(<\/span>sql_str<\/span>)<\/span>\r\n#\r\n<\/span>\treturn<\/span>\tsql_str<\/span>\r\n# --------------------------------------------------------\r\n<\/span>sys<\/span>.<\/span>stderr<\/span>.<\/span>write <\/span>(<\/span>\"<\/span>*** \u958b\u59cb ***<\/span>\\n<\/span>\"<\/span>)<\/span>\r\nkey_in<\/span> =<\/span> sys<\/span>.<\/span>argv<\/span>[<\/span>1<\/span>]<\/span>\r\npopulation_in<\/span> =<\/span> int <\/span>(<\/span>sys<\/span>.<\/span>argv<\/span>[<\/span>2<\/span>])<\/span>\r\nprint <\/span>(<\/span>\"<\/span>%s<\/span>\\t<\/span>%d<\/span>\"<\/span> %<\/span> (<\/span>key_in<\/span>,<\/span> population_in<\/span>))<\/span>\r\n#\r\n<\/span>dotenv_path<\/span> =<\/span> '<\/span>.env<\/span>'<\/span>\r\nload_dotenv<\/span>(<\/span>dotenv_path<\/span>)<\/span>\r\nUSER<\/span>=<\/span>os<\/span>.<\/span>environ<\/span>.<\/span>get<\/span>(<\/span>\"<\/span>user<\/span>\"<\/span>)<\/span>\r\nPASSWORD<\/span>=<\/span>os<\/span>.<\/span>environ<\/span>.<\/span>get<\/span>(<\/span>\"<\/span>password<\/span>\"<\/span>)<\/span>\r\nDATA_BASE<\/span>=<\/span>os<\/span>.<\/span>environ<\/span>.<\/span>get<\/span>(<\/span>\"<\/span>data_base<\/span>\"<\/span>)<\/span>\r\n#\r\n<\/span>conn<\/span> =<\/span> psycopg2<\/span>.<\/span>connect<\/span>(<\/span>\"<\/span>dbname=<\/span>\"<\/span> +<\/span> DATA_BASE<\/span> +<\/span> \"<\/span> user=<\/span>\"<\/span> +<\/span> USER<\/span> +<\/span> \"<\/span> password=<\/span>\"<\/span> +<\/span> PASSWORD<\/span>)<\/span>\r\n#\r\n<\/span>cur<\/span> =<\/span> conn<\/span>.<\/span>cursor<\/span>()<\/span>\r\n#\r\n<\/span>sql_str<\/span>=<\/span>sql_update_string_gen_proc <\/span>(<\/span>key_in<\/span>,<\/span>population_in<\/span>)<\/span>\r\ncur<\/span>.<\/span>execute<\/span>(<\/span>sql_str<\/span>)<\/span>\r\nconn<\/span>.<\/span>commit <\/span>()<\/span>\r\n#\r\n<\/span>cur<\/span>.<\/span>close <\/span>()<\/span>\r\nconn<\/span>.<\/span>close <\/span>()<\/span>\r\n#\r\n<\/span>sys<\/span>.<\/span>stderr<\/span>.<\/span>write <\/span>(<\/span>\"<\/span>*** \u7d42\u4e86 ***<\/span>\\n<\/span>\"<\/span>)<\/span>\r\n#\r\n# --------------------------------------------------------\r\n<\/span><\/code><\/pre>\n
            \u5220\u9664<\/ol>\n
            #! \/usr\/bin\/python\r\n# -*- coding: utf-8 -*-\r\n#\r\n#\tpostgre_delete.py\r\n#\r\n#\t\t\t\tMay\/19\/2019\r\n#\r\n# --------------------------------------------------------\r\n<\/span>import<\/span> os<\/span>\r\nimport<\/span> sys<\/span>\r\nimport<\/span> psycopg2<\/span>\r\nfrom<\/span> dotenv<\/span> import<\/span> load_dotenv<\/span>\r\n#\r\n# --------------------------------------------------------\r\n<\/span>sys<\/span>.<\/span>stderr<\/span>.<\/span>write <\/span>(<\/span>\"<\/span>*** \u958b\u59cb ***<\/span>\\n<\/span>\"<\/span>)<\/span>\r\nkey_in<\/span> =<\/span> sys<\/span>.<\/span>argv<\/span>[<\/span>1<\/span>]<\/span>\r\nprint <\/span>(<\/span>\"<\/span>%s<\/span>\"<\/span> %<\/span> key_in<\/span>)<\/span>\r\n#\r\n<\/span>dotenv_path<\/span> =<\/span> '<\/span>.env<\/span>'<\/span>\r\nload_dotenv<\/span>(<\/span>dotenv_path<\/span>)<\/span>\r\nUSER<\/span>=<\/span>os<\/span>.<\/span>environ<\/span>.<\/span>get<\/span>(<\/span>\"<\/span>user<\/span>\"<\/span>)<\/span>\r\nPASSWORD<\/span>=<\/span>os<\/span>.<\/span>environ<\/span>.<\/span>get<\/span>(<\/span>\"<\/span>password<\/span>\"<\/span>)<\/span>\r\nDATA_BASE<\/span>=<\/span>os<\/span>.<\/span>environ<\/span>.<\/span>get<\/span>(<\/span>\"<\/span>data_base<\/span>\"<\/span>)<\/span>\r\n#\r\n<\/span>conn<\/span> =<\/span> psycopg2<\/span>.<\/span>connect<\/span>(<\/span>\"<\/span>dbname=<\/span>\"<\/span> +<\/span> DATA_BASE<\/span> +<\/span> \"<\/span> user=<\/span>\"<\/span> +<\/span> USER<\/span> +<\/span> \"<\/span> password=<\/span>\"<\/span> +<\/span> PASSWORD<\/span>)<\/span>\r\ncur<\/span> =<\/span> conn<\/span>.<\/span>cursor<\/span>()<\/span>\r\n#\r\n<\/span>sql_str<\/span>=<\/span>u<\/span>\"<\/span>delete from cities where id = <\/span>'<\/span>%s<\/span>'\"<\/span> %<\/span> key_in<\/span>\r\ncur<\/span>.<\/span>execute <\/span>(<\/span>sql_str<\/span>)<\/span>\r\n#\r\n<\/span>conn<\/span>.<\/span>commit <\/span>()<\/span>\r\n#\r\n<\/span>cur<\/span>.<\/span>close <\/span>()<\/span>\r\nconn<\/span>.<\/span>close <\/span>()<\/span>\r\n#\r\n#\r\n<\/span>sys<\/span>.<\/span>stderr<\/span>.<\/span>write <\/span>(<\/span>\"<\/span>*** \u7d42\u4e86 ***<\/span>\\n<\/span>\"<\/span>)<\/span>\r\n#\r\n# --------------------------------------------------------\r\n<\/span><\/code><\/pre>\n
            \u9519\u8bef\u5904\u7406<\/h2>\n
            psycopg2.OperationalError: connection to server on socket \"\/var\/run\/postgresql\/.s.PGSQL.5432\" failed: FATAL:  Peer authentication failed for user \"scott\"\r\n<\/code><\/pre>\n
            \u5c06\u201cpeer\u201d\u66f4\u6539\u4e3a\u201ctrust\u201d\u3002<\/p>\n
            (\u7701\u7565\uff09\r\n#local   all             all                                     peer\r\nlocal   all             all                                     trust\r\n(\u7701\u7565\uff09\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
            \u6211\u7528Python3\u6267\u884c\u4e86\u4e0e\u8fd9\u4e2a\u9875\u9762\u76f8\u540c\u7684\u64cd\u4f5c\u3002\u7528Ruby\u8fdb\u884cPostgreSQL\u7684CRUD\u64cd\u4f5c\u3002 \u8fde\u7ebf\u4fe1\u606f u […]<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-42226","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n\u4f7f\u7528 Python3 \u8fdb\u884c PostgreSQL \u7684\u521b\u5efa\u3001\u8bfb\u53d6\u3001\u66f4\u65b0\u548c\u5220\u9664\u64cd\u4f5c - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528-python3-\u8fdb\u884c-postgresql-\u7684\u521b\u5efa\u3001\u8bfb\u53d6\u3001\u66f4\u65b0\u548c\u5220\u9664\u64cd\u4f5c\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u4f7f\u7528 Python3 \u8fdb\u884c PostgreSQL \u7684\u521b\u5efa\u3001\u8bfb\u53d6\u3001\u66f4\u65b0\u548c\u5220\u9664\u64cd\u4f5c\" \/>\n<meta property=\"og:description\" content=\"\u6211\u7528Python3\u6267\u884c\u4e86\u4e0e\u8fd9\u4e2a\u9875\u9762\u76f8\u540c\u7684\u64cd\u4f5c\u3002\u7528Ruby\u8fdb\u884cPostgreSQL\u7684CRUD\u64cd\u4f5c\u3002 \u8fde\u7ebf\u4fe1\u606f u […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528-python3-\u8fdb\u884c-postgresql-\u7684\u521b\u5efa\u3001\u8bfb\u53d6\u3001\u66f4\u65b0\u548c\u5220\u9664\u64cd\u4f5c\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-25T12:17:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-15T03:20:14+00:00\" \/>\n<meta name=\"author\" content=\"\u96c5, \u609f\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u96c5, \u609f\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-python3-%e8%bf%9b%e8%a1%8c-postgresql-%e7%9a%84%e5%88%9b%e5%bb%ba%e3%80%81%e8%af%bb%e5%8f%96%e3%80%81%e6%9b%b4%e6%96%b0%e5%92%8c%e5%88%a0%e9%99%a4%e6%93%8d%e4%bd%9c%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-python3-%e8%bf%9b%e8%a1%8c-postgresql-%e7%9a%84%e5%88%9b%e5%bb%ba%e3%80%81%e8%af%bb%e5%8f%96%e3%80%81%e6%9b%b4%e6%96%b0%e5%92%8c%e5%88%a0%e9%99%a4%e6%93%8d%e4%bd%9c%e3%80%82\/\",\"name\":\"\u4f7f\u7528 Python3 \u8fdb\u884c PostgreSQL \u7684\u521b\u5efa\u3001\u8bfb\u53d6\u3001\u66f4\u65b0\u548c\u5220\u9664\u64cd\u4f5c - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-01-25T12:17:37+00:00\",\"dateModified\":\"2024-01-15T03:20:14+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-python3-%e8%bf%9b%e8%a1%8c-postgresql-%e7%9a%84%e5%88%9b%e5%bb%ba%e3%80%81%e8%af%bb%e5%8f%96%e3%80%81%e6%9b%b4%e6%96%b0%e5%92%8c%e5%88%a0%e9%99%a4%e6%93%8d%e4%bd%9c%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-python3-%e8%bf%9b%e8%a1%8c-postgresql-%e7%9a%84%e5%88%9b%e5%bb%ba%e3%80%81%e8%af%bb%e5%8f%96%e3%80%81%e6%9b%b4%e6%96%b0%e5%92%8c%e5%88%a0%e9%99%a4%e6%93%8d%e4%bd%9c%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-python3-%e8%bf%9b%e8%a1%8c-postgresql-%e7%9a%84%e5%88%9b%e5%bb%ba%e3%80%81%e8%af%bb%e5%8f%96%e3%80%81%e6%9b%b4%e6%96%b0%e5%92%8c%e5%88%a0%e9%99%a4%e6%93%8d%e4%bd%9c%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u4f7f\u7528 Python3 \u8fdb\u884c PostgreSQL \u7684\u521b\u5efa\u3001\u8bfb\u53d6\u3001\u66f4\u65b0\u548c\u5220\u9664\u64cd\u4f5c\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6\",\"name\":\"\u96c5, \u609f\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g\",\"caption\":\"\u96c5, \u609f\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yawu\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-python3-%e8%bf%9b%e8%a1%8c-postgresql-%e7%9a%84%e5%88%9b%e5%bb%ba%e3%80%81%e8%af%bb%e5%8f%96%e3%80%81%e6%9b%b4%e6%96%b0%e5%92%8c%e5%88%a0%e9%99%a4%e6%93%8d%e4%bd%9c%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u4f7f\u7528 Python3 \u8fdb\u884c PostgreSQL \u7684\u521b\u5efa\u3001\u8bfb\u53d6\u3001\u66f4\u65b0\u548c\u5220\u9664\u64cd\u4f5c - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528-python3-\u8fdb\u884c-postgresql-\u7684\u521b\u5efa\u3001\u8bfb\u53d6\u3001\u66f4\u65b0\u548c\u5220\u9664\u64cd\u4f5c\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u4f7f\u7528 Python3 \u8fdb\u884c PostgreSQL \u7684\u521b\u5efa\u3001\u8bfb\u53d6\u3001\u66f4\u65b0\u548c\u5220\u9664\u64cd\u4f5c","og_description":"\u6211\u7528Python3\u6267\u884c\u4e86\u4e0e\u8fd9\u4e2a\u9875\u9762\u76f8\u540c\u7684\u64cd\u4f5c\u3002\u7528Ruby\u8fdb\u884cPostgreSQL\u7684CRUD\u64cd\u4f5c\u3002 \u8fde\u7ebf\u4fe1\u606f u […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528-python3-\u8fdb\u884c-postgresql-\u7684\u521b\u5efa\u3001\u8bfb\u53d6\u3001\u66f4\u65b0\u548c\u5220\u9664\u64cd\u4f5c\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-01-25T12:17:37+00:00","article_modified_time":"2024-01-15T03:20:14+00:00","author":"\u96c5, \u609f","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u96c5, \u609f","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"5 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-python3-%e8%bf%9b%e8%a1%8c-postgresql-%e7%9a%84%e5%88%9b%e5%bb%ba%e3%80%81%e8%af%bb%e5%8f%96%e3%80%81%e6%9b%b4%e6%96%b0%e5%92%8c%e5%88%a0%e9%99%a4%e6%93%8d%e4%bd%9c%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-python3-%e8%bf%9b%e8%a1%8c-postgresql-%e7%9a%84%e5%88%9b%e5%bb%ba%e3%80%81%e8%af%bb%e5%8f%96%e3%80%81%e6%9b%b4%e6%96%b0%e5%92%8c%e5%88%a0%e9%99%a4%e6%93%8d%e4%bd%9c%e3%80%82\/","name":"\u4f7f\u7528 Python3 \u8fdb\u884c PostgreSQL \u7684\u521b\u5efa\u3001\u8bfb\u53d6\u3001\u66f4\u65b0\u548c\u5220\u9664\u64cd\u4f5c - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-01-25T12:17:37+00:00","dateModified":"2024-01-15T03:20:14+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-python3-%e8%bf%9b%e8%a1%8c-postgresql-%e7%9a%84%e5%88%9b%e5%bb%ba%e3%80%81%e8%af%bb%e5%8f%96%e3%80%81%e6%9b%b4%e6%96%b0%e5%92%8c%e5%88%a0%e9%99%a4%e6%93%8d%e4%bd%9c%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-python3-%e8%bf%9b%e8%a1%8c-postgresql-%e7%9a%84%e5%88%9b%e5%bb%ba%e3%80%81%e8%af%bb%e5%8f%96%e3%80%81%e6%9b%b4%e6%96%b0%e5%92%8c%e5%88%a0%e9%99%a4%e6%93%8d%e4%bd%9c%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-python3-%e8%bf%9b%e8%a1%8c-postgresql-%e7%9a%84%e5%88%9b%e5%bb%ba%e3%80%81%e8%af%bb%e5%8f%96%e3%80%81%e6%9b%b4%e6%96%b0%e5%92%8c%e5%88%a0%e9%99%a4%e6%93%8d%e4%bd%9c%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u4f7f\u7528 Python3 \u8fdb\u884c PostgreSQL \u7684\u521b\u5efa\u3001\u8bfb\u53d6\u3001\u66f4\u65b0\u548c\u5220\u9664\u64cd\u4f5c"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/f044a4b7fa4ee2701702942002419ca6","name":"\u96c5, \u609f","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e71a913e914f1aad1efc391f92084294bac54bc782acd289638580134cf667a6?s=96&d=mm&r=g","caption":"\u96c5, \u609f"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yawu\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8-python3-%e8%bf%9b%e8%a1%8c-postgresql-%e7%9a%84%e5%88%9b%e5%bb%ba%e3%80%81%e8%af%bb%e5%8f%96%e3%80%81%e6%9b%b4%e6%96%b0%e5%92%8c%e5%88%a0%e9%99%a4%e6%93%8d%e4%bd%9c%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/42226","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=42226"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/42226\/revisions"}],"predecessor-version":[{"id":58993,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/42226\/revisions\/58993"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=42226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=42226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=42226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}