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 2760 over 12 years Aaron Marcuse-Kubitza sql.py: create_table(): Add indexes on all non-...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 2775 over 12 years Aaron Marcuse-Kubitza inputs/SALVIAS: Switched to using CSV exports o...
  lib 2789 over 12 years Aaron Marcuse-Kubitza sql.py: run_query_into(): Removed no longer use...
  mappings 2529 over 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: Removed _t...
  schemas 2778 over 12 years Aaron Marcuse-Kubitza schemas/postgresql.nimoy.conf: shared_buffers: ...
  to_do 2547 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect the mont...
Makefile 10.1 KB 2633 over 12 years Aaron Marcuse-Kubitza main Makefile: schemas/%/uninstall: Removed del...
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
2789 06/12/2012 08:35 PM Aaron Marcuse-Kubitza

sql.py: run_query_into(): Removed no longer used params parameter

2788 06/12/2012 08:32 PM Aaron Marcuse-Kubitza

sql.py: mk_insert_select(): Removed no longer used params parameter

2787 06/12/2012 08:25 PM Aaron Marcuse-Kubitza

sql.py: mk_insert_select(): Return just the query instead of the query plus empty params

2786 06/12/2012 08:22 PM Aaron Marcuse-Kubitza

sql.py: mk_select(): Return just the query instead of the query plus empty params

2785 06/12/2012 08:12 PM Aaron Marcuse-Kubitza

sql.py: tables(): Use select() instead of a custom run_query() to avoid using params, which will be deprecated to make it easier to support old versions of Python

2784 06/12/2012 08:11 PM Aaron Marcuse-Kubitza

sql.py: DbConn.DbCursor.execute(): Require that params are empty, to ensure that code uses db.esc_value() instead. This keeps literal values in the same place as the rest of the query, so that they do not need to be maintained and passed around separately in a params list.

2783 06/12/2012 08:06 PM Aaron Marcuse-Kubitza

sql.py: constraint_cols(): Use db.esc_value() instead of params

2782 06/12/2012 08:05 PM Aaron Marcuse-Kubitza

sql.py: index_cols(): Use db.esc_value() instead of params

2781 06/12/2012 08:00 PM Aaron Marcuse-Kubitza

sql.py: add_pkey(): Use simpler `ADD PRIMARY KEY` syntax to avoid having to create a name for the primary key

2780 06/12/2012 07:57 PM Aaron Marcuse-Kubitza

db_xml.py: put_table(): Subsetting in_table: Add pkey to created temp table to facilitate joining it with intermediate tables

View all revisions | View revisions

Also available in: Atom