Drop database. :param hostname: string :param username: string :param password: string :param dbname: string
(hostname='localhost', username=None, password=None,
dbname=None, port=None)
| 50 | |
| 51 | |
| 52 | def drop_db(hostname='localhost', username=None, password=None, |
| 53 | dbname=None, port=None): |
| 54 | """ |
| 55 | Drop database. |
| 56 | :param hostname: string |
| 57 | :param username: string |
| 58 | :param password: string |
| 59 | :param dbname: string |
| 60 | """ |
| 61 | cn = create_cn(hostname, password, username, 'postgres', port) |
| 62 | |
| 63 | # ISOLATION_LEVEL_AUTOCOMMIT = 0 |
| 64 | # Needed for DB drop. |
| 65 | cn.set_isolation_level(0) |
| 66 | |
| 67 | with cn.cursor() as cr: |
| 68 | cr.execute('drop database if exists %s', (AsIs(dbname),)) |
| 69 | |
| 70 | close_cn(cn) |
| 71 | |
| 72 | |
| 73 | def close_cn(cn=None): |