def get_user_list_json(global_config):
global_config['logger'].debug( 'GET User List' )
session = DbSession.open_db_session(global_config['users_db_name'] + global_config['this_season'])
user_list = UsersDataModel.getUserList(session)
session.remove()
web.header('Content-Type', 'application/json')
result = []
result.append('{ "users" : [\n')
for user in user_list:
result.append(' { "username": "******", "email_address": "%s", "display_name": "%s", "nickname": "%s", "access_level": "%s", \
"role": "%s", "subgroup": "%s", "contact_mode": "%s", "cellphone": "%s", "carrier": "%s", "state": "%s" }' % \
(user.username,user.email_address,user.display_name,user.altname, user.access_level, user.role, user.subgroup, user.contact_mode, user.cellphone, user.carrier, user.state))
result.append(',\n')
if len(user_list) > 0:
result = result[:-1]
result.append(' ] }\n')
return ''.join(result)
def get_user_list_page(global_config):
session = DbSession.open_db_session(global_config['users_db_name'] + global_config['this_season'])
result = ''
result += '<hr>'
result += '<br>'
result += '<a href="/newuser"> Create New User</a></td>'
result += '<br>'
result += '<a href="/deleteuser"> Delete User</a></td>'
result += '<br>'
result += '<a href="/loadusers"> Load Users From File</a></td>'
result += '<br>'
result += '<br>'
result += '<hr>'
users = UsersDataModel.getUsers(session)
user_list = UsersDataModel.getUserList(session)
result += insert_users_table(user_list)
session.remove()
return result
Session = sessionmaker(bind=my_db)
session = Session()
# Create the database if it doesn't already exist
if not os.path.exists('./' + db_name):
UsersDataModel.create_db_tables(my_db)
users = user_definitions.get_definitions()
for user, definition in users.iteritems():
UsersDataModel.addUserFromAttributes(session, definition)
session.commit()
taskgroups = UsersDataModel.getTaskgroupList(session)
print taskgroups
for group in taskgroups:
print group
members = UsersDataModel.getTaskgroupMembers(session,group)
print members
subgroups = UsersDataModel.getSubgroupList(session)
print subgroups
users = UsersDataModel.getUserList(session)
print users
users = UsersDataModel.getDisplayNameList(session)
print users
