def google_login():
from app import Users, db
state = None
while state is None:
google_session = OAuth2Session(CLIENT_ID, CLIENT_SECRET,
scope=AUTHORIZATION_SCOPE,
redirect_uri=AUTH_REDIRECT_URI)
uri, state = google_session.create_authorization_url(AUTHORIZATION_URL)
flask.session[AUTH_STATE_KEY] = state
print(f"\n\nGoogle Auth State: \n\n{state}\n\n")
# flask.session.permanent = True
try:
user_info = get_user_info()
email = user_info['email']
user = Users.query.filter_by(email=email).first()
print(f"\n\n\n{user}\n\n\n")
if user is None:
user = Users(email=user_info['email'],
name=user_info['name'],
avatar=user_info['picture'])
db.session.add(user)
db.session.commit()
except:
return flask.redirect(uri, code=302)
return flask.redirect(uri, code=200)
def mocked_user_model(mocked_uuid):
mocked_uuid = mocked_uuid()
return Users(
"*****@*****.**",
str(mocked_uuid),
"A Name",
AuthType.GOOGLE,
"link",
)
def test_1_create_user(self):
db.session.add(
Users(last_name='Test',
first_name='Test1',
patronymic_name='Test2',
password='******',
email='*****@*****.**'))
db.session.commit()
user = Users.query.filter_by(email='*****@*****.**').first()
self.assertEqual('*****@*****.**', user.email)
def add_user_submit(n_clicks, UserID, UserPassword, UserType, UserFN, UserLN):
print('Got here')
if n_clicks > 0:
ed_user = Users(UserID=UserID,
UserPassword=UserPassword,
UserFirstName=UserFN,
UserLastName=UserLN,
UserType=UserType)
db.session.add(ed_user)
ed_portfolio = Portfolio(UserID=UserID, Cash=1000000)
db.session.add(ed_portfolio)
db.session.commit()
return 2
def add_admin():
admin_user = {
'name': 'admin',
'email': '*****@*****.**',
'password': '******'
}
admin = Users(name=admin_user['name'],
email=admin_user['email'],
password=admin_user['password'])
try:
db.session.add(admin)
db.session.commit()
except SQLAlchemyError as e:
error = str(e.__dict__['orig'])
return error
def createAccount():
from app import db, Users
db.create_all()
if request.method == 'POST':
username = request.form['username']
password = request.form['password']
confirm_password = request.form['password2']
name = request.form['name']
if password != confirm_password:
render_template('password_error.html')
redirect('/')
else:
db.session.add(
Users(username=username, password=password, name=name))
db.session.commit()
return render_template("createAccount.html")
def user():
if request.method == 'GET':
query = request.args
print(query)
data = Users.query.filter_by(email=query["email"]).first()
return str(data)
data = request.args
if request.method == 'POST':
user = Users(email=data['email'], password=data['password'])
db.session.add(user)
db.session.commit()
return 'User has been added'
if request.method == 'PATCH':
pass
if request.method == 'DELETE':
pass
def Sign():
form = RegisterForm()
if form.validate_on_submit():
hashed_password = generate_password_hash(form.password.data,
method='sha256')
users = Users.query.filter_by(username=form.username.data).first()
usersEmail = Users.query.filter_by(email=form.email.data).first()
if users is None or usersEmail is None:
new_user = Users(username=form.username.data,
email=form.email.data,
password=hashed_password)
db.session.add(new_user)
db.session.commit()
login_user(new_user, remember=form.remember.data)
flash('Vous êtes bien connecté en tant que ' + form.username.data)
return redirect(url_for('main.home'))
else:
flash('Identifiant ou Email déjà utilisé')
return render_template('sign.html', form=form)
from app import db, Users db.drop_all() db.create_all() testuser = Users(first_name='Grooty', last_name='Toot') db.session.add(testuser) db.session.commit() ## works!
from app import db, Users
db.drop_all()
db.create_all()
testuser = Users(
first_name='Grooty', last_name='Toot'
) # Extra: this section populates the table with an example entry
db.session.add(testuser)
db.session.commit()
from app import db_add_user, db_add_comment
from app import add_event_id, mock_on_likes_dislikes
KEY_INPUT = 'input'
KEY_EXPECTED = 'expected'
INPUT = "id, event_id"
EXPECTED_OUTPUT = "expected"
ID = 'id'
EVENT_ID = 'eventID'
FIRST_ADDITION = Bookmarks(clientId='234', event_id='567')
SECOND_ADDITION = Bookmarks(clientId='678', event_id='907')
THIRD_ADDITION = Bookmarks(clientId='1234', event_id='5678')
INITIAL_PERSON = Bookmarks(clientId='1234', event_id='1234')
initial_user = Users(id="1234567", email="*****@*****.**", firstName="NameFirst", familyName="NameLast", imageURL="url.img.jpg")
expected_user = Users(id="7654321", email="*****@*****.**",firstName="firstname",familyName="lastname",imageURL="https://lh3.googleusercontent.com/754321")
class AddUserTestCase(unittest.TestCase):
def setUp(self):
self.success_test_params = [
{
KEY_INPUT: {
"googleId": "7654321",
"email": "*****@*****.**",
"givenName": "firstname",
"familyName": "lastname",
"imageUrl": "https://lh3.googleusercontent.com/754321",
},
KEY_EXPECTED: [initial_user, expected_user],
},
]
def addUser(username,email):
user = Users(username=username,email=email)
db.session.add(user)
db.session.commit()
from app import db, Users db.drop_all() db.create_all() user_1 = Users(first_name='Jalal', last_name="Saadat") db.session.add(user_1) db.session.commit()
from app import db, Users
db.drop_all()
db.create_all()
testuser = Users(
first_name='kazi', last_name='uddin'
) # Extra: this section populates the table with an example entry
db.session.add(testuser)
db.session.commit()
address_state=fake.state(),
address_country='US',
address_zip=fake.zipcode(),
phone=fake.phone_number(),
email=fake.free_email())
# set created date to simulate users creating accounts throughout the year
created_date = fake.date_this_year(before_today=True, after_today=False)
# create a record from sqlalchemy model
user_record = Users(id=user.id,
company=user.company,
date_created=created_date,
description=user.description,
email=user.email,
name=user.name,
phone=user.phone,
address_city=user.address_city,
address_country=user.address_country,
address_line1=user.address_line1,
address_line2=user.address_line2,
address_state=user.address_state,
address_zip=user.address_zip,
anniversary=str(created_date.month) + '-' +
str(created_date.day),
password=fake.md5())
# add model to db session
db.session.add(user_record)
# add all records to db session
db.session.commit()
from app import db, Users db.drop_all() ##deletes db db.create_all() ## creates db user_1 = Users(first_name="Arman", Last_name="Khan") db.session.add(user_1) db.session.commit()