def __init__(self, parent, id, title = "End Timestamp", actionCode = None):

wx.Dialog.__init__(self, parent, id)

self.InitUI(actionCode)

self.SetSize((300, 200))

if actionCode[0] == 'New':

self.SetTitle("Add End Timestamp")

if actionCode[0] == 'Edit':

self.SetTitle("Edit End Timestamp")

if actionCode[0] == None:

self.SetTitle("Add or Edit End Timestamp") # overrides title passed above

def InitUI(self, actionCode):

# pnl = InfoPanel_EndTimestamp(self, wx.ID_ANY)

self.pnl = InfoPanel_EndTimestamp(self, actionCode)

def OnClose(self, event):

def __init__(self, parent, actionCode):

scrolled.ScrolledPanel.__init__(self, parent, -1)

# def __init__(self, parent, id):

# wx.Panel.__init__(self, parent, id)

self.InitUI(actionCode)

def InitUI(self, actionCode):

print "Initializing EndTimestamp frame"

if actionCode[0] == 'Edit': # editing an existing record, only option so far

self.CSDict = scidb.dictFromTableID('ChannelSegments', actionCode[1])

print 'self.CSDict loaded from table:', self.CSDict

self.stEndTSLabel = 'Ending timestamp'

print "Initializing Panel_EndTimestamp ->>>>"

print "actionCode:", actionCode

self.LayoutPanel()

self.FillPanelFromDict()

def LayoutPanel(self):

wordWrapWidth = 350

self.SetBackgroundColour(wx.WHITE) # this overrides color of enclosing panel

ETPnlSiz = wx.GridBagSizer(1, 1)

gRow = 0

ETPnlSiz.Add(wx.StaticText(self, -1, self.stEndTSLabel),

pos=(gRow, 0), span=(1, 3), flag=wx.ALIGN_LEFT|wx.TOP|wx.LEFT|wx.BOTTOM, border=5)

# gRow += 1

# ETPnlSiz.Add(wx.StaticLine(self), pos=(gRow, 0), span=(1, 3), flag=wx.EXPAND)

gRow += 1

self.tcEndTimestamp = wx.TextCtrl(self)

ETPnlSiz.Add(self.tcEndTimestamp, pos=(gRow, 0), span=(1, 3),

flag=wx.EXPAND|wx.LEFT|wx.RIGHT, border=5)

gRow += 1

stAboutET = 'Enter or Edit the ending timestamp for this Channel Segment. ' \

'The system will automtatically ' \

'create a new Channel Segment beginning when this one ends.'

stWr = wordwrap(stAboutET, wordWrapWidth, wx.ClientDC(self))

ETPnlSiz.Add(wx.StaticText(self, -1, stWr),

pos=(gRow, 0), span=(1, 3), flag=wx.TOP|wx.LEFT|wx.BOTTOM, border=5)

gRow += 1

ETPnlSiz.Add(wx.StaticLine(self), pos=(gRow, 0), span=(1, 3),

flag=wx.EXPAND|wx.BOTTOM, border=1)

gRow += 1

self.btnSave = wx.Button(self, label="Save", size=(90, 28))

self.btnSave.Bind(wx.EVT_BUTTON, lambda evt: self.onClick_BtnSave(evt))

ETPnlSiz.Add(self.btnSave, pos=(gRow, 0), flag=wx.LEFT|wx.BOTTOM, border=5)

self.btnCancel = wx.Button(self, label="Cancel", size=(90, 28))

self.btnCancel.Bind(wx.EVT_BUTTON, lambda evt: self.onClick_BtnCancel(evt))

ETPnlSiz.Add(self.btnCancel, pos=(gRow, 1), flag=wx.LEFT|wx.BOTTOM, border=5)

self.SetSizer(ETPnlSiz)

self.SetAutoLayout(1)

self.SetupScrolling()

def FillPanelFromDict(self):

if self.CSDict['SegmentEnd'] != None:

self.tcEndTimestamp.SetValue(self.CSDict['SegmentEnd'])

def FillDictFromPanel(self):

self.CSDict['SegmentEnd'] = scidb.getDateTimeFromTC(self.tcEndTimestamp)

def onClick_BtnSave(self, event):

"""

If actionCode[0] = 'Edit', attempt to save any changes to the existing DB record

Only option so far

"""

self.FillDictFromPanel() # get all values before testing

# verify

# ending timestamp is null in not valid, any more verification needed?

recID = scidb.dictIntoTable_InsertOrReplace('ChannelSegments', self.CSDict)

# if appropriate, create the new segment starting when this one ends

if self.CSDict['SegmentEnd'] != None:

self.CSDict['ID'] = None # force new record

#self.CSDict['ChannelID'] leave the same

self.CSDict['SegmentBegin'] = self.CSDict['SegmentEnd']

self.CSDict['SegmentEnd'] = None # null means 'up till now'

self.CSDict['StationID'] = None # don't assume the same, have user assign

self.CSDict['SeriesID'] = None

recID = scidb.dictIntoTable_InsertOrReplace('ChannelSegments', self.CSDict)

parObject = self.GetParent()

if parObject.GetClassName() == "wxDialog":

parObject.EndModal(0)

def onClick_BtnCancel(self, event):

"""

This frame is shown in a Dialog, which is its parent object.

"""

parObject = self.GetParent()

if parObject.GetClassName() == "wxDialog":

def __init__(self, parent, id, title = "Station", actionCode = None):

wx.Dialog.__init__(self, parent, id)

self.InitUI(actionCode)

self.SetSize((350, 300))

if actionCode[0] == 'New':

self.SetTitle("Add Station")

if actionCode[0] == 'Edit':

self.SetTitle("Edit Station Details")

if actionCode[0] == None:

self.SetTitle("Add or Edit Station Details") # overrides title passed above

def InitUI(self, actionCode):

# pnl = InfoPanel_StationDetails(self, wx.ID_ANY)

self.pnl = InfoPanel_StationDetails(self, actionCode)

def OnClose(self, event):

def __init__(self, parent, actionCode):

scrolled.ScrolledPanel.__init__(self, parent, -1)

# def __init__(self, parent, id):

# wx.Panel.__init__(self, parent, id)

self.InitUI(actionCode)

def InitUI(self, actionCode):

print "Initializing StationDetails frame"

if actionCode[0] == 'New': # create a new Station record

self.StDict = scidb.dictFromTableDefaults('Stations')

print 'new default self.StDict:', self.StDict

self.stStaLabel = 'Name of Station you are adding to the database'

else: # editing an existing record

self.StDict = scidb.dictFromTableID('Stations', actionCode[1])

print 'self.StDict loaded from table:', self.StDict

self.stStaLabel = 'Station'

print "Initializing Panel_StationDetails ->>>>"

print "actionCode:", actionCode

self.LayoutPanel()

self.FillPanelFromDict()

def LayoutPanel(self):

wordWrapWidth = 350

self.SetBackgroundColour(wx.WHITE) # this overrides color of enclosing panel

shPnlSiz = wx.GridBagSizer(1, 1)

gRow = 0

shPnlSiz.Add(wx.StaticText(self, -1, self.stStaLabel),

pos=(gRow, 0), span=(1, 3), flag=wx.ALIGN_LEFT|wx.TOP|wx.LEFT|wx.BOTTOM, border=5)

# gRow += 1

# shPnlSiz.Add(wx.StaticLine(self), pos=(gRow, 0), span=(1, 3), flag=wx.EXPAND)

gRow += 1

self.tcStationName = wx.TextCtrl(self)

shPnlSiz.Add(self.tcStationName, pos=(gRow, 0), span=(1, 3),

flag=wx.EXPAND|wx.LEFT|wx.RIGHT, border=5)

gRow += 1

stAboutLL = 'Processing requires longitude to calculate solar time (latitude is ' \

'unused). Choose Site or enter lat/lon for each station. ' \

'Within a degree is typically accurate enough.'

stWr = wordwrap(stAboutLL, wordWrapWidth, wx.ClientDC(self))

shPnlSiz.Add(wx.StaticText(self, -1, stWr),

pos=(gRow, 0), span=(1, 3), flag=wx.TOP|wx.LEFT|wx.BOTTOM, border=5)

gRow += 1

shPnlSiz.Add(wx.StaticText(self, -1, 'Site'),

pos=(gRow, 0), span=(1, 1), flag=wx.ALIGN_RIGHT|wx.LEFT|wx.BOTTOM, border=5)

self.cbxFldSites = wx.ComboBox(self, ID_CBX_SEL_SITE, style=wx.CB_READONLY)

self.cbxFldSites.Bind(wx.EVT_COMBOBOX, self.onCbxTasks)

# txSiteLLMsg will not be emplaced till later, but needed now for fillSitesList

self.txSiteLLMsg = wx.StaticText(self, -1, label='Site lat/lon:')

self.fillSitesList()

shPnlSiz.Add(self.cbxFldSites, pos=(gRow, 1), span=(1, 1),

flag=wx.EXPAND|wx.LEFT|wx.RIGHT, border=5)

SibHorizSizer = wx.BoxSizer(wx.HORIZONTAL)

btnAddSite = wx.Button(self, label="New", size=(32, 20))

btnAddSite.Bind(wx.EVT_BUTTON, lambda evt, str=btnAddSite.GetLabel(): self.onClick_BtnWorkOnSite(evt, str))

SibHorizSizer.Add(btnAddSite)

btnEditSite = wx.Button(self, label="Edit", size=(32, 20))

btnEditSite.Bind(wx.EVT_BUTTON, lambda evt, str=btnEditSite.GetLabel(): self.onClick_BtnWorkOnSite(evt, str))

SibHorizSizer.Add(btnEditSite)

shPnlSiz.Add(SibHorizSizer, pos=(gRow, 2), span=(1, 1))

gRow += 1

shPnlSiz.Add(self.txSiteLLMsg,

pos=(gRow, 0), span=(1, 3), flag=wx.ALIGN_LEFT|wx.LEFT|wx.BOTTOM, border=5)

gRow += 1

shPnlSiz.Add(wx.StaticLine(self), pos=(gRow, 0), span=(1, 3),

flag=wx.EXPAND|wx.BOTTOM, border=1)

gRow += 1

stAboutSLL = 'You only need to enter Station latitude and longitude if ' \

'you want to override the Site latitude and longitude.'

stWr1 = wordwrap(stAboutSLL, wordWrapWidth, wx.ClientDC(self))

shPnlSiz.Add(wx.StaticText(self, -1, stWr1),

pos=(gRow, 0), span=(1, 3), flag=wx.TOP|wx.LEFT|wx.BOTTOM, border=5)

gRow += 1

shPnlSiz.Add(wx.StaticText(self, -1, 'Station latitude'),

pos=(gRow, 0), span=(1, 1), flag=wx.ALIGN_RIGHT|wx.LEFT|wx.BOTTOM, border=5)

self.tcLat = wx.TextCtrl(self)

shPnlSiz.Add(self.tcLat, pos=(gRow, 1), span=(1, 2),

flag=wx.EXPAND|wx.LEFT|wx.RIGHT, border=5)

gRow += 1

shPnlSiz.Add(wx.StaticText(self, -1, 'Station longitude'),

pos=(gRow, 0), span=(1, 1), flag=wx.ALIGN_RIGHT|wx.LEFT|wx.BOTTOM, border=5)

self.tcLon = wx.TextCtrl(self)

shPnlSiz.Add(self.tcLon, pos=(gRow, 1), span=(1, 2),

flag=wx.EXPAND|wx.LEFT|wx.RIGHT, border=5)

gRow += 1

self.btnSave = wx.Button(self, label="Save", size=(90, 28))

self.btnSave.Bind(wx.EVT_BUTTON, lambda evt: self.onClick_BtnSave(evt))

shPnlSiz.Add(self.btnSave, pos=(gRow, 0), flag=wx.LEFT|wx.BOTTOM, border=5)

self.btnCancel = wx.Button(self, label="Cancel", size=(90, 28))

self.btnCancel.Bind(wx.EVT_BUTTON, lambda evt: self.onClick_BtnCancel(evt))

shPnlSiz.Add(self.btnCancel, pos=(gRow, 1), flag=wx.LEFT|wx.BOTTOM, border=5)

self.SetSizer(shPnlSiz)

self.SetAutoLayout(1)

self.SetupScrolling()

def fillSitesList(self):

stSQLFieldSites = 'SELECT ID, SiteName FROM FieldSites'

scidb.fillComboboxFromSQL(self.cbxFldSites, stSQLFieldSites)

self.ShowSiteLatLon()

def onCbxTasks(self, event):

evt_id = event.GetId()

print 'in onCbxTasks, event ID:', evt_id

if evt_id == ID_CBX_SEL_SITE:

print 'about to call ShowSiteLatLon'

self.ShowSiteLatLon()

def FillPanelFromDict(self):

if self.StDict['StationName'] != None:

self.tcStationName.SetValue(self.StDict['StationName'])

scidb.setComboboxToClientData(self.cbxFldSites, self.StDict['SiteID'])

self.ShowSiteLatLon()

if self.StDict['LatitudeDecDegrees'] != None:

self.tcLat.SetValue('%.6f' % self.StDict['LatitudeDecDegrees'])

if self.StDict['LongitudeDecDegrees'] != None:

self.tcLon.SetValue('%.6f' % self.StDict['LongitudeDecDegrees'])

def ShowSiteLatLon(self):

recID = scidb.getComboboxIndex(self.cbxFldSites)

if recID == None:

stSiteLL = 'Site lat/lon: (none yet)'

else:

stSQL_SiLL = 'SELECT LatitudeDecDegrees, LongitudeDecDegrees FROM FieldSites WHERE ID = ?'

rec = scidb.curD.execute(stSQL_SiLL, (recID,))

rec = scidb.curD.fetchone() # returns one record, or None

if rec == None:

stSiteLL = 'Site lat/lon: (can not read)'

else:

stSiteLL = 'Site lat/lon: (' + ('%.6f' % rec['LatitudeDecDegrees']) + \

', ' + ('%.6f' % rec['LongitudeDecDegrees']) + ')'

self.txSiteLLMsg.SetLabel(stSiteLL)

def FillDictFromPanel(self):

# clean up whitespace; remove leading/trailing & multiples

self.StDict['StationName'] = " ".join(self.tcStationName.GetValue().split())

self.StDict['SiteID'] = scidb.getComboboxIndex(self.cbxFldSites)

try:

self.StDict['LatitudeDecDegrees'] = float(self.tcLat.GetValue())

except:

self.StDict['LatitudeDecDegrees'] = None

try:

self.StDict['LongitudeDecDegrees'] = float(self.tcLon.GetValue())

except:

self.StDict['LongitudeDecDegrees'] = None

def onClick_BtnWorkOnSite(self, event, str):

"""

"""

print "in onClick_BtnWorkOnSite, str = '" + str + '"'

if str == "New":

dia = Dialog_SiteDetails(self, wx.ID_ANY, actionCode = ['New', 0])

elif str == "Edit":

recNum = scidb.getComboboxIndex(self.cbxFldSites)

# siteItem = self.lstSites.GetFocusedItem()

if recNum == None:

wx.MessageBox('Select a Site to edit', 'No Selection',

wx.OK | wx.ICON_INFORMATION)

return

# recNum = self.lstSites.GetItemData(siteItem)

dia = Dialog_SiteDetails(self, wx.ID_ANY, actionCode = ['Edit', recNum])

else:

return

# the dialog contains an 'InfoPanel_SiteDetails' named 'pnl'

result = dia.ShowModal()

# dialog is exited using EndModal, and comes back here

print "Modal FieldSite dialog result:", result

# test of pulling things out of the modal dialog

self.siteName = dia.pnl.tcSiteName.GetValue()

print "Name of site, from the Modal:", self.siteName

dia.Destroy()

self.fillSitesList()

self.ShowSiteLatLon()

def onClick_BtnSave(self, event):

"""

If actionCode[0] = 'New', the StationDetails is being created.

Attempt to create a new record and make the new record ID available.

If actionCode[0] = 'Edit', attempt to save any changes to the existing DB record

"""

self.FillDictFromPanel() # get all values before testing

# verify

stStationName = self.StDict['StationName']

print "stStationName:", stStationName

if stStationName == '':

wx.MessageBox('Need Station Name', 'Missing',

wx.OK | wx.ICON_INFORMATION)

self.tcStationName.SetValue(stStationName)

self.tcStationName.SetFocus()

self.Scroll(0, 0) # the required controls are all at the top

return

maxLen = scidb.lenOfVarcharTableField('Stations', 'StationName')

if maxLen < 1:

wx.MessageBox('Error %d getting [Stations].[StationName] field length.' % maxLen, 'Error',

wx.OK | wx.ICON_INFORMATION)

return

if len(stStationName) > maxLen:

wx.MessageBox('Max length for Station Name is %d characters.\n\nIf trimmed version is acceptable, retry.' % maxLen, 'Invalid',

wx.OK | wx.ICON_INFORMATION)

self.tcStationName.SetValue(stStationName[:(maxLen)])

self.tcStationName.SetFocus()

self.Scroll(0, 0) # the required controls are all at the top

return

recID = scidb.dictIntoTable_InsertOrReplace('Stations', self.StDict)

parObject = self.GetParent()

if parObject.GetClassName() == "wxDialog":

parObject.EndModal(0)

def onClick_BtnCancel(self, event):

"""

This frame is shown in a Dialog, which is its parent object.

"""

parObject = self.GetParent()

if parObject.GetClassName() == "wxDialog":

def __init__(self, parent, id, title = "Site", actionCode = None):

wx.Dialog.__init__(self, parent, id)

self.InitUI(actionCode)

self.SetSize((350, 300))

if actionCode[0] == 'New':

self.SetTitle("Add Site")

if actionCode[0] == 'Edit':

self.SetTitle("Edit Site Details")

if actionCode[0] == None:

self.SetTitle("Add or Edit Site Details") # overrides title passed above

def InitUI(self, actionCode):

# pnl = InfoPanel_SiteDetails(self, wx.ID_ANY)

self.pnl = InfoPanel_SiteDetails(self, actionCode)

def OnClose(self, event):

def __init__(self, parent, actionCode):

scrolled.ScrolledPanel.__init__(self, parent, -1)

# def __init__(self, parent, id):

# wx.Panel.__init__(self, parent, id)

self.InitUI(actionCode)

def InitUI(self, actionCode):

print "Initializing SiteDetails frame"

if actionCode[0] == 'New': # create a new Site record

self.SiDict = scidb.dictFromTableDefaults('FieldSites')

print 'new default self.SiDict:', self.SiDict

self.stSiteLabel = 'Name of Site you are adding to the database'

else: # editing an existing record

self.SiDict = scidb.dictFromTableID('FieldSites', actionCode[1])

print 'self.SiDict loaded from table:', self.SiDict

self.stSiteLabel = 'Site'

print "Initializing Panel_SiteDetails ->>>>"

print "actionCode:", actionCode

self.LayoutPanel()

self.FillPanelFromDict()

def LayoutPanel(self):

wordWrapWidth = 350

self.SetBackgroundColour(wx.WHITE) # this overrides color of enclosing panel

siPnlSizer = wx.GridBagSizer(1, 1)

gRow = 0

siPnlSizer.Add(wx.StaticText(self, -1, self.stSiteLabel),

pos=(gRow, 0), span=(1, 3), flag=wx.ALIGN_LEFT|wx.TOP|wx.LEFT|wx.BOTTOM, border=5)

# gRow += 1

# siPnlSizer.Add(wx.StaticLine(self), pos=(gRow, 0), span=(1, 3), flag=wx.EXPAND)

gRow += 1

self.tcSiteName = wx.TextCtrl(self)

siPnlSizer.Add(self.tcSiteName, pos=(gRow, 0), span=(1, 3),

flag=wx.EXPAND|wx.LEFT|wx.RIGHT, border=5)

gRow += 1

stAboutLL = 'Processing requires longitude to calculate solar time (latitude is ' \

'unused). Within a degree is typically accurate enough. Enter as ' \

'decimal degrees, negative for South latitude and West longitude.'

stWr = wordwrap(stAboutLL, wordWrapWidth, wx.ClientDC(self))

siPnlSizer.Add(wx.StaticText(self, -1, stWr),

pos=(gRow, 0), span=(1, 3), flag=wx.TOP|wx.LEFT|wx.BOTTOM, border=5)

gRow += 1

siPnlSizer.Add(wx.StaticText(self, -1, 'Latitude'),

pos=(gRow, 0), span=(1, 1), flag=wx.ALIGN_RIGHT|wx.LEFT|wx.BOTTOM, border=5)

self.tcLat = wx.TextCtrl(self)

siPnlSizer.Add(self.tcLat, pos=(gRow, 1), span=(1, 2),

flag=wx.EXPAND|wx.LEFT|wx.RIGHT, border=5)

gRow += 1

siPnlSizer.Add(wx.StaticText(self, -1, 'Longitude'),

pos=(gRow, 0), span=(1, 1), flag=wx.ALIGN_RIGHT|wx.LEFT|wx.BOTTOM, border=5)

self.tcLon = wx.TextCtrl(self)

siPnlSizer.Add(self.tcLon, pos=(gRow, 1), span=(1, 2),

flag=wx.EXPAND|wx.LEFT|wx.RIGHT, border=5)

gRow += 1

siPnlSizer.Add(wx.StaticText(self, -1, 'Hour Offset (not required)\ne.g. US Central Time = -6'),

pos=(gRow, 0), span=(2, 2), flag=wx.ALIGN_RIGHT|wx.LEFT|wx.BOTTOM, border=5)

self.tcHrOffset = wx.TextCtrl(self)

siPnlSizer.Add(self.tcHrOffset, pos=(gRow, 2), span=(1, 1),

flag=wx.EXPAND|wx.LEFT|wx.RIGHT, border=5)

gRow += 1 # space for multiline text above

gRow += 1

self.btnSave = wx.Button(self, label="Save", size=(90, 28))

self.btnSave.Bind(wx.EVT_BUTTON, lambda evt: self.onClick_BtnSave(evt))

siPnlSizer.Add(self.btnSave, pos=(gRow, 0), flag=wx.LEFT|wx.BOTTOM, border=5)

self.btnCancel = wx.Button(self, label="Cancel", size=(90, 28))

self.btnCancel.Bind(wx.EVT_BUTTON, lambda evt: self.onClick_BtnCancel(evt))

siPnlSizer.Add(self.btnCancel, pos=(gRow, 1), flag=wx.LEFT|wx.BOTTOM, border=5)

self.SetSizer(siPnlSizer)

self.SetAutoLayout(1)

self.SetupScrolling()

def FillPanelFromDict(self):

if self.SiDict['SiteName'] != None:

self.tcSiteName.SetValue(self.SiDict['SiteName'])

if self.SiDict['LatitudeDecDegrees'] != None:

self.tcLat.SetValue('%.6f' % self.SiDict['LatitudeDecDegrees'])

if self.SiDict['LongitudeDecDegrees'] != None:

self.tcLon.SetValue('%.6f' % self.SiDict['LongitudeDecDegrees'])

if self.SiDict['UTC_Offset'] != None:

self.tcHrOffset.SetValue('%d' % self.SiDict['UTC_Offset'])

def FillDictFromPanel(self):

# clean up whitespace; remove leading/trailing & multiples

self.SiDict['SiteName'] = " ".join(self.tcSiteName.GetValue().split())

try:

self.SiDict['LatitudeDecDegrees'] = float(self.tcLat.GetValue())

except:

self.SiDict['LatitudeDecDegrees'] = None

try:

self.SiDict['LongitudeDecDegrees'] = float(self.tcLon.GetValue())

except:

self.SiDict['LongitudeDecDegrees'] = None

try:

self.SiDict['UTC_Offset'] = int(self.tcHrOffset.GetValue())

except:

self.SiDict['UTC_Offset'] = None

def onClick_BtnSave(self, event):

"""

If actionCode[0] = 'New', the SiteDetails is being created.

Attempt to create a new record and make the new record ID available.

If actionCode[0] = 'Edit', attempt to save any changes to the existing DB record

"""

self.FillDictFromPanel() # get all values before testing

# verify

stSiteName = self.SiDict['SiteName']

print "stSiteName:", stSiteName

if stSiteName == '':

wx.MessageBox('Need Site Name', 'Missing',

wx.OK | wx.ICON_INFORMATION)

self.tcSiteName.SetValue(stSiteName)

self.tcSiteName.SetFocus()

self.Scroll(0, 0) # the required controls are all at the top

return

maxLen = scidb.lenOfVarcharTableField('FieldSites', 'SiteName')

if maxLen < 1:

wx.MessageBox('Error %d getting [FieldSites].[SiteName] field length.' % maxLen, 'Error',

wx.OK | wx.ICON_INFORMATION)

return

if len(stSiteName) > maxLen:

wx.MessageBox('Max length for Site Name is %d characters.\n\nIf trimmed version is acceptable, retry.' % maxLen, 'Invalid',

wx.OK | wx.ICON_INFORMATION)

self.tcSiteName.SetValue(stSiteName[:(maxLen)])

self.tcSiteName.SetFocus()

self.Scroll(0, 0) # the required controls are all at the top

return

if self.SiDict['LatitudeDecDegrees'] == None:

wx.MessageBox('Need Latitude', 'Missing',

wx.OK | wx.ICON_INFORMATION)

self.tcLat.SetValue('')

self.tcLat.SetFocus()

self.Scroll(0, 0) # the required controls are all at the top

return

if self.SiDict['LongitudeDecDegrees'] == None:

wx.MessageBox('Need Longitude', 'Missing',

wx.OK | wx.ICON_INFORMATION)

self.tcLon.SetValue('')

self.tcLon.SetFocus()

self.Scroll(0, 0) # the required controls are all at the top

return

recID = scidb.dictIntoTable_InsertOrReplace('FieldSites', self.SiDict)

parObject = self.GetParent()

if parObject.GetClassName() == "wxDialog":

parObject.EndModal(0)

def onClick_BtnCancel(self, event):

"""

This frame is shown in a Dialog, which is its parent object.

"""

parObject = self.GetParent()

if parObject.GetClassName() == "wxDialog":

def __init__(self, *arg, **kw):

wx.ListCtrl.__init__(self, *arg, **kw)

ListCtrlAutoWidthMixin.__init__(self) # rightmost column will fill the rest of the list

self.Bind(wx.EVT_LIST_BEGIN_DRAG, self._startDrag)

def _startDrag(self, e):

""" Put together a data object for drag-and-drop _from_ this list. """

l = ['Station']

# mostly need the ItemData, which is the record ID in the Stations table

idx = self.GetFirstSelected()

l.append(self.GetItemData(idx))

# as a convenience, pass the list row text

l.append(self.GetItemText(idx))

# and the ChannelSegment list column to put it in

l.append(0)

# Pickle the object

itemdata = cPickle.dumps(l, 1)

# create our own data format and use it in a

# custom data object

ldata = wx.CustomDataObject("RecIDandTable")

ldata.SetData(itemdata)

# Now make a data object for the item list.

data = wx.DataObjectComposite()

data.Add(ldata)

# Create drop source and begin drag-and-drop.

dropSource = wx.DropSource(self)

dropSource.SetData(data)

res = dropSource.DoDragDrop(flags=wx.Drag_DefaultMove)

# If move, we could remove the item from this list.

if res == wx.DragMove:

def __init__(self, *arg, **kw):

wx.ListCtrl.__init__(self, *arg, **kw)

ListCtrlAutoWidthMixin.__init__(self) # rightmost column will fill the rest of the list

self.Bind(wx.EVT_LIST_BEGIN_DRAG, self._startDrag)

def _startDrag(self, e):

""" Put together a data object for drag-and-drop _from_ this list. """

l = ['Series']

# mostly need the ItemData, which is the record ID in the DataSeries table

idx = self.GetFirstSelected()

l.append(self.GetItemData(idx))

# as a convenience, pass the list row text

l.append(self.GetItemText(idx))

# and the ChannelSegment list column to put it in

l.append(1)

# Pickle the object

itemdata = cPickle.dumps(l, 1)

# create our own data format and use it in a

# custom data object

ldata = wx.CustomDataObject("RecIDandTable")

ldata.SetData(itemdata)

# Now make a data object for the item list.

data = wx.DataObjectComposite()

data.Add(ldata)

# Create drop source and begin drag-and-drop.

dropSource = wx.DropSource(self)

dropSource.SetData(data)

res = dropSource.DoDragDrop(flags=wx.Drag_DefaultMove)

# If move, we could remove the item from this list.

if res == wx.DragMove:

def __init__(self, *arg, **kw):

wx.ListCtrl.__init__(self, *arg, **kw)

ListCtrlAutoWidthMixin.__init__(self)

self.setResizeColumn(3) # Channel column will take up any extra spaces

dt = ListChannelSegmentDrop(self)

self.SetDropTarget(dt)

def _insert(self, x, y, lObj):

""" Target the drop to given x, y coordinates --- used with drag-and-drop. """

# Find insertion point.

index, flags = self.HitTest((x, y))

print "index from HitTest", index

print "flag from HitTest", flags

if index != wx.NOT_FOUND: # clicked on an item

ChanSegID = self.GetItemData(index)

stSQL = "UPDATE ChannelSegments SET " + lObj[0] + "ID = ? WHERE ID = ?;"

# if lObj[0] == 'Station':

# stSQL = "UPDATE ChannelSegments SET StationID = ? WHERE ID = ?;"

# if lObj[0] == 'Series':

# stSQL = "UPDATE ChannelSegments SET SeriesID = ? WHERE ID = ?;"

scidb.curD.execute(stSQL, (lObj[1], ChanSegID))

# on the next load, this change will show in the ChannelSegments list

# but for now just patch in the string

""" Drop target for Channel Segments list.

Allows dropping Station/Series onto ChannelSegment to assign those handles

"""

def __init__(self, source):

""" Arguments:

- source: source listctrl.

"""

wx.PyDropTarget.__init__(self)

self.dv = source

# specify the type of data we will accept

self.data = wx.CustomDataObject("RecIDandTable")

self.SetDataObject(self.data)

# Called when OnDrop returns True. We need to get the data and

# do something with it.

def OnData(self, x, y, d):

# copy the data from the drag source to our data object

if self.GetData():

# convert it back to a list and give it to the viewer

ldata = self.data.GetData()

l = cPickle.loads(ldata)

self.dv._insert(x, y, l)

# what is returned signals the source what to do

# with the original data (move, copy, etc.) In this

# case we just return the suggested value given to us.

def __init__(self, parent, id):

wx.Panel.__init__(self, parent, id)

self.InitUI()

def InitUI(self):

# improve this layout using wx.SplitterWindow instead

sizerWholeFrame = wx.GridBagSizer(5, 5)

hdr = wx.StaticText(self, label="Drag Stations and Series to assign them to Channel Segments")

sizerWholeFrame.Add(hdr, pos=(0, 0), span=(1, 2), flag=wx.TOP|wx.LEFT|wx.BOTTOM, border=5)

hLine = wx.StaticLine(self)

sizerWholeFrame.Add(hLine, pos=(1, 0), span=(1, 3),

flag=wx.EXPAND|wx.BOTTOM, border=1)

sizerSta = wx.GridBagSizer(1, 1)

hdrStation = wx.StaticText(self, label="Stations:")

sizerSta.Add(hdrStation, pos=(0, 0), span=(1, 1),

flag=wx.ALIGN_LEFT|wx.TOP|wx.LEFT, border=1)

StbHorizSizer = wx.BoxSizer(wx.HORIZONTAL)

btnAddStation = wx.Button(self, label="New", size=(32, 20))

btnAddStation.Bind(wx.EVT_BUTTON, lambda evt, str=btnAddStation.GetLabel(): self.onClick_BtnWorkOnStation(evt, str))

StbHorizSizer.Add(btnAddStation)

btnEditStation = wx.Button(self, label="Edit", size=(32, 20))

btnEditStation.Bind(wx.EVT_BUTTON, lambda evt, str=btnEditStation.GetLabel(): self.onClick_BtnWorkOnStation(evt, str))

StbHorizSizer.Add(btnEditStation)

sizerSta.Add(StbHorizSizer, pos=(0, 1), span=(1, 1))

self.lstStations = DragStationList(self, style=wx.LC_REPORT|wx.LC_NO_HEADER|wx.LC_SINGLE_SEL)

self.lstStations.InsertColumn(0, "Station")

self.fillStationsList()

sizerSta.Add(self.lstStations, pos=(1, 0), span=(2, 2), flag=wx.EXPAND)

sizerSta.AddGrowableRow(1)

sizerSta.AddGrowableCol(1)

sizerWholeFrame.Add(sizerSta, pos=(2, 0), span=(1, 1),

flag=wx.EXPAND)

sizerSer = wx.GridBagSizer(1, 1)

hdrSeries = wx.StaticText(self, label="Series:")

sizerSer.Add(hdrSeries, pos=(0, 0), span=(1, 1),

flag=wx.ALIGN_LEFT|wx.TOP|wx.LEFT, border=1)

btnAddSeries = wx.Button(self, label="New", size=(32, 20))

btnAddSeries.Bind(wx.EVT_BUTTON, lambda evt, str=btnAddSeries.GetLabel(): self.onClick_BtnAddSeries(evt, str))

sizerSer.Add(btnAddSeries, pos=(0, 1), flag=wx.ALIGN_LEFT|wx.LEFT, border=10)

self.lstSeries = DragSeriesList(self, style=wx.LC_REPORT|wx.LC_NO_HEADER|wx.LC_SINGLE_SEL)

self.lstSeries.InsertColumn(0, "Series")

self.fillSeriesList()

sizerSer.Add(self.lstSeries, pos=(1, 0), span=(2, 2), flag=wx.EXPAND)

sizerSer.AddGrowableRow(1)

sizerSer.AddGrowableCol(1)

sizerWholeFrame.Add(sizerSer, pos=(2, 1), span=(1, 1),

flag=wx.EXPAND)

sizerChanSegs = wx.GridBagSizer(1, 1)

hdrChanSegs = wx.StaticText(self, label="Channel Segments:")

sizerChanSegs.Add(hdrChanSegs, pos=(0, 0), span=(1, 1), flag=wx.ALIGN_LEFT|wx.TOP, border=5)

self.lstChanSegs = DragChannelSegmentList(self, style=wx.LC_REPORT|wx.LC_VRULES|wx.LC_SINGLE_SEL)

self.lstChanSegs.InsertColumn(0, "Station")

self.lstChanSegs.InsertColumn(1, "Series")

self.lstChanSegs.InsertColumn(2, "Channel Segment (Col, Logger, Sensor, Type, Units, HrOffset)")

self.lstChanSegs.InsertColumn(3, "Start")

self.lstChanSegs.InsertColumn(4, "End")

self.fillChannelSegmentsList()

# 1. Register source's EVT_s to invoke pop-up menu launcher

wx.EVT_LIST_ITEM_RIGHT_CLICK(self.lstChanSegs, -1, self.lstChanSegsRightClick)

sizerChanSegs.Add(self.lstChanSegs, pos=(1, 0), span=(1, 2), flag=wx.EXPAND)

sizerChanSegs.AddGrowableRow(1)

sizerChanSegs.AddGrowableCol(1)

sizerWholeFrame.Add(sizerChanSegs, pos=(3, 0), span=(1, 3),

flag=wx.EXPAND)

sizerWholeFrame.AddGrowableCol(0)

sizerWholeFrame.AddGrowableCol(1)

sizerWholeFrame.AddGrowableRow(3)

self.SetSizerAndFit(sizerWholeFrame)

def fillStationsList(self):

scidb.fillListctrlFromSQL(self.lstStations, "SELECT ID, StationName FROM Stations;")

def fillSeriesList(self):

scidb.fillListctrlFromSQL(self.lstSeries, "SELECT ID, DataSeriesDescription FROM DataSeries;")

def fillChannelSegmentsList(self):

self.lstChanSegs.DeleteAllItems()

stSQL = """

SELECT ChannelSegments.ID,

COALESCE(Stations.StationName, '(none)') AS Station,

COALESCE( DataSeries.DataSeriesDescription, '(none)') AS Series,

DataChannels.Column || ', ' || Loggers.LoggerSerialNumber || ', ' ||

Sensors.SensorSerialNumber || ', ' || DataTypes.TypeText || ', ' ||

DataUnits.UnitsText || ', ' || DataChannels.UTC_Offset AS Channel,

COALESCE(ChannelSegments.SegmentBegin, '(open)') AS Begin,

COALESCE(ChannelSegments.SegmentEnd, '(open)') AS End

FROM ((((((ChannelSegments

LEFT JOIN Stations ON ChannelSegments.StationID = Stations.ID)

LEFT JOIN DataSeries ON ChannelSegments.SeriesID = DataSeries.ID)

LEFT JOIN DataChannels ON ChannelSegments.ChannelID = DataChannels.ID)

LEFT JOIN Loggers ON DataChannels.LoggerID = Loggers.ID)

LEFT JOIN Sensors ON DataChannels.SensorID = Sensors.ID)

LEFT JOIN DataTypes ON DataChannels.DataTypeID = DataTypes.ID)

LEFT JOIN DataUnits ON DataChannels.DataUnitsID = DataUnits.ID

ORDER BY Loggers.LoggerSerialNumber, DataChannels.Column, ChannelSegments.SegmentBegin;

"""

scidb.curD.execute(stSQL)

recs = scidb.curD.fetchall()

for rec in recs:

idx = self.lstChanSegs.InsertStringItem(sys.maxint, rec["Station"])

self.lstChanSegs.SetItemData(idx, rec["ID"])

self.lstChanSegs.SetStringItem(idx, 1, rec["Series"])

self.lstChanSegs.SetStringItem(idx, 2, rec["Channel"])

self.lstChanSegs.SetStringItem(idx, 3, rec["Begin"])

self.lstChanSegs.SetStringItem(idx, 4, rec["End"])

def onButton(self, event, strLabel):

""""""

print ' You clicked the button labeled "%s"' % strLabel

def onClick_BtnWorkOnStation(self, event, strLabel):

"""

"""

print "in onClick_BtnWorkOnStation"

if strLabel == "New":

dia = Dialog_StationDetails(self, wx.ID_ANY, actionCode = ['New', 0])

elif strLabel == "Edit":

staItem = self.lstStations.GetFocusedItem()

if staItem == -1:

wx.MessageBox('Select a Station to edit', 'No Selection',

wx.OK | wx.ICON_INFORMATION)

return

recNum = self.lstStations.GetItemData(staItem)

dia = Dialog_StationDetails(self, wx.ID_ANY, actionCode = ['Edit', recNum])

else:

return

# the dialog contains an 'InfoPanel_StationDetails' named 'pnl'

result = dia.ShowModal()

# dialog is exited using EndModal, and comes back here

print "Modal dialog result:", result

# test of pulling things out of the modal dialog

self.stationName = dia.pnl.tcStationName.GetValue()

print "Name of new station, from the Modal:", self.stationName

dia.Destroy()

self.fillStationsList()

def onClick_BtnAddSeries(self, event, strLabel):

"""

"""

dlg = wx.TextEntryDialog(None, "Name of Data Series you are adding to the database:", "New Data Series", " ")

answer = dlg.ShowModal()

if answer == wx.ID_OK:

stNewSeries = dlg.GetValue()

stNewSeries = " ".join(stNewSeries.split())

recID = scidb.assureItemIsInTableField(stNewSeries, "DataSeries", "DataSeriesDescription")

self.fillSeriesList()

else:

stNewSeries = ''

dlg.Destroy()

# def onClick_BtnNotWorkingYet(self, event, strLabel):

# wx.MessageBox('"Hello" is not implemented yet', 'Info',

# wx.OK | wx.ICON_INFORMATION)

def lstChanSegsRightClick(self, event):

# record what was clicked

self.list_item_clicked = right_click_context = event.GetText()

### 2. Launcher creates wxMenu. ###

menu = wx.Menu()

for (id,title) in listPopMenuItems_byID.items():

### 3. Launcher packs menu with Append. ###

menu.Append( id, title )

### 4. Launcher registers menu handlers with EVT_MENU, on the menu. ###

wx.EVT_MENU( menu, id, self.MenuSelectionCb )

### 5. Launcher displays menu with call to PopupMenu, invoked on the

#source component, passing event's GetPoint. ###

self.PopupMenu( menu, event.GetPoint() )

menu.Destroy() # destroy to avoid mem leak

def MenuSelectionCb( self, event ):

# do something according to what's picked in the popup

opID = event.GetId()

operation = listPopMenuItems_byID[opID]

print "operation:", operation

if operation == 'Add ending timestamp': # only one so far

print 'list_item_clicked', self.list_item_clicked

csItem = self.lstChanSegs.GetFocusedItem()

if csItem == -1:

wx.MessageBox('Right-click failed to get an item', 'No Selection',

wx.OK | wx.ICON_INFORMATION)

return

recNum = self.lstChanSegs.GetItemData(csItem)

print 'recNum', recNum

dia = Dialog_EndTimestamp(self, wx.ID_ANY, actionCode = ['Edit', recNum])

result = dia.ShowModal()

# dialog is exited using EndModal, and comes back here

print "Modal dialog result:", result

# # test of pulling things out of the modal dialog

# self.newBookName = dia.pnl.tcBookName.GetValue()

# print "Name of new book, from the Modal:", self.newBookName

# self.newRecID = dia.pnl.newRecID

# print "record ID from the Modal:", self.newRecID

dia.Destroy()

if result == 1: # new record successfully created

pass

def __init__(self, parent, id, title):

wx.Frame.__init__(self, parent, id, title)

self.InitUI()

self.SetSize((750, 600))

# self.Centre()

self.Show(True)

def InitUI(self):