async def on_start_up(application: Application): try: logger.info('rabbitmq connection stated') application['rabbit'] = await aio_pika.connect_robust(url=RABBITMQ_URL, loop=loop) logger.info('rabbitmq connection completed') logger.info('redis connection stated') application['redis'] = await aioredis.create_pool(address=REDIS_HOST) logger.info('redis connection completed') logger.info('db connection stated') db.connect() application['db'] = db logger.info('db connection completed') except (ConnectionError, Exception): logger.info('trying to establish connection after 2 sec') await asyncio.sleep(2)
def get_users(): conn = db.connect() cursor = conn.cursor() sql = "SELECT id, username, address FROM users" cursor.execute(sql) results = cursor.fetchall() print(results) conn.close()
def doLogin(flask): content = flask.request.json mydb = db.connect() mycursor = mydb.cursor() queryString = "SELECT id FROM users WHERE email=%s AND password=%s" queryResult = mycursor.execute(queryString, (content['email'], content['password'])) myresult = mycursor.fetchone() myResponse = [] if myresult: myResponse = {"rc": "00", "data": {"userId": myresult[0]}} else: myResponse = {"rc": "01", "message": "email or password is invalid"} return flask.jsonify(myResponse)
from configs import db db = db.connect() cursor = db.cursor() sql = "SELECT id, username, address FROM users" try: cursor.execute(sql) results = cursor.fetchall() response = [] for row in results: #print("userid: " , row[0], ", username: "******", address: " + row[2]) response.append({"userid" : row[0], "username" : row[1], "address" : row[2]}) print(response) except Exception: print("Error: cannot fetch the data") db.close()
from configs import db db = db.connect() cursor = db.cursor() sql = """INSERT INTO users(username, address) VALUES('wildananugrah01', 'Jl. Pejompongan')""" try: cursor.execute(sql) db.commit() except: db.rollback() db.close()
from configs import db db = db.connect() cursor = db.cursor() cursor.execute("SELECT * FROM users") data = cursor.fetchone() print(data) db.close()