#do not change
aa={'PGRES_TimezoneTable.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_744000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timezone_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_DateTable.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_025000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Date_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_Table.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_306000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_Table.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_291000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_ShardedPartition.DDL_File': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_571000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Partitioned_test_from', 'From table.'), 'from_any_partition': ('-P', '--from_any_partition', 'Partitioned_test_from_2014', 'From partition.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_ShardedPartition.ddl', 'To DDL file.')}], 'PGRES_ShardedTable.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151406_103000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_ParallelQueryDir.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_666000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'), 'query_sql_dir': ('-Q', '--query_sql_dir', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres', 'Input dir with PostgreSQL query files sql.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_QueryFile.DDL_File': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_337000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q', '--query_sql_file', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql', 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_QueryFile.ddl', 'To DDL file.')}], 'PGRES_TimestampTable.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_806000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_Partition.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151406_040000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Partitioned_test_from', 'From table.'), 'from_any_partition': ('-P', '--from_any_partition', 'Partitioned_test_from_2014', 'From partition.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_QueryDir.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_150000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'), 'query_sql_dir': ('-Q', '--query_sql_dir', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres', 'Input dir with PostgreSQL query files sql.')}, {}], 'PGRES_Table_Limit15.DDL_File': [{'lame_duck': ('-l', '--lame_duck', 15, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_415000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_Table_Limit15.ddl', 'To DDL file.')}], 'PGRES_Table_KeepSpoolFile.DDL_File': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_197000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_Table_KeepSpoolFile.ddl', 'To DDL file.')}], 'PGRES_QueryDir.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_166000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'), 'query_sql_dir': ('-Q', '--query_sql_dir', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres', 'Input dir with PostgreSQL query files sql.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_QueryFile_Limit11.DDL_File': [{'lame_duck': ('-l', '--lame_duck', 11, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_493000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q', '--query_sql_file', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql', 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_QueryFile_Limit11.ddl', 'To DDL file.')}], 'PGRES_QueryFile_Limit11.DDL_Default': [{'lame_duck': ('-l', '--lame_duck', 11, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_509000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q', '--query_sql_file', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql', 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_QueryDir_Limit12.DDL_Dir': [{'lame_duck': ('-l', '--lame_duck', 12, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_119000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'), 'query_sql_dir': ('-Q', '--query_sql_dir', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres', 'Input dir with PostgreSQL query files sql.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_Table_KeepSpoolFile.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_244000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_Table_Limit15.DDL_Default': [{'lame_duck': ('-l', '--lame_duck', 15, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_447000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_QueryFile_Limit11.DDL_Dir': [{'lame_duck': ('-l', '--lame_duck', 11, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_540000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q', '--query_sql_file', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql', 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_ShardedTable.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151406_087000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_ShardedQueryFile.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_853000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q', '--query_sql_file', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql', 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_ParallelQueryDir.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_635000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'), 'query_sql_dir': ('-Q', '--query_sql_dir', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres', 'Input dir with PostgreSQL query files sql.')}, {}], 'PGRES_Partition_Limit33.DDL_Default': [{'lame_duck': ('-l', '--lame_duck', 33, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_931000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Partitioned_test_from', 'From table.'), 'from_any_partition': ('-P', '--from_any_partition', 'Partitioned_test_from_2014', 'From partition.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_DateTable.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_057000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Date_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_TimestampTable.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_791000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_TimezoneTable.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_713000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timezone_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_QueryFile.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_369000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q', '--query_sql_file', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql', 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_ShardedPartition.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_618000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Partitioned_test_from', 'From table.'), 'from_any_partition': ('-P', '--from_any_partition', 'Partitioned_test_from_2014', 'From partition.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_Table_Limit15.DDL_Dir': [{'lame_duck': ('-l', '--lame_duck', 15, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_462000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_Partition.DDL_File': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_978000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Partitioned_test_from', 'From table.'), 'from_any_partition': ('-P', '--from_any_partition', 'Partitioned_test_from_2014', 'From partition.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_Partition.ddl', 'To DDL file.')}], 'PGRES_QueryDir_Limit12.DDL_Default': [{'lame_duck': ('-l', '--lame_duck', 12, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_103000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'), 'query_sql_dir': ('-Q', '--query_sql_dir', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres', 'Input dir with PostgreSQL query files sql.')}, {}], 'PGRES_Partition_Limit33.DDL_File': [{'lame_duck': ('-l', '--lame_duck', 33, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_916000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Partitioned_test_from', 'From table.'), 'from_any_partition': ('-P', '--from_any_partition', 'Partitioned_test_from_2014', 'From partition.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_Partition_Limit33.ddl', 'To DDL file.')}], 'PGRES_Partition.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151406_009000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Partitioned_test_from', 'From table.'), 'from_any_partition': ('-P', '--from_any_partition', 'Partitioned_test_from_2014', 'From partition.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_ShardedTable.DDL_File': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151406_056000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_ShardedTable.ddl', 'To DDL file.')}], 'PGRES_QueryDir_Limit12.DDL_File': [{'lame_duck': ('-l', '--lame_duck', 12, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_072000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'), 'query_sql_dir': ('-Q', '--query_sql_dir', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres', 'Input dir with PostgreSQL query files sql.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_QueryDir_Limit12.ddl', 'To DDL file.')}], 'default': [{'ask_to_truncate': ['-E', '--ask_to_truncate', '', 'Ask to truncate.'], 'shard_pre_etl': ['-2', '--shard_pre_etl', '', 'Path to shard level pre-ETL Python script.'], 'keep_data_file': ['-K', '--keep_data_file', '', 'Keep data dump.'], 'default_spool_dir': ['-F', '--default_spool_dir', '', 'Default data dump dir (default_spool_dir/job_name/timestamp).'], 'arg_6': ['-6', '--arg_6', '', 'Generic string argument 1.'], 'lame_duck': ['-l', '--lame_duck', '', 'Limit rows (lame duck run).'], 'copy_vector': ['-w', '--copy_vector', '', 'Data copy direction.'], 'log_dir': ['-M', '--log_dir', '', 'Log destination.'], 'time_stamp': ['-Y', '--time_stamp', '', 'Timestamp (log_dir/job_name/timestamp).'], 'job_name': ['-B', '--job_name', '', 'Job name (log_dir/job_name).'], 'job_pre_etl': ['-1', '--job_pre_etl', '', 'Path to job level pre-ETL Python script.'], 'num_of_shards': ['-r', '--num_of_shards', '', 'Number of shards.'], 'loader_profile': ['-C', '--loader_profile', '', 'SQL*Loader profile (user defined).'], 'email_to': ['-L', '--email_to', '', 'Email job status.'], 'host_map': ['-5', '--host_map', '', 'Host-to-shard map.'], 'arg_8': ['-8', '--arg_8', '', 'Generic string argument 3.'], 'validate': ['-V', '--validate', '', 'Check if source and target objects exist.'], 'arg_7': ['-7', '--arg_7', '', 'Generic string argument 2.'], 'field_term': ['-t', '--field_term', '', 'Field terminator.'], 'pool_size': ['-o', '--pool_size', '', 'Pool size.'], 'column_buckets': ['-0', '--column_buckets', '', 'Wide row support.'], 'job_post_etl': ['-3', '--job_post_etl', '', 'Jobs post-etl script.'], 'truncate_target': ['-U', '--truncate_target', '', 'Truncate target table/partition/subpartition.'], 'shard_post_etl': ['-4', '--shard_post_etl', '', 'Shards post-etl script.'], 'key_on_exit': ['-X', '--key_on_exit', '', 'Ask for an "Enter" key upon exit.']}, {'query_sql_file': ['-q', '--query_sql_file', '', 'Input file with PostgreSQL query sql.'], 'from_db_name': ['-b', '--from_db_name', '', 'PostgreSQL source database.'], 'from_table': ['-c', '--from_table', '', 'From table.'], 'from_any_partition': ['-P', '--from_any_partition', '', 'From partition.'], 'source_client_home': ['-z', '--source_client_home', '', 'Path to PostgreSQL client home.'], 'from_user': ['-j', '--from_user', '', 'PostgreSQL source user.'], 'source_port': ['-R', '--source_port', '', 'Connection port for source PostgreSQL.'], 'from_passwd': ['-x', '--from_passwd', '', 'PostgreSQL source user password.'], 'from_db_server': ['-n', '--from_db_server', '', 'PostgreSQL source instance name.'], 'query_sql_dir': ['-Q', '--query_sql_dir', '', 'Input dir with PostgreSQL query files sql.']}, {'to_file': ['-g', '--to_file', '', 'To DDL file.'], 'to_dir': ['-D', '--to_dir', '', 'To directory.']}], 'PGRES_Table.DDL_File': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_259000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_Table.ddl', 'To DDL file.')}], 'PGRES_Table_KeepSpoolFile.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_213000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_ShardedQueryFile.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_884000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q', '--query_sql_file', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql', 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_TimestampTable.DDL_File': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_760000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_TimestampTable.ddl', 'To DDL file.')}], 'PGRES_Partition_Limit33.DDL_Dir': [{'lame_duck': ('-l', '--lame_duck', 33, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_962000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Partitioned_test_from', 'From table.'), 'from_any_partition': ('-P', '--from_any_partition', 'Partitioned_test_from_2014', 'From partition.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_ShardedQueryFile.DDL_File': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_838000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q', '--query_sql_file', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql', 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_ShardedQueryFile.ddl', 'To DDL file.')}], 'PGRES_TimezoneTable.DDL_File': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_682000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timezone_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_TimezoneTable.ddl', 'To DDL file.')}], 'PGRES_ShardedPartition.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_587000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Partitioned_test_from', 'From table.'), 'from_any_partition': ('-P', '--from_any_partition', 'Partitioned_test_from_2014', 'From partition.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_QueryFile.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_384000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q', '--query_sql_file', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql', 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}]}
69bdc13813ce9d630b33f5e6e052cb28e351dd3d
<mask token>

aa = {'PGRES_TimezoneTable.DDL_Dir': [{'field_term': ('-t', '--field_term',
    '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards',
    1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1,
    'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl',
    'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1,
    'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_744000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Timezone_test_from',
    'From table.'), 'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_dir': ('-D', '--to_dir',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}],
    'PGRES_DateTable.DDL_Default': [{'field_term': ('-t', '--field_term',
    '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards',
    1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1,
    'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl',
    'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1,
    'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_025000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Date_test_from', 'From table.'),
    'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {}], 'PGRES_Table.DDL_Dir': [{'field_term': ('-t', '--field_term',
    '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards',
    1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1,
    'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl',
    'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1,
    'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_306000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Timestamp_test_from',
    'From table.'), 'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_dir': ('-D', '--to_dir',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}],
    'PGRES_Table.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"',
    'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1,
    'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1,
    'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl',
    'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1,
    'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_291000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Timestamp_test_from',
    'From table.'), 'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {}], 'PGRES_ShardedPartition.DDL_File': [{'field_term': ('-t',
    '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r',
    '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_571000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Partitioned_test_from',
    'From table.'), 'from_any_partition': ('-P', '--from_any_partition',
    'Partitioned_test_from_2014', 'From partition.'), 'source_client_home':
    ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_file': ('-g', '--to_file',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_ShardedPartition.ddl'
    , 'To DDL file.')}], 'PGRES_ShardedTable.DDL_Dir': [{'field_term': (
    '-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': (
    '-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151406_103000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Timestamp_test_from',
    'From table.'), 'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_dir': ('-D', '--to_dir',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}],
    'PGRES_ParallelQueryDir.DDL_Dir': [{'field_term': ('-t', '--field_term',
    '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards',
    3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3,
    'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl',
    'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1,
    'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_666000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'),
    'query_sql_dir': ('-Q', '--query_sql_dir',
    'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres',
    'Input dir with PostgreSQL query files sql.')}, {'to_dir': ('-D',
    '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT',
    'To directory.')}], 'PGRES_QueryFile.DDL_File': [{'field_term': ('-t',
    '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r',
    '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_337000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q',
    '--query_sql_file',
    'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql'
    , 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_file': ('-g', '--to_file',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_QueryFile.ddl',
    'To DDL file.')}], 'PGRES_TimestampTable.DDL_Dir': [{'field_term': (
    '-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': (
    '-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_806000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Timestamp_test_from',
    'From table.'), 'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_dir': ('-D', '--to_dir',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}],
    'PGRES_Partition.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"',
    'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1,
    'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1,
    'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl',
    'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1,
    'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151406_040000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Partitioned_test_from',
    'From table.'), 'from_any_partition': ('-P', '--from_any_partition',
    'Partitioned_test_from_2014', 'From partition.'), 'source_client_home':
    ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_dir': ('-D', '--to_dir',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}],
    'PGRES_QueryDir.DDL_Default': [{'field_term': ('-t', '--field_term',
    '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards',
    1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1,
    'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl',
    'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1,
    'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_150000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'),
    'query_sql_dir': ('-Q', '--query_sql_dir',
    'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres',
    'Input dir with PostgreSQL query files sql.')}, {}],
    'PGRES_Table_Limit15.DDL_File': [{'lame_duck': ('-l', '--lame_duck', 15,
    'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term',
    '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards',
    1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1,
    'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl',
    'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1,
    'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_415000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Timestamp_test_from',
    'From table.'), 'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_file': ('-g', '--to_file',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_Table_Limit15.ddl'
    , 'To DDL file.')}], 'PGRES_Table_KeepSpoolFile.DDL_File': [{
    'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'),
    'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'),
    'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': (
    '-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'),
    'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'),
    'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_197000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Timestamp_test_from',
    'From table.'), 'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_file': ('-g', '--to_file',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_Table_KeepSpoolFile.ddl'
    , 'To DDL file.')}], 'PGRES_QueryDir.DDL_Dir': [{'field_term': ('-t',
    '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r',
    '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_166000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'),
    'query_sql_dir': ('-Q', '--query_sql_dir',
    'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres',
    'Input dir with PostgreSQL query files sql.')}, {'to_dir': ('-D',
    '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT',
    'To directory.')}], 'PGRES_QueryFile_Limit11.DDL_File': [{'lame_duck':
    ('-l', '--lame_duck', 11, 'Limit rows (lame duck run).'), 'field_term':
    ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': (
    '-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_493000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q',
    '--query_sql_file',
    'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql'
    , 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_file': ('-g', '--to_file',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_QueryFile_Limit11.ddl'
    , 'To DDL file.')}], 'PGRES_QueryFile_Limit11.DDL_Default': [{
    'lame_duck': ('-l', '--lame_duck', 11, 'Limit rows (lame duck run).'),
    'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'),
    'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'),
    'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': (
    '-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'),
    'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'),
    'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_509000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q',
    '--query_sql_file',
    'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql'
    , 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {}], 'PGRES_QueryDir_Limit12.DDL_Dir': [{'lame_duck': ('-l',
    '--lame_duck', 12, 'Limit rows (lame duck run).'), 'field_term': ('-t',
    '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r',
    '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_119000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'),
    'query_sql_dir': ('-Q', '--query_sql_dir',
    'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres',
    'Input dir with PostgreSQL query files sql.')}, {'to_dir': ('-D',
    '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT',
    'To directory.')}], 'PGRES_Table_KeepSpoolFile.DDL_Dir': [{'field_term':
    ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': (
    '-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_244000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Timestamp_test_from',
    'From table.'), 'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_dir': ('-D', '--to_dir',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}],
    'PGRES_Table_Limit15.DDL_Default': [{'lame_duck': ('-l', '--lame_duck',
    15, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term',
    '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards',
    1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1,
    'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl',
    'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1,
    'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_447000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Timestamp_test_from',
    'From table.'), 'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {}], 'PGRES_QueryFile_Limit11.DDL_Dir': [{'lame_duck': ('-l',
    '--lame_duck', 11, 'Limit rows (lame duck run).'), 'field_term': ('-t',
    '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r',
    '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_540000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q',
    '--query_sql_file',
    'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql'
    , 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_dir': ('-D', '--to_dir',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}],
    'PGRES_ShardedTable.DDL_Default': [{'field_term': ('-t', '--field_term',
    '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards',
    3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3,
    'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl',
    'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1,
    'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151406_087000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Timestamp_test_from',
    'From table.'), 'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {}], 'PGRES_ShardedQueryFile.DDL_Default': [{'field_term': ('-t',
    '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r',
    '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_853000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q',
    '--query_sql_file',
    'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql'
    , 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {}], 'PGRES_ParallelQueryDir.DDL_Default': [{'field_term': ('-t',
    '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r',
    '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_635000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'),
    'query_sql_dir': ('-Q', '--query_sql_dir',
    'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres',
    'Input dir with PostgreSQL query files sql.')}, {}],
    'PGRES_Partition_Limit33.DDL_Default': [{'lame_duck': ('-l',
    '--lame_duck', 33, 'Limit rows (lame duck run).'), 'field_term': ('-t',
    '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r',
    '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_931000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Partitioned_test_from',
    'From table.'), 'from_any_partition': ('-P', '--from_any_partition',
    'Partitioned_test_from_2014', 'From partition.'), 'source_client_home':
    ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {}], 'PGRES_DateTable.DDL_Dir': [{'field_term': ('-t', '--field_term',
    '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards',
    1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1,
    'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl',
    'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1,
    'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_057000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Date_test_from', 'From table.'),
    'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_dir': ('-D', '--to_dir',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}],
    'PGRES_TimestampTable.DDL_Default': [{'field_term': ('-t',
    '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r',
    '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_791000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Timestamp_test_from',
    'From table.'), 'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {}], 'PGRES_TimezoneTable.DDL_Default': [{'field_term': ('-t',
    '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r',
    '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_713000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Timezone_test_from',
    'From table.'), 'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {}], 'PGRES_QueryFile.DDL_Default': [{'field_term': ('-t',
    '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r',
    '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_369000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q',
    '--query_sql_file',
    'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql'
    , 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {}], 'PGRES_ShardedPartition.DDL_Dir': [{'field_term': ('-t',
    '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r',
    '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_618000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Partitioned_test_from',
    'From table.'), 'from_any_partition': ('-P', '--from_any_partition',
    'Partitioned_test_from_2014', 'From partition.'), 'source_client_home':
    ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_dir': ('-D', '--to_dir',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}],
    'PGRES_Table_Limit15.DDL_Dir': [{'lame_duck': ('-l', '--lame_duck', 15,
    'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term',
    '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards',
    1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1,
    'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl',
    'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1,
    'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_462000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Timestamp_test_from',
    'From table.'), 'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_dir': ('-D', '--to_dir',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}],
    'PGRES_Partition.DDL_File': [{'field_term': ('-t', '--field_term',
    '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards',
    1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1,
    'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl',
    'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1,
    'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_978000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Partitioned_test_from',
    'From table.'), 'from_any_partition': ('-P', '--from_any_partition',
    'Partitioned_test_from_2014', 'From partition.'), 'source_client_home':
    ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_file': ('-g', '--to_file',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_Partition.ddl',
    'To DDL file.')}], 'PGRES_QueryDir_Limit12.DDL_Default': [{'lame_duck':
    ('-l', '--lame_duck', 12, 'Limit rows (lame duck run).'), 'field_term':
    ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': (
    '-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_103000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'),
    'query_sql_dir': ('-Q', '--query_sql_dir',
    'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres',
    'Input dir with PostgreSQL query files sql.')}, {}],
    'PGRES_Partition_Limit33.DDL_File': [{'lame_duck': ('-l', '--lame_duck',
    33, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term',
    '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards',
    1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1,
    'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl',
    'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1,
    'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_916000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Partitioned_test_from',
    'From table.'), 'from_any_partition': ('-P', '--from_any_partition',
    'Partitioned_test_from_2014', 'From partition.'), 'source_client_home':
    ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_file': ('-g', '--to_file',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_Partition_Limit33.ddl'
    , 'To DDL file.')}], 'PGRES_Partition.DDL_Default': [{'field_term': (
    '-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': (
    '-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151406_009000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Partitioned_test_from',
    'From table.'), 'from_any_partition': ('-P', '--from_any_partition',
    'Partitioned_test_from_2014', 'From partition.'), 'source_client_home':
    ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {}], 'PGRES_ShardedTable.DDL_File': [{'field_term': ('-t',
    '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r',
    '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151406_056000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Timestamp_test_from',
    'From table.'), 'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_file': ('-g', '--to_file',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_ShardedTable.ddl'
    , 'To DDL file.')}], 'PGRES_QueryDir_Limit12.DDL_File': [{'lame_duck':
    ('-l', '--lame_duck', 12, 'Limit rows (lame duck run).'), 'field_term':
    ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': (
    '-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_072000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'),
    'query_sql_dir': ('-Q', '--query_sql_dir',
    'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres',
    'Input dir with PostgreSQL query files sql.')}, {'to_file': ('-g',
    '--to_file',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_QueryDir_Limit12.ddl'
    , 'To DDL file.')}], 'default': [{'ask_to_truncate': ['-E',
    '--ask_to_truncate', '', 'Ask to truncate.'], 'shard_pre_etl': ['-2',
    '--shard_pre_etl', '', 'Path to shard level pre-ETL Python script.'],
    'keep_data_file': ['-K', '--keep_data_file', '', 'Keep data dump.'],
    'default_spool_dir': ['-F', '--default_spool_dir', '',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'],
    'arg_6': ['-6', '--arg_6', '', 'Generic string argument 1.'],
    'lame_duck': ['-l', '--lame_duck', '', 'Limit rows (lame duck run).'],
    'copy_vector': ['-w', '--copy_vector', '', 'Data copy direction.'],
    'log_dir': ['-M', '--log_dir', '', 'Log destination.'], 'time_stamp': [
    '-Y', '--time_stamp', '', 'Timestamp (log_dir/job_name/timestamp).'],
    'job_name': ['-B', '--job_name', '', 'Job name (log_dir/job_name).'],
    'job_pre_etl': ['-1', '--job_pre_etl', '',
    'Path to job level pre-ETL Python script.'], 'num_of_shards': ['-r',
    '--num_of_shards', '', 'Number of shards.'], 'loader_profile': ['-C',
    '--loader_profile', '', 'SQL*Loader profile (user defined).'],
    'email_to': ['-L', '--email_to', '', 'Email job status.'], 'host_map':
    ['-5', '--host_map', '', 'Host-to-shard map.'], 'arg_8': ['-8',
    '--arg_8', '', 'Generic string argument 3.'], 'validate': ['-V',
    '--validate', '', 'Check if source and target objects exist.'], 'arg_7':
    ['-7', '--arg_7', '', 'Generic string argument 2.'], 'field_term': [
    '-t', '--field_term', '', 'Field terminator.'], 'pool_size': ['-o',
    '--pool_size', '', 'Pool size.'], 'column_buckets': ['-0',
    '--column_buckets', '', 'Wide row support.'], 'job_post_etl': ['-3',
    '--job_post_etl', '', 'Jobs post-etl script.'], 'truncate_target': [
    '-U', '--truncate_target', '',
    'Truncate target table/partition/subpartition.'], 'shard_post_etl': [
    '-4', '--shard_post_etl', '', 'Shards post-etl script.'], 'key_on_exit':
    ['-X', '--key_on_exit', '', 'Ask for an "Enter" key upon exit.']}, {
    'query_sql_file': ['-q', '--query_sql_file', '',
    'Input file with PostgreSQL query sql.'], 'from_db_name': ['-b',
    '--from_db_name', '', 'PostgreSQL source database.'], 'from_table': [
    '-c', '--from_table', '', 'From table.'], 'from_any_partition': ['-P',
    '--from_any_partition', '', 'From partition.'], 'source_client_home': [
    '-z', '--source_client_home', '', 'Path to PostgreSQL client home.'],
    'from_user': ['-j', '--from_user', '', 'PostgreSQL source user.'],
    'source_port': ['-R', '--source_port', '',
    'Connection port for source PostgreSQL.'], 'from_passwd': ['-x',
    '--from_passwd', '', 'PostgreSQL source user password.'],
    'from_db_server': ['-n', '--from_db_server', '',
    'PostgreSQL source instance name.'], 'query_sql_dir': ['-Q',
    '--query_sql_dir', '', 'Input dir with PostgreSQL query files sql.']},
    {'to_file': ['-g', '--to_file', '', 'To DDL file.'], 'to_dir': ['-D',
    '--to_dir', '', 'To directory.']}], 'PGRES_Table.DDL_File': [{
    'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'),
    'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'),
    'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': (
    '-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'),
    'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'),
    'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_259000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Timestamp_test_from',
    'From table.'), 'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_file': ('-g', '--to_file',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_Table.ddl',
    'To DDL file.')}], 'PGRES_Table_KeepSpoolFile.DDL_Default': [{
    'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'),
    'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'),
    'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': (
    '-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'),
    'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'),
    'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_213000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Timestamp_test_from',
    'From table.'), 'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {}], 'PGRES_ShardedQueryFile.DDL_Dir': [{'field_term': ('-t',
    '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r',
    '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_884000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q',
    '--query_sql_file',
    'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql'
    , 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_dir': ('-D', '--to_dir',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}],
    'PGRES_TimestampTable.DDL_File': [{'field_term': ('-t', '--field_term',
    '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards',
    1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1,
    'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl',
    'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1,
    'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_760000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Timestamp_test_from',
    'From table.'), 'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_file': ('-g', '--to_file',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_TimestampTable.ddl'
    , 'To DDL file.')}], 'PGRES_Partition_Limit33.DDL_Dir': [{'lame_duck':
    ('-l', '--lame_duck', 33, 'Limit rows (lame duck run).'), 'field_term':
    ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': (
    '-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_962000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Partitioned_test_from',
    'From table.'), 'from_any_partition': ('-P', '--from_any_partition',
    'Partitioned_test_from_2014', 'From partition.'), 'source_client_home':
    ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_dir': ('-D', '--to_dir',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}],
    'PGRES_ShardedQueryFile.DDL_File': [{'field_term': ('-t',
    '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r',
    '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_838000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q',
    '--query_sql_file',
    'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql'
    , 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_file': ('-g', '--to_file',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_ShardedQueryFile.ddl'
    , 'To DDL file.')}], 'PGRES_TimezoneTable.DDL_File': [{'field_term': (
    '-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': (
    '-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o',
    '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector',
    'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K',
    '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F',
    '--default_spool_dir', 'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_682000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Timezone_test_from',
    'From table.'), 'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_file': ('-g', '--to_file',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_TimezoneTable.ddl'
    , 'To DDL file.')}], 'PGRES_ShardedPartition.DDL_Default': [{
    'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'),
    'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'),
    'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': (
    '-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'),
    'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'),
    'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_587000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'from_table': ('-c', '--from_table', 'Partitioned_test_from',
    'From table.'), 'from_any_partition': ('-P', '--from_any_partition',
    'Partitioned_test_from_2014', 'From partition.'), 'source_client_home':
    ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {}], 'PGRES_QueryFile.DDL_Dir': [{'field_term': ('-t', '--field_term',
    '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards',
    1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1,
    'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl',
    'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1,
    'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir',
    'C:\\tmp\\TEST_default_spool',
    'Default data dump dir (default_spool_dir/job_name/timestamp).'),
    'time_stamp': ('-Y', '--time_stamp', '20150515_151405_384000',
    'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5',
    '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'),
    'job_name': ('-B', '--job_name', 'qc_job',
    'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir',
    'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q',
    '--query_sql_file',
    'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql'
    , 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b',
    '--from_db_name', '"postgres"', 'PostgreSQL source database.'),
    'source_client_home': ('-z', '--source_client_home',
    '"C:\\Program Files\\PostgreSQL\\9.4\\bin"',
    'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user',
    '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R',
    '--source_port', '5434', 'Connection port for source PostgreSQL.'),
    'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"',
    'PostgreSQL source user password.'), 'from_db_server': ('-n',
    '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')},
    {'to_dir': ('-D', '--to_dir',
    'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}]}

#do not change
aa={'PGRES_TimezoneTable.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_744000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timezone_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_DateTable.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_025000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Date_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_Table.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_306000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_Table.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_291000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_ShardedPartition.DDL_File': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_571000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Partitioned_test_from', 'From table.'), 'from_any_partition': ('-P', '--from_any_partition', 'Partitioned_test_from_2014', 'From partition.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_ShardedPartition.ddl', 'To DDL file.')}], 'PGRES_ShardedTable.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151406_103000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_ParallelQueryDir.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_666000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'), 'query_sql_dir': ('-Q', '--query_sql_dir', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres', 'Input dir with PostgreSQL query files sql.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_QueryFile.DDL_File': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_337000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q', '--query_sql_file', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql', 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_QueryFile.ddl', 'To DDL file.')}], 'PGRES_TimestampTable.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_806000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_Partition.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151406_040000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Partitioned_test_from', 'From table.'), 'from_any_partition': ('-P', '--from_any_partition', 'Partitioned_test_from_2014', 'From partition.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_QueryDir.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_150000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'), 'query_sql_dir': ('-Q', '--query_sql_dir', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres', 'Input dir with PostgreSQL query files sql.')}, {}], 'PGRES_Table_Limit15.DDL_File': [{'lame_duck': ('-l', '--lame_duck', 15, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_415000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_Table_Limit15.ddl', 'To DDL file.')}], 'PGRES_Table_KeepSpoolFile.DDL_File': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_197000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_Table_KeepSpoolFile.ddl', 'To DDL file.')}], 'PGRES_QueryDir.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_166000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'), 'query_sql_dir': ('-Q', '--query_sql_dir', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres', 'Input dir with PostgreSQL query files sql.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_QueryFile_Limit11.DDL_File': [{'lame_duck': ('-l', '--lame_duck', 11, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_493000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q', '--query_sql_file', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql', 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_QueryFile_Limit11.ddl', 'To DDL file.')}], 'PGRES_QueryFile_Limit11.DDL_Default': [{'lame_duck': ('-l', '--lame_duck', 11, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_509000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q', '--query_sql_file', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql', 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_QueryDir_Limit12.DDL_Dir': [{'lame_duck': ('-l', '--lame_duck', 12, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_119000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'), 'query_sql_dir': ('-Q', '--query_sql_dir', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres', 'Input dir with PostgreSQL query files sql.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_Table_KeepSpoolFile.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_244000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_Table_Limit15.DDL_Default': [{'lame_duck': ('-l', '--lame_duck', 15, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_447000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_QueryFile_Limit11.DDL_Dir': [{'lame_duck': ('-l', '--lame_duck', 11, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_540000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q', '--query_sql_file', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql', 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_ShardedTable.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151406_087000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_ShardedQueryFile.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_853000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q', '--query_sql_file', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql', 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_ParallelQueryDir.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_635000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'), 'query_sql_dir': ('-Q', '--query_sql_dir', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres', 'Input dir with PostgreSQL query files sql.')}, {}], 'PGRES_Partition_Limit33.DDL_Default': [{'lame_duck': ('-l', '--lame_duck', 33, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_931000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Partitioned_test_from', 'From table.'), 'from_any_partition': ('-P', '--from_any_partition', 'Partitioned_test_from_2014', 'From partition.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_DateTable.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_057000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Date_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_TimestampTable.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_791000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_TimezoneTable.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_713000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timezone_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_QueryFile.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_369000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q', '--query_sql_file', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql', 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_ShardedPartition.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_618000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Partitioned_test_from', 'From table.'), 'from_any_partition': ('-P', '--from_any_partition', 'Partitioned_test_from_2014', 'From partition.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_Table_Limit15.DDL_Dir': [{'lame_duck': ('-l', '--lame_duck', 15, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_462000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_Partition.DDL_File': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_978000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Partitioned_test_from', 'From table.'), 'from_any_partition': ('-P', '--from_any_partition', 'Partitioned_test_from_2014', 'From partition.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_Partition.ddl', 'To DDL file.')}], 'PGRES_QueryDir_Limit12.DDL_Default': [{'lame_duck': ('-l', '--lame_duck', 12, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_103000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'), 'query_sql_dir': ('-Q', '--query_sql_dir', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres', 'Input dir with PostgreSQL query files sql.')}, {}], 'PGRES_Partition_Limit33.DDL_File': [{'lame_duck': ('-l', '--lame_duck', 33, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_916000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Partitioned_test_from', 'From table.'), 'from_any_partition': ('-P', '--from_any_partition', 'Partitioned_test_from_2014', 'From partition.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_Partition_Limit33.ddl', 'To DDL file.')}], 'PGRES_Partition.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151406_009000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Partitioned_test_from', 'From table.'), 'from_any_partition': ('-P', '--from_any_partition', 'Partitioned_test_from_2014', 'From partition.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_ShardedTable.DDL_File': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151406_056000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_ShardedTable.ddl', 'To DDL file.')}], 'PGRES_QueryDir_Limit12.DDL_File': [{'lame_duck': ('-l', '--lame_duck', 12, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_072000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.'), 'query_sql_dir': ('-Q', '--query_sql_dir', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\query_dir_pgres', 'Input dir with PostgreSQL query files sql.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_QueryDir_Limit12.ddl', 'To DDL file.')}], 'default': [{'ask_to_truncate': ['-E', '--ask_to_truncate', '', 'Ask to truncate.'], 'shard_pre_etl': ['-2', '--shard_pre_etl', '', 'Path to shard level pre-ETL Python script.'], 'keep_data_file': ['-K', '--keep_data_file', '', 'Keep data dump.'], 'default_spool_dir': ['-F', '--default_spool_dir', '', 'Default data dump dir (default_spool_dir/job_name/timestamp).'], 'arg_6': ['-6', '--arg_6', '', 'Generic string argument 1.'], 'lame_duck': ['-l', '--lame_duck', '', 'Limit rows (lame duck run).'], 'copy_vector': ['-w', '--copy_vector', '', 'Data copy direction.'], 'log_dir': ['-M', '--log_dir', '', 'Log destination.'], 'time_stamp': ['-Y', '--time_stamp', '', 'Timestamp (log_dir/job_name/timestamp).'], 'job_name': ['-B', '--job_name', '', 'Job name (log_dir/job_name).'], 'job_pre_etl': ['-1', '--job_pre_etl', '', 'Path to job level pre-ETL Python script.'], 'num_of_shards': ['-r', '--num_of_shards', '', 'Number of shards.'], 'loader_profile': ['-C', '--loader_profile', '', 'SQL*Loader profile (user defined).'], 'email_to': ['-L', '--email_to', '', 'Email job status.'], 'host_map': ['-5', '--host_map', '', 'Host-to-shard map.'], 'arg_8': ['-8', '--arg_8', '', 'Generic string argument 3.'], 'validate': ['-V', '--validate', '', 'Check if source and target objects exist.'], 'arg_7': ['-7', '--arg_7', '', 'Generic string argument 2.'], 'field_term': ['-t', '--field_term', '', 'Field terminator.'], 'pool_size': ['-o', '--pool_size', '', 'Pool size.'], 'column_buckets': ['-0', '--column_buckets', '', 'Wide row support.'], 'job_post_etl': ['-3', '--job_post_etl', '', 'Jobs post-etl script.'], 'truncate_target': ['-U', '--truncate_target', '', 'Truncate target table/partition/subpartition.'], 'shard_post_etl': ['-4', '--shard_post_etl', '', 'Shards post-etl script.'], 'key_on_exit': ['-X', '--key_on_exit', '', 'Ask for an "Enter" key upon exit.']}, {'query_sql_file': ['-q', '--query_sql_file', '', 'Input file with PostgreSQL query sql.'], 'from_db_name': ['-b', '--from_db_name', '', 'PostgreSQL source database.'], 'from_table': ['-c', '--from_table', '', 'From table.'], 'from_any_partition': ['-P', '--from_any_partition', '', 'From partition.'], 'source_client_home': ['-z', '--source_client_home', '', 'Path to PostgreSQL client home.'], 'from_user': ['-j', '--from_user', '', 'PostgreSQL source user.'], 'source_port': ['-R', '--source_port', '', 'Connection port for source PostgreSQL.'], 'from_passwd': ['-x', '--from_passwd', '', 'PostgreSQL source user password.'], 'from_db_server': ['-n', '--from_db_server', '', 'PostgreSQL source instance name.'], 'query_sql_dir': ['-Q', '--query_sql_dir', '', 'Input dir with PostgreSQL query files sql.']}, {'to_file': ['-g', '--to_file', '', 'To DDL file.'], 'to_dir': ['-D', '--to_dir', '', 'To directory.']}], 'PGRES_Table.DDL_File': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_259000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_Table.ddl', 'To DDL file.')}], 'PGRES_Table_KeepSpoolFile.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_213000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_ShardedQueryFile.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_884000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q', '--query_sql_file', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql', 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_TimestampTable.DDL_File': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_760000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timestamp_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_TimestampTable.ddl', 'To DDL file.')}], 'PGRES_Partition_Limit33.DDL_Dir': [{'lame_duck': ('-l', '--lame_duck', 33, 'Limit rows (lame duck run).'), 'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_962000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Partitioned_test_from', 'From table.'), 'from_any_partition': ('-P', '--from_any_partition', 'Partitioned_test_from_2014', 'From partition.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}], 'PGRES_ShardedQueryFile.DDL_File': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_838000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q', '--query_sql_file', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql', 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_ShardedQueryFile.ddl', 'To DDL file.')}], 'PGRES_TimezoneTable.DDL_File': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_682000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Timezone_test_from', 'From table.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_file': ('-g', '--to_file', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT\\testPGRES_TimezoneTable.ddl', 'To DDL file.')}], 'PGRES_ShardedPartition.DDL_Default': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 3, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 3, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_587000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'from_table': ('-c', '--from_table', 'Partitioned_test_from', 'From table.'), 'from_any_partition': ('-P', '--from_any_partition', 'Partitioned_test_from_2014', 'From partition.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {}], 'PGRES_QueryFile.DDL_Dir': [{'field_term': ('-t', '--field_term', '"|"', 'Field terminator.'), 'num_of_shards': ('-r', '--num_of_shards', 1, 'Number of shards.'), 'pool_size': ('-o', '--pool_size', 1, 'Pool size.'), 'copy_vector': ('-w', '--copy_vector', 'pgres-ddl', 'Data copy direction.'), 'keep_data_file': ('-K', '--keep_data_file', 1, 'Keep data dump.'), 'default_spool_dir': ('-F', '--default_spool_dir', 'C:\\tmp\\TEST_default_spool', 'Default data dump dir (default_spool_dir/job_name/timestamp).'), 'time_stamp': ('-Y', '--time_stamp', '20150515_151405_384000', 'Timestamp (log_dir/job_name/timestamp).'), 'host_map': ('-5', '--host_map', '".\\config\\host_map_v2.py"', 'Host-to-shard map.'), 'job_name': ('-B', '--job_name', 'qc_job', 'Job name (log_dir/job_name).'), 'log_dir': ('-M', '--log_dir', 'C:\\Temp\\qc_log', 'Log destination.')}, {'query_sql_file': ('-q', '--query_sql_file', 'C:\\Python27\\data_migrator_1239_12c\\test\\v101\\query\\postgre_query.sql', 'Input file with PostgreSQL query sql.'), 'from_db_name': ('-b', '--from_db_name', '"postgres"', 'PostgreSQL source database.'), 'source_client_home': ('-z', '--source_client_home', '"C:\\Program Files\\PostgreSQL\\9.4\\bin"', 'Path to PostgreSQL client home.'), 'from_user': ('-j', '--from_user', '"postgres"', 'PostgreSQL source user.'), 'source_port': ('-R', '--source_port', '5434', 'Connection port for source PostgreSQL.'), 'from_passwd': ('-x', '--from_passwd', '"postgre_pwd"', 'PostgreSQL source user password.'), 'from_db_server': ('-n', '--from_db_server', '"localhost"', 'PostgreSQL source instance name.')}, {'to_dir': ('-D', '--to_dir', 'C:\\Python27\\data_migrator_1239_12c\\DDL_OUT', 'To directory.')}]}