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 2062 about 12 years Aaron Marcuse-Kubitza Calls to sql.esc_name*(): Removed preserve_case...
  config 272 over 12 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 2028 about 12 years Aaron Marcuse-Kubitza mappings/DwC1-DwC2.specimens.csv: Mapped collec...
  lib 2087 about 12 years Aaron Marcuse-Kubitza sql.py: put_table(): Take multiple in_tables. I...
  mappings 2028 about 12 years Aaron Marcuse-Kubitza mappings/DwC1-DwC2.specimens.csv: Mapped collec...
  schemas 2036 about 12 years Aaron Marcuse-Kubitza Moved "CREATE PROCEDURAL LANGUAGE plpgsql" to m...
  to_do 811 over 12 years Aaron Marcuse-Kubitza Added to_do/milestones.doc
Makefile 8.78 KB 2037 about 12 years Aaron Marcuse-Kubitza main Makefile: VegBIEN DB: mk_db: Use template1...
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
2087 05/05/2012 09:55 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Take multiple in_tables. Initial implementation just used the first in_table.

2086 05/05/2012 09:48 PM Aaron Marcuse-Kubitza

sql.py: Added add_row_num(). put_table(): Add row_num to pkeys_table, so it can be joined with in_table's pkeys.

2085 05/05/2012 09:38 PM Aaron Marcuse-Kubitza

sql.py: Added run_query_into() and use it in insert_select()

2084 05/05/2012 08:53 PM Aaron Marcuse-Kubitza

sql.py: pkey(): Support escaped table names

2083 05/05/2012 07:32 PM Aaron Marcuse-Kubitza

sql.py: mk_insert_select(): embeddable: Name the function alias "f" since it will just be wrapped in a nested SELECT, so the exact name doesn't matter (and won't be visible outside the nested SELECT anyway)

2082 05/05/2012 07:08 PM Aaron Marcuse-Kubitza

db_xml.py: put_table(): Return the (table, col) where the pkeys are made available, now that this information is available from sql.put_table()

2081 05/05/2012 07:05 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Return just the name of the table where the pkeys are made available, since the column name in that table now equals the pkey name

2080 05/05/2012 06:58 PM Aaron Marcuse-Kubitza

sql.py: mk_insert_select(): embeddable: Make the column returned by the function have the same name as the returning column

2079 05/05/2012 06:39 PM Aaron Marcuse-Kubitza

db_xml.py: put_table() Use new sql.put_table()

2078 05/05/2012 06:39 PM Aaron Marcuse-Kubitza

sql.py: Added put_table()

View all revisions | View revisions

Also available in: Atom