Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 over 12 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  bin 2490 over 12 years Aaron Marcuse-Kubitza bin/map: Logging: log(): Remove extra debug inf...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 2438 over 12 years Aaron Marcuse-Kubitza input.Makefile: Configuration: Removed debug va...
  lib 2494 over 12 years Aaron Marcuse-Kubitza db_xml.py: into_table_name(): Format relational...
  mappings 2364 over 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: plantname....
  schemas 2412 over 12 years Aaron Marcuse-Kubitza schemas/functions.sql, vegbien.sql: Changed CAS...
  to_do 811 almost 13 years Aaron Marcuse-Kubitza Added to_do/milestones.doc
Makefile 9.47 KB 2095 over 12 years Aaron Marcuse-Kubitza main Makefile: VegBIEN DB: functions schema: Re...
README.TXT 2.7 KB 1967 over 12 years Aaron Marcuse-Kubitza main Makefile: VegBIEN DB: Install public schem...
map 978 Bytes 1979 over 12 years Aaron Marcuse-Kubitza root map: Fill in defaults for inputs from VegB...

Latest revisions

# Date Author Comment
2494 05/30/2012 08:26 PM Aaron Marcuse-Kubitza

db_xml.py: into_table_name(): Format relational functions' into table names as a function call on the value column, using special chars for readability

2493 05/30/2012 08:19 PM Aaron Marcuse-Kubitza

sql.py: run_query(): Exception parsing: Use "(.+?)" wherever possible to match names containing special chars

2492 05/30/2012 07:52 PM Aaron Marcuse-Kubitza

sql.py: clean_name(): For clarity, just remove '"'s, so that "."s are preserved and show the path structure of the input name

2491 05/30/2012 07:38 PM Aaron Marcuse-Kubitza

db_xml.py: put_table(): sql.put_table(): Name the into table ...literal instead of ...value if the value column is a literal value

2490 05/30/2012 07:08 PM Aaron Marcuse-Kubitza

bin/map: Logging: log(): Remove extra debug info from DB query messages and format level 1.5 (summary) messages as Redmine list items

2489 05/30/2012 06:50 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Renamed temp_prefix param to into and allow it to be a sql_gen.Table object. Use into directly as the pkeys table, and make its default value be `out_table.name+'_pkeys'`.

2488 05/30/2012 06:31 PM Aaron Marcuse-Kubitza

db_xml.py: put_table(): Pass custom temp_prefix to sql.put_table() for relational funcs, so that their value param's input column name is included in the temp table name

2487 05/30/2012 06:19 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Added optional param temp_prefix for the prefix of generated temp tables

2486 05/30/2012 06:13 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Made debug messages more self-documenting

2485 05/30/2012 05:44 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Changed "Setting missing rows' pkeys to NULL" to "Setting pkeys of missing rows to NULL" to avoid having single quote in debug output, which messes up text editor SQL syntax highlighting

View all revisions | View revisions

Also available in: Atom