Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 almost 13 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 about 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 2497 over 12 years Aaron Marcuse-Kubitza sql.py: mk_insert_select(): embeddable: functio...
  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 almost 13 years Aaron Marcuse-Kubitza main Makefile: VegBIEN DB: Install public schem...
map 978 Bytes 1979 almost 13 years Aaron Marcuse-Kubitza root map: Fill in defaults for inputs from VegB...

Latest revisions

# Date Author Comment
2497 05/30/2012 08:53 PM Aaron Marcuse-Kubitza

sql.py: mk_insert_select(): embeddable: function_name is first line of query for clarity, and to reduce length from including the column names. This also fixes the problem of double quotes around column names in the previous function_name.

2496 05/30/2012 08:47 PM Aaron Marcuse-Kubitza

sql.py: esc_name_by_module(): Double embedded quotes to escape them instead of removing them

2495 05/30/2012 08:35 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Use "-" to separate temp table suffixes from into table name

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

View all revisions | View revisions

Also available in: Atom