sqlalchemy基础

#coding=utf-8
from  sqlalchemy.orm import mapper, sessionmaker
from  sqlalchemy import Table, MetaData, Column, ForeignKey, Integer, String, Unicode, DateTime, create_engine
from sqlalchemy.ext.declarative import declarative_base
Base1 = declarative_base()
class User(Base1):
    __tablename__= 'tf_user'
    id = Column(Integer, primary_key = True)
    name = Column(Unicode(32))

# mapper(User, user_table)
engin = create_engine('mysql://cg:123456@127.0.0.1/test')
Session = sessionmaker(bind = engin)
session = Session()
new_user = User(name = 'cgg1')
session.add(new_user)
session.commit()
query = session.query(User)
print query.get(1).id