def list_result(engine):
engine = sa.create_engine(engine)
result = {}
with engine.begin() as connection:
select = vote_results.select()
results = connection.execute(select)
for id, name, votes in results.fetchall():
result[name] = votes
result = json.dumps(result)
return result
def increase_animal(engine, animal):
engine = sa.create_engine(engine)
with engine.begin() as connection:
select = vote_results.select().where(vote_results.c.name == animal)
results = connection.execute(select)
id, _, votes = results.fetchone()
new_votes = votes + 1
update = (vote_results.update().values(votes=new_votes).where(
vote_results.c.id == id))
connection.execute(update)
def get_results_list():
engine = sa.create_engine("sqlite:///vote_db.sqlite")
with engine.begin() as connection:
query = vote_results.select()
results = connection.execute(query)
res_list = []
for _, name, votes in results:
res_list.append([name, votes])
return res_list
def make_vote(animal):
engine = sa.create_engine("sqlite:///vote_db.sqlite")
with engine.begin() as connection:
select = vote_results.select().where(vote_results.c.name == animal)
results = connection.execute(select)
id, _, votes = results.fetchone()
new_vote = votes + 1
update = (vote_results.update().values(votes=new_vote).where(
vote_results.c.id == id))
connection.execute(update)
def get_results_json():
engine = sa.create_engine("sqlite:///vote_db.sqlite")
with engine.begin() as connection:
query = vote_results.select()
results = connection.execute(query)
# res_list = []
res_json = {}
for _, name, votes in results:
# res_list.append([name, votes])
res_json[name] = votes
return json.dumps(res_json)
def results():
engine = sa.create_engine("sqlite:///my_db.sqlite")
dict = {}
with engine.begin() as connection:
select = vote_results.select()
results = connection.execute(select)
for id, name, votes in results.fetchall():
dict[name] = votes
print(dict)
return dict
# results()
def add_animal_vote(animal):
"""
Функция для того чтобы принять название животного, найти его в базе и обновить значение (количество голосов)
:param animal:
:return:
"""
# engine = sa.create_engine("sqlite:///scripts/my_db.sqlite")
engine = sa.create_engine("sqlite:///my_db.sqlite")
with engine.begin() as connection:
select = vote_results.select().where(vote_results.c.name == animal)
results = connection.execute(select)
id, _, votes = results.fetchone()
new_votes = votes + 1
update = (vote_results.update().values(votes=new_votes).where(
vote_results.c.id == id))
connection.execute(update)
import sqlalchemy as sa
from app.db import vote_results
if __name__ == "__main__":
engine = sa.create_engine("sqlite:///my_db.sqlite")
with engine.begin() as connection:
select = vote_results.select()
results = connection.execute(select)
for id, name, votes in results.fetchall():
print(id, name, votes)
import sqlalchemy as sa
from app.db import vote_results
if __name__ == "__main__":
engine = sa.create_engine("sqlite:///my_db.sqlite")
with engine.begin() as connection:
select = vote_results.select().where(vote_results.c.name == "parrots")
results = connection.execute(select)
id, _, votes = results.fetchone()
new_votes = votes + 1
update = (vote_results.update().values(votes=new_votes).where(
vote_results.c.id == id))
connection.execute(update)
import sqlalchemy as sa
from app.db import vote_results
if __name__ == "__main__":
engine = sa.create_engine("sqlite:///my_db.sqlite")
with engine.begin() as connection:
select = vote_results.select().where(vote_results.c.name == "dogs")
results = connection.execute(select)
id, _, votes = results.fetchone()
new_votes = votes + 1
update = (
vote_results.update().values(votes=new_votes).where(vote_results.c.id == id)
)
connection.execute(update)
