Project

General

Profile

Statistics
| Revision:

root @ 2274

Name Size Revision Age Author Comment
  _archive 1598 over 12 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  bin 2195 over 12 years Aaron Marcuse-Kubitza db_xml.py: put_table(): Added limit and start o...
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 2250 over 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: Filter dat...
  lib 2274 over 12 years Aaron Marcuse-Kubitza sql.py: mk_insert_select(): Use sql_gen.table2s...
  mappings 2250 over 12 years Aaron Marcuse-Kubitza mappings/DwC2-VegBIEN.specimens.csv: Filter dat...
  schemas 2249 over 12 years Aaron Marcuse-Kubitza schemas/functions.sql: Added _toTimestamp
  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
2274 05/21/2012 11:04 PM Aaron Marcuse-Kubitza

sql.py: mk_insert_select(): Use sql_gen.table2sql_gen().to_str() to escape the table
2273 05/21/2012 10:57 PM Aaron Marcuse-Kubitza

db_xml.py: put_table(): First in_tables table is sql_gen.Table object
2272 05/21/2012 10:49 PM Aaron Marcuse-Kubitza

db_xml.py: put_table(): Converted row (mapping) values to sql_gen objects
2271 05/21/2012 10:45 PM Aaron Marcuse-Kubitza

sql.py: mk_select(): Accept main tables (table0's) that are Table objects. This change requires plain SQL code to be wrapped in a CustomCode object if it should not be unescaped and converted to a Table object.
2270 05/21/2012 10:42 PM Aaron Marcuse-Kubitza

sql_gen.py: as_Table(): Accept tables that are Code objects, not just Table objects
2269 05/21/2012 10:40 PM Aaron Marcuse-Kubitza

sql_gen.py: CustomCode: Fixed bug where needed to inherit from Code
2268 05/21/2012 10:19 PM Aaron Marcuse-Kubitza

sql.py: put_table(): Return a sql_gen.Col object instead of an old-style tuple
2267 05/21/2012 10:00 PM Aaron Marcuse-Kubitza

sql.py: mk_select(): joins: Switched to using filter_out as an attribute of the Join object instead of a sentinel value for the first column. Filter by the right table's pkey being NULL instead of each joined column being NULL, because some joined columns may contain NULL values which would mess things up, but the pkey presumably is NOT NULL.
2266 05/21/2012 09:56 PM Aaron Marcuse-Kubitza

sql_gen.py: Join.to_str(): Fixed bug where type_ None was being concatenated with the JOIN str
2265 05/21/2012 09:31 PM Aaron Marcuse-Kubitza

sql_gen.py: Join.to_str(): Fixed bug where USING syntax could not be used for filter_out join type, because a separate right column is required for filtering

View all revisions | View revisions

Also available in: Atom