Untitled

def add_deploy_header(deployFile, schema):
    """
    Add deployment header with environment settings and schema validation
    """
    header = f"""spool Deploy_fk_trigger_{schema.lower()}.log
set serveroutput on size unlimited
set sqlblankline on
set timing on
ALTER SESSION SET CURRENT_SCHEMA={schema}
/
ALTER SESSION SET ddl_lock_timeout=1800
/
-- deploy detail print
SELECT
'-----------------------------------------------------------------'||chr(10)||
'DB name        : '||sys_context('userenv','db_name')||chr(10)||
'Instance name  : '||sys_context('userenv','instance_name')||chr(10)||
'Service name   : '||sys_context('userenv','service_name')||chr(10)||
'current schema : '||sys_context('userenv','current_schema')||chr(10)||
'user           : '||sys_context('userenv','current_user')||chr(10)||
'started at     : '||systimestamp||chr(10)||
'------------------------------------------------------------------' as deploy_detail
 from dual
/