5 DEBUG_DEFINE_SOME_DEBUGF(sql,sql_dprintf);
8 int commodid, src_price, src_qty, dst_price, dst_qty;
16 static void ipair_gettrades(int si, int di) {
19 " sell.commodid commodid,\n"
20 " sell.price src_price,\n"
21 " sum(sell.qty) src_qty,\n"
22 " buy.price dst_price,\n"
23 " sum(buy.qty) dst_qty\n"
24 " FROM sell JOIN buy\n"
25 " ON sell.commodid = buy.commodid\n"
26 " AND buy.price > sell.price\n"
27 " WHERE sell.islandid=%d\n"
28 " AND buy.islandid=%d\n"
29 " GROUP BY sell.commodid, sell.price, buy.price\n",
32 sql_dprintf("SQL\n[\n%s\n]\n", stmt);
37 void value_route(int nislands, const int *islands) {
40 for (s=0; s<nislands; s++) {
41 for (d=s; d<nislands; d++) {
42 ipair_gettrades(islands[s], islands[d]);
47 //struct sqlite_vm *sth;
48 //r= sqlite_compile(db, stmt, &tail, &sth,