Python 应用知识 sqlalchemy 入门

https://juejin.im/post/5bf741886fb9a049fa0f671e

# !/usr/bin/env python3

# -*- coding: utf-8 -*

 

 

from sqlalchemy import Column, Integer, String

from sqlalchemy import create_engine

from sqlalchemy.ext.declarative import declarative_base

from sqlalchemy.orm import sessionmaker

 

Base = declarative_base()

engine = create_engine('mysql+pymysql://thinktik:Secure_123@mys'

                       '@mysql.missioncenter.online:7306/think_db?charset=utf8mb4')

Session = sessionmaker(bind=engine)

 

session = Session()

 

 

def to_dict(self):

    return {c.name: getattr(self, c.name, None)

            for c in self.__table__.columns}

 

 

Base.to_dict = to_dict

 

 

class User(Base):

    # 对应表名

    __tablename__ = 'user_main'

    # 类成员变量对应表字段，并指定表字段类型，是否为主键等

    user_id = Column('id', Integer, primary_key=True)

    user_name = Column('username', String(120))

    password = Column('pazzword', String(120))

 

 

# 添加

user_id = 1

book = session.query(User).get(user_id)

print(book.user_name)

 

#