def getAllDevicesQuery(self):
from server import db_connect
conn = db_connect.connect() # connect to database
query = conn.execute(
"select * from users"
) # This line performs query and returns json result
return query
def getAllItemsByCategoryQuery(self, category_id):
from server import db_connect
conn = db_connect.connect() # connect to database
query = conn.execute("select * from items where category_id =%d " %
int(category_id))
# result = {'items': [dict(zip(tuple (query.keys()) ,i)) for i in query.cursor]}
return query
def day_data_currency_pair(currency_pair, date):
"""Get data about one currency pair
@currency_pair String: receives as value the currency pairs how 'EUR-USD'
@date String: recive as value a date how '5-2-2021'
"""
result = {}
try:
# Connect to DataBase
conn = db_connect.connect()
date_r = date.replace('-', '/')
query = conn.execute(
f'select name, exchange_pair from divisas where name="{currency_pair.upper()}" and date="{date_r}";'
)
result = {
'data': [dict(zip(tuple(query.keys()), i)) for i in query.cursor]
}
if len(result.get('data')) > 0:
hit_webhook(result['data'][0])
except Exception as error:
print(f'Error generate in day_data_currency_pair: {error}')
return error
return jsonify(result)
def getAllDevices(self):
from server import db_connect
conn = db_connect.connect() # connect to database
query = conn.execute(
"select registeration_id from users"
) # This line performs query and returns json result
devices = []
for row in query:
data = row['registeration_id']
devices.append(data)
# devices = devices[:-1]
print(devices)
return devices
def all_data_currency_pair(currency_pair):
"""Get All data of a currency pair
@currency_pair String: receives as value the currency pairs how 'EUR-USD'
"""
result = {}
try:
# Connect to DataBase
conn = db_connect.connect()
query = conn.execute(
f'select name, date from divisas where name="{currency_pair.upper()}";'
)
result = {
'data': [dict(zip(tuple(query.keys()), i)) for i in query.cursor]
}
except Exception as error:
print(f'Error generate in all_data_currency_pair: {error}')
return error
return jsonify(result)
def getAllItemsQuery(self):
from server import db_connect
conn = db_connect.connect() # connect to database
query = conn.execute("select * from items ")
return query