# -*- coding:utf-8 -*-
import pyodbc
import sqlalchemy as sa
from sqlalchemy.orm import sessionmaker
# Create on 2018/5/26
# By leslie
def sql_engine():
# set your connect information
user = 'sa'
pwd = '123456'
database = 'mydb'
# start connect
engine = sa.create_engine('mssql+pyodbc://{0}:{1}@{2}'.format(user, pwd, database))
return engine