#!/usr/bin/env python3
"""
Create translator_api database
"""

import psycopg2
from psycopg2.extensions import ISOLATION_LEVEL_AUTOCOMMIT

def create_database():
    """Create the translator_api database"""
    try:
        # Connect to PostgreSQL server (not to a specific database)
        conn = psycopg2.connect(
            host="localhost",
            port=5432,
            user="postgres",
            password="newsecurepassword123",
            database="postgres"  # Connect to default postgres database
        )
        conn.set_isolation_level(ISOLATION_LEVEL_AUTOCOMMIT)
        
        cursor = conn.cursor()
        
        # Check if database exists
        cursor.execute("SELECT 1 FROM pg_database WHERE datname = 'translator_api';")
        exists = cursor.fetchone()
        
        if exists:
            print("Database 'translator_api' already exists!")
        else:
            # Create the database
            cursor.execute("CREATE DATABASE translator_api;")
            print("Database 'translator_api' created successfully!")
        
        cursor.close()
        conn.close()
        
    except psycopg2.Error as e:
        print(f"Error creating database: {e}")
        return False
    
    return True

if __name__ == "__main__":
    print("Creating translator_api database...")
    create_database()