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