Open connection to database. :param hostname: :param port: :param password: :param username: :param dbname: string :return: psycopg2.connection
(hostname, port, password, username, dbname)
| 31 | |
| 32 | |
| 33 | def create_cn(hostname, port, password, username, dbname): |
| 34 | """Open connection to database. |
| 35 | |
| 36 | :param hostname: |
| 37 | :param port: |
| 38 | :param password: |
| 39 | :param username: |
| 40 | :param dbname: string |
| 41 | :return: psycopg2.connection |
| 42 | |
| 43 | """ |
| 44 | cn = pymysql.connect( |
| 45 | host=hostname, |
| 46 | port=port, |
| 47 | user=username, |
| 48 | password=password, |
| 49 | db=dbname, |
| 50 | charset=DEFAULT_CHARSET, |
| 51 | cursorclass=pymysql.cursors.DictCursor, |
| 52 | ) |
| 53 | |
| 54 | return cn |
| 55 | |
| 56 | |
| 57 | def drop_db(hostname=DEFAULT_HOST, port=DEFAULT_PORT, username=None, password=None, dbname=None): |