def _create_db_from_chain_via_python(self, from_database_configuration,
to_database_configuration,
tables_to_copy):
db_server_from = DatabaseServer(from_database_configuration)
db_server_to = DatabaseServer(to_database_configuration)
db_server_to.drop_database(to_database_configuration.database_name)
db_server_to.create_database(to_database_configuration.database_name)
database_out = db_server_to.get_database(
to_database_configuration.database_name)
scenario_db_manager = ScenarioDatabaseManager(
server_configuration=from_database_configuration,
base_scenario_database_name=from_database_configuration.
database_name)
table_mapping = scenario_db_manager.get_database_to_table_mapping()
cross_db_operations = CrossDatabaseOperations()
#by default, copy all tables
if tables_to_copy == []:
tables_to_copy = sum(table_mapping.values(),
[]) # flat a list of lists
elif 'scenario_information' not in tables_to_copy:
tables_to_copy.append('scenario_information')
for database_name, tables in table_mapping.items():
database_in = db_server_from.get_database(database_name)
for table in tables:
if table not in tables_to_copy:
continue
logger.start_block("Copying table '%s' from database '%s'" %
(table, database_name))
try:
cross_db_operations.copy_table(table_to_copy=table,
database_in=database_in,
database_out=database_out,
use_chunking=True)
finally:
logger.end_block()
database_in.close()
self._fix_scenario_information_table(database_out)
database_out.close()
db_server_from.close()
db_server_to.close()
def _create_db_from_chain_via_python(self,
from_database_configuration,
to_database_configuration,
tables_to_copy):
db_server_from = DatabaseServer(from_database_configuration)
db_server_to = DatabaseServer(to_database_configuration)
db_server_to.drop_database(to_database_configuration.database_name)
db_server_to.create_database(to_database_configuration.database_name)
database_out = db_server_to.get_database(to_database_configuration.database_name)
scenario_db_manager = ScenarioDatabaseManager(
server_configuration = from_database_configuration,
base_scenario_database_name = from_database_configuration.database_name)
table_mapping = scenario_db_manager.get_database_to_table_mapping()
cross_db_operations = CrossDatabaseOperations()
#by default, copy all tables
if tables_to_copy == []:
tables_to_copy = sum(table_mapping.values(), []) # flat a list of lists
elif 'scenario_information' not in tables_to_copy:
tables_to_copy.append('scenario_information')
for database_name, tables in table_mapping.items():
database_in = db_server_from.get_database(database_name)
for table in tables:
if table not in tables_to_copy:
continue
logger.start_block("Copying table '%s' from database '%s'"
% (table, database_name))
try:
cross_db_operations.copy_table(table_to_copy = table,
database_in = database_in,
database_out = database_out,
use_chunking = True)
finally:
logger.end_block()
database_in.close()
self._fix_scenario_information_table(database_out)
database_out.close()
db_server_from.close()
db_server_to.close()
if options.database == None:
parser.print_help()
sys.exit(1)
config = DatabaseServerConfiguration(
host_name = options.host,
protocol = 'mysql',
user_name = options.username,
password = options.password,
)
db_server = DatabaseServer(config)
db = db_server.get_database(options.database)
cdo = CrossDatabaseOperations()
cdo.copy_table('employment_home_based_location_choice_model_specification',
db, db,
'single_family_home_elcm_specification')
cdo.copy_table('employment_home_based_location_choice_model_specification',
db, db,
'multiple_family_home_elcm_specification')
cdo.copy_table('employment_home_based_location_choice_model_coefficients',
db, db,
'single_family_home_elcm_coefficients')
cdo.copy_table('employment_home_based_location_choice_model_coefficients',
db, db,
'multiple_family_home_elcm_coefficients')
if options.database == None:
parser.print_help()
sys.exit(1)
config = DatabaseServerConfiguration(
host_name = options.host,
protocol = 'mysql',
user_name = options.username,
password = options.password,
)
db_server = DatabaseServer(config)
db = db_server.get_database(options.database)
cdo = CrossDatabaseOperations()
cdo.copy_table('employment_home_based_location_choice_model_specification',
db, db,
'single_family_home_elcm_specification')
cdo.copy_table('employment_home_based_location_choice_model_specification',
db, db,
'multiple_family_home_elcm_specification')
cdo.copy_table('employment_home_based_location_choice_model_coefficients',
db, db,
'single_family_home_elcm_coefficients')
cdo.copy_table('employment_home_based_location_choice_model_coefficients',
db, db,
'multiple_family_home_elcm_coefficients')