def leavegroup(self,group_id): if self.isingroup(group_id): conn = engine.connect() sql = 'delete from uig where group_id = \'' + str(group_id) + '\' and user_id=\'' + str(self.id) +'\'' rs = conn.execute(sql) return True else: return False
def joingroup(self,group_id,authtype): conn = engine.connect() if not self.is_hasgroup(group_id): sql = 'insert into auth_groups(\'authitem_id\',\'group_id\',\'authtype\',\'lasttime\') values(\'' + str(self.id) + '\',' + '\'' + str(group_id) +'\',' + '\'' + str(authtype) +'\',' + '\'2012-03-31 20:58:40\')' else: sql = 'update auth_groups set authtype = \'' + str(authtype) +'\'' + ' where authitem_id = \'' + str(self.id) + '\' and group_id= \'' + str(group_id) +'\'' rs = conn.execute(sql)
def has_auths(self): userauths =[] conn = engine.connect() sql = 'select reponame,authitem,authtype from auth_users cross join users,repos,auth_items where auth_users.user_id=users.id and auth_users.authitem_id = auth_items.id and auth_items.repo_id = repos.id and users.id = \'' + str(self.id) +'\' order by reponame,authitem,authtype' rs = conn.execute(sql) for r in rs: userauths.append([' ',r.reponame,r.authitem,r.authtype]) return userauths
def joinuser(self,user_id,authtype): conn = engine.connect() if not self.is_hasuser(user_id): sql = 'insert into auth_users(\'authitem_id\',\'user_id\',\'authtype\',\'lasttime\') values(\'' +\ str(self.id) + '\',' + '\'' + str(user_id) +'\',' + '\'' + str(authtype) +'\',' + '\'2012-03-31 20:58:40\')' else: sql = 'update auth_users set authtype = \'' + str(authtype) +'\'' + ' where authitem_id = \'' + str(self.id) + '\' and user_id= \'' + str(user_id) +'\'' rs = conn.execute(sql)
def has_auths(self): groupauths =[] conn = engine.connect() sql = 'select groupname,reponame,authitem,authtype from auth_groups cross join groups,repos,auth_items where auth_groups.group_id=groups.id and auth_groups.authitem_id = auth_items.id and auth_items.repo_id = repos.id and groups.id = \'' + str(self.id) +'\' order by groupname,reponame,authitem,authtype' rs = conn.execute(sql) for r in rs: groupauths.append([r.groupname,r.reponame,r.authitem,r.authtype]) return groupauths
def joingroup(self,group_id): if not self.isingroup(group_id): conn = engine.connect() sql = 'insert into uig(\'group_id\',\'user_id\',\'lasttime\') values(\'' + str(group_id) + '\',' + '\'' + str(self.id) +'\',' + '\'2012-03-31 20:58:40\')' rs = conn.execute(sql) return True else: return False
def has_Authitems(self): authitems=[] conn = engine.connect() sql = 'select authitem FROM repos CROSS JOIN auth_items where auth_items.repo_id = repos.id and repos.id = \'' + \ str(self.id) + '\'' + 'order by authitem' rs = conn.execute(sql) for r in rs: authitems.append([r.authitem]) return authitems
def has_users(self): users = [] conn = engine.connect() sql = 'select users.id as userid,fullname,username FROM users CROSS JOIN uig where users.id = uig.user_id and uig.group_id = \'' + \ str(self.id) + '\'' + 'order by username' rs = conn.execute(sql) for r in rs: users.append([r.userid, r.fullname, r.username]) return users
def has_auths(self): userauths = [] conn = engine.connect() sql = 'select reponame,authitem,authtype from auth_users cross join users,repos,auth_items where auth_users.user_id=users.id and auth_users.authitem_id = auth_items.id and auth_items.repo_id = repos.id and users.id = \'' + str( self.id) + '\' order by reponame,authitem,authtype' rs = conn.execute(sql) for r in rs: userauths.append([' ', r.reponame, r.authitem, r.authtype]) return userauths
def has_groups(self): groups =[] conn = engine.connect() sql = 'select groups.id as groupid,groupname FROM groups CROSS JOIN uig where groups.id = uig.group_id and uig.user_id = \'' + \ str(self.id) + '\'' + 'order by groupname' rs = conn.execute(sql) for r in rs: groups.append([r.groupid,r.groupname]) return groups
def has_groups(self): groups = [] conn = engine.connect() sql = 'select groups.id as groupid,groupname FROM groups CROSS JOIN uig where groups.id = uig.group_id and uig.user_id = \'' + \ str(self.id) + '\'' + 'order by groupname' rs = conn.execute(sql) for r in rs: groups.append([r.groupid, r.groupname]) return groups
def leavegroup(self, group_id): if self.isingroup(group_id): conn = engine.connect() sql = 'delete from uig where group_id = \'' + str( group_id) + '\' and user_id=\'' + str(self.id) + '\'' rs = conn.execute(sql) return True else: return False
def has_Authitems(self): authitems = [] conn = engine.connect() sql = 'select authitem FROM repos CROSS JOIN auth_items where auth_items.repo_id = repos.id and repos.id = \'' + \ str(self.id) + '\'' + 'order by authitem' rs = conn.execute(sql) for r in rs: authitems.append([r.authitem]) return authitems
def has_users(self): users =[] conn = engine.connect() sql = 'select users.id as userid,fullname,username FROM users CROSS JOIN uig where users.id = uig.user_id and uig.group_id = \'' + \ str(self.id) + '\'' + 'order by username' rs = conn.execute(sql) for r in rs: users.append([r.userid,r.fullname,r.username]) return users
def has_auths(self): groupauths = [] conn = engine.connect() sql = 'select groupname,reponame,authitem,authtype from auth_groups cross join groups,repos,auth_items where auth_groups.group_id=groups.id and auth_groups.authitem_id = auth_items.id and auth_items.repo_id = repos.id and groups.id = \'' + str( self.id) + '\' order by groupname,reponame,authitem,authtype' rs = conn.execute(sql) for r in rs: groupauths.append( [r.groupname, r.reponame, r.authitem, r.authtype]) return groupauths
def has_authusers(self): authusers=[] conn = engine.connect() sql = 'select users.id as userid,fullname,username,authtype from auth_users cross join users,\ repos,auth_items where auth_users.user_id=users.id and auth_users.authitem_id = auth_items.id and \ auth_items.repo_id = repos.id and auth_items.id = \'' + str(self.id) + '\'' + 'order by username' rs = conn.execute(sql) for r in rs: authusers.append([r.userid,r.fullname,r.username,r.authtype]) return authusers
def joinuser(self, user_id, authtype): conn = engine.connect() if not self.is_hasuser(user_id): sql = 'insert into auth_users(\'authitem_id\',\'user_id\',\'authtype\',\'lasttime\') values(\'' +\ str(self.id) + '\',' + '\'' + str(user_id) +'\',' + '\'' + str(authtype) +'\',' + '\'2012-03-31 20:58:40\')' else: sql = 'update auth_users set authtype = \'' + str( authtype) + '\'' + ' where authitem_id = \'' + str( self.id) + '\' and user_id= \'' + str(user_id) + '\'' rs = conn.execute(sql)
def joingroup(self, group_id): if not self.isingroup(group_id): conn = engine.connect() sql = 'insert into uig(\'group_id\',\'user_id\',\'lasttime\') values(\'' + str( group_id) + '\',' + '\'' + str( self.id) + '\',' + '\'2012-03-31 20:58:40\')' rs = conn.execute(sql) return True else: return False
def isingroup(self,group_id): result =[] conn = engine.connect() sql = 'select * from uig where group_id = \'' + str(group_id) + '\' and user_id=\'' + str(self.id) +'\'' rs = conn.execute(sql) for r in rs: result.append(r) if len(result)==0: return False else: return True
def has_authusers(self): authusers = [] conn = engine.connect() sql = 'select users.id as userid,fullname,username,authtype from auth_users cross join users,\ repos,auth_items where auth_users.user_id=users.id and auth_users.authitem_id = auth_items.id and \ auth_items.repo_id = repos.id and auth_items.id = \'' + str( self.id) + '\'' + 'order by username' rs = conn.execute(sql) for r in rs: authusers.append([r.userid, r.fullname, r.username, r.authtype]) return authusers
def is_hasgroup(self,group_id): result = [] conn = engine.connect() sql = 'select * from auth_groups where authitem_id = \'' + str(self.id) + '\' and group_id= \'' + str(group_id) +'\'' rs = conn.execute(sql) for r in rs: result.append(r) if len(result)==0: return False else: return True
def isingroup(self, group_id): result = [] conn = engine.connect() sql = 'select * from uig where group_id = \'' + str( group_id) + '\' and user_id=\'' + str(self.id) + '\'' rs = conn.execute(sql) for r in rs: result.append(r) if len(result) == 0: return False else: return True
def joingroup(self, group_id, authtype): conn = engine.connect() if not self.is_hasgroup(group_id): sql = 'insert into auth_groups(\'authitem_id\',\'group_id\',\'authtype\',\'lasttime\') values(\'' + str( self.id) + '\',' + '\'' + str(group_id) + '\',' + '\'' + str( authtype) + '\',' + '\'2012-03-31 20:58:40\')' else: sql = 'update auth_groups set authtype = \'' + str( authtype) + '\'' + ' where authitem_id = \'' + str( self.id) + '\' and group_id= \'' + str(group_id) + '\'' rs = conn.execute(sql)
def is_hasgroup(self, group_id): result = [] conn = engine.connect() sql = 'select * from auth_groups where authitem_id = \'' + str( self.id) + '\' and group_id= \'' + str(group_id) + '\'' rs = conn.execute(sql) for r in rs: result.append(r) if len(result) == 0: return False else: return True
def removegroup(self,group_id): conn = engine.connect() sql = 'delete from auth_groups where group_id = \'' + str(group_id) + '\' and authitem_id=\'' + str(self.id) +'\'' rs = conn.execute(sql) return True
def removeuser(self,user_id): conn = engine.connect() sql = 'delete from auth_users where user_id = \'' + str(user_id) + '\' and authitem_id=\'' + str(self.id) +'\'' rs = conn.execute(sql) return True
def removegroup(self, group_id): conn = engine.connect() sql = 'delete from auth_groups where group_id = \'' + str( group_id) + '\' and authitem_id=\'' + str(self.id) + '\'' rs = conn.execute(sql) return True
def removeuser(self, user_id): conn = engine.connect() sql = 'delete from auth_users where user_id = \'' + str( user_id) + '\' and authitem_id=\'' + str(self.id) + '\'' rs = conn.execute(sql) return True