common_func.py 447 B

123456789101112131415161718
  1. from sqlalchemy import create_engine
  2. from urllib import parse
  3. def get_db_engine(db_info):
  4. db_con_str = 'mysql+pymysql://%s:%s@%s:%d/%s' % \
  5. (db_info['username'],
  6. parse.quote_plus(db_info['password']),
  7. db_info['host'],
  8. db_info['port'],
  9. db_info['database'])
  10. engine = create_engine(db_con_str, connect_args={'charset': 'utf8'})
  11. return engine