Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  _archive 1598 almost 13 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 4751 over 12 years Aaron Marcuse-Kubitza backups/Makefile: Backups: Full DB: Specify the...
  bin 5006 about 12 years Aaron Marcuse-Kubitza tnrs.py: tnrs_request(): Return the CSV stream ...
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 5014 about 12 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: Use new, more gen...
  lib 5025 about 12 years Aaron Marcuse-Kubitza sql_io.py: import_csv(): Only do the import in ...
  mappings 5014 about 12 years Aaron Marcuse-Kubitza mappings/VegCore-VegBIEN.csv: Use new, more gen...
  schemas 5009 about 12 years Aaron Marcuse-Kubitza schemas/functions.sql: Added _join_words()
  to_do 4524 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect addition...
  validation 4523 over 12 years Aaron Marcuse-Kubitza Added validation/
Makefile 9.99 KB 4752 over 12 years Aaron Marcuse-Kubitza root Makefile: PostgreSQL: postgres-Linux: Adde...
README.TXT 11.3 KB 5016 about 12 years Aaron Marcuse-Kubitza README.TXT: Data import: `make test by_col=1`: ...
map 1.28 KB 4981 over 12 years Aaron Marcuse-Kubitza root map: Fixed custom public schema override t...
new_terms.csv 30.4 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv
unmapped_terms.csv 5.8 KB 4887 over 12 years Aaron Marcuse-Kubitza Regenerated root unmapped_terms.csv, new_terms.csv

Latest revisions

# Date Author Comment
5025 09/26/2012 11:34 PM Aaron Marcuse-Kubitza

sql_io.py: import_csv(): Only do the import in a savepoint if using COPY FROM, to allow autocommits after each insert and thus make rows visible immediately after they are inserted

5024 09/26/2012 10:53 PM Aaron Marcuse-Kubitza

db_xml.py: put_table(): Subsetting in_table: Add a row number column if in_table does not already have a pkey

5023 09/26/2012 10:48 PM Aaron Marcuse-Kubitza

db_xml.py: put_table(): Subsetting in_table: Copy all of in_table's structure, rather than just the column types, by using sql.copy_table_struct() and sql.insert_select(). This preserves pkeys and NOT NULL constraints, which are useful for column-based import.

5022 09/26/2012 10:47 PM Aaron Marcuse-Kubitza

db_xml.py: put_table(): Subsetting in_table: Create in_table as a completely new sql_gen.Table instead of copying full_in_table and relying on sql.run_query_into() to set is_temp and remove the schema

5021 09/26/2012 10:40 PM Aaron Marcuse-Kubitza

sql.py: add_row_num(): Use if_not_exists in order to abort if the column already exists rather than adding a version #

5020 09/26/2012 10:36 PM Aaron Marcuse-Kubitza

sql.py: add_col(): Added if_not_exists param to abort if the column already exists rather than adding a version #

5019 09/26/2012 10:14 PM Aaron Marcuse-Kubitza

db_xml.py: put_table(): Removed no longer accurate comment that full_in_table will be shadowed (hidden) by the created temp table. (The temp table is now named differently, so the shadowing does not occur.)

5018 09/26/2012 10:02 PM Aaron Marcuse-Kubitza

db_xml.py: put_table(): Replaced no longer accurate Recurse comment with Import data. Rewrapped lines.

5017 09/26/2012 09:12 PM Aaron Marcuse-Kubitza

sql_io.py: import_csv(): Factored insertion code out into new append_csv()

5016 09/26/2012 08:47 PM Aaron Marcuse-Kubitza

README.TXT: Data import: `make test by_col=1`: Replaced errors explanation with pointer to updated explanation in the Testing section

View all revisions | View revisions

Also available in: Atom