import logging
import psycopg2

from emily_backend import settings # pass Your settings here

db_config = settings.DATABASES.get('default')
logger = logging.getLogger(__name__)

try:
    conn = psycopg2.connect(f""
                            f"dbname='postgres' "
                            f"user='postgres' "
                            f"port='{db_config.get('PORT')}' "
                            f"host='{db_config.get('HOST') }' "
                            f"password='postgres'"
                            )

    conn.set_isolation_level(0)
    cursor = conn.cursor()

    cursor.execute(f"CREATE DATABASE {db_config.get('NAME')}")
    cursor.execute(f"CREATE ROLE {db_config.get('USER')} WITH PASSWORD \'{db_config.get('PASSWORD')}\'")
    cursor.execute(f"ALTER ROLE {db_config.get('USER')} WITH LOGIN")
    cursor.execute(f"ALTER ROLE {db_config.get('USER')} CREATEDB")
    cursor.execute(f"GRANT ALL PRIVILEGES ON DATABASE {db_config.get('NAME')} TO {db_config.get('USER')}")

except:
    logger.warning("Initialization failed, skipping")