python 数据库相关

非常非常好用的数据操作包：sqlalchemy

用于生成假数据库的包：faker

sqlalchemy + sqlite3

from sqlacchemy import Column, Integer, create_engine, TEXT, DateTime
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()
class User(Base): 
  __tablename__  = 'users'
  id = Column(Integer, primary_key = True)
  name = Column(TEXT)
  up_time = Column(DateTime)

if __name__ == '__main__':
  engine = create_engine('sqlite:////home/user_name/test.bd')
  Base.matedata.create_all(engine)
  db_session = sessionmaker(bind=engine)
  session = db_session()
  res =  session.query(User.id)
  print(list(res))