Discuss / Python / get.主键。外键这些建议看眼sql教程
Back

get.主键。外键这些建议看眼sql教程

Topic source

叫是先生

#1 Created at ... [Delete] [Delete and Lock User]

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

Base = declarative_base()

class User(Base):
    __tablename__ = 'testtable'
    username = Column(String(20),primary_key= True)
    passwd = Column(String(20))

engine = create_engine('mysql+pymysql://root:123456@127.0.0.1:3306/test') DBSession = sessionmaker(bind = engine)

session = DBSession() new_user= User(username='DDD', passwd= '666') session.add(new_user) session.commit() session.close()

上面是查询的

下面是添加的 session = DBSession() testtable = session.query(User).filter(User.username =='DDD').one() print('type:',type(testtable)) print('name:',testtable.passwd) session.close()

注意，要看下自己的数据库中有没有这些表。 我用pyMysql 连接的是 test3.db， table是testtable.主键是username

  • 1

Reply