def copy_to(self, displayname):
sqlsession.commit()
name=self.dao.name
user=self.dao.user
self.dao=None
self.dao=TelemetryWindowModel(user = user, name=name, displayname=displayname).dao
sqlsession.commit()
def __init__(self, user, name, parentname, displayname, type):
self.type = type
self.user = user
self.display=displayname
self.parent=parentname
self.name=name
sqlsession.add(self)
sqlsession.commit()
def delete(self):
for model in self.filtermodels:
model.delete()
self.filtermodels=[]
self.filteredattrs=[]
sqlsession.delete(self.dao)
sqlsession.commit()
del self.dao
def set_display(self, display):
self._model.set_parent(display.get_name())
sqlsession.commit()
for row in self.tiles:
for tile in row:
if tile!=None:
tile.tile.set_display(display)
tile.properties.set_display(display)
def copy_to(self, displayname):
sqlsession.commit()
for model in self.filtermodels:
model.copy_to(displayname)
newview=MonitorView(name=self.dao.name, user=self.dao.user, parentname=self.dao.parent,displayname=displayname, format=self.format, index=self.index)
self.dao=None
self.dao=newview.dao
sqlsession.commit()
def set_value( self, value ):
self.dao.set_value(str(value))
try:
sqlsession.add(self.dao)
except:
pass
sqlsession.commit()
print "SET VALUE OF " +self.dao.parent +" TO " + self.dao.name + " TO " + self.dao.value
def get_name(self):
try:
return self.dao.name
except:
sqlsession.commit()
sqlsession.add(self.dao)
sqlsession.commit()
return self.dao.name
def delete(self):
"""
Remove from database
"""
if self.dao != None:
sqlsession.flush()
sqlsession.delete(self.dao)
sqlsession.commit()
del self.dao
def __init__(self, user, name, parentname,displayname,index=None):
self.display=displayname
self.parent=parentname
self.name=name
self.user=user
self.index=index
sqlsession.commit()
sqlsession.add(self)
sqlsession.commit()
def delete(self):
sqlsession.flush()
sqlsession.delete(self.dao)
sqlsession.flush()
for monitor in self.monitors:
monitor.delete()
del self.monitors
sqlsession.commit()
del self.dao
self.monitors=[]
def append(self, monitorview):
if not(isinstance(monitorview, MonitorView)):
raise Exception("Type mismatch")
for index in range(len(self.monitors)):
mon=self.monitors[index]
if mon.monitor().get_name()==monitorview.monitor().get_name():
self.monitors[index]=monitorview
return
self.monitors.append(monitorview)
sqlsession.commit()
def copy_to(self, displayname):
sqlsession.commit()
name=self.dao.name
type = self.dao.type
parentname=self.dao.parent
for mon in self.monitors:
mon.copy_to(displayname=displayname)
user=self.dao.user
self.dao=None
self.dao=TileModel(name=name, user=user, type=type,parentname=parentname, displayname=displayname).dao
sqlsession.commit()
def __init__(self, name, user, ownername, displayname, value, type):
self.name=name
self.user=user
self.parent=ownername
self.display=displayname
self.type=type
if value==None:
self.value='0'
else:
self.value=value
sqlsession.add(self)
sqlsession.commit()
def place_monitor(self, monitor, index):
if (monitor in self.monitors):
del self.monitors[index]
self.monitors.insert(index,monitor)
else:
if index > len(self.monitors):
#add to end
self.monitors.append(monitor)
else:
#insert new monitor
self.monitors.insert(index,monitor)
print self.monitors
sqlsession.commit()
def set_filtered(self, filteredattrs):
self.filteredattrs=filteredattrs
if filteredattrs==None:
self.filtermodels=[]
return
try:
for filter in self.filtermodels:
if not(filter.dao.name in filteredattrs):
filter.delete()
except:
pass
self.filtermodels=[]
for attrname in filteredattrs:
self.filtermodels.append(MonitorFilter(user=self.dao.user, name=attrname, parentname=self.get_name(),
tilename=self.dao.parent, displayname=self.dao.display))
sqlsession.commit()
def copy_to(self, newname):
olddisplay = self
oldname = self.dao.name
if newname == oldname:
return
daos = sqlsession.query(DisplayModel.DAO).filter_by(user=self.dao.user, name=newname).all()
if len(daos) > 0:
raise Exception("Name already exists")
sqlsession.commit()
format = self.dao.format
user = self.dao.user
self.dao = None
self.dao = DisplayModel(user=user, name=newname, format=format).dao
sqlsession.add(self.dao)
sqlsession.commit()
if oldname == "unnamed":
olddisplay.delete()
def render_html(self, properties, for_editing=False):
sqlsession.flush()
sqlsession.commit()
c.formatview= self.get_name().replace(' ','_')
c.properties=properties
c.monitors=self.monitors()
c.flatattrs={}
c.x_pos=properties.x_pos()
c.y_pos=properties.y_pos()
for mon in c.monitors:
for attr in mon.attrs():
if not(c.flatattrs.has_key(attr[0])):
c.flatattrs[attr[0]]=attr
c.content_type = 'html'
c.name = self.display.format.name
c.tile = self
c.display_ops=for_editing
try:
return render('/tlm/develop/Visualization-tile_view.html');
except:
import traceback
traceback.print_exception(sys.exc_info()[0], sys.exc_info()[1], sys.exc_info()[2])
return "<b><i>ERROR rendering tile</i></b>"
def __init__(self, project_name, contract_id, project_type):
self.project_name = project_name
self.contract_id = contract_id
self.project_type = project_type
sqlsession.add(self)
sqlsession.commit()
def copy_to(self, displayname):
sqlsession.commit()
newfilter=MonitorFilter(user=self.dao.user, name=self.dao.name, parentname=self.dao.parent,tilename=self.dao.tile, displayname=displayname)
self.dao=None
self.dao=newfilter.dao
sqlsession.commit()
def __init__(self, name, format, user):
self.name = name
self.format = format
self.user = user
sqlsession.add(self)
sqlsession.commit()
def save(self):
sqlsession.commit()
def copy_to(self, displayname):
sqlsession.commit()
newdao=DisplayPropertyItem(name=self.dao.name, user=self.dao.user, owner=self.owner, displayname=displayname, value=self.dao.value, type=self.dao.type).dao
self.dao=None
self.dao=newdao
sqlsession.commit()
def commit_change(self):
sqlsession.commit()
def __init__(self, user, name, displayname):
self.name = name
self.user = user
self.display=displayname
sqlsession.add(self)
sqlsession.commit()
def set_parent(self, parentname):
self.dao.parent=parentname
sqlsession.add(self.dao)
sqlsession.commit()
def set_name(self, name):
self.dao.name = name
sqlsession.add(self.dao)
sqlsession.commit()
def __init__(self, project_name, workbook_name):
self.project_name = project_name
self.workbook_name = workbook_name
sqlsession.add(self)
sqlsession.commit()
def delete(self):
sqlsession.delete(self.dao)
sqlsession.commit()
UserRoleMapping.table=sqlalchemy.Table('userroles',metadata,
Column('id',Integer,primary_key=True),
Column('userid',String(80), nullable=False),
Column('roleid',Integer, nullable=False),
useexisting=True)
"""map tables to database"""
sqlalchemy.orm.mapper(User, User.table)
sqlalchemy.orm.mapper(Role, Role.table)
sqlalchemy.orm.mapper(UserRoleMapping, UserRoleMapping.table)
"""Setup user and user roles for basic admin"""
import hashlib
try:
User.ROOT = sqlsession.query(User).filter_by(userid="admin").one()
User.ROOT.password=hashlib.md5("admin").hexdigest()
sqlsession.commit()
except:
User.ROOT= User("admin", hashlib.md5("admin").hexdigest())
sqlsession.add(User.ROOT)
sqlsession.commit()
Role.ADMIN = Role(1,"admin")
Role.DEVELOPER = Role(2,"developer")
Role.PRODCUT_MANAGER=Role(3,"product_manager")
UserRoleMapping.ROOT = UserRoleMapping(User.ROOT,Role.ADMIN)
