def init(ac_id, pswd, email): create_tables() salt = create_salt() ps_hash = hashPass(salt + pswd) account = Account(ac_id, ps_hash, salt, email, 0) # セッションを生成 ses = Session() count = ses.query(Account).count() if count > 0: print("This database is already inited") return ses.add(account) ses.commit() ses.close()
def passwordCheck(ac_id, pswd): ses = Session() try: count = ses.query(Account).filter_by(ac_id=ac_id).count() if count <= 0: return False ac_query = ses.query(Account).filter_by(ac_id=ac_id)[0] pshs = hashPass(ac_query.salt + pswd) if pshs == ac_query.pass_hash: return True return False finally: print("close") ses.close()