{"id":9504,"date":"2024-10-27T17:29:20","date_gmt":"2024-10-27T08:29:20","guid":{"rendered":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=9504"},"modified":"2024-10-29T17:17:41","modified_gmt":"2024-10-29T08:17:41","slug":"python-sqlalchemy","status":"publish","type":"post","link":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=9504","title":{"rendered":"Python – SQLAlchemy"},"content":{"rendered":"

Python – SQLAlchemy<\/h1>\n

CRUD \uc758 \uc2dc\uc810\uc744 session.commit()<\/code> \uc774 \ud638\ucd9c\ub418\ub294 \uc2dc\uc810\uc73c\ub85c \ucd5c\ub300\ud55c \ubbf8\ub8e8\uae30\ub54c\ubb38\uc5d0,
\n\ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \uc811\uc18d\uc744 \ucd5c\uc18c\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\ub2e4\ub9cc, session.commit()<\/code> \uc744 \ub204\ub77d\ud558\uba74 \ub2f9\uc5f0\ud788 \ub864\ubc31\ub429\ub2c8\ub2e4.<\/p>\n

\ud14c\uc774\ube14 \uc0dd\uc131<\/h2>\n
CREATE TABLE `user` (\n    `id` INT(11) NOT NULL AUTO_INCREMENT,\n    `username` VARCHAR(256) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',\n    `email` VARCHAR(256) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',\n    PRIMARY KEY (`id`) USING BTREE\n)\nCOLLATE='utf8mb4_general_ci'\nENGINE=InnoDB\n;<\/code><\/pre>\n
VSCode \uc5d0\uc11c session \uc5d0 \ub300\ud55c \uc790\ub3d9\uc644\uc131\uc774 \ud544\uc694\ud558\uba74 Pylance \ub97c \uc124\uce58\ud574\uc57c \ud569\ub2c8\ub2e4.
\n\uc124\uce58 \ud6c4 VSCode \ub97c \uc7ac\uc2e4\ud589\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
from __future__ import annotations\n\nfrom sqlalchemy import create_engine\nfrom sqlalchemy.orm import sessionmaker, declarative_base\nfrom sqlalchemy import Column, Integer, String, DateTime, Boolean\n\nengine = create_engine('mysql+mysqldb:\/\/root:12345678@localhost:3306\/testdb')\nSession = sessionmaker(engine)\nsession = Session()\n\nBase = declarative_base()\n\nclass User(Base):\n    __tablename__ = 'user'\n    id = Column(Integer, primary_key=True)\n    username = Column(String)\n    email = Column(String)\n    # time = Column(DateTime, default=datetime.datetime.utcnow, primary_key=True)\n    def __init__(self, user: User):\n        # self.id = user.id\n        self.username = user.username\n        self.email = user.email\n    def __init__(self, username: str, email: str):\n        # self.id = user.id\n        self.username = username\n        self.email = email\n    def update(self, user: User):\n        self.username = user.username\n        self.email = user.email<\/code><\/pre>\n
\ud14c\uc2a4\ud2b8 \ud658\uacbd \uad6c\ucd95<\/h2>\n
pip install sqlalchemy\npip install mysqlclient<\/code><\/pre>\n
insert<\/h2>\n
# insert\nuser = User(username="Lee", email="aaa@aaa.com")\nsession.add(user)\nsession.commit()<\/code><\/pre>\n
select<\/h2>\n
user: User<\/code> \uc640 \uac19\uc774 \ud0c0\uc785\uc744 \uba85\uc2dc\ud574 \uc8fc\uc5b4\uc57c \uc790\ub3d9\uc644\uc131\uc774 \uc791\ub3d9\ud569\ub2c8\ub2e4.<\/p>\n
# select one\nuser: User = session.query(User).filter(User.username == "Lee").first()\n# user: User = session.query(User).filter(User.username == "Lee 2", User.id == 2).first()\nprint(user.id)<\/code><\/pre>\n
# select all\nusers: List[User] = session.query(User).filter(User.username == "Lee").all()\n# users: List[User] = session.query(User).filter(User.username == "Lee 2").order_by(User.id.desc()).all()\nfor user in users:\n    print(user.id)<\/code><\/pre>\n
update<\/h2>\n
# update one\nuser2 = User(username="Lee 2", email="aaa2@aaa.com")\nuser: User = session.query(User).filter(User.username == "Lee").first()\nuser.update(user2)\n\n# update list\nuser2 = User(username="Lee 2", email="aaa2@aaa.com")\nusers: List[User] = session.query(User).filter(User.username == "Lee").all()\nfor user in users:\n    user.update(user2)\n\n# \ucee4\ubc0b\uc744 \ud560 \ub54c \uc790\ub3d9\uc73c\ub85c update \ubb38\uc774 \uc2e4\ud589\ub41c\ub2e4.\nsession.commit()<\/code><\/pre>\n
delete<\/h2>\n
# delete\nuser: User = session.query(User).filter(User.id == 1).first()\nif user is not None:\n    session.delete(user)\nsession.commit()<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
Python – SQLAlchemy CRUD \uc758 \uc2dc\uc810\uc744 session.commit() \uc774 \ud638\ucd9c\ub418\ub294 \uc2dc\uc810\uc73c\ub85c \ucd5c\ub300\ud55c \ubbf8\ub8e8\uae30\ub54c\ubb38\uc5d0, \ub370\uc774\ud0c0\ubca0\uc774\uc2a4 \uc811\uc18d\uc744 \ucd5c\uc18c\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\ub9cc, session.commit() \uc744 \ub204\ub77d\ud558\uba74 \ub2f9\uc5f0\ud788 \ub864\ubc31\ub429\ub2c8\ub2e4. \ud14c\uc774\ube14 \uc0dd\uc131 CREATE TABLE `user` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `username` VARCHAR(256) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci', `email` VARCHAR(256) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci', PRIMARY KEY (`id`) USING BTREE\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-9504","post","type-post","status-publish","format-standard","hentry","category-python"],"_links":{"self":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/9504","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9504"}],"version-history":[{"count":9,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/9504\/revisions"}],"predecessor-version":[{"id":9513,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/9504\/revisions\/9513"}],"wp:attachment":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9504"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9504"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}