SQLAlchemy

from sqlalchemy import create_engine, Column, String, INT, DateTime
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

# pymysql.install_as_MySQLdb()

# 初始化数据库连接:
engine = create_engine('mysql+pymysql://autoit:Autoit123456@52.83.32.119/hscontacts?charset=utf8', pool_pre_ping=True,
                       encoding="utf-8", pool_recycle=3600)
# 创建DBSession类型:
DBSession = sessionmaker(bind=engine)
# 创建对象的基类:
Base = declarative_base()


# 定义User对象:
class CodeAmount(Base):
    # 表的名字:
    __tablename__ = 'CodeAmount'

    # 表的结构:
    id = Column(INT(), primary_key=True)
    product_name = Column(String(255))
    short_id = Column(String(128))
    commit_id = Column(String(255))
    message = Column(String(255))
    committed_date = Column(DateTime())
    additions = Column(INT())
    deletions = Column(INT())
    total = Column(INT())
    url = Column(String(255))

session = DBSession()