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...
  analysis 3076 over 12 years Aaron Marcuse-Kubitza Added top-level analysis dir for range modeling
  backups 4200 over 12 years Aaron Marcuse-Kubitza backups/: svn:ignore: Also ignore .*, which inc...
  bin 4497 about 12 years Aaron Marcuse-Kubitza join: Match terms case-insensitively
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 4497 about 12 years Aaron Marcuse-Kubitza join: Match terms case-insensitively
  lib 4495 about 12 years Aaron Marcuse-Kubitza sql_io.py: put_table(): Creating the into table...
  mappings 4458 about 12 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: if subplot: Also ...
  schemas 4493 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: analytical_db_view: Change...
  to_do 4091 over 12 years Aaron Marcuse-Kubitza to_do/: svn:ignore OpenOffice lock files
Makefile 10.1 KB 3764 over 12 years Aaron Marcuse-Kubitza root Makefile, input.Makefile: Maps validation:...
README.TXT 10.4 KB 4487 about 12 years Aaron Marcuse-Kubitza README.TXT: Data import: Added testing steps to...
map 1.22 KB 3475 over 12 years Aaron Marcuse-Kubitza root map: Run bin/map with a nice increment of ...

Latest revisions

# Date Author Comment
4497 09/07/2012 07:15 AM Aaron Marcuse-Kubitza

join: Match terms case-insensitively

4496 09/06/2012 11:17 PM Aaron Marcuse-Kubitza

Added inputs/TEAM/

4495 09/06/2012 10:55 PM Aaron Marcuse-Kubitza

sql_io.py: put_table(): Creating the into table: into_out_pkey: If is_function, just use "result" as the output column name, without prefixing the function name. This shortens the table names of function calls on function calls, which need a fixed column name to detect which columns are function results and use just the table names for those columns.

4494 09/06/2012 10:32 PM Aaron Marcuse-Kubitza

input.Makefile: Documentation: $(steps): Fixed bug where import make target needed to be changed to new single-table import target

4493 09/06/2012 09:38 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_db_view: Changed LEFT JOINs to JOINs where tables contain information that's required for the analytical DB. This should also enable the PostgreSQL query planner to make additional join optimizations, in the hopes of avoiding disk-space-intensive hash joins.

4492 09/06/2012 08:42 PM Aaron Marcuse-Kubitza

Replaced repr() with strings.urepr() (or equivalent) everywhere needed, to avoid future UnicodeEncodeErrors

4491 09/06/2012 08:30 PM Aaron Marcuse-Kubitza

Replaced str() with strings.ustr() (or equivalent) everywhere needed, to avoid future UnicodeEncodeErrors

4490 09/06/2012 08:03 PM Aaron Marcuse-Kubitza

sql.py: map_expr(): Replacing without quotes: Don't match unquoted name where it's preceded or followed by '.', because this could be a '.' embedded in a punctuation-containing column name, such as those frequently used by column-based import. Note that because database-internal names currently do not contain punctuation, this situation only occurs when a database-internal expression (such as a check constraint condition) is replaced in two steps, and the first step introduces punctuation-containing column names into the expression.

4489 09/06/2012 07:19 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: project: Don't require projectname to be specified when sourceaccessioncode is provided

4488 09/06/2012 07:14 PM Aaron Marcuse-Kubitza

sql_gen.py: ensure_not_null(): If type_ is set, cast the column to it if needed

View all revisions | View revisions

Also available in: Atom