def check_user(name, pwd):
stmt = 'SELECT COUNT(*) FROM users WHERE name=%s'
log = MySQL.query(stmt, name)
if 1 in log[0]:
stmt = 'SELECT password FROM users WHERE name=%s'
hash_pwd = MySQL.query(stmt, name)
return verify_password(str(pwd), str(hash_pwd[0]))
else:
return False
def add_user(name, age, gender, pwd):
stmt = 'INSERT INTO users (name, age, gender, password) VALUES (%s, %s, %s, %s)'
reg = MySQL.ins_query(stmt, name, age, gender, pwd)
if reg:
return True
else:
return reg
def check_duplicate(name):
stmt = 'SELECT COUNT(*) FROM users WHERE name=%s'
log = MySQL.query(stmt, name)
if not 1 in log[0]:
return True
else:
return False
def check_calendar():
name = get_name()
dt = request.form.get('date')
props = {'title': 'user old log', 'msg': '過去の記録確認'}
stmt = 'SELECT memo, dt, tm FROM users_log\
WHERE name = %s AND dt = %s'
timeline = MySQL.query(stmt, name, dt)
return render_template('user_old_log.html',
name=name, dt=dt, timeline=timeline, props=props)
def check_old_log():
name = get_name()
dt = get_today()
props = {'title': 'user old log', 'msg': '過去の記録確認'}
stmt = 'SELECT memo, dt, tm FROM users_log\
WHERE name = %s AND dt = cast(now() as date)'
timeline = MySQL.query(stmt, name)
return render_template('user_old_log.html',
name=name, dt=dt,timeline=timeline, props=props)
def write_log():
name = get_name()
memo = request.form.get('text')
dt = get_today()
tm = get_time()
props = {'title': 'success write log', 'msg': '記録出来ました！この調子！'}
stmt = 'INSERT INTO users_log values\
(%s, %s, %s, %s);'
write_log = MySQL.ins_query(stmt, name, memo, dt, tm)
return render_template('user_add_log.html',
name=name, memo=memo, dt=dt, tm=tm, props=props)
def users():
items = {'title': 'Users List', 'msg': 'Users List'}
dns = {'user': '******', 'host': 'localhost', 'database': 'kaggle'}
db = MySQL()
db.open(**dns)
sql = 'SELECT * FROM users'
users = db.query(sql)
db.close()
html = render_template('users.html', items=items, users=users)
return html
def user(id):
items = {'title': 'User Infomation', 'msg': 'User Infomation'}
dns = {'user': '******', 'host': 'localhost', 'database': 'kaggle'}
db = MySQL()
db.open(**dns)
sql = 'SELECT * FROM users WHERE id = ?'
data = db.query(sql, id, prepared=True)
user = [
bary.decode('utf-8') if isinstance(bary, bytearray) else bary
for bary in data[0]
]
db.close()
html = render_template('user.html', items=items, user=user)
return html
from flask import Flask
from flask import url_for
from flask import redirect
from flask import render_template
from DataStore.MySQL import MySQL
dns = {
'user': '******',
'host': 'localhost',
'password': '******',
'database': 'kaggle'
}
db = MySQL(**dns)
app = Flask(__name__)
@app.route('/')
def main():
props = {
'title': 'Step-by-Step Flask - index',
'msg': 'Welcom to Index Page.'
}
html = render_template('index.html', props=props)
return html
@app.route('/hello')
def hello():
props = {'title': 'Step-by-Step Flask - hello', 'msg': 'Hello World.'}
html = render_template('hello.html', props=props)