接之前的一二三
三中是建立类,获取table信息,然后将两者绑定,达到面向对象
1.通过类来建立数据库,真的面向对象
2.依旧利用configparse读取配置文件
3.通过session add delete update 等
import ConfigParser
#get the connect db conf
def read_conf(db_type="mysql"):
conf=ConfigParser.ConfigParser()
conf.read("./db.conf")
sec=db_type
db_user=conf.get(sec,"db_user")
db_password=conf.get(sec,"db_password")
db_host=conf.get(sec,"db_host")
db_port=conf.get(sec,"db_port")
db_name=conf.get(sec,"db_name")
return "{0}://{1}:{2}@{3}:{4}/{5}".format(db_type,db_user,db_password,db_host,db_port,db_name)
#class test two#############################################
from sqlalchemy import Column, Integer, String, ForeignKey
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalch