Python-сообщество

from sqlalchemy import create_engine
from sqlalchemy_utils import database_exists, create_database
from sqlalchemy import Table, Column, Integer, String, TIMESTAMP, func
from sqlalchemy.ext.declarative import declarative_base
BaseTable = declarative_base()
class TestTable(BaseTable):
    __tablename__ = 'testtable'
    id = Column(Integer, primary_key = True)
    testfield = Column(String(100))
    page = Column(Integer, default = 0)
q = 'mysql+pymysql://root:1234@localhost:3306/testdb?charset=utf8mb4'
engine = create_engine(q, pool_recycle = 3306)
if not database_exists(engine.url):
    create_database(engine.url)
BaseTable.metadata.create_all(engine)

create_engine(q, encoding="cp1251", convert_unicode=True)