def create_qualifer(self, code, description):
serv_man = ServiceManager()
cv_service = serv_man.get_cv_service()
q = Qualifier()
q.code = code
q.description = description
cv_service.create_qualifer(q)
return q.id
def create_qualifer(self, code, description):
serv_man = ServiceManager()
cv_service = serv_man.get_cv_service()
q = Qualifier()
q.code = code
q.description = description
cv_service.create_qualifer(q)
return q.id
def __init__(self, parent, id, size, style, name, dbservice,pos=None,):
self.parent= parent
self._init_ctrls(parent)
self.dbservice = dbservice
self.initTableSeries()
self.initSVBoxes()
sm = ServiceManager()
self.export_service = sm.get_export_service()
def __init__(self, parent):
self.service_manager = ServiceManager()
self.record_service = None
if self.service_manager.get_current_connection() == None:
# Create a DB form which will set a connection for the service manager
db_config = frmDBConfiguration.frmDBConfig(None, self.service_manager, False)
db_config.ShowModal()
self.createService()
self._init_ctrls(parent)
self.Refresh()
def __init__(self, parent):
wx.Frame.__init__(self, id=2, name=u'test_ss', parent=parent,
size=wx.Size(900, 700),
style=wx.DEFAULT_FRAME_STYLE, title=u'test_ss')
id=1
size=wx.Size(900, 700)
pos = (0,0)
style="wx.TAB_TRAVERSAL"
name=u'pnlSelector'
service_manager = ServiceManager()
dbservice= service_manager.get_series_service()
pnl= pnlSeriesSelector(parent= self, id=id, size=size, style=style, name=name, dbservice = dbservice,pos = pos)
def __init__(self, parent):
self.service_manager = ServiceManager()
self.record_service = None
conn_dict = self.service_manager.get_current_connection()
#there is a connection but it is unsuccessful
if (conn_dict == None
or (conn_dict != None and not self.service_manager.test_connection(conn_dict))):
# Create a DB form which will set a connection for the service manager
db_config = frmDBConfiguration.frmDBConfig(None, self.service_manager, False)
db_config.ShowModal()
if (conn_dict != None and self.service_manager.get_db_version(conn_dict) != u'1.1.1'):
wx.MessageBox('The ODM database must be version 1.1.1 to use ODMToolsPython', 'Database Version Incompatible', wx.OK)
db_config = frmDBConfiguration.frmDBConfig(None, self.service_manager, False)
db_config.ShowModal()
self.createService()
self._init_ctrls(parent)
self.Refresh()
def __init__(self, parent, series_id): self.series_id = series_id self._init_ctrls(parent) sm = ServiceManager() self.export_service = sm.get_export_service()
def export_series_metadata(self, series_id, filename):
serv_man = ServiceManager()
export_service = serv_man.get_export_service()
export_service.export_series_metadata(series_id, filename)
import sys
import os
import pyodbc
this_file = os.path.realpath(__file__)
directory = os.path.dirname(os.path.dirname(this_file))
sys.path.insert(0, directory)
from odmservices import ServiceManager
sm = ServiceManager()
sm._current_connection= {'engine':'mssql', 'user':'******' , 'password':'******', 'address':'iutahdbs.uwrl.usu.edu', 'db':'iUTAH_RedButte_OD'}
#conn = 'mssql:pyodbc//webapplication:[email protected]/iUTAH_Logan_OD'
conn_dict = sm.get_current_connection()
#print conn_dict
#print sm.get_db_version(conn_dict)
ss= sm.get_series_service()
sites= ss.get_all_sites()
print "========================================================="
#print sites
#print sites[0].code
print dir(sites[0])
print sites[0].code
print sites[0].name
print sites[0].latitude
print sites[0].longitude
print sites[0].lat_long_datum_id #WTheck?
print sites[0].elevation_m
print sites[0].local_x
print sites[0].local_y
def __init__(self, parent, series_id):
self.series_id = series_id
self._init_ctrls(parent)
sm = ServiceManager()
self.export_service = sm.get_export_service()
def export_series_metadata(self, series_id, filename):
serv_man = ServiceManager()
export_service = serv_man.get_export_service()
export_service.export_series_metadata(series_id, filename)
class frmODMToolsMain(wx.Frame):
def __init__(self, parent):
self.service_manager = ServiceManager()
self.record_service = None
if self.service_manager.get_current_connection() == None:
# Create a DB form which will set a connection for the service manager
db_config = frmDBConfiguration.frmDBConfig(None,
self.service_manager,
False)
db_config.ShowModal()
self.createService()
self._init_ctrls(parent)
self.Refresh()
#############Entire Form Sizers##########
def _init_sizers(self):
# generated method, don't edit
self.s = wx.BoxSizer(wx.VERTICAL)
self._init_s_Items(self.s)
self.SetSizer(self.s)
def _init_s_Items(self, parent):
# generated method, don't edit
parent.AddWindow(self._ribbon, 0, wx.EXPAND)
parent.AddWindow(self.pnlDocking, 85, flag=wx.ALL | wx.EXPAND)
###################### Form ################
def _init_ctrls(self, prnt):
# generated method, don't edit
wx.Frame.__init__(self,
id=wxID_ODMTOOLS,
name=u'ODMTools',
parent=prnt,
pos=wx.Point(150, 150),
size=wx.Size(1190, 812),
style=wx.DEFAULT_FRAME_STYLE,
title=u'ODM Tools')
self.SetFont(
wx.Font(9, wx.SWISS, wx.NORMAL, wx.NORMAL, False, u'Tahoma'))
# Publisher.subscribe(self.addPlot, ("add.NewPlot"))
# Publisher.subscribe(self.addEdit, ("edit.NewPlot"))
Publisher.subscribe(self.onDocking, ("adjust.Docking"))
Publisher.subscribe(self.onDocking, ("adjust.Docking"))
Publisher.subscribe(self.onPlotSelection, ("select.Plot"))
Publisher.subscribe(self.onExecuteScript, ("execute.script"))
Publisher.subscribe(self.onExecuteScript, ("execute.script"))
Publisher.subscribe(self.onChangeDBConn, ("change.dbConfig"))
Publisher.subscribe(self.onSetScriptTitle, ("script.title"))
Publisher.subscribe(self.OnClose, ("onClose"))
############### Ribbon ###################
self._ribbon = mnuRibbon.mnuRibbon(parent=self,
id=wx.ID_ANY,
name='ribbon')
################ Docking Tools##############
self.pnlDocking = wx.Panel(id=wxID_ODMTOOLSPANEL1,
name='pnlDocking',
parent=self,
pos=wx.Point(0, 0),
size=wx.Size(605, 458),
style=wx.TAB_TRAVERSAL)
################ Series Selection Panel ##################
self.pnlSelector = pnlSeriesSelector.pnlSeriesSelector(
id=wxID_PNLSELECTOR,
name=u'pnlSelector',
parent=self.pnlDocking,
pos=wx.Point(0, 0),
size=wx.Size(770, 388),
style=wx.TAB_TRAVERSAL,
dbservice=self.sc)
####################grid##################
self.dataTable = pnlDataTable.pnlDataTable(id=wxID_ODMTOOLSGRID1,
name='dataTable',
parent=self.pnlDocking,
pos=wx.Point(64, 160),
size=wx.Size(376, 280),
style=0)
############# Graph ###############
self.pnlPlot = pnlPlot.pnlPlot(id=wxID_ODMTOOLSPANEL1,
name='pnlPlot',
parent=self.pnlDocking,
pos=wx.Point(0, 0),
size=wx.Size(605, 458),
style=wx.TAB_TRAVERSAL)
############# Script & Console ###############
self.txtPythonConsole = wx.py.crust.CrustFrame(
id=wxID_TXTPYTHONCONSOLE,
name=u'txtPython',
parent=self,
rootObject=self,
rootLabel="Main Window",
pos=wx.Point(72, 24),
size=wx.Size(500, 800),
style=0)
# Console tools object for usability
self.console_tools = ConsoleTools(self._ribbon)
self.txtPythonConsole.shell.run("Tools = app.TopWindow.console_tools",
prompt=False,
verbose=False)
self.txtPythonScript = pnlScript(id=wxID_TXTPYTHONSCRIPT,
name=u'txtPython',
parent=self,
pos=wx.Point(72, 24),
size=wx.Size(200, 200))
# print self.txtPythonConsole.fileMenu.MenuItems
# for menu in self.txtPythonConsole.fileMenu.MenuItems:
# print menu.Label, menu.Kind
# print self.txtPythonConsole.fileMenu.MenuItems[11].IsEnabled()
# self.txtPythonConsole.fileMenu.MenuItems[11].Enable=False
# print self.txtPythonConsole.fileMenu.MenuItems[11].IsEnabled()
############ Docking ###################
self._mgr = aui.AuiManager()
self._mgr.SetManagedWindow(self.pnlDocking)
self._mgr.AddPane(
self.dataTable,
aui.AuiPaneInfo().Right().Name("Table").Show(
show=False).Caption('Table View').MinSize(wx.Size(200, 200)))
# DestroyOnClose(b=False)
self._mgr.AddPane(
self.pnlSelector,
aui.AuiPaneInfo().Bottom().Name("Selector").Layer(0).Caption(
'Series Selector').MinSize(wx.Size(100, 200)))
self._mgr.AddPane(
self.txtPythonScript,
aui.AuiPaneInfo().Caption('Script').Name("Script").Show(
show=False).Layer(0).Float().MinSize(wx.Size(200, 200)))
# self._mgr.CreateFloatingFrame(self.txtPythonScript, aui.AuiPaneInfo().Caption('Script').
# Name("Script").MinSize(wx.Size(500,800)))
self._mgr.AddPane(
self.txtPythonConsole,
aui.AuiPaneInfo().Caption('Python Console').Name("Console").Layer(
1).Show(show=False).Float())
# self.txtPythonConsole.ToggleTools()
self._mgr.AddPane(
self.pnlPlot,
aui.AuiPaneInfo().CenterPane().Name("Plot").Caption("Plot"))
self.loadDockingSettings()
self._mgr.Update()
self.Bind(wx.EVT_CLOSE, self.OnClose)
self._init_sizers()
self._ribbon.Realize()
def onDocking(self, value):
panedet = self._mgr.GetPane(self.pnlPlot)
if value == "Table":
panedet = self._mgr.GetPane(self.dataTable)
elif value == "Selector":
panedet = self._mgr.GetPane(self.pnlSelector)
elif value == "Script":
panedet = self._mgr.GetPane(self.txtPythonScript)
elif value == "Console":
# self.txtPythonConsole = wx.py.crust.CrustFrame(id=wxID_TXTPYTHONCONSOLE,
# name=u'txtPython', parent=self, pos=wx.Point(72, 24),
# size=wx.Size(500,800), style=0)
# self._mgr.AddPane(self.txtPythonConsole, aui.AuiPaneInfo().Caption('Python Console').
# Name("Console").Layer(1).Show(show=False).Float())
panedet = self._mgr.GetPane(self.txtPythonConsole)
# print self.txtPythonConsole.fileMenu.MenuItems[11].IsEnabled()
# self._mgr.SetFont(wx.Font(9, wx.SWISS, wx.NORMAL, wx.NORMAL,
# False, u'Tahoma'))
if panedet.IsShown():
panedet.Show(show=False)
else:
panedet.Show(show=True)
self._mgr.Update()
# for p in self._mgr.GetAllPanes():
# print p.caption
# print "\n"
def onPlotSelection(self, value):
self.pnlPlot.selectPlot(value)
def addPlot(self, dataRep, seriesID):
self.pnlPlot.addPlot(dataRep, seriesID)
self._ribbon.enableButtons(self.pnlPlot.getActivePlotID())
def onSetScriptTitle(self, title):
scriptPane = self._mgr.GetPane(self.txtPythonScript)
scriptPane.Caption(title)
if scriptPane.IsFloating():
# print "script is floating"
scriptPane.Restore()
self._mgr.Update()
def addEdit(self, seriesID, memDB):
self.record_service = self.service_manager.get_record_service(
self.txtPythonScript, seriesID, connection=memDB.conn)
self.pnlPlot.addEditPlot(memDB, seriesID, self.record_service)
self.dataTable.Init(memDB, self.record_service)
self._ribbon.toggleEditButtons(True)
# set record service for console
self.console_tools.set_record_service(self.record_service)
def stopEdit(self):
self.pnlPlot.stopEdit()
self.dataTable.stopEdit()
self.pnlSelector.stopEdit()
self.record_service = None
self._ribbon.toggleEditButtons(False)
def getRecordService(self):
return self.record_service
def onChangeDBConn(self, event):
db_config = frmDBConfiguration.frmDBConfig(None, self.service_manager,
False)
value = db_config.ShowModal()
if value == wx.ID_OK:
#reset Series Selector
self.pnlSelector.resetDB(self.sc)
#clear editseries
#clear all plots
self.pnlPlot.Clear()
#clear table
self.dataTable.Clear()
def createService(self):
self.sc = self.service_manager.get_series_service()
def GetDBService(self):
return self.service_manager
def toggleConsoleTools(self):
self.txtPythonConsole.ToggleTools()
def onExecuteScript(self, value):
# print "testing file execution with test.py"
for i in ('red', 'blue', 'green', 'magenta', 'gold', 'cyan', 'brown',
'lime', 'purple', 'navy'):
self.txtPythonScript('This is a test\n', i)
def loadDockingSettings(self):
#test if there is a perspective to load
try:
f = open('ODMTools.config', 'r')
self._mgr.LoadPerspective(f.read(), True)
except:
print "error loading docking data"
def OnClose(self, event):
# deinitialize the frame manager
self.pnlPlot.Close()
try:
f = open('ODMTools.config', 'w')
f.write(self._mgr.SavePerspective())
except:
print "error saving docking data"
self._mgr.UnInit()
# delete the frame
self.Destroy()
class frmODMToolsMain(wx.Frame):
def __init__(self, parent):
self.service_manager = ServiceManager()
self.record_service = None
conn_dict = self.service_manager.get_current_connection()
#there is a connection but it is unsuccessful
if (conn_dict == None
or (conn_dict != None and not self.service_manager.test_connection(conn_dict))):
# Create a DB form which will set a connection for the service manager
db_config = frmDBConfiguration.frmDBConfig(None, self.service_manager, False)
db_config.ShowModal()
if (conn_dict != None and self.service_manager.get_db_version(conn_dict) != u'1.1.1'):
wx.MessageBox('The ODM database must be version 1.1.1 to use ODMToolsPython', 'Database Version Incompatible', wx.OK)
db_config = frmDBConfiguration.frmDBConfig(None, self.service_manager, False)
db_config.ShowModal()
self.createService()
self._init_ctrls(parent)
self.Refresh()
#############Entire Form Sizers##########
def _init_sizers(self):
# generated method, don't edit
self.s = wx.BoxSizer(wx.VERTICAL)
self._init_s_Items(self.s)
self.SetSizer(self.s)
def _init_s_Items(self, parent):
# generated method, don't edit
parent.AddWindow(self._ribbon, 0, wx.EXPAND)
parent.AddWindow(self.pnlDocking, 85, flag=wx.ALL | wx.EXPAND)
###################### Form ################
def _init_ctrls(self, prnt):
# generated method, don't edit
wx.Frame.__init__(self, id=wxID_ODMTOOLS, name=u'ODMTools', parent=prnt,
size=wx.Size(900, 700),
style=wx.DEFAULT_FRAME_STYLE, title=u'ODM Tools')
self.SetFont(wx.Font(9, wx.SWISS, wx.NORMAL, wx.NORMAL,
False, u'Tahoma'))
# Publisher.subscribe(self.addPlot, ("add.NewPlot"))
# Publisher.subscribe(self.addEdit, ("edit.NewPlot"))
Publisher.subscribe(self.onDocking, ("adjust.Docking"))
Publisher.subscribe(self.onDocking, ("adjust.Docking"))
Publisher.subscribe(self.onPlotSelection, ("select.Plot"))
Publisher.subscribe(self.onExecuteScript, ("execute.script"))
Publisher.subscribe(self.onExecuteScript, ("execute.script"))
Publisher.subscribe(self.onChangeDBConn, ("change.dbConfig"))
Publisher.subscribe(self.onSetScriptTitle, ("script.title"))
Publisher.subscribe(self.OnClose, ("onClose"))
############### Ribbon ###################
self._ribbon = mnuRibbon.mnuRibbon(parent=self, id=wx.ID_ANY, name ='ribbon')
################ Docking Tools##############
self.pnlDocking = wx.Panel(id=wxID_ODMTOOLSPANEL1, name='pnlDocking',
parent=self, size=wx.Size(605, 458),
style=wx.TAB_TRAVERSAL)
################ Series Selection Panel ##################
self.pnlSelector = pnlSeriesSelector.pnlSeriesSelector(id=wxID_PNLSELECTOR, name=u'pnlSelector',
parent=self.pnlDocking, size=wx.Size(770, 388),
style=wx.TAB_TRAVERSAL, dbservice= self.sc)
####################grid##################
self.dataTable = pnlDataTable.pnlDataTable(id=wxID_ODMTOOLSGRID1, name='dataTable',
parent=self.pnlDocking, size=wx.Size(376, 280),
style=0)
############# Graph ###############
self.pnlPlot= pnlPlot.pnlPlot(id=wxID_ODMTOOLSPANEL1, name='pnlPlot',
parent=self.pnlDocking, size=wx.Size(605, 458),
style=wx.TAB_TRAVERSAL)
############# Script & Console ###############
self.txtPythonConsole = wx.py.crust.CrustFrame(id=wxID_TXTPYTHONCONSOLE,
size=wx.Size(500,800), style=0)
# Console tools object for usability
self.console_tools = ConsoleTools(self._ribbon)
self.txtPythonConsole.shell.run("Tools = app.TopWindow.console_tools", prompt=False, verbose=False)
self.txtPythonScript = pnlScript(id=wxID_TXTPYTHONSCRIPT,
name=u'txtPython', parent=self,
size=wx.Size(200,200))
############ Docking ###################
self._mgr = aui.AuiManager()
self._mgr.SetManagedWindow(self.pnlDocking)
self._mgr.AddPane(self.dataTable, aui.AuiPaneInfo().Right().Name("Table").
Show(show=False).Caption('Table View').MinSize(wx.Size( 200, 200)))
self._mgr.AddPane(self.pnlSelector, aui.AuiPaneInfo().Bottom().Name("Selector").
Layer(0).Caption('Series Selector').MinSize(wx.Size(100, 200)) )
self._mgr.AddPane(self.txtPythonScript, aui.AuiPaneInfo().Caption('Script').
Name("Script").Show(show=False).Layer(0).Float().MinSize(wx.Size(200,200)))
self._mgr.AddPane(self.txtPythonConsole, aui.AuiPaneInfo().Caption('Python Console').
Name("Console").Layer(1).Show(show=False).Float())
self._mgr.AddPane(self.pnlPlot, aui.AuiPaneInfo().CenterPane().Name("Plot").Caption("Plot"))
self.loadDockingSettings()
self._mgr.Update()
self.Bind(wx.EVT_CLOSE, self.OnClose)
self._init_sizers()
self._ribbon.Realize()
def onDocking(self, value):
panedet=self._mgr.GetPane(self.pnlPlot)
if value == "Table":
panedet=self._mgr.GetPane(self.dataTable)
elif value == "Selector":
panedet=self._mgr.GetPane(self.pnlSelector)
elif value == "Script":
panedet=self._mgr.GetPane(self.txtPythonScript)
elif value == "Console":
panedet=self._mgr.GetPane(self.txtPythonConsole)
if panedet.IsShown():
panedet.Show(show=False)
else:
panedet.Show(show=True)
self._mgr.Update()
def onPlotSelection(self, value):
self.pnlPlot.selectPlot(value)
def addPlot(self, dataRep, seriesID):
self.pnlPlot.addPlot(dataRep, seriesID)
self._ribbon.enableButtons(self.pnlPlot.getActivePlotID() )
def onSetScriptTitle(self, title):
scriptPane = self._mgr.GetPane(self.txtPythonScript)
scriptPane.Caption(title)
if scriptPane.IsFloating():
scriptPane.Restore()
self._mgr.Update()
def addEdit(self, seriesID, memDB):
self.record_service = self.service_manager.get_record_service(self.txtPythonScript, seriesID, connection=memDB.conn)
self.pnlPlot.addEditPlot(memDB, seriesID, self.record_service)
self.dataTable.Init(memDB, self.record_service)
self._ribbon.toggleEditButtons(True)
# set record service for console
self.console_tools.set_record_service(self.record_service)
def stopEdit(self):
self.pnlPlot.stopEdit()
self.dataTable.stopEdit()
self.pnlSelector.stopEdit()
self.record_service = None
self._ribbon.toggleEditButtons(False)
def getRecordService(self):
return self.record_service
def onChangeDBConn(self, event):
db_config = frmDBConfiguration.frmDBConfig(None, self.service_manager, False)
value = db_config.ShowModal()
print value
if value == 5101:
#reset Series Selector
self.pnlSelector.resetDB(self.sc)
#clear editseries
#clear all plots
self.pnlPlot.Clear()
#clear table
self.dataTable.Clear()
def createService(self):
self.sc = self.service_manager.get_series_service()
def GetDBService(self):
return self.service_manager
def toggleConsoleTools(self):
self.txtPythonConsole.ToggleTools()
def onExecuteScript(self, value):
for i in ('red', 'blue', 'green', 'magenta', 'gold', 'cyan', 'brown', 'lime','purple', 'navy'):
self.txtPythonScript('This is a test\n', i)
def loadDockingSettings(self):
#test if there is a perspective to load
try:
f= open(util.resource_path('ODMTools.config'), 'r')
except:
# Create the file if it doesn't exist
open(util.resource_path('ODMTools.config'), 'w').close()
f = open(util.resource_path('ODMTools.config'), 'r')
self._mgr.LoadPerspective(f.read(), True)
def OnClose(self, event):
# deinitialize the frame manager
self.pnlPlot.Close()
try:
f= open(util.resource_path('ODMTools.config'), 'w')
f.write(self._mgr.SavePerspective())
except:
print "error saving docking data"
self._mgr.UnInit()
# delete the frame
self.Destroy()