chiark / gitweb /
ypp-sc-tools.db-test.git
10 years agoOrganise TODO list
Ian Jackson [Tue, 25 Aug 2009 23:52:18 +0000 (00:52 +0100)]
Organise TODO list

10 years agodhandler turns / into /lookup for us, and gives 404s too
Ian Jackson [Tue, 25 Aug 2009 17:56:43 +0000 (18:56 +0100)]
dhandler turns / into /lookup for us, and gives 404s too

10 years agoHonour YARRG_DATA_DIR in CommodsWeb
Ian Jackson [Tue, 25 Aug 2009 17:56:19 +0000 (18:56 +0100)]
Honour YARRG_DATA_DIR in CommodsWeb

10 years agoFix broken sourcedir things
Ian Jackson [Tue, 25 Aug 2009 16:16:46 +0000 (17:16 +0100)]
Fix broken sourcedir things

10 years agoMerge branch 'web' of /u/ijackson/things/ypp-sc-tools
Ian Jackson [Tue, 25 Aug 2009 16:12:43 +0000 (17:12 +0100)]
Merge branch 'web' of /u/ijackson/things/ypp-sc-tools

10 years agoFix installation problems
Ian Jackson [Tue, 25 Aug 2009 16:12:34 +0000 (17:12 +0100)]
Fix installation problems

10 years agoSaner sourcebasedir function
Ian Jackson [Tue, 25 Aug 2009 16:11:59 +0000 (17:11 +0100)]
Saner sourcebasedir function

10 years agoMerge branch 'master' of ijackson@chiark:things/Yarrgweb/ypp-sc-tools
Ian Jackson [Tue, 25 Aug 2009 16:03:22 +0000 (17:03 +0100)]
Merge branch 'master' of ijackson@chiark:things/Yarrgweb/ypp-sc-tools

10 years agoCalculate sourcebasedir and datadir each time
Ian Jackson [Tue, 25 Aug 2009 16:02:23 +0000 (17:02 +0100)]
Calculate sourcebasedir and datadir each time

10 years agoTODO list items
Ian Jackson [Mon, 24 Aug 2009 15:52:56 +0000 (16:52 +0100)]
TODO list items

10 years agoTODO list items
Ian Jackson [Mon, 24 Aug 2009 15:48:42 +0000 (16:48 +0100)]
TODO list items

10 years agoDo arbitrage in the middle
Ian Jackson [Mon, 24 Aug 2009 15:38:30 +0000 (16:38 +0100)]
Do arbitrage in the middle

10 years agoSort deliveries by price in decreasing order
Ian Jackson [Mon, 24 Aug 2009 15:16:03 +0000 (16:16 +0100)]
Sort deliveries by price in decreasing order

10 years agoDe-%ify a big chunk of perl
Ian Jackson [Mon, 24 Aug 2009 14:37:03 +0000 (15:37 +0100)]
De-%ify a big chunk of perl

10 years agoShow arbitrage purchases sooner in plan
Ian Jackson [Mon, 24 Aug 2009 14:33:52 +0000 (15:33 +0100)]
Show arbitrage purchases sooner in plan

10 years agoDo not display number available in trading plan
Ian Jackson [Mon, 24 Aug 2009 14:01:46 +0000 (15:01 +0100)]
Do not display number available in trading plan

10 years agoFix profit margin
Ian Jackson [Mon, 24 Aug 2009 13:58:54 +0000 (14:58 +0100)]
Fix profit margin

10 years agoRedo aggregation
Ian Jackson [Mon, 24 Aug 2009 13:08:04 +0000 (14:08 +0100)]
Redo aggregation

10 years agoMake strips slightly darker
Ian Jackson [Mon, 24 Aug 2009 11:36:40 +0000 (12:36 +0100)]
Make strips slightly darker

10 years agoFix stupid optimisation bug (typoed variable name)
Ian Jackson [Mon, 24 Aug 2009 10:59:18 +0000 (11:59 +0100)]
Fix stupid optimisation bug (typoed variable name)

10 years agoData ages and other fixes
Ian Jackson [Mon, 24 Aug 2009 03:14:00 +0000 (04:14 +0100)]
Data ages and other fixes

10 years agoFurther revisions for generalised dataage
Ian Jackson [Mon, 24 Aug 2009 03:13:24 +0000 (04:13 +0100)]
Further revisions for generalised dataage

10 years agoGet foreground css right
Ian Jackson [Mon, 24 Aug 2009 03:12:50 +0000 (04:12 +0100)]
Get foreground css right

10 years agoMake da_Refresh output into a method
Ian Jackson [Mon, 24 Aug 2009 02:32:35 +0000 (03:32 +0100)]
Make da_Refresh output into a method

10 years agoFix prettyprint_age again
Ian Jackson [Mon, 24 Aug 2009 02:31:51 +0000 (03:31 +0100)]
Fix prettyprint_age again

10 years agoStripey tables
Ian Jackson [Mon, 24 Aug 2009 02:22:52 +0000 (03:22 +0100)]
Stripey tables

10 years agoprettyprint_age moved to commodsweb
Ian Jackson [Mon, 24 Aug 2009 02:18:24 +0000 (03:18 +0100)]
prettyprint_age moved to commodsweb

10 years agoTrade plan; wip data age
Ian Jackson [Mon, 24 Aug 2009 02:15:05 +0000 (03:15 +0100)]
Trade plan; wip data age

10 years agoStripy tables.
Ian Jackson [Sun, 23 Aug 2009 23:54:40 +0000 (00:54 +0100)]
Stripy tables.

10 years agofix spurious comma causing syntax error in query
Ian Jackson [Sun, 23 Aug 2009 21:23:20 +0000 (22:23 +0100)]
fix spurious comma causing syntax error in query

10 years agoCapitalise some keywords
Ian Jackson [Sun, 23 Aug 2009 20:51:25 +0000 (21:51 +0100)]
Capitalise some keywords

10 years agoPut forwards-sort arrow to right
Ian Jackson [Sun, 23 Aug 2009 20:50:16 +0000 (21:50 +0100)]
Put forwards-sort arrow to right

10 years agoSortable trades table
Ian Jackson [Sun, 23 Aug 2009 20:48:57 +0000 (21:48 +0100)]
Sortable trades table

10 years agofix bugs in new arrangements
Ian Jackson [Sun, 23 Aug 2009 20:48:25 +0000 (21:48 +0100)]
fix bugs in new arrangements

10 years agoAlso cope with tbrow, and add all stuff from then onwards to bottom
Ian Jackson [Sun, 23 Aug 2009 20:29:21 +0000 (21:29 +0100)]
Also cope with tbrow, and add all stuff from then onwards to bottom

10 years agoParse old master info files too
Ian Jackson [Sun, 23 Aug 2009 20:21:22 +0000 (21:21 +0100)]
Parse old master info files too

10 years agoPrefer short trades, using distance table
Ian Jackson [Sun, 23 Aug 2009 16:27:07 +0000 (17:27 +0100)]
Prefer short trades, using distance table

10 years agoorganise todo list
Ian Jackson [Sun, 23 Aug 2009 16:11:11 +0000 (17:11 +0100)]
organise todo list

10 years agoReorder columns; rename "suggested" to "planned"
Ian Jackson [Sun, 23 Aug 2009 16:08:00 +0000 (17:08 +0100)]
Reorder columns; rename "suggested" to "planned"

10 years agoFix unticking
Ian Jackson [Sun, 23 Aug 2009 16:04:29 +0000 (17:04 +0100)]
Fix unticking

10 years agotodo list - POST
Ian Jackson [Sun, 23 Aug 2009 16:01:24 +0000 (17:01 +0100)]
todo list - POST

10 years agotodo list
Ian Jackson [Sun, 23 Aug 2009 15:59:55 +0000 (16:59 +0100)]
todo list

10 years agoWIP trade plan
Ian Jackson [Sun, 23 Aug 2009 15:41:47 +0000 (16:41 +0100)]
WIP trade plan

10 years agoTotals
Ian Jackson [Sun, 23 Aug 2009 15:22:44 +0000 (16:22 +0100)]
Totals

10 years agoTurn @columns=qw(..) into @cols=( {Name=>...}... )
Ian Jackson [Sun, 23 Aug 2009 15:16:07 +0000 (16:16 +0100)]
Turn @columns=qw(..) into @cols=( {Name=>...}... )

10 years agoBetter title for routetrade results
Ian Jackson [Sun, 23 Aug 2009 15:05:07 +0000 (16:05 +0100)]
Better title for routetrade results

10 years agoImprove presentation
Ian Jackson [Sun, 23 Aug 2009 15:03:05 +0000 (16:03 +0100)]
Improve presentation

10 years agoCompress flow ids
Ian Jackson [Sun, 23 Aug 2009 14:39:49 +0000 (15:39 +0100)]
Compress flow ids

10 years agoTickbox for each line
Ian Jackson [Sun, 23 Aug 2009 12:49:55 +0000 (13:49 +0100)]
Tickbox for each line

10 years agoRationalise various ids
Ian Jackson [Sun, 23 Aug 2009 12:32:47 +0000 (13:32 +0100)]
Rationalise various ids

10 years agoDo not dump sql results table if not debug
Ian Jackson [Sun, 23 Aug 2009 12:08:51 +0000 (13:08 +0100)]
Do not dump sql results table if not debug

10 years agoAllow showing stall names in routetrade
Ian Jackson [Sun, 23 Aug 2009 12:07:11 +0000 (13:07 +0100)]
Allow showing stall names in routetrade

10 years agoDump optimisation results too
Ian Jackson [Sun, 23 Aug 2009 10:47:04 +0000 (11:47 +0100)]
Dump optimisation results too

10 years agoGeneralise dumpqueryresults and rename to dumptable
Ian Jackson [Sun, 23 Aug 2009 10:41:31 +0000 (11:41 +0100)]
Generalise dumpqueryresults and rename to dumptable

10 years agoChoose columns for routetrade
Ian Jackson [Sun, 23 Aug 2009 10:33:23 +0000 (11:33 +0100)]
Choose columns for routetrade

10 years agoRuns glpsol, calculates optimal solution
Ian Jackson [Sun, 23 Aug 2009 10:22:29 +0000 (11:22 +0100)]
Runs glpsol, calculates optimal solution

10 years agopipethrough_run_along checks for errors on $tf
Ian Jackson [Sun, 23 Aug 2009 10:22:11 +0000 (11:22 +0100)]
pipethrough_run_along checks for errors on $tf

10 years agoprepare cplex input file for glpsol
Ian Jackson [Sat, 22 Aug 2009 15:27:24 +0000 (16:27 +0100)]
prepare cplex input file for glpsol

10 years agoPut data into flows
Ian Jackson [Sat, 22 Aug 2009 14:45:57 +0000 (15:45 +0100)]
Put data into flows

10 years agoTidy up GROUP BY a bit
Ian Jackson [Sat, 22 Aug 2009 14:32:27 +0000 (15:32 +0100)]
Tidy up GROUP BY a bit

10 years agoMake query more directly useful for display[
Ian Jackson [Sat, 22 Aug 2009 14:29:46 +0000 (15:29 +0100)]
Make query more directly useful for display[

10 years agoQuery planner and dumpqueryresults doc strings; dumpqueryresults improved
Ian Jackson [Sat, 22 Aug 2009 13:21:04 +0000 (14:21 +0100)]
Query planner and dumpqueryresults doc strings; dumpqueryresults improved

10 years agoMake query dumping conditional on debug
Ian Jackson [Sat, 22 Aug 2009 13:04:08 +0000 (14:04 +0100)]
Make query dumping conditional on debug

10 years agoBetter answers for arch queries
Ian Jackson [Sat, 22 Aug 2009 13:01:05 +0000 (14:01 +0100)]
Better answers for arch queries

10 years agoWIP route trade finding: does query to find flows
Ian Jackson [Sat, 22 Aug 2009 12:53:36 +0000 (13:53 +0100)]
WIP route trade finding: does query to find flows

10 years agoNew dumpqueryresults component for handy debugging etc.
Ian Jackson [Sat, 22 Aug 2009 12:35:28 +0000 (13:35 +0100)]
New dumpqueryresults component for handy debugging etc.

10 years agoMerge branch 'ceb'
Ian Jackson [Sat, 22 Aug 2009 11:52:56 +0000 (12:52 +0100)]
Merge branch 'ceb'

10 years agoRemove obsolete WIP script
Ian Jackson [Sat, 22 Aug 2009 11:51:32 +0000 (12:51 +0100)]
Remove obsolete WIP script

10 years agoSQL queries from ceb, including profitable trade calculator
Ian Jackson [Sat, 22 Aug 2009 11:50:59 +0000 (12:50 +0100)]
SQL queries from ceb, including profitable trade calculator

10 years agoMerge branch 'ijackson'
Ian Jackson [Fri, 21 Aug 2009 22:50:06 +0000 (23:50 +0100)]
Merge branch 'ijackson'

10 years agoCommodity stats
Ian Jackson [Fri, 21 Aug 2009 22:07:36 +0000 (23:07 +0100)]
Commodity stats

10 years agoMake %commods more versatile by making srcs be in Srcs
Ian Jackson [Fri, 21 Aug 2009 22:12:14 +0000 (23:12 +0100)]
Make %commods more versatile by making srcs be in Srcs

10 years agowip arch assigner. Many problems in Ice and Sage at least
Ian Jackson [Fri, 21 Aug 2009 17:51:46 +0000 (18:51 +0100)]
wip arch assigner.  Many problems in Ice and Sage at least

10 years agoyppedia-chart-parser better debug
Ian Jackson [Fri, 21 Aug 2009 16:35:19 +0000 (17:35 +0100)]
yppedia-chart-parser better debug

10 years agoWIP comparison; better debug
Ian Jackson [Fri, 21 Aug 2009 16:31:51 +0000 (17:31 +0100)]
WIP comparison; better debug

10 years agoUse unionfind=>0 since that works.
Ian Jackson [Thu, 20 Aug 2009 19:24:05 +0000 (20:24 +0100)]
Use unionfind=>0 since that works.
See https://rt.cpan.org/Public/Bug/Display.html?id=31068
and Debian bug just submitted.

10 years agoDemonstrate bug in Graph::Undirected
Ian Jackson [Thu, 20 Aug 2009 19:08:20 +0000 (20:08 +0100)]
Demonstrate bug in Graph::Undirected

10 years agoMerge branch 'ijackson'
Ian Jackson [Thu, 20 Aug 2009 18:26:27 +0000 (19:26 +0100)]
Merge branch 'ijackson'

10 years agoFound bug in Graph::Undirected
Ian Jackson [Thu, 20 Aug 2009 17:55:47 +0000 (18:55 +0100)]
Found bug in Graph::Undirected

10 years agoWIP chart parser
Ian Jackson [Thu, 20 Aug 2009 14:46:58 +0000 (15:46 +0100)]
WIP chart parser

10 years agoMerge branch 'stable-3.x'
Ian Jackson [Thu, 20 Aug 2009 00:54:29 +0000 (01:54 +0100)]
Merge branch 'stable-3.x'

10 years agoSortable commodity price table
Ian Jackson [Thu, 20 Aug 2009 00:26:27 +0000 (01:26 +0100)]
Sortable commodity price table

10 years agoMake including islands with no offers optional
Ian Jackson [Wed, 19 Aug 2009 23:30:23 +0000 (00:30 +0100)]
Make including islands with no offers optional

10 years agoInclude islands with no offers at all
Ian Jackson [Wed, 19 Aug 2009 23:27:03 +0000 (00:27 +0100)]
Include islands with no offers at all

10 years agoReorganise columns
Ian Jackson [Wed, 19 Aug 2009 23:09:10 +0000 (00:09 +0100)]
Reorganise columns

10 years agoSome notes regarding database corruption fix 3.2
Ian Jackson [Wed, 19 Aug 2009 22:49:50 +0000 (23:49 +0100)]
Some notes regarding database corruption fix

10 years agoActually add unrecognised commodities in email processor
Ian Jackson [Wed, 19 Aug 2009 22:44:23 +0000 (23:44 +0100)]
Actually add unrecognised commodities in email processor

10 years agoPick correct island's stall record for stallid when inserting (!)
Ian Jackson [Wed, 19 Aug 2009 22:44:02 +0000 (23:44 +0100)]
Pick correct island's stall record for stallid when inserting (!)

10 years agoShow medians etc.
Ian Jackson [Wed, 19 Aug 2009 22:37:10 +0000 (23:37 +0100)]
Show medians etc.

10 years agoMerge branch 'stable-3.x'
Ian Jackson [Wed, 19 Aug 2009 20:07:43 +0000 (21:07 +0100)]
Merge branch 'stable-3.x'

10 years agoTweaks to page collector: do not use XTest delay ms parameter; clamp max delay; etc.
Ian Jackson [Wed, 19 Aug 2009 00:15:54 +0000 (01:15 +0100)]
Tweaks to page collector: do not use XTest delay ms parameter; clamp max delay; etc.

10 years agoMerge branch 'clareb'
Ian Jackson [Sun, 16 Aug 2009 20:43:43 +0000 (21:43 +0100)]
Merge branch 'clareb'

10 years agoCope with display which doesn't have a commod pixel-exactly at the top
Ian Jackson [Sun, 16 Aug 2009 20:41:27 +0000 (21:41 +0100)]
Cope with display which doesn't have a commod pixel-exactly at the top

10 years agoFixes from tests on harley, including horrid bodge for git-describe failure
Clare [Sun, 16 Aug 2009 20:39:20 +0000 (21:39 +0100)]
Fixes from tests on harley, including horrid bodge for git-describe failure

10 years agoClean up tabsort and add %doc
Ian Jackson [Sun, 16 Aug 2009 18:30:52 +0000 (19:30 +0100)]
Clean up tabsort and add %doc

10 years agoJavascript sorting for query_age
Ian Jackson [Sun, 16 Aug 2009 18:19:36 +0000 (19:19 +0100)]
Javascript sorting for query_age

10 years agoBetter title for commodity enquiries
Ian Jackson [Sun, 16 Aug 2009 15:36:40 +0000 (16:36 +0100)]
Better title for commodity enquiries

10 years agoCommodity listing, but query is wrong
Ian Jackson [Sun, 16 Aug 2009 15:34:10 +0000 (16:34 +0100)]
Commodity listing, but query is wrong

10 years agoQuery-specific "var"s
Ian Jackson [Sun, 16 Aug 2009 15:33:59 +0000 (16:33 +0100)]
Query-specific "var"s

10 years agoPass $dbh down through the stack, for better lifetime
Ian Jackson [Sun, 16 Aug 2009 15:03:45 +0000 (16:03 +0100)]
Pass $dbh down through the stack, for better lifetime