def get_kws_mgt_kws_info(self, kws_id):
ps = PropStore()
ps.kws_id = kws_id
ps.org_name = ""
ps.user_list = []
cur = db_session.execute(("SELECT creation_date, name FROM kcd_kws_list WHERE kws_id = %i") % (kws_id))
row = cur.fetchone()
if row == None: raise ErrorMsg("Teambox %i not found" % (kws_id))
ps.creation_date = row["creation_date"]
ps.name = ltu(row["name"])
cur.close()
cur = db_session.execute(("SELECT file_size, file_quota FROM kcd_kws_kfs_limit WHERE kws_id = %i") % (kws_id))
row = cur.fetchone()
if row == None: raise ErrorMsg("Teambox %i not found" % (kws_id))
ps.file_quota = row["file_quota"]
ps.file_size = row["file_size"]
cur.close()
cur = db_session.execute(("SELECT user_id, email, name_admin, name_user, org_name FROM " +\
"kcd_kws_users WHERE kws_id = %i ORDER BY user_id") % (kws_id))
for row in cur.fetchall():
user = PropStore()
user.user_id = row["user_id"]
user.email = ltu(row["email"])
if row["name_admin"] != "": user.name = ltu(row["name_admin"])
elif row["name_user"] != "": user.name = ltu(row["name_user"])
else: user.name = ""
user.org_name = ltu(row["org_name"])
ps.user_list.append(user)
db_session.rollback()
if len(ps.user_list): ps.org_name = ps.user_list[0].org_name
return ps
