Create test database. :param hostname: string :param port: int :param username: string :param password: string :param dbname: string :return:
(hostname=DEFAULT_HOST, port=DEFAULT_PORT, username=None, password=None, dbname=None)
| 6 | |
| 7 | |
| 8 | def create_db(hostname=DEFAULT_HOST, port=DEFAULT_PORT, username=None, password=None, dbname=None): |
| 9 | """Create test database. |
| 10 | |
| 11 | :param hostname: string |
| 12 | :param port: int |
| 13 | :param username: string |
| 14 | :param password: string |
| 15 | :param dbname: string |
| 16 | :return: |
| 17 | |
| 18 | """ |
| 19 | cn = pymysql.connect( |
| 20 | host=hostname, port=port, user=username, password=password, charset=DEFAULT_CHARSET, cursorclass=pymysql.cursors.DictCursor |
| 21 | ) |
| 22 | |
| 23 | with cn.cursor() as cr: |
| 24 | cr.execute("drop database if exists " + dbname) |
| 25 | cr.execute("create database " + dbname) |
| 26 | |
| 27 | cn.close() |
| 28 | |
| 29 | cn = create_cn(hostname, port, password, username, dbname) |
| 30 | return cn |
| 31 | |
| 32 | |
| 33 | def create_cn(hostname, port, password, username, dbname): |