GitLab

Start using the new db_conn.pl script instead of building driver-specific commands and running them.

Execute individual SQL commands as well as sessions; translate some db-meta SQLite into Bash; control verbosity

Schema change: changed the data type of monitor.analysis to TEXT as per Michael Paulini's suggestion, to fit more and longer analysis names.

Allow multiple driver-dependent versions of the same patch; suggest schema patching with db_conn.pl commands.

A unified dispatching client for databases. Finds the correct database client via -url or -reg_conf/-reg_alias combination.

Give a more meaningful warning if EHIVE_ROOT_DIR is not set (probably because an external script is trying to run Hive API)

included a new -nosqlvc flag in beekeeper.pl and runWorker.pl to overcome the version restriction in non-critical cases

bugfix: propagate no_sql_schema_version_check parameter through the URLFactory/DBAdaptor loop (should be re-factored at some point)

changed the interface of balance_semaphores() : pass in $filter_analysis_id instead of $filter_analysis

tell the user whether to update the code to match the database SQL schema version, or which SQL patches to apply to the database

use SqlSchemaAdaptor to detect the current code's sql version and record it in 'hive_meta' (leave it out of tables.*sql* files)

A new "adaptor" for detection of software's sql version based on the number of available sql patches.

move Core 'schema_version' out of tables.* files into HiveGeneric_conf (via ApiVersion), expose it for manipulation and make it available to PipeConfigs

new 'hive_meta' table to keep hive_sql_schema_version (=number of patches), hive_pipeline_name and hive_use_triggers