Untitled

#Deployment files
add_deploy_header(schDeployFinalsql, sch, validation_schema)

# Add APM grants right after header
sql2script(schDeployFinalsql,f'------------\n-- APM Grants\n------------', True)
concat_files(schDeployFinalsql, schDeployGrantsql)

sql2script(schDeployFinalsql,f'------------\n-- Synonyms\n------------', True)
concat_files(schDeployFinalsql,schSynonymsql)
sql2script(schDeployFinalsql,f'------------\n-- Foreign Keys\n------------', True)
concat_files(schDeployFinalsql,schForeignKeysql)

# Add drop triggers before creating new triggers
sql2script(schDeployFinalsql,f'------------\n-- Drop Triggers\n------------', True)
concat_files(schDeployFinalsql, schDropTriggersql)

sql2script(schDeployFinalsql,f'------------\n-- Triggers\n------------', True)
concat_files_from_folder(sch_directory, schDeployFinalsql, 'trg_')
add_deploy_footer(schDeployFinalsql, validation_schema)