def save_group_details(self,login,groupid, groupname, userids,desc):
dupGrp=None
group=Group()
db=DBHelper()
session=DBHelper().get_session()
dupGrp=session.query(Group).filter(Group.group_name==groupname).first()
if dupGrp is None:
result = []
group.group_name=groupname
group.created_by=(login)
group.modified_by=(login)
group.created_date=datetime.now()
group.description=desc
L=(userids).split(',')
if userids !="":
for i in L:
user=session.query(User).filter(User.user_id==int(i)).first()
group.users.append(user);
db.add(group)
return result
else:
result="False"
return result
def save_oper_det(self, login,opname, descr, context_disp, entityid,dispname,icon):
result = []
dupOp=None
operation=Operation()
db=DBHelper()
session=DBHelper().get_session()
dupOp=session.query(Operation).filter(Operation.name==opname).first()
if dupOp is None:
operation.name=(opname)
operation.description=(descr)
operation.display_name=(dispname)
operation.icon=(icon)
operation.created_by=(login)
operation.modified_by=(login)
operation.created_date=datetime.now()
if context_disp=="true":
operation.display=True
else:
operation.display=False
L=(entityid).split(',')
for i in L:
ent=session.query(EntityType).filter(EntityType.id==int(i)).first()
operation.entityType.append(ent);
db.add(operation)
return result
else:
result="False"
return result
def save_oper_det(self, login, opname, descr, context_disp, entityid,
dispname, icon):
result = []
dupOp = None
operation = Operation()
db = DBHelper()
session = DBHelper().get_session()
dupOp = session.query(Operation).filter(
Operation.name == opname).first()
if dupOp is None:
operation.name = (opname)
operation.description = (descr)
operation.display_name = (dispname)
operation.icon = (icon)
operation.created_by = (login)
operation.modified_by = (login)
operation.created_date = datetime.now()
if context_disp == "true":
operation.display = True
else:
operation.display = False
L = (entityid).split(',')
for i in L:
ent = session.query(EntityType).filter(
EntityType.id == int(i)).first()
operation.entityType.append(ent)
db.add(operation)
return result
else:
result = "False"
return result
def save_opsgroup_details(self, login, opsgroupname, opsgroupdesc,
operation):
dupOpsgrp = None
db = DBHelper()
session = DBHelper().get_session()
dupOpsgrp = session.query(OperationGroup).filter(
OperationGroup.name == opsgroupname).first()
opsgroup = OperationGroup()
if dupOpsgrp is None:
result = []
opsgroup.name = (opsgroupname)
opsgroup.description = (opsgroupdesc)
opsgroup.created_by = (login)
opsgroup.modified_by = (login)
opsgroup.created_date = datetime.now()
L = ((operation)).split(',')
for i in L:
oper = session.query(Operation).filter(
Operation.id == int(i)).first()
opsgroup.operations.append(oper)
db.add(opsgroup)
return result
else:
result = "False"
return result
def save_group_details(self, login, groupid, groupname, userids, desc):
dupGrp = None
group = Group()
db = DBHelper()
session = DBHelper().get_session()
dupGrp = session.query(Group).filter(
Group.group_name == groupname).first()
if dupGrp is None:
result = []
group.group_name = groupname
group.created_by = (login)
group.modified_by = (login)
group.created_date = datetime.now()
group.description = desc
L = (userids).split(',')
if userids != "":
for i in L:
user = session.query(User).filter(
User.user_id == int(i)).first()
group.users.append(user)
db.add(group)
return result
else:
result = "False"
return result
def save_enttype_details(self,login,enttypename,dispname):
dupEnt=None
db=DBHelper()
session=DBHelper().get_session()
dupEnt=session.query(EntityType).filter(EntityType.name==enttypename).first()
if dupEnt is None:
result=[]
ent=EntityType();
ent.name=(enttypename)
ent.display_name=(dispname)
ent.created_by=(login)
ent.created_date=datetime.now()
ent.modified_by=(login)
db.add(ent);
return result
else:
result="False"
return result
def save_enttype_details(self, login, enttypename, dispname):
dupEnt = None
db = DBHelper()
session = DBHelper().get_session()
dupEnt = session.query(EntityType).filter(
EntityType.name == enttypename).first()
if dupEnt is None:
result = []
ent = EntityType()
ent.name = (enttypename)
ent.display_name = (dispname)
ent.created_by = (login)
ent.created_date = datetime.now()
ent.modified_by = (login)
db.add(ent)
return result
else:
result = "False"
return result
def save_opsgroup_details(self,login, opsgroupname, opsgroupdesc, operation):
dupOpsgrp=None
db=DBHelper()
session=DBHelper().get_session()
dupOpsgrp=session.query(OperationGroup).filter(OperationGroup.name==opsgroupname).first()
opsgroup=OperationGroup();
if dupOpsgrp is None:
result=[]
opsgroup.name=(opsgroupname)
opsgroup.description=(opsgroupdesc)
opsgroup.created_by=(login)
opsgroup.modified_by=(login)
opsgroup.created_date=datetime.now()
L=((operation)).split(',')
for i in L:
oper=session.query(Operation).filter(Operation.id==int(i)).first()
opsgroup.operations.append(oper);
db.add(opsgroup);
return result
else:
result="False"
return result
