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)
