chiark / gitweb /
ypp-sc-tools.db-live.git
15 years agoTrade plan; wip data age
Ian Jackson [Mon, 24 Aug 2009 02:15:05 +0000 (03:15 +0100)]
Trade plan; wip data age

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

15 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

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

15 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

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

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

15 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

15 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

15 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

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

15 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"

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

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

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

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

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

15 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=>...}... )

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

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

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

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

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

15 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

15 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

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

15 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

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

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

15 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

15 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

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

15 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

15 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[

15 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

15 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

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

15 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

15 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.

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

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

15 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

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

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

15 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

15 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

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

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

15 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.

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

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

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

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

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

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

15 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

15 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

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

15 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

15 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

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

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

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

15 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.

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

15 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

15 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

15 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

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

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

15 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

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

15 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

15 years agocheck_routestring not for direct invocation any more
Ian Jackson [Sun, 16 Aug 2009 14:46:12 +0000 (15:46 +0100)]
check_routestring not for direct invocation any more

15 years agoFurther refactoring to make query_commod small
Ian Jackson [Sun, 16 Aug 2009 13:19:35 +0000 (14:19 +0100)]
Further refactoring to make query_commod small

15 years agoMuch tidying; preserve query type etc. in query_commod
Ian Jackson [Sun, 16 Aug 2009 12:36:47 +0000 (13:36 +0100)]
Much tidying; preserve query type etc. in query_commod

15 years agoRevamp qtextstring arrangements
Ian Jackson [Sun, 16 Aug 2009 12:06:12 +0000 (13:06 +0100)]
Revamp qtextstring arrangements

15 years agoFix some warnings
Ian Jackson [Sun, 16 Aug 2009 02:27:25 +0000 (03:27 +0100)]
Fix some warnings

15 years agoFix new textstring indirection
Ian Jackson [Sun, 16 Aug 2009 02:13:58 +0000 (03:13 +0100)]
Fix new textstring indirection

15 years agoWIP commodity query
Ian Jackson [Sun, 16 Aug 2009 02:10:10 +0000 (03:10 +0100)]
WIP commodity query

15 years agoCope when cpio doesn't like -o -R
Ian Jackson [Sun, 16 Aug 2009 02:09:44 +0000 (03:09 +0100)]
Cope when cpio doesn't like -o -R

15 years agoFurther generalisation of text string entry; add missing copyrights
Ian Jackson [Sun, 16 Aug 2009 02:03:37 +0000 (03:03 +0100)]
Further generalisation of text string entry; add missing copyrights

15 years agoGeneralise route[text]string
Ian Jackson [Sun, 16 Aug 2009 01:04:04 +0000 (02:04 +0100)]
Generalise route[text]string

15 years agoSlightly improved formatting
Ian Jackson [Sat, 15 Aug 2009 23:55:34 +0000 (00:55 +0100)]
Slightly improved formatting

15 years agoNotes from linear programming research (for meat of route query)
Ian Jackson [Sat, 15 Aug 2009 23:52:58 +0000 (00:52 +0100)]
Notes from linear programming research (for meat of route query)

15 years agoRemove query-specific invocations from lookup (regexp preserving query entries remains)
Ian Jackson [Sat, 15 Aug 2009 23:52:15 +0000 (00:52 +0100)]
Remove query-specific invocations from lookup (regexp preserving query entries remains)

15 years agoSplit lookup options into separate query_ components
Ian Jackson [Sat, 15 Aug 2009 23:49:45 +0000 (00:49 +0100)]
Split lookup options into separate query_ components

15 years agowebsite copes with older JSON.pm
Ian Jackson [Fri, 14 Aug 2009 19:41:54 +0000 (20:41 +0100)]
website copes with older JSON.pm

15 years agoMerge branch 'stable-3.x'
Ian Jackson [Fri, 14 Aug 2009 19:17:55 +0000 (20:17 +0100)]
Merge branch 'stable-3.x'

15 years agoHandle opening errors in gzopen properly 3.1
Ian Jackson [Fri, 14 Aug 2009 19:09:57 +0000 (20:09 +0100)]
Handle opening errors in gzopen properly

15 years agoFix up example invocations of dictionary-manager for directory rename
Ian Jackson [Fri, 14 Aug 2009 19:08:32 +0000 (20:08 +0100)]
Fix up example invocations of dictionary-manager for directory rename

15 years agoNew --dict-no-update option prevents some rsyncs, for testing. (but is a bit broken...
Ian Jackson [Fri, 14 Aug 2009 19:07:09 +0000 (20:07 +0100)]
New --dict-no-update option prevents some rsyncs, for testing.  (but is a bit broken, and not documented)

15 years agoMerge branch 'ijackson'
Ian Jackson [Fri, 14 Aug 2009 18:44:27 +0000 (19:44 +0100)]
Merge branch 'ijackson'

15 years agoEncode instance in emails properly
Ian Jackson [Fri, 14 Aug 2009 18:38:04 +0000 (19:38 +0100)]
Encode instance in emails properly

15 years agoPut webcopyright in autohandler
Ian Jackson [Fri, 14 Aug 2009 14:32:16 +0000 (15:32 +0100)]
Put webcopyright in autohandler

15 years agoUnbreak routetextstring
Ian Jackson [Fri, 14 Aug 2009 14:28:50 +0000 (15:28 +0100)]
Unbreak routetextstring

15 years agoFurther minor validation fixups
Ian Jackson [Fri, 14 Aug 2009 14:21:50 +0000 (15:21 +0100)]
Further minor validation fixups

15 years agoSort out validation errors in dataage and tidy up
Ian Jackson [Fri, 14 Aug 2009 14:19:21 +0000 (15:19 +0100)]
Sort out validation errors in dataage and tidy up

15 years agoset content-type charset and LC_CTYPE to UTF-8
Ian Jackson [Fri, 14 Aug 2009 14:12:07 +0000 (15:12 +0100)]
set content-type charset and LC_CTYPE to UTF-8
also add some forgotten files

15 years agoMake it pass W3C validator: add DTD, work around crazy javascript escaping, etc
Ian Jackson [Fri, 14 Aug 2009 14:02:36 +0000 (15:02 +0100)]
Make it pass W3C validator: add DTD, work around crazy javascript escaping, etc