def create_roles(serv, role):
session = Session()
s = session.query(Server).filter(Server.id == serv.id).first()
r = Role(role.id, role.name, s)
session.add(r)
session.commit()
session.close()
def give_item(user_id, item_id):
session = Session()
i = session.query(Item).filter(Item.id == item_id).first()
w = session.query(ItemInventory).filter(
ItemInventory.user_id == user_id).filter(ItemInventory.item_id == i.id)
if w.count() > 0:
w.first().count += 1
else:
n = ItemInventory(user_id, item_id, 1)
session.add(n)
session.commit()
session.close()
def win_lose_history(winner_id, loser_id, server_id):
session = Session()
h = session.query(HiscoresReport).filter(HiscoresReport.winner_id == winner_id) \
.filter(HiscoresReport.loser_id == loser_id) \
.filter(HiscoresReport.server_id == server_id)
if h.count() > 0:
h.first().count += 1
else:
r = HiscoresReport(winner_id, loser_id, server_id)
r.count = 1
session.add(r)
session.commit()
session.close()
def create_channel(channel, server):
session = Session()
s = session.query(Server).filter(Server.id == server.id).first()
chan = Channel(channel.id, channel.name, s)
match = Match(chan)
p1 = Player(match, 1)
p2 = Player(match, 2)
session.add(chan)
session.add(match)
session.add(p1)
session.add(p2)
session.commit()
session.close()
def create_user(user):
session = Session()
u = User(user.id, user.name)
session.add(u)
session.commit()
session.close()
def create_server(server_id, server_name):
session = Session()
s = Server(server_id, server_name)
session.add(s)
session.commit()
session.close()
def create_item(name, description, price):
session = Session()
i = Item(name, description, price)
session.add(i)
session.commit()
session.close()
