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 1965 about 12 years Aaron Marcuse-Kubitza csv2db: Fixed bug where extra columns were not ...
  config 272 over 12 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 1955 about 12 years Aaron Marcuse-Kubitza input.Makefile: Staging tables: import/install-...
  lib 1964 about 12 years Aaron Marcuse-Kubitza streams.py: StreamIter: Define readline() as a ...
  mappings 1843 about 12 years Aaron Marcuse-Kubitza mappings: Build VegX-VegBIEN.organisms.csv from...
  schemas 1966 about 12 years Aaron Marcuse-Kubitza schemas/postgresql.Mac.conf: Set unix_socket_di...
  to_do 811 over 12 years Aaron Marcuse-Kubitza Added to_do/milestones.doc
Makefile 8.44 KB 1967 about 12 years Aaron Marcuse-Kubitza main Makefile: VegBIEN DB: Install public schem...
README.TXT 2.7 KB 1967 about 12 years Aaron Marcuse-Kubitza main Makefile: VegBIEN DB: Install public schem...
map 870 Bytes 1951 about 12 years Aaron Marcuse-Kubitza env_password: return instead of exit if passwor...

Latest revisions

# Date Author Comment
1967 04/24/2012 12:34 PM Aaron Marcuse-Kubitza

main Makefile: VegBIEN DB: Install public schema in a separate step, so that it can be dropped without dropping the entire DB (which also contains staging tables that shouldn't be dropped when there is a schema change). Added schemas/install, schemas/uninstall, implicit schemas/reinstall to manage the public schema separately from the rest of the DB. Moved Subdir forwarding to the bottom so overridden targets are not forwarded. README.TXT: Since `make reinstall_db` would drop the entire DB, tell user to run new `make schemas/reinstall` instead to reinstall (main) DB from schema.

1966 04/24/2012 12:30 PM Aaron Marcuse-Kubitza

schemas/postgresql.Mac.conf: Set unix_socket_directory to the new dir it seems to be using, which is now /tmp

1965 04/24/2012 11:43 AM Aaron Marcuse-Kubitza

csv2db: Fixed bug where extra columns were not truncated in INSERT mode. Replace empty column names with the column # to avoid errors with CSVs that have trailing ","s, etc.

1964 04/24/2012 11:41 AM Aaron Marcuse-Kubitza

streams.py: StreamIter: Define readline() as a separate method so it can be overridden, and all calls to self.next() will use the overridden readline(). This fixes a bug in ProgressInputStream where incremental counts would not be displayed and it would end with "not all input read" if the StreamIter interface was used instead of readline().

1963 04/23/2012 09:57 PM Aaron Marcuse-Kubitza

csv2db: Fall back to manually inserting each row (autodetecting the encoding for each field) if COPY FROM doesn't work

1962 04/23/2012 09:56 PM Aaron Marcuse-Kubitza

streams.py: FilterStream: Inherit from StreamIter so that all descendants automatically have StreamIter functionality

1961 04/23/2012 09:42 PM Aaron Marcuse-Kubitza

sql.py: insert(): Support using the default value for columns designated with the special value sql.default

1960 04/23/2012 09:21 PM Aaron Marcuse-Kubitza

sql.py: insert(): Support rows that are just a list of values, with no columns. Support already-escaped table names.

1959 04/23/2012 08:54 PM Aaron Marcuse-Kubitza

strings.py: Added contains_any()

1958 04/23/2012 08:54 PM Aaron Marcuse-Kubitza

csvs.py: reader_and_header(): Use make_reader()

View all revisions | View revisions

Also available in: Atom