def setapikeys(self, full_apikey = None, apiuserid = None, error = 0):
session = EVCstate(trust=True)
db = evec_func.db_con()
user = User.get(session, db)
if not user.valid:
return
t = display.template('user_setapikeys.tmpl', session)
t.errormsg = ""
t.full_apikey = user.full_apikey
t.apiuserid = user.apiuserid
if full_apikey is not None and full_apikey != "":
user.full_apikey = full_apikey
user.apiuserid = apiuserid
session['user'] = user
user.update_user(db)
session.save()
t.full_apikey = user.full_apikey
t.apiuserid = user.apiuserid
if error == 1:
t.errormsg = "We couldn't access the API services with the keys below - please double check your input"
return t.respond()
def tradefind_search(self, qtype, fromt, to):
session = EVCstate()
t = display.template('tradefind_search.tmpl', session)
db = evec_func.db_con()
cur_f = db.cursor()
cur_t = db.cursor()
t.qtype = qtype
t.fromt = fromt
t.to = to
fromt = "%" + fromt + "%"
to = "%" + to + "%"
if qtype == "Systems":
cur_f.execute(
"SELECT systemid,(systemname || ' / ') || regionname FROM systems,regions WHERE systems.regionid = regions.regionid AND systemname ILIKE %s ORDER BY systemname",
[fromt])
cur_t.execute(
"SELECT systemid,(systemname || ' / ') || regionname FROM systems,regions WHERE systems.regionid = regions.regionid AND systemname ILIKE %s ORDER BY systemname",
[to])
elif qtype == "Regions":
cur_f.execute(
"SELECT regionid,regionname FROM regions WHERE regionname ILIKE %s ORDER BY regionname",
[fromt])
cur_t.execute(
"SELECT regionid,regionname FROM regions WHERE regionname ILIKE %s ORDER BY regionname",
[to])
elif qtype == "SystemToRegion":
cur_f.execute(
"SELECT systemid,(systemname || ' / ') || regionname FROM systems,regions WHERE systems.regionid = regions.regionid AND systemname ILIKE %s ORDER BY systemname",
[fromt])
cur_t.execute(
"SELECT regionid,regionname FROM regions WHERE regionname ILIKE %s ORDER BY regionname",
[to])
from_list = []
to_list = []
for (q, list) in [(cur_f, from_list), (cur_t, to_list)]:
r = q.fetchone()
while r:
d = {}
d['id'] = r[0]
d['name'] = r[1]
list.append(d)
r = q.fetchone()
t.from_list = from_list
t.to_list = to_list
db.close()
session.save()
return t.respond()
def tradefind_search(self, qtype, fromt, to):
session = EVCstate()
t = display.template("tradefind_search.tmpl", session)
db = evec_func.db_con()
cur_f = db.cursor()
cur_t = db.cursor()
t.qtype = qtype
t.fromt = fromt
t.to = to
fromt = "%" + fromt + "%"
to = "%" + to + "%"
if qtype == "Systems":
cur_f.execute(
"SELECT systemid,(systemname || ' / ') || regionname FROM systems,regions WHERE systems.regionid = regions.regionid AND systemname ILIKE %s ORDER BY systemname",
[fromt],
)
cur_t.execute(
"SELECT systemid,(systemname || ' / ') || regionname FROM systems,regions WHERE systems.regionid = regions.regionid AND systemname ILIKE %s ORDER BY systemname",
[to],
)
elif qtype == "Regions":
cur_f.execute(
"SELECT regionid,regionname FROM regions WHERE regionname ILIKE %s ORDER BY regionname", [fromt]
)
cur_t.execute("SELECT regionid,regionname FROM regions WHERE regionname ILIKE %s ORDER BY regionname", [to])
elif qtype == "SystemToRegion":
cur_f.execute(
"SELECT systemid,(systemname || ' / ') || regionname FROM systems,regions WHERE systems.regionid = regions.regionid AND systemname ILIKE %s ORDER BY systemname",
[fromt],
)
cur_t.execute("SELECT regionid,regionname FROM regions WHERE regionname ILIKE %s ORDER BY regionname", [to])
from_list = []
to_list = []
for (q, list) in [(cur_f, from_list), (cur_t, to_list)]:
r = q.fetchone()
while r:
d = {}
d["id"] = r[0]
d["name"] = r[1]
list.append(d)
r = q.fetchone()
t.from_list = from_list
t.to_list = to_list
db.close()
session.save()
return t.respond()
def setigb(self, isigb="0"):
session = EVCstate()
if isigb == "1":
session['isigb'] = True
else:
session['isigb'] = False
session.save()
emit_redirect('/home/')
def setigb(self, isigb="0"):
session = EVCstate()
if isigb == "1":
session["isigb"] = True
else:
session["isigb"] = False
session.save()
emit_redirect("/home/")
def tradefind_display(self,
qtype,
fromt,
to,
set=None,
age=24,
cashonhand=10000000.00,
minprofit=100000,
size=10000,
startat=0,
limit=50,
newsearch="0",
sort="jprofit",
prefer_sec="0"):
session = EVCstate()
t = display.template('tradefind_display.tmpl', session)
db = evec_func.db_con()
newsearch = int(newsearch)
if 'trade_results' not in session:
newsearch = 1
cur = db.cursor()
limit = int(limit)
prefer_sec = int(prefer_sec)
recalc_route = False
if sort not in ['jprofit', 'sprofit', 'profit', 'jumps']:
return
if set:
session['tf_age'] = age
session['tf_minprofit'] = minprofit
session['tf_size'] = size
session['tf_limit'] = limit
session['tf_sort'] = sort
session['tf_prefer_sec'] = prefer_sec
newsearch = 1
else:
if 'tf_age' in session:
age = session['tf_age']
if 'tf_minprofit' in session:
minprofit = session['tf_minprofit']
if 'tf_size' in session:
size = session['tf_size']
if 'tf_limit' in session:
limit = session['tf_limit']
if 'tf_sort' in session:
sort = session['tf_sort']
if 'tf_prefer_sec' in session:
prefer_sec = session['tf_prefer_sec']
else:
prefer_sec = 1
age_t = str(int(age)) + " hours"
size = str(int(size))
cashonhand = str(double(cashonhand))
sql_profit_size = """ (t.price - f.price)* min(""" + size + """, min(t.volremain,f.volremain) * types.size)/types.size """
sql_profit_jumps = """ '1' """
#sql_cash = """ f.price <= $(cashonhand)s """
sql_sec_limit = """ """
if prefer_sec:
sql_sec_limit = """ fsys.security > 0.4 AND tsys.security > 0.4 AND """
cur_f = db.cursor()
cur_t = db.cursor()
#####
# Warning: This is easily the worst piece of code I have ever written.
# I really am sorry.
#####
# Pure suck query
if qtype == "Systems" and newsearch:
cur.execute(
"""SELECT types.typeid,types.typename,fs.systemid,ts.systemid,fs.stationname,ts.stationname,t.price - f.price AS pricediff,
min(t.volremain,f.volremain),
(t.price - f.price)* min(t.volremain,f.volremain) AS profit,
""" + sql_profit_size + """ AS profit_size,
""" + sql_profit_jumps + """ AS profit_jumps,
t.price,f.price,
t.volremain,f.volremain
FROM
types, current_market AS f, current_market AS t, stations AS fs, stations AS ts, systems AS fsys, systems AS tsys
WHERE
""" + sql_sec_limit + """
ts.systemid = tsys.systemid AND fs.systemid = fsys.systemid AND
f.minvolume <= 1 AND t.minvolume <= 1 AND
f.bid = 0 AND t.bid = 1 AND f.systemid = %(fromt)s AND t.systemid = %(to)s AND t.typeid = f.typeid AND t.stationid = ts.stationid AND
f.stationid = fs.stationid AND
age(f.reportedtime) < %(age)s AND age(t.reportedtime) < %(age)s AND
""" + sql_profit_size + """ >= %(minprofit)s AND
types.size <= """ + size + """ AND
t.typeid = types.typeid
AND f.typeid = types.typeid
AND f.price < t.price""", {
'fromt': fromt,
'to': to,
'age': age_t,
'minprofit': minprofit,
})
cur_f.execute(
"SELECT systemid,(systemname || ' / ') || regionname FROM systems,regions WHERE systems.regionid = regions.regionid AND systemid = %s ORDER BY systemname",
[fromt])
cur_t.execute(
"SELECT systemid,(systemname || ' / ') || regionname FROM systems,regions WHERE systems.regionid = regions.regionid AND systemid = %s ORDER BY systemname",
[to])
elif qtype == "Regions" and newsearch:
cur.execute(
"""SELECT types.typeid,types.typename,fs.systemid,ts.systemid,fs.stationname,ts.stationname,t.price - f.price AS pricediff,
min(t.volremain,f.volremain),
(t.price - f.price)*min(t.volremain,f.volremain) AS profit,
""" + sql_profit_size + """ AS profit_size,
""" + sql_profit_jumps + """ AS profit_jumps,
t.price,f.price, t.volremain, f.volremain
FROM types, current_market AS f, current_market AS t, stations AS fs, stations AS ts, systems AS fsys, systems AS tsys
WHERE
""" + sql_sec_limit + """
ts.systemid = tsys.systemid AND fs.systemid = fsys.systemid AND
f.minvolume <= 1 AND t.minvolume <= 1 AND
f.bid = 0 AND t.bid = 1 AND f.regionid = %(fromt)s AND t.regionid = %(to)s AND t.typeid = f.typeid AND t.stationid = ts.stationid AND
f.stationid = fs.stationid AND
age(f.reportedtime) < %(age)s AND age(t.reportedtime) < %(age)s AND
""" + sql_profit_size + """ >= %(minprofit)s AND
types.size <= """ + size + """ AND
t.typeid = types.typeid
AND f.typeid = types.typeid
AND f.price < t.price""", {
'fromt': fromt,
'to': to,
'age': age_t,
'minprofit': minprofit,
})
cur_f.execute(
"SELECT regionid,regionname FROM regions WHERE regionid = %s ORDER BY regionname",
[fromt])
cur_t.execute(
"SELECT regionid,regionname FROM regions WHERE regionid = %s ORDER BY regionname",
[to])
elif qtype == "SystemToRegion" and newsearch:
cur.execute(
"""SELECT types.typeid,types.typename,fs.systemid,ts.systemid,fs.stationname,ts.stationname,t.price - f.price AS pricediff,
min(t.volremain,f.volremain),
(t.price - f.price)*min(t.volremain,f.volremain) AS profit,
""" + sql_profit_size + """ AS profit_size,
""" + sql_profit_jumps + """ AS profit_jumps,
t.price,f.price, t.volremain, f.volremain
FROM types, current_market AS f, current_market AS t, stations AS fs, stations AS ts, systems AS fsys, systems AS tsys
WHERE
""" + sql_sec_limit + """
ts.systemid = tsys.systemid AND fs.systemid = fsys.systemid AND
f.minvolume <= 1 AND t.minvolume <= 1 AND
f.bid = 0 AND t.bid = 1 AND f.systemid = %(fromt)s AND t.regionid = %(to)s AND t.typeid = f.typeid AND t.stationid = ts.stationid AND
f.stationid = fs.stationid AND
age(f.reportedtime) < %(age)s AND age(t.reportedtime) < %(age)s AND
""" + sql_profit_size + """ >= %(minprofit)s AND
types.size <= """ + size + """ AND
t.typeid = types.typeid
AND f.typeid = types.typeid
AND f.price < t.price""", {
'fromt': fromt,
'to': to,
'age': age_t,
'minprofit': minprofit,
})
cur_f.execute(
"SELECT systemid,(systemname || ' / ') || regionname FROM systems,regions WHERE systems.regionid = regions.regionid AND systemid = %s ORDER BY systemname",
[fromt])
cur_t.execute(
"SELECT regionid,regionname FROM regions WHERE regionid = %s ORDER BY regionname",
[to])
trades = []
time_net = 0.0
import __builtin__
from_set = __builtin__.set()
from_map = {}
from_to_map = {}
error_log = []
fromcache = 0
if newsearch:
r = cur.fetchone()
while r:
row = SorterDict('sortby')
row['typeid'] = r[0]
row['typename'] = r[1]
fr = int(r[2])
to2 = int(r[3])
row['fr'] = int(r[2])
row['to2'] = int(r[3])
row['fromstation'] = r[4]
row['tostation'] = r[5]
row['pricediff'] = r[6]
row['tradeable'] = format_long(long(r[7]))
row['profit'] = format_price(float(r[8]))
row['profit_num'] = float(r[8])
row['profit_size'] = float(r[9])
from_set.add(fr)
row['tprice'] = format_price(float(r[11]))
row['fprice'] = format_price(float(r[12]))
row['tvol'] = format_long(long(r[13]))
row['fvol'] = format_long(long(r[14]))
trades.append(row)
# Add to from_to_map - map source
if fr in from_to_map:
from_to_map[fr].add(row['to2'])
else:
from_to_map[fr] = __builtin__.set()
from_to_map[fr].add(row['to2'])
if fr in from_map:
from_map[fr].append(row)
else:
from_map[fr] = []
from_map[fr].append(row)
r = cur.fetchone()
# Now we try to compute distance
for compsys in from_set:
distance_map = {}
distance = 0
time_net_ = time.time()
for tosystem in from_to_map[compsys]:
load = urllib.urlopen(
'http://127.0.0.1:8081/api/distance/from/' +
str(int(compsys)) + '/to/' + str(int(tosystem)))
s = load.read()
load.close()
distance_map[tosystem] = json.loads(s)['distance']
time_net += time.time() - time_net_
for row in from_map[compsys]:
if row['fr'] == compsys:
if compsys == row['to2']:
distance = 0
else:
distance = distance_map[row['to2']]
ps = row['profit_size']
row['profit_size'] = format_price(ps)
if sort == "jprofit":
row['sortby'] = ps / (max(0, distance) + 1)
t.sort_nice = "Profit per jump"
elif sort == "sprofit":
row['sortby'] = ps
t.sort_nice = "Profit per trip"
elif sort == "profit":
row['sortby'] = row['profit_num']
t.sort_nice = "Profit"
elif sort == "jumps":
t.sort_nice = "Distance"
row['sortby'] = distance
row.reverse = True
row['profit_jumps'] = format_price(
float(ps / (1 + max(0, distance))))
row['distance'] = distance
time_sort = time.time()
trades.sort(reverse=True)
time_sort = time.time() - time_sort
#session['trade_results'] = trades
else:
trades = session['trade_results']
fromcache = 1
trade_num = len(trades)
trades = trades[int(startat):int(startat) + int(limit)]
t.fromcache = fromcache
t.num_trades = trade_num
t.trades = trades
t.fromt = fromt
t.to = to
t.qtype = qtype
t.age = age
t.minprofit = minprofit
t.size = size
t.startat = startat
t.limit = limit
t.sort = sort
t.prefer_sec = prefer_sec
t.fromname = cur_f.fetchone()[1]
t.toname = cur_t.fetchone()[1]
t.page = int((int(startat) + 1) / limit) + 1
t.next = int(startat) + limit
t.prev = max(0, int(startat) - limit)
db.close()
session.save()
return t.respond(
) + "Pathfinder time: %0.3fs, Sort time: %0.3fs, recompute set was %d elements long<br>" % (
time_net, time_sort, len(from_set))
def tradefind_display(self, qtype, fromt, to, set = None, age = 24, cashonhand = 10000000.00, minprofit = 100000, size = 10000, startat = 0, limit = 10, newsearch = "0", sort = "jprofit", prefer_sec = "0"):
mapserver = Pyro.core.getProxyForURI("PYROLOC://localhost:7766/mapserver")
session = EVCstate()
t = display.template('tradefind_display.tmpl', session)
db = evec_func.db_con()
newsearch = int(newsearch)
if 'trade_results' not in session:
newsearch = 1
cur = db.cursor()
limit = int(limit)
prefer_sec = int(prefer_sec)
recalc_route = False
if sort not in ['jprofit', 'sprofit', 'profit', 'jumps']:
return
if set:
session['tf_age'] = age
session['tf_minprofit'] = minprofit
session['tf_size'] = size
session['tf_limit'] = limit
session['tf_sort'] = sort
session['tf_prefer_sec'] = prefer_sec
newsearch = 1
else:
if 'tf_age' in session:
age = session['tf_age']
if 'tf_minprofit' in session:
minprofit = session['tf_minprofit']
if 'tf_size' in session:
size = session['tf_size']
if 'tf_limit' in session:
limit = session['tf_limit']
if 'tf_sort' in session:
sort = session['tf_sort']
if 'tf_prefer_sec' in session:
prefer_sec = session['tf_prefer_sec']
else:
prefer_sec = 1
age_t = str(int(age)) + " hours"
size = str(int(size))
cashonhand = str(double(cashonhand))
sql_profit_size = """ (t.price - f.price)* min(""" + size + """, min(t.volremain,f.volremain) * types.size)/types.size """
sql_profit_jumps = """ '1' """
#sql_cash = """ f.price <= $(cashonhand)s """
sql_sec_limit = """ """
if prefer_sec:
sql_sec_limit = """ fsys.security > 0.4 AND tsys.security > 0.4 AND """
cur_f = db.cursor()
cur_t = db.cursor()
# Pure suck query
if qtype == "Systems" and newsearch:
cur.execute("""SELECT types.typeid,types.typename,fs.systemid,ts.systemid,fs.stationname,ts.stationname,t.price - f.price AS pricediff,
min(t.volremain,f.volremain),
(t.price - f.price)* min(t.volremain,f.volremain) AS profit,
""" + sql_profit_size + """ AS profit_size,
""" + sql_profit_jumps + """ AS profit_jumps,
t.price,f.price,
t.volremain,f.volremain
FROM
types, current_market AS f, current_market AS t, stations AS fs, stations AS ts, systems AS fsys, systems AS tsys
WHERE
""" + sql_sec_limit + """
ts.systemid = tsys.systemid AND fs.systemid = fsys.systemid AND
f.bid = 0 AND t.bid = 1 AND f.systemid = %(fromt)s AND t.systemid = %(to)s AND t.typeid = f.typeid AND t.stationid = ts.stationid AND
f.stationid = fs.stationid AND
age(f.reportedtime) < %(age)s AND age(t.reportedtime) < %(age)s AND
""" + sql_profit_size + """ >= %(minprofit)s AND
types.size <= """ + size + """ AND
t.typeid = types.typeid
AND f.typeid = types.typeid
AND f.price < t.price""",
{'fromt':fromt, 'to':to, 'age':age_t, 'minprofit':minprofit,})
cur_f.execute("SELECT systemid,(systemname || ' / ') || regionname FROM systems,regions WHERE systems.regionid = regions.regionid AND systemid = %s ORDER BY systemname", [fromt])
cur_t.execute("SELECT systemid,(systemname || ' / ') || regionname FROM systems,regions WHERE systems.regionid = regions.regionid AND systemid = %s ORDER BY systemname", [to])
elif qtype == "Regions" and newsearch:
cur.execute("""SELECT types.typeid,types.typename,fs.systemid,ts.systemid,fs.stationname,ts.stationname,t.price - f.price AS pricediff,
min(t.volremain,f.volremain),
(t.price - f.price)*min(t.volremain,f.volremain) AS profit,
"""+ sql_profit_size + """ AS profit_size,
""" + sql_profit_jumps + """ AS profit_jumps,
t.price,f.price, t.volremain, f.volremain
FROM types, current_market AS f, current_market AS t, stations AS fs, stations AS ts, systems AS fsys, systems AS tsys
WHERE
""" + sql_sec_limit + """
ts.systemid = tsys.systemid AND fs.systemid = fsys.systemid AND
f.bid = 0 AND t.bid = 1 AND f.regionid = %(fromt)s AND t.regionid = %(to)s AND t.typeid = f.typeid AND t.stationid = ts.stationid AND
f.stationid = fs.stationid AND
age(f.reportedtime) < %(age)s AND age(t.reportedtime) < %(age)s AND
""" + sql_profit_size + """ >= %(minprofit)s AND
types.size <= """ + size + """ AND
t.typeid = types.typeid
AND f.typeid = types.typeid
AND f.price < t.price""",
{'fromt':fromt, 'to':to, 'age':age_t, 'minprofit':minprofit, })
cur_f.execute("SELECT regionid,regionname FROM regions WHERE regionid = %s ORDER BY regionname", [fromt])
cur_t.execute("SELECT regionid,regionname FROM regions WHERE regionid = %s ORDER BY regionname", [to])
elif qtype == "SystemToRegion" and newsearch:
cur.execute("""SELECT types.typeid,types.typename,fs.systemid,ts.systemid,fs.stationname,ts.stationname,t.price - f.price AS pricediff,
min(t.volremain,f.volremain),
(t.price - f.price)*min(t.volremain,f.volremain) AS profit,
""" + sql_profit_size + """ AS profit_size,
""" + sql_profit_jumps + """ AS profit_jumps,
t.price,f.price, t.volremain, f.volremain
FROM types, current_market AS f, current_market AS t, stations AS fs, stations AS ts, systems AS fsys, systems AS tsys
WHERE
""" + sql_sec_limit + """
ts.systemid = tsys.systemid AND fs.systemid = fsys.systemid AND
f.bid = 0 AND t.bid = 1 AND f.systemid = %(fromt)s AND t.regionid = %(to)s AND t.typeid = f.typeid AND t.stationid = ts.stationid AND
f.stationid = fs.stationid AND
age(f.reportedtime) < %(age)s AND age(t.reportedtime) < %(age)s AND
""" + sql_profit_size + """ >= %(minprofit)s AND
types.size <= """ + size + """ AND
t.typeid = types.typeid
AND f.typeid = types.typeid
AND f.price < t.price""",
{'fromt':fromt, 'to':to, 'age':age_t, 'minprofit':minprofit, })
cur_f.execute("SELECT systemid,(systemname || ' / ') || regionname FROM systems,regions WHERE systems.regionid = regions.regionid AND systemid = %s ORDER BY systemname", [fromt])
cur_t.execute("SELECT regionid,regionname FROM regions WHERE regionid = %s ORDER BY regionname", [to])
elif qtype == "Global" and newsearch:
cur.execute("""SELECT types.typeid,types.typename,fs.systemid,ts.systemid,fs.stationname,ts.stationname,t.price - f.price AS pricediff,
min(t.volremain,f.volremain),
(t.price - f.price)*min(t.volremain,f.volremain) AS profit,
"""+ sql_profit_size + """ AS profit_size,
""" + sql_profit_jumps + """ AS profit_jumps,
t.price,f.price
FROM types, current_market AS f, current_market AS t, stations AS fs, stations AS ts, systems AS fsys, systems AS tsys
WHERE
""" + sql_sec_limit + """
ts.systemid = tsys.systemid AND fs.systemid = fsys.systemid AND
f.bid = 0 AND t.bid = 1 AND t.typeid = f.typeid AND t.stationid = ts.stationid AND
f.stationid = fs.stationid AND
age(f.reportedtime) < %(age)s AND age(t.reportedtime) < %(age)s AND
""" + sql_profit_size + """ >= %(minprofit)s AND
types.size <= """ + size + """ AND
t.typeid = types.typeid
AND f.typeid = types.typeid
AND f.price < t.price""",
# ORDER BY profit_size DESC LIMIT %(limit)s OFFSET %(startat)s""",
{'age':age_t, 'minprofit':minprofit})
cur_f.execute("SELECT regionid,regionname FROM regions WHERE regionid = %s ORDER BY regionname", [fromt])
cur_t.execute("SELECT regionid,regionname FROM regions WHERE regionid = %s ORDER BY regionname", [to])
trades = []
time_net = 0.0
import __builtin__
from_set = __builtin__.set()
from_map = {}
from_to_map = {}
error_log = []
fromcache = 0
if newsearch:
r = cur.fetchone()
while r:
row = SorterDict('sortby')
row['typeid'] = r[0]
row['typename'] = r[1]
fr = int(r[2])
to2 = int(r[3])
row['fr'] = int(r[2])
row['to2'] = int(r[3])
row['fromstation'] = r[4]
row['tostation'] = r[5]
row['pricediff'] = r[6]
row['tradeable'] = format_long(long(r[7]))
row['profit'] = format_price(float(r[8]))
row['profit_size'] = float(r[9])
from_set.add(fr)
row['tprice'] = format_price(float(r[11]))
row['fprice'] = format_price(float(r[12]))
row['tvol'] = format_long(long(r[13]))
row['fvol'] = format_long(long(r[14]))
trades.append(row)
# Add to from_to_map - map source
if fr in from_to_map:
from_to_map[fr].add(row['to2'])
else:
from_to_map[fr] = __builtin__.set()
from_to_map[fr].add(row['to2'])
if fr in from_map:
from_map[fr].append(row)
else:
from_map[fr] = []
from_map[fr].append(row)
r = cur.fetchone()
# Now we try to compute distance
for compsys in from_set:
distance_map = {}
distance = 0
time_net_ = time.time()
distance_map = mapserver.route_comp(compsys, list(from_to_map[compsys]))
time_net += time.time() - time_net_
for row in from_map[compsys]:
if row['fr'] == compsys:
if compsys == row['to2']:
distance = 0
else:
distance = distance_map[row['to2']]
ps = row['profit_size']
row['profit_size'] = format_price(ps)
if sort == "jprofit":
row['sortby'] = ps/(max(0,distance)+1)
t.sort_nice = "Profit per jump"
elif sort == "sprofit":
row['sortby'] = ps
t.sort_nice = "Profit per trip"
elif sort == "profit":
row['sortby'] = row['profit']
t.sort_nice = "Profit"
elif sort == "jumps":
t.sort_nice = "Distance"
row['sortby'] = distance
row.reverse= True
row['profit_jumps'] = format_price(float(ps/(1+max(0,distance))))
row['distance'] = distance
time_sort = time.time()
trades.sort(reverse=True)
time_sort = time.time() - time_sort
#session['trade_results'] = trades
else:
trades = session['trade_results']
fromcache = 1
trade_num = len(trades)
trades = trades[int(startat):int(startat)+int(limit)]
t.fromcache = fromcache
t.num_trades = trade_num
t.trades = trades
t.fromt = fromt
t.to = to
t.qtype = qtype
t.age = age
t.minprofit = minprofit
t.size = size
t.startat = startat
t.limit = limit
t.sort = sort
t.prefer_sec = prefer_sec
t.fromname = cur_f.fetchone()[1]
t.toname = cur_t.fetchone()[1]
t.page = int((int(startat) + 1) / limit) + 1
t.next = int(startat) +limit
t.prev = max(0,int(startat) - limit)
db.close()
session.save()
return t.respond() +"Pathfinder time: %0.3fs, Sort time: %0.3fs, recompute set was %d elements long<br>" % (time_net, time_sort, len(from_set))
def tradefind_display(
self,
qtype,
fromt,
to,
set=None,
age=24,
cashonhand=10000000.00,
minprofit=100000,
size=10000,
startat=0,
limit=50,
newsearch="0",
sort="jprofit",
prefer_sec="0",
):
session = EVCstate()
t = display.template("tradefind_display.tmpl", session)
db = evec_func.db_con()
newsearch = int(newsearch)
if "trade_results" not in session:
newsearch = 1
cur = db.cursor()
limit = int(limit)
prefer_sec = int(prefer_sec)
recalc_route = False
if sort not in ["jprofit", "sprofit", "profit", "jumps"]:
return
if set:
session["tf_age"] = age
session["tf_minprofit"] = minprofit
session["tf_size"] = size
session["tf_limit"] = limit
session["tf_sort"] = sort
session["tf_prefer_sec"] = prefer_sec
newsearch = 1
else:
if "tf_age" in session:
age = session["tf_age"]
if "tf_minprofit" in session:
minprofit = session["tf_minprofit"]
if "tf_size" in session:
size = session["tf_size"]
if "tf_limit" in session:
limit = session["tf_limit"]
if "tf_sort" in session:
sort = session["tf_sort"]
if "tf_prefer_sec" in session:
prefer_sec = session["tf_prefer_sec"]
else:
prefer_sec = 1
age_t = str(int(age)) + " hours"
size = str(int(size))
cashonhand = str(double(cashonhand))
sql_profit_size = (
""" (t.price - f.price)* min(""" + size + """, min(t.volremain,f.volremain) * types.size)/types.size """
)
sql_profit_jumps = """ '1' """
# sql_cash = """ f.price <= $(cashonhand)s """
sql_sec_limit = """ """
if prefer_sec:
sql_sec_limit = """ fsys.security > 0.4 AND tsys.security > 0.4 AND """
cur_f = db.cursor()
cur_t = db.cursor()
#####
# Warning: This is easily the worst piece of code I have ever written.
# I really am sorry.
#####
# Pure suck query
if qtype == "Systems" and newsearch:
cur.execute(
"""SELECT types.typeid,types.typename,fs.systemid,ts.systemid,fs.stationname,ts.stationname,t.price - f.price AS pricediff,
min(t.volremain,f.volremain),
(t.price - f.price)* min(t.volremain,f.volremain) AS profit,
"""
+ sql_profit_size
+ """ AS profit_size,
"""
+ sql_profit_jumps
+ """ AS profit_jumps,
t.price,f.price,
t.volremain,f.volremain
FROM
types, current_market AS f, current_market AS t, stations AS fs, stations AS ts, systems AS fsys, systems AS tsys
WHERE
"""
+ sql_sec_limit
+ """
ts.systemid = tsys.systemid AND fs.systemid = fsys.systemid AND
f.minvolume <= 1 AND t.minvolume <= 1 AND
f.bid = 0 AND t.bid = 1 AND f.systemid = %(fromt)s AND t.systemid = %(to)s AND t.typeid = f.typeid AND t.stationid = ts.stationid AND
f.stationid = fs.stationid AND
age(f.reportedtime) < %(age)s AND age(t.reportedtime) < %(age)s AND
"""
+ sql_profit_size
+ """ >= %(minprofit)s AND
types.size <= """
+ size
+ """ AND
t.typeid = types.typeid
AND f.typeid = types.typeid
AND f.price < t.price""",
{"fromt": fromt, "to": to, "age": age_t, "minprofit": minprofit},
)
cur_f.execute(
"SELECT systemid,(systemname || ' / ') || regionname FROM systems,regions WHERE systems.regionid = regions.regionid AND systemid = %s ORDER BY systemname",
[fromt],
)
cur_t.execute(
"SELECT systemid,(systemname || ' / ') || regionname FROM systems,regions WHERE systems.regionid = regions.regionid AND systemid = %s ORDER BY systemname",
[to],
)
elif qtype == "Regions" and newsearch:
cur.execute(
"""SELECT types.typeid,types.typename,fs.systemid,ts.systemid,fs.stationname,ts.stationname,t.price - f.price AS pricediff,
min(t.volremain,f.volremain),
(t.price - f.price)*min(t.volremain,f.volremain) AS profit,
"""
+ sql_profit_size
+ """ AS profit_size,
"""
+ sql_profit_jumps
+ """ AS profit_jumps,
t.price,f.price, t.volremain, f.volremain
FROM types, current_market AS f, current_market AS t, stations AS fs, stations AS ts, systems AS fsys, systems AS tsys
WHERE
"""
+ sql_sec_limit
+ """
ts.systemid = tsys.systemid AND fs.systemid = fsys.systemid AND
f.minvolume <= 1 AND t.minvolume <= 1 AND
f.bid = 0 AND t.bid = 1 AND f.regionid = %(fromt)s AND t.regionid = %(to)s AND t.typeid = f.typeid AND t.stationid = ts.stationid AND
f.stationid = fs.stationid AND
age(f.reportedtime) < %(age)s AND age(t.reportedtime) < %(age)s AND
"""
+ sql_profit_size
+ """ >= %(minprofit)s AND
types.size <= """
+ size
+ """ AND
t.typeid = types.typeid
AND f.typeid = types.typeid
AND f.price < t.price""",
{"fromt": fromt, "to": to, "age": age_t, "minprofit": minprofit},
)
cur_f.execute("SELECT regionid,regionname FROM regions WHERE regionid = %s ORDER BY regionname", [fromt])
cur_t.execute("SELECT regionid,regionname FROM regions WHERE regionid = %s ORDER BY regionname", [to])
elif qtype == "SystemToRegion" and newsearch:
cur.execute(
"""SELECT types.typeid,types.typename,fs.systemid,ts.systemid,fs.stationname,ts.stationname,t.price - f.price AS pricediff,
min(t.volremain,f.volremain),
(t.price - f.price)*min(t.volremain,f.volremain) AS profit,
"""
+ sql_profit_size
+ """ AS profit_size,
"""
+ sql_profit_jumps
+ """ AS profit_jumps,
t.price,f.price, t.volremain, f.volremain
FROM types, current_market AS f, current_market AS t, stations AS fs, stations AS ts, systems AS fsys, systems AS tsys
WHERE
"""
+ sql_sec_limit
+ """
ts.systemid = tsys.systemid AND fs.systemid = fsys.systemid AND
f.minvolume <= 1 AND t.minvolume <= 1 AND
f.bid = 0 AND t.bid = 1 AND f.systemid = %(fromt)s AND t.regionid = %(to)s AND t.typeid = f.typeid AND t.stationid = ts.stationid AND
f.stationid = fs.stationid AND
age(f.reportedtime) < %(age)s AND age(t.reportedtime) < %(age)s AND
"""
+ sql_profit_size
+ """ >= %(minprofit)s AND
types.size <= """
+ size
+ """ AND
t.typeid = types.typeid
AND f.typeid = types.typeid
AND f.price < t.price""",
{"fromt": fromt, "to": to, "age": age_t, "minprofit": minprofit},
)
cur_f.execute(
"SELECT systemid,(systemname || ' / ') || regionname FROM systems,regions WHERE systems.regionid = regions.regionid AND systemid = %s ORDER BY systemname",
[fromt],
)
cur_t.execute("SELECT regionid,regionname FROM regions WHERE regionid = %s ORDER BY regionname", [to])
trades = []
time_net = 0.0
import __builtin__
from_set = __builtin__.set()
from_map = {}
from_to_map = {}
error_log = []
fromcache = 0
if newsearch:
r = cur.fetchone()
while r:
row = SorterDict("sortby")
row["typeid"] = r[0]
row["typename"] = r[1]
fr = int(r[2])
to2 = int(r[3])
row["fr"] = int(r[2])
row["to2"] = int(r[3])
row["fromstation"] = r[4]
row["tostation"] = r[5]
row["pricediff"] = format_price(r[6])
row["tradeable"] = format_long(r[7])
row["profit"] = format_price(r[8])
row["profit_num"] = float(r[8])
row["profit_size"] = float(r[9])
from_set.add(fr)
row["tprice"] = format_price(r[11])
row["fprice"] = format_price(r[12])
row["tvol"] = format_long(r[13])
row["fvol"] = format_long(r[14])
trades.append(row)
# Add to from_to_map - map source
if fr in from_to_map:
from_to_map[fr].add(row["to2"])
else:
from_to_map[fr] = __builtin__.set()
from_to_map[fr].add(row["to2"])
if fr in from_map:
from_map[fr].append(row)
else:
from_map[fr] = []
from_map[fr].append(row)
r = cur.fetchone()
# Now we try to compute distance
for compsys in from_set:
distance_map = {}
distance = 0
time_net_ = time.time()
for tosystem in from_to_map[compsys]:
load = urllib.urlopen(
"http://127.0.0.1:8081/api/distance/from/" + str(int(compsys)) + "/to/" + str(int(tosystem))
)
s = load.read()
load.close()
distance_map[tosystem] = json.loads(s)["distance"]
time_net += time.time() - time_net_
for row in from_map[compsys]:
if row["fr"] == compsys:
if compsys == row["to2"]:
distance = 0
else:
distance = distance_map[row["to2"]]
ps = row["profit_size"]
row["profit_size"] = format_price(ps)
if sort == "jprofit":
row["sortby"] = ps / (max(0, distance) + 1)
t.sort_nice = "Profit per jump"
elif sort == "sprofit":
row["sortby"] = ps
t.sort_nice = "Profit per trip"
elif sort == "profit":
row["sortby"] = row["profit_num"]
t.sort_nice = "Profit"
elif sort == "jumps":
t.sort_nice = "Distance"
row["sortby"] = distance
row.reverse = True
row["profit_jumps"] = format_price(ps / (1 + max(0, distance)))
row["distance"] = distance
time_sort = time.time()
trades.sort(reverse=True)
time_sort = time.time() - time_sort
# session['trade_results'] = trades
else:
trades = session["trade_results"]
fromcache = 1
trade_num = len(trades)
trades = trades[int(startat) : int(startat) + int(limit)]
t.fromcache = fromcache
t.num_trades = trade_num
t.trades = trades
t.fromt = fromt
t.to = to
t.qtype = qtype
t.age = age
t.minprofit = minprofit
t.size = size
t.startat = startat
t.limit = limit
t.sort = sort
t.prefer_sec = prefer_sec
t.fromname = cur_f.fetchone()[1]
t.toname = cur_t.fetchone()[1]
t.page = int((int(startat) + 1) / limit) + 1
t.next = int(startat) + limit
t.prev = max(0, int(startat) - limit)
db.close()
session.save()
return t.respond() + "Pathfinder time: %0.3fs, Sort time: %0.3fs, recompute set was %d elements long<br>" % (
time_net,
time_sort,
len(from_set),
)
def index(self, join_password = None):
session = EVCstate(trust=True)
db = evec_func.db_con()
user = User.get(session, db)
t = display.template('corpmain.tmpl', session)
ucorp = None
if user.valid:
ucorp = Corp(db,user.corpid)
if join_password:
if ucorp.join_password == join_password:
user.make_member(db)
session.save()
t.can_create = False
t.ucorp = ucorp
if user.valid and (user.ismember or ucorp.join_password == ''):
if user.isdirector:
if not ucorp.exists:
t.can_create = True
t.corp = user.corporation
t.corpid = user.corpid
t.ismember = 1
t.user = user
elif user.valid and not user.ismember:
t.corp = user.corporation
t.corpid = user.corpid
t.user = user
t.ismember = 0
else:
t.corp = None
t.corpid = None
t.can_create = False
t.user = None
t.ismember = 0
cur = db.cursor()
cur.execute("SELECT corpname,description,headquarters,ticker,corpid FROM corps WHERE ticker IS NOT NULL AND ticker != '' ORDER BY corpname")
r = cur.fetchone()
corps = []
while r:
c = {}
c['corpname'] = r[0]
c['description'] = r[1]
c['headquarters'] = r[2]
c['ticker'] = r[3]
corpid = r[4]
ccheck = db.cursor()
ccheck.execute("SELECT contents FROM corppages WHERE corpid = %s", [corpid])
rc = ccheck.fetchone()
if rc[0] == "Placeholder text - this corporation has not yet provided a webpage":
pass
else:
corps.append(c)
r = cur.fetchone()
t.corps = corps
return t.respond()
