def login(self): username = request.form['username'].strip() kata_sandi = request.form['kata_sandi'].strip() # cek record (ada?) instance_Model = Models( 'SELECT password, fullname FROM tbl_users WHERE username = %s') user = instance_Model.select_row(username) # record ditemukan if user != None: # cek kecocokan kata sandi if 'textmining_' + str(kata_sandi) + '_sentimentanalysis' == list( user)[0]: # session['username'] = username session['fullname'] = list(user)[1] return True flash('Username atau Kata Sandi tidak sesuai.') return False flash('Username tidak terdaftar.') return False
def register(self): username = request.form['username'].strip() kata_sandi = request.form['kata_sandi'].strip() fullname = request.form['fullname'].strip() # cek record (ada?) instance_Model = Models( 'SELECT password, fullname FROM tbl_users WHERE username = %s') user = instance_Model.select_row(username) # record TIDAK ditemukan if user == None: data_tambah = (username, 'textmining_' + str(kata_sandi) + '_sentimentanalysis', fullname) # simpan data user instance_Model = Models( 'INSERT INTO tbl_users(username, password, fullname) VALUES (%s, %s, %s)' ) instance_Model.query_sql(data_tambah) flash('Berhasil mendaftar, silakan masuk.', 'success') return True flash('Username telah terdaftar.', 'error') return False