def put(self): # update a single user print('User API: update a single user') requestData = request.get_data().decode('utf8') userData = json.loads(requestData) newUser = User() newUser.id = userData['p_user_id'] newUser.firstName = userData['p_first_name'] newUser.lastName = userData['p_last_name'] newUser.email = userData['p_email'] newUser.emailValidated = userData['p_email_validated'] newUser.accountStatus = userData['p_account_status'] newUser.username = userData['p_username'] newUser.password = userData['p_password'] newUser.bio = userData['p_bio'] newUser.subscribe = userData['p_subscribe'] newUser.category = userData['p_category'] newUser.role = userData['p_role'] mod_user(newUser) return jsonify({"data":"5"})
def post(self): # create a new user print('User API: create a new user') requestData = request.get_data().decode('utf8') userData = json.loads(requestData) newUser = User() newUser.firstName = userData['p_first_name'] newUser.lastName = userData['p_last_name'] newUser.email = userData['p_email'] newUser.emailValidated = userData['p_email_validated'] newUser.accountStatus = userData['p_account_status'] newUser.username = userData['p_username'] newUser.password = userData['p_password'] newUser.bio = userData['p_bio'] newUser.subscribe = userData['p_subscribe'] newUser.category = userData['p_category'] newUser.role = userData['p_role'] add_user(newUser) # TODO: Finish this section, then do "def put()" return jsonify({"Saved": True})
def load_initial_data(): with session_scope() as s: totalUserRecords = s.query(User).count() if totalUserRecords == 0: user_1 = User() user_1.firstName = 'Steve' user_1.lastName = 'OHearn' user_1.email = '*****@*****.**' user_1.accountStatus = 'ACTIVE' user_1.username = '******' user_1.password = '******' user_1.bio = 'Creator of the DatabaseTraining.com site.' user_1.role = 'ADMIN' user_1.language = 'English' s.add(user_1) lov_master_1 = LOV_Master() lov_master_1.lov_master_category = 'Role' the_pk = s.add(lov_master_1) lov_entity_1 = LOV_Entity() lov_entity_1.lov_master_id = the_pk lov_entity_1.lov_value = 'VISITOR' lov_entity_1.lov_sort_order = 1 s.add(lov_category_1) lov_entity_2 = LOV_Entity() lov_entity_2.lov_master_id = the_pk lov_entity_2.lov_value = 'REGISTERED' lov_entity_2.lov_sort_order = 2 s.add(lov_category_2) lov_entity_3 = LOV_Entity() lov_entity_3.lov_master_id = the_pk lov_entity_3.lov_value = 'ADMIN' lov_entity_3.lov_sort_order = 3 s.add(lov_category_3) s.commit() print('Starting FOR loop ...') theResults = s.query(User, User.firstName, User.lastName).all() for row in theResults: print(row.User, row.firstName) print('Initialization completed.') else: print('Already initialized at a prior time')