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 2313 about 12 years Aaron Marcuse-Kubitza db_xml.py: put_table(): Accept sql_gen.Table ob...
  config 272 over 12 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 2364 about 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: plantname....
  lib 2396 about 12 years Aaron Marcuse-Kubitza sql.py: Added clean_name()
  mappings 2364 about 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: plantname....
  schemas 2338 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql, schemas/functions.sql: Rel...
  to_do 811 over 12 years Aaron Marcuse-Kubitza Added to_do/milestones.doc
Makefile 9.47 KB 2095 about 12 years Aaron Marcuse-Kubitza main Makefile: VegBIEN DB: functions schema: Re...
README.TXT 2.7 KB 1967 about 12 years Aaron Marcuse-Kubitza main Makefile: VegBIEN DB: Install public schem...
map 978 Bytes 1979 about 12 years Aaron Marcuse-Kubitza root map: Fill in defaults for inputs from VegB...

Latest revisions

# Date Author Comment
2396 05/24/2012 03:58 PM Aaron Marcuse-Kubitza

sql.py: Added clean_name()

2395 05/24/2012 03:43 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Join together input tables into new table for speed and so don't modify input if values edited

2394 05/24/2012 03:37 PM Aaron Marcuse-Kubitza

sql.py: mk_flatten_mapping(): Take as_items param to return a list of dict items instead of a dict. Sort preserve cols before other cols. flatten(): Turn on as_items so that cols list is sorted in input order, with preserve cols first. This ensures that if a pkey is provided in preserve, it will be the first col in the generated table.

2393 05/24/2012 03:24 PM Aaron Marcuse-Kubitza

sql.py: mk_flatten_mapping(), flatten(): Take list of cols to select instead of using all cols in all tables to join

2392 05/24/2012 02:58 PM Aaron Marcuse-Kubitza

sql.py: mk_flatten_mapping(), flatten(): Renamed flat_table param to into to be consistent with run_query_into() and put it first because it is the output param

2391 05/24/2012 02:55 PM Aaron Marcuse-Kubitza

sql.py: Added flatten()

2390 05/24/2012 02:38 PM Aaron Marcuse-Kubitza

sql.py: mk_flatten_mapping(): preserve Col objects will have tables changed to flat_table to work with flattened table

2389 05/24/2012 02:29 PM Aaron Marcuse-Kubitza

sql.py: mk_flatten_mapping(): Added preserve param for list of columns not to rename

2388 05/24/2012 02:18 PM Aaron Marcuse-Kubitza

sql.py: esc_name_by_module(): Support module value None, and use default module psycopg2 for it

2387 05/23/2012 09:58 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Renamed *pkeys_ref to *pkeys to reflect that they are now objects rather than an array-based references

View all revisions | View revisions

Also available in: Atom