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')
