def setup(bot, update, session):
logger.info("Ricevuto comando setup da: %s",
update.message.from_user.username)
#data = models.registerUpdate(session, update)
if update.effective_user.id == OWNER:
models.createTables()
update.message.reply_text("Tabelle del database aggiornate",
quote="False")
import gtk
import models
import views
import os
connection = "sqlite://%s" % os.path.realpath("db.sqlite")
models.setConnection(connection)
models.createTables()
view = views.Shell()
view.show_all()
view.focus_topmost()
gtk.main()
def test_money_owed():
# Dump data
group_id = createTables()
print("Group %d created" % group_id)
# Dumping data for table 'person'
conn = sqlite3.connect('%s/person.db' % DB_DIR)
c = conn.cursor()
c.execute("INSERT INTO person (name, group_id) VALUES ('Alice', ?)", (group_id, ))
print("Alice's id is %d" % c.lastrowid)
c.execute("INSERT INTO person (name, group_id) VALUES ('Bob', ?)", (group_id, ))
print("Bob's id is %d" % c.lastrowid)
c.execute("INSERT INTO person (name, group_id) VALUES ('Charlie', ?)", (group_id, ))
print("Charlie's id is %d" % c.lastrowid)
conn.commit()
c.close()
# Table structure for table 'shop'
conn = sqlite3.connect('%s/shop.db' % DB_DIR)
c = conn.cursor()
c.execute("INSERT INTO shop (delivery_date, group_id) VALUES (140329, ?)", (group_id, ))
shop_id = c.lastrowid
conn.commit()
c.close()
# Table structure for table 'item'
conn = sqlite3.connect('%s/item.db' % DB_DIR)
c = conn.cursor()
c.execute("INSERT INTO item (name, price) VALUES ('Bananas', '200')")
print("Bananas' id is %d" % c.lastrowid)
c.execute("INSERT INTO item (name, price) VALUES ('Chocolate', '300')")
print("Chocolate's id is %d" % c.lastrowid)
c.execute("INSERT INTO item (name, price) VALUES ('Toilet Rolls', '600')")
print("Toilet Rolls's id is %d" % c.lastrowid)
conn.commit()
c.close()
# Table structure for table 'item_to_shop'
conn = sqlite3.connect('%s/item_to_shop.db' % DB_DIR)
c = conn.cursor()
c.execute("INSERT INTO item_to_shop (item_id, shop_id) VALUES (1, ?)", (shop_id, ))
c.execute("INSERT INTO item_to_shop (item_id, shop_id) VALUES (2, ?)", (shop_id, ))
c.execute("INSERT INTO item_to_shop (item_id, shop_id) VALUES (3, ?)", (shop_id, ))
conn.commit()
c.close()
# Table structure for table 'item_to_shop_to_person'
conn = sqlite3.connect('%s/item_to_shop_to_person.db' % DB_DIR)
c = conn.cursor()
c.execute("INSERT INTO item_to_shop_to_person (item_id, shop_id, person_id) VALUES (1, ?, 1)", (shop_id, ))
c.execute("INSERT INTO item_to_shop_to_person (item_id, shop_id, person_id) VALUES (1, ?, 2)", (shop_id, ))
c.execute("INSERT INTO item_to_shop_to_person (item_id, shop_id, person_id) VALUES (2, ?, 1)", (shop_id, ))
c.execute("INSERT INTO item_to_shop_to_person (item_id, shop_id, person_id) VALUES (3, ?, 1)", (shop_id, ))
c.execute("INSERT INTO item_to_shop_to_person (item_id, shop_id, person_id) VALUES (3, ?, 2)", (shop_id, ))
c.execute("INSERT INTO item_to_shop_to_person (item_id, shop_id, person_id) VALUES (3, ?, 3)", (shop_id, ))
conn.commit()
c.close()
# Alice and Bob share the Bananas. The Chocolate belongs to Alice. Everyone contributes to the toilet paper.
# Alice paid £6.00 (£2.00/2 + £3.00 + £6.00/3)
# Bob paid £3.00 (£2.00/2 + £6.00/3)
# Charlie paid £2.00 (£6.00/3)
flatmates = calculateMoneyOwed(shop_id)
print(flatmates)
if flatmates["Alice"] == 600:
print("Alice passed")
else:
print("Alice NOT passed")
if flatmates["Bob"] == 300:
print("Bob passed")
else:
print("Bob NOT passed")
if flatmates["Charlie"] == 200:
print("Charlie passed")
else:
print("Charlie NOT passed")
return
