sql.py: DbConn._db(): search_path: Don't append the existing search_path, because it usually includes the public schema, which is now different from the schema being imported into. This fixes a bug where sql.function_exists() would find public-schema functions in both the public schema and the import's schema because both were in the search_path, causing a DuplicateException "more than one function named ...". Note that the elements of the existing search_path are no longer needed now that vegbien_dest's $schemas includes $public. Also note that if an instance of DbConn does not specify the schemas param, the existing search_path will be left as-is rather than overwritten with an empty list.

README.TXT: Data import: recording the import times in inputs/import.stats.xls: Added step to determine the import date using import_date

import_date: Added note that Mac and Linux differ in the order they sort the logs in

README.TXT: Data import: recording the import times in inputs/import.stats.xls: Updated pattern for new log filename format

README.TXT: Data import: recording the import times in inputs/import.stats.xls: Removed extra ./ before bin/import_times

import_date: Added note that the time this outputs is the time the first special input finished importing. The import itself generally starts a few minutes before that, and the exact time is in that import's public schema comment.

import_date: Removed duplicate Usage message at top of file, which is repeated in the Usage message provided when the program is run with no arguments

Added import_date

Added mtime

lib/common.Makefile: System: Added $(mtime)

lib/common.Makefile: $(date): Factored date format out into $(dateFmt)

backups/Makefile: Factored $(isMac) out into lib/common.Makefile

README.TXT: Data import: tailing logs: Updated pattern for new log filename format

schemas/Makefile: Installation: %/publish: Fixed bug where need quotes around source schema name

README.TXT: Data import: Moved deletion previous imports before the import, so that full DB backup can be automated

README.TXT: Data import: `make backups/vegbien.$version.backup/test`: Added --exclude-schema=public to leave out the previous (now published) import so it doesn't bloat the backup. Note that public is included in the vegbien.$version.backup for the previous import, named according to its version.

import_all: after_import(): Added `make backups/TNRS.backup-remake`

README.TXT: Data import: Added step to publish the import to the public schema

import_all: after_import(): Added export_analytical_db

README.TXT: Data import: bin/export_analytical_db: Removed `env public=$version` because export_analytical_db now uses $version as $public when provided

README.TXT: Data import: To remake analytical DB: Removed `env public=...` because $version (which replaces $public) is now set automatically by import_all

schemas/Makefile: Installation: py_functions/install: Removed `env public=`, which is not needed since $(psqlAsAdminVegbien) does not use psql_script_vegbien (which uses $public)

export_analytical_db: Use vegbien_dest to set the default value for $public

README.TXT: Data import: If many inputs have errors: Updated command to `make schemas/$version/uninstall` because the current import's schema is now named $version

schemas/Makefile: Installation: $(schemas), $(schemasReversed) (used e.g. by `make schemas/reinstall`): Removed public so that when `make schemas/reinstall` is run before an import, it will not remove any active (published) import which resides in the public schema

README.TXT: Schema changes: Reinstall public separately from the other schemas so that it will still be reinstalled when schemas/reinstall excludes the public schema to avoid removing any active (published) import

vegbien_dest callers: Removed no longer needed explicit setting $prefix to "", because this is now the default value

vegbien_dest: Changed default $prefix to "", so that the majority of callers don't need to manually set $prefix to "" to avoid it defaulting to out_

README.TXT: Data import: Use env var $version, which is now set by import_all, instead of manually inserting the version for <version>

vegbien_dest: Also export $version

import_all: Run the import directly into a new, already-versioned public schema. This removes the need to manually rename the schema after import, and allows the backup commands to use the stored $version shell variable to refer to the last import.

schemas/Makefile: %/publish: Added instruction to run `unset version` after the command, to clear the $version shell variable which will be set by import_all

README.TXT: Data import: Replaced <import_name> with <version> because the import name is now just the version

README.TXT: Data import: Replaced r<revision> with <version> because the version string is now equal to r<revision>

README.TXT: Backups: Replaced <date> with <version> because the date is no longer included in the version string

README.TXT: Name archived imports without the "public." prefix so that their backups will work with the new `make backups/%.backup/remove` command, which does not add back the prefix

backups/Makefile; $(public*): Don't add a "public." prefix to get the name of the public schema

backups/Makefile: Removed no longer used $(rmSchema)

backups/Makefile: Use \$(rmSchemaCmd) from lib/common.Makefile instead of \$(rmSchema)

vegbien_dest: Use $version as $public when $public not provided. When neither is provided, continue to use "public" and also set $version to that.

schemas/Makefile: Installation: rotate: Use just the version, without the "public." prefix

schemas/Makefile: Installation: `public/install public%/install`: Generalized to /install to allow public schema versions with any name. This requires moving `/install: %.sql` before it to override it.

schemas/Makefile: Installation: Merged public/install and public%/install

schemas/Makefile: Installation: Moved %/uninstall to beginning of section because it applies to all schemas

schemas/Makefile: Installation: public: Generalized public%/publish to %/publish so that public schema versions don't have to start with public_

schemas/Makefile: Installation: %/uninstall: Also display schema delete confirmation for schemas whose name is just the version suffix (r<revision #>)

schemas/Makefile: Merged public%/uninstall and %/uninstall

lib/common.Makefile: Added version target, which prints the current $(version) value

schemas/Makefile: Installation: public: public%/uninstall: Fixed bug where need to remove the specified version of the public schema, not public itself. Generalized $(confirmRmPublicSchema) so it could also be used for named versions of the public schema. Inlined $(rmPublicSchema) since it's now only used in one place.

lib/common.Makefile: Revisions: $(version): Use just the revision # to avoid cluttering the schema and log file names with long datetime strings

schemas/Makefile: public%/install: schema comment: Include current date/time after version

lib/common.Makefile: Replaced no longer used $(date) with function to generate human-readable text date (rather than date to put in filename). Removed leading zeros from date and hour. Added timezone.

backups/Makefile: Removed no longer used $(dateFmt), $(mtime)

backups/Makefile: Removed %.backup/rotate, because this incorrectly causes the current time rather than the version to be used in the backup filename. The version should instead be specified in the backup filename when it's created.

schemas/Makefile: Installation: public: Added public%/publish to replace the current public schema with the given version

schemas/Makefile: Installation: public: public/uninstall: Added public%/uninstall as a target to allow uninstalling versions of the public schema

schemas/Makefile: Installation: public: public%/install: Add a comment on the schema containing the versioned schema name, so that if the schema is later renamed to just public (i.e. "published" as the current version), it will still be possible to tell which version the public schema came from

schemas/Makefile: Installation: public: Added public%/install, to install a version of the public schema

schemas/Makefile: Removed unused $(os)

schemas/Makefile: Removed unused $(SED)

Moved schemas-related commands from root Makefile to schemas/Makefile

Makefiles: Factored out common vars/functions into lib/common.Makefile

root Makefile: $(psqlNoSearchPath): Merged $(psqlAsBien) into it because it's the only place $(psqlAsBien) is used

root Makefile: $(psqlAsBien): Use psql_script_vegbien instead of psql_vegbien, which adds $(psqlOpts) itself

schemas/Makefile: Include lib/common.Makefile

inputs/import.stats.xls: Reformatted so the first by column import and the comparison by row import will fit on the same page when printed on portrait-mode letter paper

inputs/import.stats.xls: Changed import type labels to By row/By column so they would fit into one field, leaving the extra field free to contain the revision #

lib/common.Makefile: Revisions: Allow $(version) to be overridden in the environment, so that the public schema and all log files share the same, pregenerated version

schemas/vegbien.sql: Merged provider_view, provider_count, and owner_count into provider_count, using the combining query for Brad's data providers page at <http://bien.nceas.ucsb.edu/bien/people/data-providers/>

schemas/vegbien.sql: sync_taxon_trait_to_view(): Changed pkey to index because there can be multiple values of the same taxon's trait from different observations

mappings/Makefile: VegCore.csv: Filter out the VegCore tables so they are not matched as terms. This is necessary because some terms have the same name as a table, but the term should be the match rather than the table.

sql.py: DbConn.col_info(): raising sql_gen.NoUnderlyingTableException: Fixed bug where also need to catch DoesNotExistException, which is thrown by ::regclass

sql.py: DbConn.col_info(): Fixed bug where need to run run_query() recoverably, because this query throws an exception if the column's table does not exist (the information_schema query just returned no rows)

sql.py: DbConn.col_info(): Fixed bug where need to use pg_get_expr() on pg_attrdef.adbin instead of shortcut field adsrc, because adsrc does not include schema qualifiers on table names (including strings passed to `nextval('..._seq'::regclass)`)

sql.py: DbConn.col_info(): Fixed bug where need to pass through cacheable param to run_query()

sql.py: DbConn.col_info(): Fixed bug where need to use .to_str(self) instead of self.esc_value() because self.esc_value() expects a value, not a sql_gen.Literal instance

sql.py: DbConn.col_info(): Fixed bug where self needs to be used everywhere that db normally is, because this is a DbConn method rather than a global function

sql.py: DbConn.col_info(): For PostgreSQL, use pg_catalog tables directly instead of their views in information_schema. This allows using ::regclass to look up the table in the search_path, and fixes a bug in imports with an explicit public schema where column types were looked up in public instead of public.<version>. Also don't wrap default using sql_gen.as_Code() when it's None (indicating no default value, aka default=NULL), because this value is interpreted specially by sql_gen.TypedCol.

inputs/Makefile: Input data: $(rsyncSrcs): Also include log files other than install.log.sql

import_all: Run all imports (not just the main datasources' import) with $import_source turned off, so that the Source tables will not be imported a second time when the datasource's main tables are imported. Note that it's not necessary to wait for asynchronous commands after the jobs for the main import are started (so that $import_source is not unset until after they are started), because with_all does not return until all jobs are started and have noted the $import_source setting in effect in the shell environment.

import_all: Source tables import: Fixed bug where need to use $all option to with_all to also include special datasources starting with "."

make_analytical_db: Also create taxon_trait materialized view

inputs/*/*/map.csv: Reverted special OMIT mappings for input columns that have the same name as a VegCore table and have not yet been mapped to a VegCore term

mappings/Makefile: VegCore.csv: Filter out the VegCore tables so they are not matched as terms. This is necessary because some terms have the same name as a table, but the term should be the match rather than the table.

mappings/VegCore.csv: Changed line endings to \r\n to match the output of filter_out_ci

inputs/CTFS/TaxonOccurrence/map.csv: Mapped SpeciesAuthority

backups/Makefile: Synchronization: $(remote): Fixed bug where need trailing / at end of path

backups/Makefile: Synchronization: $(remote): Updated path to backups

README.TXT: Data import: On jupiter: Updated path to backups

README.TXT: Installation: Added command to change to the directory of the checked out files

README.TXT: Installation: Added command to check out files from svn

schemas/vegbien.sql: Added taxon_trait materialized view

mappings/Veg+-VegCore.csv: Sources: Removed redundant bien2_ prefix from bien2_staging subnamespace

schemas/vegbien.sql: trait: trait_unique: Removed value and units because there should only be one value of a trait for each taxonoccurrence

schemas/vegbien.sql: Reattached trait to taxonoccurrence instead of taxonlabel, because the TraitObservation traits data is actually associated with a particular occurrence (plant observation complete with location, date, etc.), rather than just a taxon

Added inputs/bien2_traits/

mappings/VegCore-VegBIEN.csv: Mapped traits-related DwC terms measurementType, measurementValue, measurementUnit

schemas/vegbien.ERD.mwb: Added trait table to ERD

schemas/vegbien.sql: trait: Added trait_unique unique index

schemas/vegbien.sql: trait: Added units field