#!/usr/bin/env?python
#?-*-?coding:?utf-8?-*-
#-------------------------------------------------------------------------------
#?Name:?????????sqlalchemy_test02
#?Purpose:
#
#?Author:???????longc
#?Created:??????2019/2/12
#?IDE:??????????PyCharm
#?Copyright:???（c）?longc?2019
#?Licence:?????
#?Version:?????
#-------------------------------------------------------------------------------
import?pymysql
pymysql.install_as_MySQLdb（）

import?random
from?faker?import?Factory

from?sqlalchemy?import?create_engine?Table
from?sqlalchemy.ext.declarative?import?declarative_base
from?sqlalchemy?import?ForeignKey
from?sqlalchemy?import?Column?String?Integer?Text
from?sqlalchemy.orm?import?sessionmaker?relationship


engine?=?create_engine（‘mysql+mysqldb://root:123456@192.168.38.128:3306/blog_test?charset=utf8‘）
base?=?declarative_base（）


class?User（base）:

????__tablename__?=?‘users‘

????id?=?Column（Integer?primary_key=True）
???