python create_engine

使用连接数据库 pymysql库 例子

import pymysql
from sqlalchemy import create_engine
class Mysql():
    def __init__(self):
        self.ip = "127.0.0.1"
        self.port = "3306"
        self.port2 = 3306
        self.username = "root"
        self.secret = "xxxxxx"
        self.dbname = "dbname"
        self.tablename = "tablename"
    def connect(self):
        url = 'mysql+pymysql://'+self.username+':'+self.secret+'@'+self.ip+':'+self.port+'/'+self.dbname+'?charset=utf8mb4'
        print(url)
        connect = create_engine(url)
        return connect
    def connect2(self):
        db = pymysql.connect(host=self.ip, user=self.username, password=self.secret, port=self.port2, database=self.dbname)
        cursor = db.cursor()  # 获得指针
        return cursor
    def select(self):
        cursor = self.connect2()
        sql = 'select * from dbname.tablename;'
        cursor.execute(sql)  # 执行
        return cursor