def current_map_data(cls):
data = {}
for candidate in session.query(cls).all():
data[candidate.name] = {}
q = session.query(TweetSentiment)
sentiments = q.filter_by(candidate=candidate)
for sentiment in sentiments.all():
map_data = sentiment.map_data
data[map_data.pop('name')][map_data.pop('state')] = map_data
return data
def get_all_coord():
response.headers['Content-Type'] = 'application/json'
coords = session.query(Coord).all()
js = coords_schema.dump(coords).data
print(type(js))
print(js)
return json.dumps(js)
def get_one_coord(coord_id):
coord = session.query(Coord).filter_by(id=coord_id).first()
if not coord:
return json.dumps({'message': 'No coord found!'}, 404)
response.headers['Content-Type'] = 'application/json'
print(coord_schema.dump(coord).data)
return coord_schema.dump(coord).data
def main():
c = Coord(id="test", x=0, y=0)
print("c: " + str(coord_schema.dump(c).data))
session.add(c)
session.commit()
coords = session.query(Coord).all()
print("all: " + str(coords_schema.dump(coords).data))
if len(sys.argv) > 1 and sys.argv[1] == "exit":
return
bottle.run(server='gunicorn', host='127.0.0.1', port=5000)
def delete_coord(coord_id):
response.headers['Content-Type'] = 'application/json'
coord = session.query(Coord).filter_by(coord_id=coord_id).first()
if not coord:
return json.dumps({'message': 'No coord found!'})
session.delete(coord)
session.commit()
return json.dumps({'message': 'The coord has been deleted!'})
def get_user(**arguments):
"""
Creates a query with the given arguments for user selection. Returns the query.
"""
query = session.query(User)
if "id" in arguments:
query = query.filter_by(id=int(arguments["id"]))
if "discord_id" in arguments:
query = query.filter_by(discord_id=arguments["discord_id"])
return query
def get_currency(**arguments):
"""
Creates a query with given arguments for currency selection. Returns the query.
"""
query = session.query(Currency)
if "id" in arguments:
query = query.filter_by(id=int(arguments["id"]))
if "short_code" in arguments:
query = query.filter_by(short_code=str(arguments["short_code"]))
if "value" in arguments:
query = query.filter_by(value=float(arguments["value"]))
return query
def get_user_currency(**arguments):
"""
Creates a query with the given arguments for user currency selection. Returns the query.
"""
query = session.query(UserCurrency)
if "id" in arguments:
query = query.filter_by(id=int(arguments["id"]))
if "user_id" in arguments:
query = query.filter_by(user_id=int(arguments["user_id"]))
if "short_code" in arguments:
query = query.filter_by(short_code=str(arguments["short_code"]))
if "amount" in arguments:
query = query.filter_by(amount=float(arguments["amount"]))
return query
def get_user_bet(**arguments):
"""
Creates a query with the given arguments for a bet. Returns the query.
"""
query = session.query(UserBet)
if "id" in arguments:
query = query.filter_by(id=int(arguments["id"]))
if "user_id" in arguments:
query = query.filter_by(user_id=int(arguments["user_id"]))
if "bet_id" in arguments:
query = query.filter_by(bet_id=int(arguments["bet_id"]))
if "deposit" in arguments:
query = query.filter_by(deposit=float(arguments["deposit"]))
return query
def get_bet(**arguments):
"""
Creates a query with the given arguments for a bet. Returns the query.
"""
query = session.query(Bet)
if "id" in arguments:
query = query.filter_by(id=int(arguments["id"]))
if "created_by" in arguments:
query = query.filter_by(created_by=int(arguments["created_by"]))
if "bet" in arguments:
query = query.filter_by(bet=str(arguments["bet"]))
if "rate" in arguments:
query = query.filter_by(rate=float(arguments["rate"]))
return query
def get_system_variable(variable):
"""
Returns a system variable from database.
"""
return session.query(System).filter_by(variable=variable).first()
