python3.6 sqlalchemy安装与使用

小白学习python，一边学一边做项目，直接从3.6开始

由于是做个比较简单的socket服务器，所以基本用python原生库，sql选用sqlalchemy

安装python就不说了（3.6自带pip）

 

1.先安装mysql模块

 

进入cmd，安装pymysql

 

"D:\Program Files\Python\Scripts\pip.exe" install pymysql

 

 

2.安装sqlalchemy

"D:\Program Files\Python\Scripts\pip.exe" install SQLAlchemy

 

3.在cmd里测试一下sqlalchemy安装成功没有

import sqlalchemy
sqlalchemy.__version__

'1.1.6'

只要打印出版本号，sqlalchemy安装成功

4.新建一个testAlchemy.py来测试一下

from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import create_engine

5.创建model.py文件 Column为字段

from sqlalchemy import Column, String

#创建模型
class User(sqlConfig.Base):
    __tablename__ = 'dev_user'
    uid = Column(String(20), primary_key=True)
    username = Column(String(20))
    realname = Column(String(20))

# 创建对象的基类:
Base = declarative_base()
# 初始化数据库连接:
engine = create_engine('mysql+pymysql://root:@localhost:3306/jfmonitor?charset=utf8') #现在是用pymysql做sql驱动了
# 创建DBSession类型:
DBSession = sessionmaker(bind=engine)
session = DBSession()
res = session.query(model.User).all()
for i in range(len(res)): 
    print("username:{0} realname:{1}".format(res[i].username, res[i].realname)