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 get_name(self): try: return self.dao.name except: sqlsession.commit() sqlsession.add(self.dao) sqlsession.commit() return self.dao.name
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 __init__(self,id,name): self.id = id self.name = name try: if (sqlsession.query(Role).filter_by(id=self.id).count() == 0): sqlsession.add(self) except: sqlsession.add(self)
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 __init__(self, user,role): self.userid=user.userid try: self.id=sqlsession.query(UserRoleMapping).filter_by(userid=user.userid, roleid=role.id).first().id except: self.roleid=role.id UserRoleMapping.id = UserRoleMapping.id+1 self.id = UserRoleMapping.id sqlsession.add(self)
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 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 __call__(self): """ Treat this class like a function to be called with no parameters It will return the value of the property item it holds """ try: sqlsession.add(self.dao) except: pass try: if self.name=='x_pos' or self.name=='y_pos' or \ self.name=='col_span' or self.name=='row_span': return int(self.dao.value) else: return self.dao.value except: import traceback traceback.print_exception(sys.exc_info()[0], sys.exc_info()[1], sys.exc_info()[2]) return ''
def __init__(self, name, format, user): self.name = name self.format = format self.user = user sqlsession.add(self) sqlsession.commit()
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 set_parent(self, parentname): self.dao.parent=parentname sqlsession.add(self.dao) sqlsession.commit()
def create(self, admin): if admin.verify_has_admin(): sqlsession.add(self)
def __init__(self, user, name, displayname): self.name = name self.user = user self.display=displayname sqlsession.add(self) 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 set_name(self, name): self.dao.name = name sqlsession.add(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)