sqlalchemy-连接数据库

# -*- coding: UTF-8 -*-
from sqlalchemy import *
import sqlalchemy.util as util
import string, sys
from sqlalchemy.databases import mysql

mysql_engine = create_engine('mysql://root:@localhost:3306/test?charset=utf8',encoding = "utf-8",echo =True)  
#mysql_engine.connect()   
metadata = MetaData()

#创建users表
users_table = Table('users', metadata,
    Column('id', Integer, primary_key=True),
    Column('username', String(20), nullable = False),
    Column('fullname', String(20), nullable = False),
    Column('password', String(20), nullable = False),
    mysql_engine='InnoDB'
)

#mysql_engine='InnoDB' 或者 mysql_engine='MyISAM' 表类型
metadata.create_all(mysql_engine)

说明:
create_engine(数据库://用户名:密码(没有密码则为空)@主机名:端口/数据库名',echo =True)
create_engine('mysql://root:@localhost:3306/test',echo =True)