def get_issue_form(global_config, issue_id): global_config['logger'].debug( 'GET Issue Form, Issue: %s', issue_id ) session = DbSession.open_db_session(global_config['issues_db_name'] + global_config['this_season']) users_session = DbSession.open_db_session(global_config['users_db_name'] + global_config['this_season']) issue_id = issue_id platform = issue_id.split('-')[0] issue = IssueTrackerDataModel.getIssue(session, issue_id) form = issueform() form[issue_id_label].value = issue_id form[issue_platform_label].value = platform form[issue_summary_label].value = issue.summary form[issue_status_label].value = issue.status form[issue_priority_label].value = issue.priority # TODO: can also extract the subgroup and taskgroup(component) lists from the # database and override the form with the contents # IssueTrackerDataModel.getSubgroupList() and getTaskgroupList() form[issue_subgroup_label].value = issue.subgroup form[issue_component_label].value = issue.component # apply the valid list of user names to the dropdown # for the owner field and the submitter field username_list = UsersDataModel.getDisplayNameList(users_session) form[issue_owner_label].args = username_list form[issue_submitter_label].args = username_list form[issue_owner_label].value = issue.owner form[issue_submitter_label].value = issue.submitter form[issue_description_label].value = issue.description return form
def get_new_issue_form(global_config, platform_type=None): global_config['logger'].debug( 'GET New Issue Form' ) users_session = DbSession.open_db_session(global_config['users_db_name'] + global_config['this_season']) form = new_issueform() # apply the valid list of user names to the dropdown # for the owner field and the submitter field username_list = UsersDataModel.getDisplayNameList(users_session) form[issue_owner_label].args = username_list form[issue_submitter_label].args = username_list # if the platform type is specified, then constrain the platform to that value if platform_type != None: form[issue_platform_label].args = [ platform_type ] # TODO: can also extract the subgroup and taskgroup(component) lists from the # database and override the form with the contents # IssueTrackerDataModel.getSubgroupList() and getTaskgroupList() return form
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