def fuel_estimation_add():
payload = request.get_json(force=True)
token = Token.verify(payload['token'])
stations = payload['stations']
date = today()
print('Recording fuel price estimations for {} from {}, token {}'.format(
date, token.character.name, token.id))
FuelPriceEstimation.query.filter_by(day=date).delete()
for station_name, price in stations.items():
try:
station = Station.query.filter_by(name=station_name).one()
est = FuelPriceEstimation(
station=station,
day=date,
price_per_g=price,
)
db.session.add(est)
except NoResultFound:
print(' Found no station {}'.format(station_name))
db.session.commit()
return jsonify({'recorded': True})
def all_today(cls):
return cls.query.filter(cls.day == today()).order_by(
cls.price_per_g.asc())
def add_vendory_inventory():
payload = request.get_json(force=True)
token = Token.verify(payload['token'])
token.record_script_version(payload.get('script_version'))
messages = []
station = get_station(payload['system'], payload['station'])
vendor_name = payload['vendor']
print('Vendor {} at {} submitted by {}'.format(vendor_name, station.short
or station.id,
token.character.name))
vendor = Vendor.query.filter_by(station_id=station.id,
name=vendor_name).first()
if not vendor:
messages.append('Vendor created.')
vendor = Vendor(
station=station,
name=vendor_name,
)
db.session.add(vendor)
slugs = {iv['slug'] for iv in payload['inventory']} - vendor_blacklist
items = {
item.slug: item
for item in Item.query.filter(Item.slug.in_(sorted(slugs)))
}
missing = [slug for slug in slugs if not slug in items]
if missing:
return jsonify({
'recorded':
False,
'message':
'The Tracker does not know about the following item(s): ' +
', '.join([linkify(slug) for slug in missing])
})
new_timestamp = datetime.utcnow()
day = today()
# make sure the inventory is up-to-date
latest_inventory = VendorInventory.query.filter_by(vendor_id=vendor.id, is_current=True) \
.order_by(VendorInventory.last_seen.desc()).first()
has_current_inventory = False
if latest_inventory:
if latest_inventory.item_slugs == slugs:
has_current_inventory = True
# inventory still up to date
latest_inventory.last_seen = new_timestamp
messages.append('Updated inventory timestamp.')
else:
latest_inventory.is_current = False
if not has_current_inventory:
latest_inventory = VendorInventory(
token=token,
vendor=vendor,
first_seen=new_timestamp,
last_seen=new_timestamp,
)
db.session.add(latest_inventory)
for item in items.values():
db.session.add(
VendorInventoryItem(
vendor_inventory=latest_inventory,
item=item,
))
# check/update item prices
def price_tuple(d):
v = d['price']
return (float(v), None) if d['currency'] == 'credits' else (None,
int(v))
existing_prices = {
vipr.item.slug: vipr
for vipr in VendorItemPriceReading.query.filter_by(
vendor_inventory_id=latest_inventory.id, day=day)
}
prices_updated = False
for d in payload['inventory']:
slug = d['slug']
if slug in vendor_blacklist:
continue
credits, bonds = price_tuple(d)
if slug in existing_prices:
record = existing_prices[slug]
if record.price_credits != credits or record.price_bonds != bonds:
prices_updated = True
record.price_credits = credits
record.price_bonds = bonds
record.token = token
else:
vipr = VendorItemPriceReading(
token=token,
vendor=vendor,
vendor_inventory=latest_inventory,
item=Item.query.filter_by(slug=slug).one(),
day=day,
price_credits=credits,
price_bonds=bonds,
)
db.session.add(vipr)
prices_updated = True
if prices_updated:
messages.append('Price information recorded/updated.')
db.session.commit()
return jsonify({'recorded': True, 'message': ' '.join(messages)})