Python 3.8.10
\npsycopg\u304c\u5fc5\u8981\u3002<\/p>\n
from sqlalchemy import create_engine\r\nfrom sqlalchemy import Column, Integer, String\r\nfrom sqlalchemy.ext.declarative import declarative_base\r\nfrom sqlalchemy.orm import sessionmaker\r\n\r\ndb_string = \"postgresql:\/\/user:password@localhost:5432\/testdb\"\r\n\r\ndb = create_engine(db_string)\r\nbase = declarative_base()\r\n\r\n# OR\u30de\u30c3\u30d4\u30f3\u30b0\r\nclass Hello(base):\r\n __tablename__ = 'hello'\r\n\r\n id = Column(Integer, primary_key=True)\r\n msg = Column(String)\r\n\r\nSession = sessionmaker(db)\r\nsession = Session()\r\n\r\n# \u30c6\u30fc\u30d6\u30eb\u304c\u5b58\u5728\u3057\u306a\u3051\u308c\u3070\u4f5c\u6210\u3002\r\nbase.metadata.create_all(db)\r\n\r\n# INSERT\r\ndata = Hello(msg=\"Hello World!\")\r\nsession.add(data)\r\nsession.commit()\r\n\r\n# SELECT\r\nselect = session.query(Hello)\r\nfor row in select:\r\n print(row.msg)\r\n\r\n# UPDATE\r\ndata.msg = \"Hello Wolrd! 2\"\r\nsession.commit()\r\n\r\n# SELECT\r\nselect = session.query(Hello)\r\nfor row in select:\r\n print(row.msg)\r\n\r\n# Delete\r\nsession.delete(data)\r\nsession.commit()<\/pre>\n<\/div>\n\u5b9f\u884c\u7d50\u679c<\/p>\n
\npython test.py\r\nHello World!\r\nHello Wolrd! 2<\/pre>\n<\/div>\n\u4f5c\u6210\u3055\u308c\u305f\u30c6\u30fc\u30d6\u30eb<\/p>\n
\ntestdb=> \\d hello;\r\n Table \"public.hello\"\r\n Column | Type | Collation | Nullable | Default\r\n--------+-------------------+-----------+----------+-----------------------------------\r\n id | integer | | not null | nextval('hello_id_seq'::regclass)\r\n msg | character varying | | |\r\nIndexes:\r\n \"hello_pkey\" PRIMARY KEY, btree (id)<\/pre>\n<\/div>\n<\/p>\n","protected":false},"excerpt":{"rendered":"