Open connection to database. :param hostname: :param password: :param username: :param dbname: string :return: psycopg2.connection
(hostname, password, username, dbname, port)
| 34 | |
| 35 | |
| 36 | def create_cn(hostname, password, username, dbname, port): |
| 37 | """ |
| 38 | Open connection to database. |
| 39 | :param hostname: |
| 40 | :param password: |
| 41 | :param username: |
| 42 | :param dbname: string |
| 43 | :return: psycopg2.connection |
| 44 | """ |
| 45 | cn = connect(host=hostname, user=username, database=dbname, |
| 46 | password=password, port=port) |
| 47 | |
| 48 | print('Created connection: {0}.'.format(cn.dsn)) |
| 49 | return cn |
| 50 | |
| 51 | |
| 52 | def drop_db(hostname='localhost', username=None, password=None, |