chiark / gitweb /
ypp-sc-tools.db-live.git
14 years agoCan actually update the database
Ian Jackson [Tue, 28 Jul 2009 19:06:22 +0000 (20:06 +0100)]
Can actually update the database

14 years agoWe don't care about backslashes
Ian Jackson [Tue, 28 Jul 2009 18:02:30 +0000 (19:02 +0100)]
We don't care about backslashes

14 years agoRecompress the tsv (and err make it work again??)
Ian Jackson [Tue, 28 Jul 2009 18:02:08 +0000 (19:02 +0100)]
Recompress the tsv (and err make it work again??)

14 years agobetter error messages from pipethrough_*
Ian Jackson [Tue, 28 Jul 2009 17:14:58 +0000 (18:14 +0100)]
better error messages from pipethrough_*

14 years agoWIP email processor, now prepares some SQL
Ian Jackson [Tue, 28 Jul 2009 17:11:32 +0000 (18:11 +0100)]
WIP email processor, now prepares some SQL

14 years agoNew CommodsDatabase module for broken out DBI stuff
Ian Jackson [Tue, 28 Jul 2009 17:11:19 +0000 (18:11 +0100)]
New CommodsDatabase module for broken out DBI stuff

14 years agoRename age to timestamp; add field for email (rfc822) messageid
Ian Jackson [Tue, 28 Jul 2009 17:10:17 +0000 (18:10 +0100)]
Rename age to timestamp; add field for email (rfc822) messageid

14 years agoDetect a few more inconsistencies
Ian Jackson [Tue, 28 Jul 2009 17:07:03 +0000 (18:07 +0100)]
Detect a few more inconsistencies

14 years agoUse commas to separate islands in route database for easier editing
Ian Jackson [Tue, 28 Jul 2009 11:03:23 +0000 (12:03 +0100)]
Use commas to separate islands in route database for easier editing

14 years agoWIP db populate; compute shortest paths in Perl (takes 1.5s on liberator)
Ian Jackson [Mon, 27 Jul 2009 00:02:36 +0000 (01:02 +0100)]
WIP db populate; compute shortest paths in Perl (takes 1.5s on liberator)

14 years agoWIP database populate before perl route calc
Ian Jackson [Sun, 26 Jul 2009 22:55:38 +0000 (23:55 +0100)]
WIP database populate before perl route calc

14 years agowip route computation
Ian Jackson [Sun, 26 Jul 2009 19:20:33 +0000 (20:20 +0100)]
wip route computation

14 years agoschema creator in Perl
Ian Jackson [Sun, 26 Jul 2009 18:19:04 +0000 (19:19 +0100)]
schema creator in Perl

14 years agoDB schema in sqlite format
Ian Jackson [Sun, 26 Jul 2009 17:02:45 +0000 (18:02 +0100)]
DB schema in sqlite format

14 years agoids in schema; distances
Ian Jackson [Sun, 26 Jul 2009 11:38:45 +0000 (12:38 +0100)]
ids in schema; distances

14 years agoWIP schema
Ian Jackson [Sun, 26 Jul 2009 11:08:30 +0000 (12:08 +0100)]
WIP schema

14 years agowip commod-email-processor: can parse, now need to make it handle database
Ian Jackson [Sat, 25 Jul 2009 18:35:47 +0000 (19:35 +0100)]
wip commod-email-processor: can parse, now need to make it handle database

14 years agowip commod-email-processor; tab-delimit metadata in emails
Ian Jackson [Sat, 25 Jul 2009 14:55:36 +0000 (15:55 +0100)]
wip commod-email-processor; tab-delimit metadata in emails

14 years agometadata as tsv text header means we don't care about = in values
Ian Jackson [Sat, 25 Jul 2009 13:28:58 +0000 (14:28 +0100)]
metadata as tsv text header means we don't care about = in values

14 years agometadata as tsv text header
Ian Jackson [Sat, 25 Jul 2009 11:05:52 +0000 (12:05 +0100)]
metadata as tsv text header

14 years agoWIP commod-update-receiver testing - seems to work
Ian Jackson [Fri, 24 Jul 2009 21:51:12 +0000 (22:51 +0100)]
WIP commod-update-receiver testing - seems to work

14 years agoWIP commod-update-receiver testing
Ian Jackson [Fri, 24 Jul 2009 19:15:46 +0000 (20:15 +0100)]
WIP commod-update-receiver testing

14 years agoMerge branch 'master' into ourdb
Ian Jackson [Fri, 24 Jul 2009 16:58:49 +0000 (17:58 +0100)]
Merge branch 'master' into ourdb

Conflicts:

pctb/commod-results-processor

14 years agoMerge branch 'stable'
Ian Jackson [Fri, 24 Jul 2009 16:54:14 +0000 (17:54 +0100)]
Merge branch 'stable'

14 years agoActually compress marketdata.gz (!)
Ian Jackson [Fri, 24 Jul 2009 16:48:42 +0000 (17:48 +0100)]
Actually compress marketdata.gz (!)

14 years agowip commod-update-receiver and new uploader
Ian Jackson [Fri, 24 Jul 2009 16:29:12 +0000 (17:29 +0100)]
wip commod-update-receiver and new uploader

14 years agowip commod-update-receiver
Ian Jackson [Fri, 24 Jul 2009 16:23:01 +0000 (17:23 +0100)]
wip commod-update-receiver

14 years agoWIP update processor, generating outgoing email
Ian Jackson [Wed, 22 Jul 2009 14:40:56 +0000 (15:40 +0100)]
WIP update processor, generating outgoing email

14 years agoWIP commod-update-receiver
Ian Jackson [Mon, 20 Jul 2009 02:30:36 +0000 (03:30 +0100)]
WIP commod-update-receiver

14 years agoPut _commodmap.tsv parsing all in Commods.pm
Ian Jackson [Sun, 19 Jul 2009 20:08:41 +0000 (21:08 +0100)]
Put _commodmap.tsv parsing all in Commods.pm

14 years agoBreak parse_master out into Commods.pm
Ian Jackson [Sun, 19 Jul 2009 19:27:56 +0000 (20:27 +0100)]
Break parse_master out into Commods.pm

14 years agoWIP commod-update-receiver; before make parse_parser into library
Ian Jackson [Sun, 19 Jul 2009 19:18:32 +0000 (20:18 +0100)]
WIP commod-update-receiver; before make parse_parser into library

14 years agoMerge branch 'master' into ourdb
Ian Jackson [Sun, 19 Jul 2009 18:16:40 +0000 (19:16 +0100)]
Merge branch 'master' into ourdb

14 years agoMerge branch 'origin'
Ian Jackson [Sun, 19 Jul 2009 16:35:21 +0000 (17:35 +0100)]
Merge branch 'origin'

14 years agoLaxer identification for subpixel antialiasing
Ian Jackson [Sun, 19 Jul 2009 15:54:32 +0000 (16:54 +0100)]
Laxer identification for subpixel antialiasing

14 years agoInclude last page(!) 2.1
Ian Jackson [Sun, 19 Jul 2009 15:53:39 +0000 (16:53 +0100)]
Include last page(!)

14 years agoDo not flush in ocr debug if debug not enabled
Ian Jackson [Sun, 19 Jul 2009 15:20:17 +0000 (16:20 +0100)]
Do not flush in ocr debug if debug not enabled

14 years agoUse fixed point arithmetic in find_aa_density
Ian Jackson [Sun, 19 Jul 2009 15:11:21 +0000 (16:11 +0100)]
Use fixed point arithmetic in find_aa_density

14 years agoReverse order of samples in Rgb and other optimisations
Ian Jackson [Sun, 19 Jul 2009 14:31:07 +0000 (15:31 +0100)]
Reverse order of samples in Rgb and other optimisations

14 years agoAdjust colours early so that we don't have to keep all RGBs in RAM
Ian Jackson [Sun, 19 Jul 2009 12:52:56 +0000 (13:52 +0100)]
Adjust colours early so that we don't have to keep all RGBs in RAM

14 years agoprint vprogress messages to files if any -D options specified
Ian Jackson [Sun, 19 Jul 2009 11:21:38 +0000 (12:21 +0100)]
print vprogress messages to files if any -D options specified

14 years agoWIP our own database
Ian Jackson [Thu, 16 Jul 2009 18:09:45 +0000 (19:09 +0100)]
WIP our own database

14 years agoCompress _pages.ppm for faster execution (less disk traffic) 2.0
Ian Jackson [Thu, 9 Jul 2009 19:16:12 +0000 (20:16 +0100)]
Compress _pages.ppm for faster execution (less disk traffic)

14 years agoCompress the screenshots file on output
Ian Jackson [Thu, 9 Jul 2009 18:43:26 +0000 (19:43 +0100)]
Compress the screenshots file on output

14 years agoMerge branch 'ijackson'
Ian Jackson [Thu, 9 Jul 2009 18:26:57 +0000 (19:26 +0100)]
Merge branch 'ijackson'

14 years agoFix up wait_for_stability delays
Ian Jackson [Thu, 9 Jul 2009 18:21:22 +0000 (19:21 +0100)]
Fix up wait_for_stability delays

14 years agoMerge branch 'ijackson'
Ian Jackson [Thu, 9 Jul 2009 16:58:36 +0000 (17:58 +0100)]
Merge branch 'ijackson'

14 years agoUse gzip --rsyncable -7 instead of -1
Ian Jackson [Thu, 9 Jul 2009 16:57:41 +0000 (17:57 +0100)]
Use gzip --rsyncable -7 instead of -1

14 years agoSupport --screenshots-file as alternative spelling
Ian Jackson [Thu, 9 Jul 2009 16:49:07 +0000 (17:49 +0100)]
Support --screenshots-file as alternative spelling

14 years agoPrint that we are updating for every rsync
Ian Jackson [Thu, 9 Jul 2009 16:48:19 +0000 (17:48 +0100)]
Print that we are updating for every rsync

14 years agoUse compressed _master-pixmap.txt.gz
Ian Jackson [Thu, 9 Jul 2009 16:38:52 +0000 (17:38 +0100)]
Use compressed _master-pixmap.txt.gz

14 years agopage with the mouse to avoid the silly page-back-to-top effect 1.9.4
Ian Jackson [Sun, 5 Jul 2009 23:51:21 +0000 (00:51 +0100)]
page with the mouse to avoid the silly page-back-to-top effect

14 years agoWhen setting focus on commodities, always use top left corner of table
Ian Jackson [Sun, 5 Jul 2009 22:38:39 +0000 (23:38 +0100)]
When setting focus on commodities, always use top left corner of table

14 years agoCope if very few commodities on screen. Use ADJUST_BOX much more.
Ian Jackson [Sun, 5 Jul 2009 22:34:53 +0000 (23:34 +0100)]
Cope if very few commodities on screen.  Use ADJUST_BOX much more.

14 years agoCope with islands with names ending in y, from land
Ian Jackson [Sun, 5 Jul 2009 21:57:55 +0000 (22:57 +0100)]
Cope with islands with names ending in y, from land

14 years agoDiscard obsolete 1U<<31 from colon searcher
Ian Jackson [Sun, 5 Jul 2009 21:55:58 +0000 (22:55 +0100)]
Discard obsolete 1U<<31 from colon searcher

14 years agoProvide compressed version of dictionaries
Ian Jackson [Sun, 5 Jul 2009 20:56:19 +0000 (21:56 +0100)]
Provide compressed version of dictionaries

14 years agoclarify Word
Ian Jackson [Sun, 5 Jul 2009 20:12:56 +0000 (21:12 +0100)]
clarify Word

14 years agoshowentry scales by 3
Ian Jackson [Sun, 5 Jul 2009 20:07:19 +0000 (21:07 +0100)]
showentry scales by 3

14 years agocope with subpixel antialiasing (urgh) 1.9.3
Ian Jackson [Sun, 5 Jul 2009 19:39:29 +0000 (20:39 +0100)]
cope with subpixel antialiasing (urgh)

14 years agoconstify CanonImage->rgb and make a copy in find_islandname
Ian Jackson [Sun, 5 Jul 2009 19:09:57 +0000 (20:09 +0100)]
constify CanonImage->rgb and make a copy in find_islandname

14 years agoproperly initialise blues in canonicalisation table
Ian Jackson [Sun, 5 Jul 2009 18:56:42 +0000 (19:56 +0100)]
properly initialise blues in canonicalisation table

14 years agocompare ::VERSION with 2.0 as that's clearer
Ian Jackson [Sun, 5 Jul 2009 18:42:53 +0000 (19:42 +0100)]
compare ::VERSION with 2.0 as that's clearer

14 years agoFix message saying when OK to mess with YPP client
Ian Jackson [Sun, 5 Jul 2009 18:39:42 +0000 (19:39 +0100)]
Fix message saying when OK to mess with YPP client

14 years agoSay when OK to mess with YPP client
Ian Jackson [Sun, 5 Jul 2009 18:36:07 +0000 (19:36 +0100)]
Say when OK to mess with YPP client

14 years agoCope with JSON.pm version 2 which has an incompatible change
Ian Jackson [Sun, 5 Jul 2009 18:28:54 +0000 (19:28 +0100)]
Cope with JSON.pm version 2 which has an incompatible change

14 years agoDo not mention bpp in mustfail1 since we check it ourselves nowadays
Ian Jackson [Sun, 5 Jul 2009 18:18:02 +0000 (19:18 +0100)]
Do not mention bpp in mustfail1 since we check it ourselves nowadays

14 years agoUse find_aa_density for colon detection
Ian Jackson [Sun, 5 Jul 2009 18:11:21 +0000 (19:11 +0100)]
Use find_aa_density for colon detection

14 years agofixes to find_aa_density: MUST failures print p, deal with rounding problems in alpha...
Ian Jackson [Sun, 5 Jul 2009 18:10:50 +0000 (19:10 +0100)]
fixes to find_aa_density: MUST failures print p, deal with rounding problems in alpha_mean; fix range end test for alpha_mean

14 years agoDon't put quotes around MF output
Ian Jackson [Sun, 5 Jul 2009 18:09:48 +0000 (19:09 +0100)]
Don't put quotes around MF output

14 years agosplit out find_aa_density
Ian Jackson [Sun, 5 Jul 2009 17:57:25 +0000 (18:57 +0100)]
split out find_aa_density

14 years agoBetter usage instructions
Ian Jackson [Sun, 5 Jul 2009 17:21:28 +0000 (18:21 +0100)]
Better usage instructions

14 years agoSome additional copyright info
Ian Jackson [Sun, 5 Jul 2009 17:09:15 +0000 (18:09 +0100)]
Some additional copyright info

14 years agoMode default is --upload so don't mention that in the README top example
Ian Jackson [Sun, 5 Jul 2009 16:58:40 +0000 (17:58 +0100)]
Mode default is --upload so don't mention that in the README top example

14 years agoRemove "example" file and include it in decode-pctb-marketdata
Ian Jackson [Sun, 5 Jul 2009 16:49:53 +0000 (17:49 +0100)]
Remove "example" file and include it in decode-pctb-marketdata

14 years agoIs faster now 1.9.2
Ian Jackson [Sun, 5 Jul 2009 15:00:51 +0000 (16:00 +0100)]
Is faster now

14 years agoNew colour canonification based on tree
Ian Jackson [Sun, 5 Jul 2009 14:51:10 +0000 (15:51 +0100)]
New colour canonification based on tree

14 years agoupdate .gitignore for new filenames
Ian Jackson [Sun, 5 Jul 2009 14:30:10 +0000 (15:30 +0100)]
update .gitignore for new filenames

14 years agoOptimised copyout from XImage for 24-deep 32bpp RGB LE XImages
Ian Jackson [Sun, 5 Jul 2009 14:14:27 +0000 (15:14 +0100)]
Optimised copyout from XImage for 24-deep 32bpp RGB LE XImages

14 years agoNotice and explicitly fail of display is <24bpp
Ian Jackson [Sun, 5 Jul 2009 13:32:28 +0000 (14:32 +0100)]
Notice and explicitly fail of display is <24bpp

14 years agoChange #<thing>#.<ext> filenames to _<thing>.<ext>
Ian Jackson [Sun, 5 Jul 2009 10:49:13 +0000 (11:49 +0100)]
Change #<thing>#.<ext> filenames to _<thing>.<ext>

14 years agofactor out execpnm_createphoto and use it everywhere
Ian Jackson [Sat, 4 Jul 2009 20:50:43 +0000 (21:50 +0100)]
factor out execpnm_createphoto and use it everywhere

14 years agoUse tmpfile trick for pixmaps too [-iwj]
ceb [Sat, 4 Jul 2009 20:45:05 +0000 (21:45 +0100)]
Use tmpfile trick for pixmaps too [-iwj]

14 years agoCope with AA island name on land
Ian Jackson [Sat, 4 Jul 2009 20:28:26 +0000 (21:28 +0100)]
Cope with AA island name on land

14 years agoFix Ahoy! recognition; make ADJUST_BOX take an OP argument
Ian Jackson [Sat, 4 Jul 2009 20:15:17 +0000 (21:15 +0100)]
Fix Ahoy! recognition; make ADJUST_BOX take an OP argument

14 years agomention that screenshots file must be noraw
Ian Jackson [Sat, 4 Jul 2009 20:11:48 +0000 (21:11 +0100)]
mention that screenshots file must be noraw

14 years agodo not attempt to parse the shoppe tab
Ian Jackson [Sat, 4 Jul 2009 20:08:28 +0000 (21:08 +0100)]
do not attempt to parse the shoppe tab

14 years agoPermit Return instead of clicking on pixmap selection
Ian Jackson [Sat, 4 Jul 2009 20:02:15 +0000 (21:02 +0100)]
Permit Return instead of clicking on pixmap selection

14 years agoChange MAX_PAGES to 1000
Ian Jackson [Sat, 4 Jul 2009 19:55:17 +0000 (20:55 +0100)]
Change MAX_PAGES to 1000

14 years agoDefault cursor is LH one
Ian Jackson [Sat, 4 Jul 2009 19:54:56 +0000 (20:54 +0100)]
Default cursor is LH one

14 years agodisable OK button while approving
Ian Jackson [Sat, 4 Jul 2009 19:40:43 +0000 (20:40 +0100)]
disable OK button while approving

14 years agocharset query D L U W go straight to entry
Ian Jackson [Sat, 4 Jul 2009 19:33:37 +0000 (20:33 +0100)]
charset query  D L U W  go straight to entry

14 years agosome more cleaning
Ian Jackson [Sat, 4 Jul 2009 19:30:40 +0000 (20:30 +0100)]
some more cleaning

14 years agosort approvals by context
Ian Jackson [Sat, 4 Jul 2009 19:29:31 +0000 (20:29 +0100)]
sort approvals by context

14 years agoactually do version protocol; use tempfile to stop exec truncating our binary ppm
Ian Jackson [Sat, 4 Jul 2009 19:29:15 +0000 (20:29 +0100)]
actually do version protocol; use tempfile to stop exec truncating our binary ppm

14 years agofix STRING macro
Ian Jackson [Sat, 4 Jul 2009 19:28:35 +0000 (20:28 +0100)]
fix STRING macro

14 years agoVersion protocol better error message
Ian Jackson [Sat, 4 Jul 2009 19:24:34 +0000 (20:24 +0100)]
Version protocol better error message

14 years agoVersion protocol better error message
Ian Jackson [Sat, 4 Jul 2009 19:22:54 +0000 (20:22 +0100)]
Version protocol better error message

14 years agoVersion protocol
Ian Jackson [Sat, 4 Jul 2009 19:21:29 +0000 (20:21 +0100)]
Version protocol

14 years agoAADEPTH=2
Ian Jackson [Sat, 4 Jul 2009 19:02:33 +0000 (20:02 +0100)]
AADEPTH=2