import MySQLdb
import sqlalchemy
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String
from sqlalchemy.orm import sessionmaker
from sqlalchemy import create_engine, Table, MetaData
conn=MySQLdb.connect(host="localhost",user="root",passwd="123456")
cur=conn.cursor()
db="test"
if cur.execute('show databases like %s',(db,)):
engine = create_engine("mysql+mysqldb://root:123456@localhost/%s?charset=utf8"%(db),encoding='utf-8')
else:
print("there is no database of %s"%(db))
exit()
Base = declarative_base() #生成orm基类
Session_class = sessionmaker(bind=engine) #创建与数据库的会话session class ,注意,这里返回给session的是个class,不是实例