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)