import os
from string import Template as string_Template
from django.db import connection
from django.conf import settings

# --- EXECUTE.SQL.START --- #
if settings.AUTORUN_CUSTOM_MIGRATE:
	cfg_migrates_vars = dict(
		usr_pwd_default='8725b54dcced16bd1d4944600ae5e9349c525110',
	);

	cfg_migrates_base = os.path.join(settings.BASE_DIR,'migrates','postgre')
	cfg_migrates = os.listdir(cfg_migrates_base)
	cfg_migrates.sort()

	for cfg_migrate_name in cfg_migrates:
		cfg_migrate_path = os.path.join(cfg_migrates_base,cfg_migrate_name)
		print(cfg_migrate_path)
		with open(cfg_migrate_path, 'r') as fs:
			cfg_migrate_query = string_Template(fs.read().strip()).safe_substitute(**cfg_migrates_vars)

			if cfg_migrate_query:
				with connection.cursor() as cursor:
				    cursor.execute(cfg_migrate_query)
# --- EXECUTE.SQL.STOP --- #