/ - Repository - BIEN 3 - NCEAS Projects

Name	Size	Revision	Age	Author	Comment
_archive		1598	over 12 years	Aaron Marcuse-Kubitza	Moved _archive/tapir2flatClient/trunk/client/ t...
analysis		3076	over 12 years	Aaron Marcuse-Kubitza	Added top-level analysis dir for range modeling
bin		3339	over 12 years	Aaron Marcuse-Kubitza	bin/map: Fixed bug where errors table indexes c...
config		272	almost 13 years	Aaron Marcuse-Kubitza	Moved bien_password to new config dir
inputs		3341	over 12 years	Aaron Marcuse-Kubitza	inputs/import.stats.xls: Updated with stats fro...
lib		3357	over 12 years	Aaron Marcuse-Kubitza	sql.py: distinct_table(): Support literal value...
mappings		3337	over 12 years	Aaron Marcuse-Kubitza	mappings/VegX-VegBIEN.stems.csv: Reattached loc...
schemas		3344	over 12 years	Aaron Marcuse-Kubitza	schemas/vegbien.sql: specimenreplicate: specime...
to_do		2547	over 12 years	Aaron Marcuse-Kubitza	to_do/timeline.doc: Updated to reflect the mont...
Makefile	10.5 KB	3249	over 12 years	Aaron Marcuse-Kubitza	root Makefile: VegBIEN DB: Schemas: Added schem...
README.TXT	2.96 KB	3205	over 12 years	Aaron Marcuse-Kubitza	README.TXT: Data import: Import data into VegBI...
map	1.21 KB	3140	over 12 years	Aaron Marcuse-Kubitza	top-level map: Added support for custom public ...

#	Date	Author	Comment
3357	07/12/2012 01:11 PM	Aaron Marcuse-Kubitza	sql.py: distinct_table(): Support literal values as column expressions. Filter out untyped NULLs because the type unknown can't be indexed.
3356	07/12/2012 01:09 PM	Aaron Marcuse-Kubitza	sql.py: add_index(): Support literal values as expressions
3355	07/12/2012 01:06 PM	Aaron Marcuse-Kubitza	sql_gen.py: ensure_not_null(): Support Literal value inputs, which are passed through if not nullable
3354	07/12/2012 01:05 PM	Aaron Marcuse-Kubitza	sql_gen.py: Added cast_literal()
3353	07/12/2012 11:52 AM	Aaron Marcuse-Kubitza	sql.py: Added simplify_expr() and use it in parse_expr_col(). This will remove extraneous information from the condition that gets included in the errors table, so it's easy for the data provider to see what constraint is being violated as it applies to their data.
3352	07/12/2012 11:40 AM	Aaron Marcuse-Kubitza	sql_io.py: put_table(): Handle CheckExceptions. This fixes a REMIB bug where some rows violated the specimenreplicate.specimenreplicate_required_key CHECK constraint, but there was previously no way to filter out just these rows so all rows were removed instead.
3351	07/12/2012 11:33 AM	Aaron Marcuse-Kubitza	sql.py: Added map_expr()
3350	07/12/2012 11:33 AM	Aaron Marcuse-Kubitza	sql_gen.py: Added NotCond
3349	07/12/2012 10:06 AM	Aaron Marcuse-Kubitza	sql.py: run_query(): ConstraintException: Get and include the constraint condition in the exception
3348	07/12/2012 10:05 AM	Aaron Marcuse-Kubitza	sql.py: Added constraint_cond()

root @ 3357