Drop database. :param hostname: string :param username: string :param password: string :param dbname: string
(hostname="localhost", username=None, password=None, dbname=None, port=None)
| 54 | |
| 55 | |
| 56 | def drop_db(hostname="localhost", username=None, password=None, dbname=None, port=None): |
| 57 | """ |
| 58 | Drop database. |
| 59 | :param hostname: string |
| 60 | :param username: string |
| 61 | :param password: string |
| 62 | :param dbname: string |
| 63 | """ |
| 64 | cn = create_cn(hostname, password, username, "postgres", port) |
| 65 | |
| 66 | # Needed for DB drop. |
| 67 | cn.autocommit = True |
| 68 | |
| 69 | with cn.cursor() as cr: |
| 70 | cr.execute(f"drop database if exists {dbname}") |
| 71 | |
| 72 | close_cn(cn) |
| 73 | |
| 74 | |
| 75 | def close_cn(cn=None): |