SQLAlchemy连接mssql的demo

# -*- coding: ISO-8859-1 -*-

#test.py

import sqlalchemy import traceback import pyodbc from sqlalchemy import create_engine from sqlalchemy import Table, Column, Integer, String, MetaData, ForeignKey from sqlalchemy.orm import mapper from sqlalchemy.orm import sessionmaker from sqlalchemy.orm import deferred

class User(object):  def __init__(self, name, usercode, password,id):   self.name = name   self.usercosde = usercode   self.password = password   self.id   = id  def __repr__(self):   return "<User('%s','%s','%s', '%s')>" % (self.id,self.name, self.usercode, self.password)

print sqlalchemy.__version__ try:

 engine = create_engine('mssql://sa:123456@/?dsn=officialcar',module=pyodbc,echo=True)

 metadata = MetaData()  users_table = Table('t_user_info', metadata,       Column('id', Integer, primary_key=True),       Co