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()