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()