def __init__(self, parent, mainDbPane, sourceDbPane, **kargs):
tk.Frame.__init__(self, parent)
self.parent = parent
self.mainDbPane = mainDbPane
self.sourceDbPane = sourceDbPane
self.pullDataPane = PullIntegrationDataCommandPane(self.parent, self.mainDbPane, self.sourceDbPane, silentMode = True)
processFrame = add_label_frame(parent, "Process", 400, 50)
row = add_buttons(processFrame,
[["Pull Data from Integration DB & Initialize Merlin Output Tables", self.initialize_merlin, "red"],
["Start Allocation", self.start_allocation, "red"]],
0, 0, "vertical")
grid_panel(processFrame)
parent.add(processFrame)
def start_allocation(self):
print("Allocation in progress...")
# Hook in the new merlin.exe at this point in the process
print("Allocation completed sucessfully.")
# Allocation run had just completed, so we now offer the user the choice to download allocation error log and rendered layer3 data to the Integration DB
# NOTE: A simple trickery is employed here, whereby the sourceDbPane becomes the mainDbPane and the mainDbPane becomes the sourceDbPane for the new
# self.pullAllocationLogPane object created below
#
self.pullAllocationLogPane = PullIntegrationDataCommandPane(self.parent, self.sourceDbPane, self.mainDbPane, silentMode = True, suppressTableListButton = True)
self.pullAllocationLogPane.setupCommandPane()
scb = tk.Button(self.parent, text="Send allocation error log to integration DB", fg="red", height=1,
command=self.pull_allocation_error_log)
self.parent.add(scb)
# Adding a filler pane for look only
self.parent.add(ttk.Panedwindow(self.parent, orient=VERTICAL))
def __init__(self, master):
tk.Frame.__init__(self, master)
mainNB = ttk.Notebook(master, width=820, height=520)
dbPane = ttk.Panedwindow(mainNB, orient=VERTICAL)
mainDB = DBConnectionPane(dbPane, 'Main DB')
sourceDB = DBConnectionPane(dbPane, 'Source DB')
dbPane.add(ttk.Panedwindow(dbPane, orient=VERTICAL)
) # Also added a filler pane to improve look and feel only
# rds tab
rdsPane = add_pane(mainNB,
mainDB,
RdsCommandPane,
add_filler_pane=True)
# taxon_extent tab
taxonExtentPane = add_pane(mainNB,
mainDB,
TaxonExtentCommandPane,
add_filler_pane=True)
# distribution tab
distributionPane = add_pane(mainNB,
mainDB,
DistributionCommandPane,
add_filler_pane=True)
# allocation tab
allocationPane = ttk.Panedwindow(mainNB, orient=VERTICAL)
AllocationCommandPane(allocationPane, mainDB, sourceDB)
allocationPane.add(ttk.Panedwindow(allocationPane, orient=VERTICAL))
# pull tab
pullDataPane = ttk.Panedwindow(mainNB, orient=VERTICAL)
PullIntegrationDataCommandPane(
pullDataPane,
mainDB,
sourceDB,
suppressMaterializedViewRefreshButton=TRUE)
PullAllocationDataCommandPane(pullDataPane, mainDB, sourceDB)
pullDataPane.add(ttk.Panedwindow(pullDataPane, orient=VERTICAL))
# summarize tab
summarizePane = ttk.Panedwindow(mainNB, orient=VERTICAL)
SummarizeCommandPane(summarizePane, mainDB, True, [
'Summarize data for marine layers 1, 2, 3, 4 and 6',
'Summarize data for marine layer 1',
'Summarize data for marine layer 2',
'Summarize data for marine layer 3',
'Summarize data for marine layer 4',
'Summarize data for marine layer 6'
])
# Also added a filler pane to purely improve look and feel only
summarizePane.add(ttk.Panedwindow(summarizePane, orient=VERTICAL))
# aggregate tab
aggregatePane = ttk.Panedwindow(mainNB, orient=VERTICAL)
AggregateCommandPane(aggregatePane, mainDB, True, [
'Aggregrate data for marine layers 1, 2, 3, 4 and 6',
'Aggregrate data for marine layer 1',
'Aggregrate data for marine layer 2',
'Aggregrate data for marine layer 3',
'Aggregrate data for marine layer 4',
'Aggregrate data for marine layer 6'
])
aggregatePane.add(ttk.Panedwindow(aggregatePane, orient=VERTICAL))
# cell_catch tab
cellCatchPane = add_pane(mainNB,
mainDB,
CellCatchCommandPane,
add_filler_pane=True)
# cache_data tab
cacheDataPane = add_pane(mainNB,
mainDB,
CacheDataCommandPane,
add_filler_pane=True)
# sqlprocessor tab
sqlProcessorGuiPane = ttk.Panedwindow(mainNB, orient=VERTICAL)
SqlProcessorGuiCommandPane(sqlProcessorGuiPane, mainDB, True)
sqlProcessorGuiPane.add(
ttk.Panedwindow(sqlProcessorGuiPane, orient=VERTICAL))
mainNB.add(dbPane, text='DB Connection')
mainNB.add(rdsPane, text='RDS')
mainNB.add(taxonExtentPane, text='Taxon Extent')
mainNB.add(distributionPane, text='Distribution')
mainNB.add(allocationPane, text='Allocation')
mainNB.add(pullDataPane, text='Pull Data')
mainNB.add(summarizePane, text='Summarize')
mainNB.add(aggregatePane, text='Aggregate')
mainNB.add(cellCatchPane, text='Cell Catch')
mainNB.add(cacheDataPane, text='Cache Data')
mainNB.add(sqlProcessorGuiPane, text='SQL Processor')
mainNB.pack(expand=1, fill='both')
class AllocationCommandPane(tk.Frame):
def __init__(self, parent, mainDbPane, sourceDbPane, **kargs):
tk.Frame.__init__(self, parent)
self.parent = parent
self.mainDbPane = mainDbPane
self.sourceDbPane = sourceDbPane
self.pullDataPane = PullIntegrationDataCommandPane(self.parent, self.mainDbPane, self.sourceDbPane, silentMode = True)
processFrame = add_label_frame(parent, "Process", 400, 50)
row = add_buttons(processFrame,
[["Pull Data from Integration DB & Initialize Merlin Output Tables", self.initialize_merlin, "red"],
["Start Allocation", self.start_allocation, "red"]],
0, 0, "vertical")
grid_panel(processFrame)
parent.add(processFrame)
def initialize_merlin(self):
mainDbConn = getDbConnection(optparse.Values(self.mainDbPane.getDbOptions()))
print("Truncating ao.AllocationResult, ao.Log_Import_Raw, ao.Data...")
mainDbConn.execute("TRUNCATE ao.AllocationResult, ao.Log_Import_Raw, ao.Data")
print("Pulling data from Integration DB")
drop_foreign_key(self.mainDbPane)
self.pullDataPane.pullAllIntegrationDbData()
restore_foreign_key(self.mainDbPane)
refresh_all_materialized_views(self.mainDbPane)
print("Transfering layer3 data...")
mainDbConn.execute("SELECT ai.layer3_transfer_to_dataraw()")
mainDbConn.execute("SELECT ai.layer3_update_taxon_substitutions()")
print("Truncating and initializing ao tables...")
mainDbConn.execute("TRUNCATE TABLE ao.AllocationSimpleArea")
mainDbConn.execute("TRUNCATE TABLE ao.AllocationHybridArea")
mainDbConn.execute("TRUNCATE TABLE ao.AutoGen_HybridToSimpleAreaMapper")
mainDbConn.execute("TRUNCATE TABLE ao.SimpleAreaCellAssignment")
mainDbConn.execute("SELECT SETVAL('ao.allocationsimplearea_allocationsimpleareaid_seq', 1)");
mainDbConn.execute("Insert into ao.AllocationSimpleArea " +
"SELECT nextval('ao.allocationsimplearea_allocationsimpleareaid_seq'), * FROM a_internal.generate_allocation_simple_area_table()")
mainDbConn.execute("SELECT SETVAL('ao.simpleareacellassignment_rowid_seq', 1)");
mainDbConn.execute("SELECT a_internal.SimpleAreaCellAssignment_Populate()")
print("Initialize Merlin process completed successfully.")
def start_allocation(self):
print("Allocation in progress...")
# Hook in the new merlin.exe at this point in the process
print("Allocation completed sucessfully.")
# Allocation run had just completed, so we now offer the user the choice to download allocation error log and rendered layer3 data to the Integration DB
# NOTE: A simple trickery is employed here, whereby the sourceDbPane becomes the mainDbPane and the mainDbPane becomes the sourceDbPane for the new
# self.pullAllocationLogPane object created below
#
self.pullAllocationLogPane = PullIntegrationDataCommandPane(self.parent, self.sourceDbPane, self.mainDbPane, silentMode = True, suppressTableListButton = True)
self.pullAllocationLogPane.setupCommandPane()
scb = tk.Button(self.parent, text="Send allocation error log to integration DB", fg="red", height=1,
command=self.pull_allocation_error_log)
self.parent.add(scb)
# Adding a filler pane for look only
self.parent.add(ttk.Panedwindow(self.parent, orient=VERTICAL))
def pull_allocation_error_log(self):
self.pullAllocationLogPane.pullAllIntegrationDbData()
print("Downloading of allocation error log and rendered layer3 data completed.")
