def select(self, data):
command_string = "select USER_ID, PASSWORD from STAT_SNAP_USER where USER_ID = '" + str(
data) + "'"
self.cur.execute(command_string)
row = self.cur.fetchone()
user = User()
user.set_values_from_row([row[0], row[1]])
return user
def create_account():
if request.method == 'POST':
userDao = UserDAO()
user = User()
user.set_values_from_row(
[str(request.form['username']),
str(request.form['password'])])
userDao.insert(user)
return redirect(url_for('login'))
return render_template("create_account.html")
def insert_new_user(json):
if (
not json
or (not 'firstName' in json)
or (not 'lastName' in json)
or (not 'email' in json)
or (not 'hashedPassword' in json)
or (not 'userType' in json)
):
abort(400, 'Not all fields were received.')
if not validate_email(json['email']):
abort(400, 'The email address is invalid.')
query_result = db.session.query(User).filter(and_(User.email == json['email'], not_(User.deleted))).first()
if query_result:
abort(400, 'A user with this email address already exists.')
user = User(
email = json['email'],
first_name = json['firstName'],
last_name = json['lastName'],
user_type = json['userType'],
password = json['hashedPassword'],
creation_date = datetime.now(),
deleted = False,
description = '',
phone_number = '',
avatar = 'default'
)
db.session.add(user)
db.session.commit()
resp = jsonify({
'success': True,
'user': user.to_dict()
})
resp.status_code = 200
return resp
from database.PostRecord import PostRecord
with app.app_context():
db.drop_all()
db.create_all()
print("All tables created.")
# Users
js = User(
email = 'js@ex',
first_name = 'John',
last_name = 'Smith',
password = '******', #aaaaaa
deleted = False,
user_type = 'Movee',
creation_date = datetime.now(),
description = '',
phone_number = '0400 111 222',
avatar = 'male1'
)
db.session.add(js)
db.session.commit()
ml = User(
email = 'ml@ex',
first_name = 'Movee',
last_name = 'Lee',
password = '******', #aaaaaa
deleted = False,
