[Bio] / FigKernelPackages / DBKernel.pm Repository:
ViewVC logotype

Log of /FigKernelPackages/DBKernel.pm

Parent Directory Parent Directory


Links to HEAD: (view) (download) (as text) (annotate)
Links to rast_rel_2010_1206: (view) (download) (as text) (annotate)
Sticky Tag:

Revision 1.63 - (view) (download) (as text) (annotate) - [select for diffs]
Fri Dec 11 21:21:04 2009 UTC (9 years, 11 months ago) by parrello
Branch: MAIN
CVS Tags: rast_rel_2010_0118, rast_rel_2010_0526, rast_rel_2010_0827, rast_rel_2010_0928, rast_rel_2010_1206
Changes since 1.62: +74 -2 lines
Diff to previous 1.62
Server database recovery fix.

Revision 1.62 - (view) (download) (as text) (annotate) - [select for diffs]
Wed Dec 9 21:07:09 2009 UTC (9 years, 11 months ago) by parrello
Branch: MAIN
Changes since 1.61: +3 -1 lines
Diff to previous 1.61
Turned on mysql auto reconnect.

Revision 1.61 - (view) (download) (as text) (annotate) - [select for diffs]
Wed Dec 2 00:38:48 2009 UTC (9 years, 11 months ago) by parrello
Branch: MAIN
Changes since 1.60: +62 -40 lines
Diff to previous 1.60
Created a separate method for reconnecting.

Revision 1.60 - (view) (download) (as text) (annotate) - [select for diffs]
Fri Jul 3 15:47:22 2009 UTC (10 years, 4 months ago) by parrello
Branch: MAIN
CVS Tags: rast_rel_2009_07_09, rast_rel_2009_0925
Changes since 1.59: +1 -1 lines
Diff to previous 1.59
Removed connect_cached.

Revision 1.59 - (view) (download) (as text) (annotate) - [select for diffs]
Thu Jun 4 18:26:48 2009 UTC (10 years, 5 months ago) by parrello
Branch: MAIN
Changes since 1.58: +22 -0 lines
Diff to previous 1.58
Added support for turning off the MySQL query cache during testing.

Revision 1.58 - (view) (download) (as text) (annotate) - [select for diffs]
Thu May 28 17:50:56 2009 UTC (10 years, 5 months ago) by parrello
Branch: MAIN
Changes since 1.57: +2 -7 lines
Diff to previous 1.57
Added connect-cached support.

Revision 1.57 - (view) (download) (as text) (annotate) - [select for diffs]
Mon May 18 16:59:26 2009 UTC (10 years, 6 months ago) by olson
Branch: MAIN
CVS Tags: rast_rel_2009_05_18
Changes since 1.56: +2 -2 lines
Diff to previous 1.56
prepare_command(): Pass attribute variable through to $dbh->prepare()

Revision 1.56 - (view) (download) (as text) (annotate) - [select for diffs]
Thu Apr 2 01:03:43 2009 UTC (10 years, 7 months ago) by parrello
Branch: MAIN
Changes since 1.55: +105 -26 lines
Diff to previous 1.55
Added support for retrying after a lost connection.

Revision 1.55 - (view) (download) (as text) (annotate) - [select for diffs]
Tue Mar 10 03:35:10 2009 UTC (10 years, 8 months ago) by parrello
Branch: MAIN
CVS Tags: rast_rel_2009_03_26
Changes since 1.54: +18 -0 lines
Diff to previous 1.54
Added last-insert-id support.

Revision 1.54 - (view) (download) (as text) (annotate) - [select for diffs]
Sun Feb 22 03:43:00 2009 UTC (10 years, 8 months ago) by parrello
Branch: MAIN
Changes since 1.53: +1 -1 lines
Diff to previous 1.53
Fixed an overly aggressive trace message.

Revision 1.53 - (view) (download) (as text) (annotate) - [select for diffs]
Thu Feb 5 06:37:16 2009 UTC (10 years, 9 months ago) by parrello
Branch: MAIN
Changes since 1.52: +38 -1 lines
Diff to previous 1.52
Added a method to turn on demand-driven query processing.
Added logic to use the correct syntax when loading into a database that is on a remote server.

Revision 1.52 - (view) (download) (as text) (annotate) - [select for diffs]
Fri Apr 18 15:20:06 2008 UTC (11 years, 7 months ago) by gdpusch
Branch: MAIN
CVS Tags: mgrast_rel_2008_0625, mgrast_rel_2008_0806, mgrast_rel_2008_0917, mgrast_rel_2008_0919, mgrast_rel_2008_0923, mgrast_rel_2008_0924, mgrast_rel_2008_1110, mgrast_rel_2008_1110_v2, rast_2008_0924, rast_rel_2008_04_23, rast_rel_2008_06_16, rast_rel_2008_06_18, rast_rel_2008_07_21, rast_rel_2008_08_07, rast_rel_2008_09_29, rast_rel_2008_09_30, rast_rel_2008_10_09, rast_rel_2008_10_29, rast_rel_2008_11_24, rast_rel_2008_12_18, rast_rel_2009_02_05, rast_release_2008_09_29
Changes since 1.51: +8 -7 lines
Diff to previous 1.51
Included the name of the failed load-file in the &reload_tables() load failure msg, and added $dbname, $dbuser, $dbport to various DB-action Trace() lines. -- /gdp

Revision 1.51 - (view) (download) (as text) (annotate) - [select for diffs]
Tue Feb 5 00:49:33 2008 UTC (11 years, 9 months ago) by parrello
Branch: MAIN
Changes since 1.50: +1 -0 lines
Diff to previous 1.50
Added a trace message.

Revision 1.50 - (view) (download) (as text) (annotate) - [select for diffs]
Wed Jan 23 00:57:23 2008 UTC (11 years, 9 months ago) by parrello
Branch: MAIN
Changes since 1.49: +21 -5 lines
Diff to previous 1.49
Added support for concurrent and low-priority loading.

Revision 1.49 - (view) (download) (as text) (annotate) - [select for diffs]
Thu Dec 6 13:39:32 2007 UTC (11 years, 11 months ago) by parrello
Branch: MAIN
Changes since 1.48: +29 -29 lines
Diff to previous 1.48
Changed POD format for better compatability with Wiki.

Revision 1.48 - (view) (download) (as text) (annotate) - [select for diffs]
Thu Nov 1 16:33:29 2007 UTC (12 years ago) by olson
Branch: MAIN
Changes since 1.47: +5 -1 lines
Diff to previous 1.47
some fixes for RAST genome installation.

Revision 1.47 - (view) (download) (as text) (annotate) - [select for diffs]
Tue Jun 12 20:23:25 2007 UTC (12 years, 5 months ago) by olson
Branch: MAIN
Changes since 1.46: +29 -1 lines
Diff to previous 1.46
fix for get_tables() for latest DBD::mysql

Revision 1.46 - (view) (download) (as text) (annotate) - [select for diffs]
Sun Feb 18 21:18:34 2007 UTC (12 years, 9 months ago) by parrello
Branch: MAIN
Changes since 1.45: +16 -0 lines
Diff to previous 1.45
Added a method for transaction rollback.

Revision 1.45 - (view) (download) (as text) (annotate) - [select for diffs]
Sun Nov 5 03:52:26 2006 UTC (13 years ago) by parrello
Branch: MAIN
Changes since 1.44: +2 -4 lines
Diff to previous 1.44
Fixed a comment.

Revision 1.44 - (view) (download) (as text) (annotate) - [select for diffs]
Sat Oct 14 17:28:48 2006 UTC (13 years, 1 month ago) by parrello
Branch: MAIN
Changes since 1.43: +6 -7 lines
Diff to previous 1.43
Modified to allow for creation of full-text indices.

Revision 1.43 - (view) (download) (as text) (annotate) - [select for diffs]
Wed Jun 28 22:23:03 2006 UTC (13 years, 4 months ago) by parrello
Branch: MAIN
Changes since 1.42: +20 -0 lines
Diff to previous 1.42
Added a command to flush the tables in MySQL.

Revision 1.42 - (view) (download) (as text) (annotate) - [select for diffs]
Wed Jun 21 19:52:00 2006 UTC (13 years, 4 months ago) by parrello
Branch: MAIN
Changes since 1.41: +1 -1 lines
Diff to previous 1.41
Changed load method to eschew LOCAL.

Revision 1.41 - (view) (download) (as text) (annotate) - [select for diffs]
Thu May 18 01:04:04 2006 UTC (13 years, 6 months ago) by parrello
Branch: MAIN
Changes since 1.40: +1 -1 lines
Diff to previous 1.40
Fixed a bad comment.

Revision 1.40 - (view) (download) (as text) (annotate) - [select for diffs]
Sat May 13 15:24:33 2006 UTC (13 years, 6 months ago) by parrello
Branch: MAIN
Changes since 1.39: +2 -2 lines
Diff to previous 1.39
*** empty log message ***

Revision 1.39 - (view) (download) (as text) (annotate) - [select for diffs]
Sat May 13 15:23:57 2006 UTC (13 years, 6 months ago) by parrello
Branch: MAIN
Changes since 1.38: +2 -2 lines
Diff to previous 1.38
Fixed to print a better error message when a query fails and RaiseError is 0.

Revision 1.38 - (view) (download) (as text) (annotate) - [select for diffs]
Sat May 13 15:20:04 2006 UTC (13 years, 6 months ago) by parrello
Branch: MAIN
Changes since 1.37: +6 -2 lines
Diff to previous 1.37
Fixed to print a better error message when a query fails and no message is available.

Revision 1.37 - (view) (download) (as text) (annotate) - [select for diffs]
Sat May 13 03:37:46 2006 UTC (13 years, 6 months ago) by parrello
Branch: MAIN
Changes since 1.36: +2 -2 lines
Diff to previous 1.36
Fixed so that the socket and port values are converted to default if the incoming value is either undefined or null.

Revision 1.36 - (view) (download) (as text) (annotate) - [select for diffs]
Sat May 13 03:02:23 2006 UTC (13 years, 6 months ago) by parrello
Branch: MAIN
Changes since 1.35: +5 -5 lines
Diff to previous 1.35
Updated some comments.

Revision 1.35 - (view) (download) (as text) (annotate) - [select for diffs]
Wed Mar 29 20:41:33 2006 UTC (13 years, 7 months ago) by overbeek
Branch: MAIN
Changes since 1.34: +32 -1 lines
Diff to previous 1.34
Add support for readonly database instance, and for FileLocking module.

Revision 1.34 - (view) (download) (as text) (annotate) - [select for diffs]
Wed Feb 15 22:12:26 2006 UTC (13 years, 9 months ago) by overbeek
Branch: MAIN
Changes since 1.33: +12 -0 lines
Diff to previous 1.33
minor fixes to assignment for close strains

Revision 1.33 - (view) (download) (as text) (annotate) - [select for diffs]
Tue Feb 7 15:58:55 2006 UTC (13 years, 9 months ago) by parrello
Branch: MAIN
CVS Tags: caBIG-05Apr06-00, caBIG-13Feb06-00
Changes since 1.32: +4 -0 lines
Diff to previous 1.32
Fixed to remove DESC modifiers from CREATE INDEX statements if the dbms is Postgres.

Revision 1.32 - (view) (download) (as text) (annotate) - [select for diffs]
Tue Feb 7 15:26:41 2006 UTC (13 years, 9 months ago) by parrello
Branch: MAIN
Changes since 1.31: +1 -1 lines
Diff to previous 1.31
*** empty log message ***

Revision 1.31 - (view) (download) (as text) (annotate) - [select for diffs]
Tue Feb 7 15:21:56 2006 UTC (13 years, 9 months ago) by parrello
Branch: MAIN
Changes since 1.30: +4 -1 lines
Diff to previous 1.30
Added tracing for table creation.

Revision 1.30 - (view) (download) (as text) (annotate) - [select for diffs]
Thu Feb 2 21:46:29 2006 UTC (13 years, 9 months ago) by olson
Branch: MAIN
Changes since 1.29: +22 -1 lines
Diff to previous 1.29
Check, before doing a reload of a portion of a table, to be sure that the table exists.

Revision 1.29 - (view) (download) (as text) (annotate) - [select for diffs]
Tue Jan 31 07:34:26 2006 UTC (13 years, 9 months ago) by parrello
Branch: MAIN
Changes since 1.28: +38 -0 lines
Diff to previous 1.28
Added a static method for creating databases.

Revision 1.28 - (view) (download) (as text) (annotate) - [select for diffs]
Mon Jan 30 04:09:35 2006 UTC (13 years, 9 months ago) by parrello
Branch: MAIN
Changes since 1.27: +1 -1 lines
Diff to previous 1.27
*** empty log message ***

Revision 1.27 - (view) (download) (as text) (annotate) - [select for diffs]
Mon Jan 30 04:03:56 2006 UTC (13 years, 9 months ago) by parrello
Branch: MAIN
Changes since 1.26: +46 -0 lines
Diff to previous 1.26
Added a method for fomatting DELETE-USING statements, which have a different syntax in MySQL than they have in PostGres.

Revision 1.26 - (view) (download) (as text) (annotate) - [select for diffs]
Sat Jan 28 08:51:59 2006 UTC (13 years, 9 months ago) by parrello
Branch: MAIN
Changes since 1.25: +1 -1 lines
Diff to previous 1.25
Fixed an error in the documentation.

Revision 1.25 - (view) (download) (as text) (annotate) - [select for diffs]
Wed Jan 25 20:05:14 2006 UTC (13 years, 9 months ago) by olson
Branch: MAIN
Changes since 1.24: +11 -3 lines
Diff to previous 1.24
Support mysql3.

Revision 1.24 - (view) (download) (as text) (annotate) - [select for diffs]
Fri Jan 13 19:45:02 2006 UTC (13 years, 10 months ago) by parrello
Branch: MAIN
Changes since 1.23: +70 -64 lines
Diff to previous 1.23
Fixed reload_table to work with empty or nonexistent load files.
Fixed load_table trace message to not show -1 as a row count.

Revision 1.23 - (view) (download) (as text) (annotate) - [select for diffs]
Fri Jan 6 20:20:40 2006 UTC (13 years, 10 months ago) by olson
Branch: MAIN
Changes since 1.22: +21 -6 lines
Diff to previous 1.22
Add support for using system  mysql installation.

Revision 1.22 - (view) (download) (as text) (annotate) - [select for diffs]
Tue Jan 3 20:52:38 2006 UTC (13 years, 10 months ago) by olson
Branch: MAIN
Changes since 1.21: +63 -1 lines
Diff to previous 1.21
SQLite support.

#CVS: ----------------------------------------------------------------------

Revision 1.21 - (view) (download) (as text) (annotate) - [select for diffs]
Wed Dec 21 22:17:19 2005 UTC (13 years, 10 months ago) by parrello
Branch: MAIN
Changes since 1.20: +3 -1 lines
Diff to previous 1.20
Updated the documentation to indicate that field delimiters in "load_table" must be a single character in order to work with PostGRES.

Revision 1.20 - (view) (download) (as text) (annotate) - [select for diffs]
Wed Dec 21 22:04:56 2005 UTC (13 years, 10 months ago) by parrello
Branch: MAIN
Changes since 1.19: +2 -2 lines
Diff to previous 1.19
Added nonstandard-delimiter support for MySQL in "load_table".

Revision 1.19 - (view) (download) (as text) (annotate) - [select for diffs]
Mon Dec 12 21:55:56 2005 UTC (13 years, 11 months ago) by parrello
Branch: MAIN
Changes since 1.18: +2 -2 lines
Diff to previous 1.18
Changed to use the traced Confess in the "SQL" method.

Revision 1.18 - (view) (download) (as text) (annotate) - [select for diffs]
Mon Dec 5 19:06:30 2005 UTC (13 years, 11 months ago) by olson
Branch: MAIN
Changes since 1.17: +17 -0 lines
Diff to previous 1.17
Added license words.

Revision 1.17 - (view) (download) (as text) (annotate) - [select for diffs]
Mon Oct 31 23:07:48 2005 UTC (14 years ago) by overbeek
Branch: MAIN
CVS Tags: caBIG-00-00-00
Changes since 1.16: +54 -1 lines
Diff to previous 1.16
RAE: adding a drop_index method

Revision 1.16 - (view) (download) (as text) (annotate) - [select for diffs]
Wed Oct 12 02:23:42 2005 UTC (14 years, 1 month ago) by parrello
Branch: MAIN
Changes since 1.15: +49 -24 lines
Diff to previous 1.15
Fixed so that the collation order for MySQL is latin binary.
Added the ability to retrieve the error message from the last DB call.
Modified to drop any existing index before creating it.
Modified to terminate abnormally if an index creation failure occurs.

Revision 1.15 - (view) (download) (as text) (annotate) - [select for diffs]
Wed Oct 5 20:34:02 2005 UTC (14 years, 1 month ago) by overbeek
Branch: MAIN
CVS Tags: caBIG-dataload-0
Changes since 1.14: +10 -1 lines
Diff to previous 1.14
fixes to update_uniq_id_data

Revision 1.14 - (view) (download) (as text) (annotate) - [select for diffs]
Thu Sep 15 18:47:58 2005 UTC (14 years, 2 months ago) by olson
Branch: MAIN
Changes since 1.13: +1 -1 lines
Diff to previous 1.13
Careful cleanup of subsystem indexing. Patched a bunch of spots where needed updates didn't happen.

Add variant code to subsystem index.

Revision 1.13 - (view) (download) (as text) (annotate) - [select for diffs]
Thu Sep 1 09:31:54 2005 UTC (14 years, 2 months ago) by parrello
Branch: MAIN
Changes since 1.12: +5 -3 lines
Diff to previous 1.12
Fixed a grammatical error in an error message. Fixed the Load to work properly with the two-byte line terminators used by Windows.

Revision 1.12 - (view) (download) (as text) (annotate) - [select for diffs]
Mon Aug 29 21:26:06 2005 UTC (14 years, 2 months ago) by olson
Branch: MAIN
Changes since 1.11: +1 -1 lines
Diff to previous 1.11
Turna Confess into a confess so we get backtraces.

Revision 1.11 - (view) (download) (as text) (annotate) - [select for diffs]
Wed Aug 17 19:32:24 2005 UTC (14 years, 3 months ago) by olson
Branch: MAIN
Changes since 1.10: +64 -3 lines
Diff to previous 1.10
Add table size estimation code for supporting MyISAM.

Revision 1.10 - (view) (download) (as text) (annotate) - [select for diffs]
Mon Aug 1 22:26:11 2005 UTC (14 years, 3 months ago) by parrello
Branch: MAIN
Changes since 1.9: +18 -2 lines
Diff to previous 1.9
Added the capability to use MyISAM in MySQL. To make this work, the "create_table" call must contain an estimates parameter that indicates the estimated number of rows and the estimated row size. The estimate must be accurate to within a power of 256. Currently, this estimation process is done for Sprout, but not for FIG. MyISAM can provide a factor-of-6 improvement in load performance, but is not as stable as InnoDB.

Revision 1.9 - (view) (download) (as text) (annotate) - [select for diffs]
Tue Jul 26 20:01:48 2005 UTC (14 years, 3 months ago) by parrello
Branch: MAIN
Changes since 1.8: +3 -3 lines
Diff to previous 1.8
Modified to do table analysis at the end of a load rather than after indexes are created.

Revision 1.8 - (view) (download) (as text) (annotate) - [select for diffs]
Fri Jun 24 21:40:16 2005 UTC (14 years, 4 months ago) by parrello
Branch: MAIN
CVS Tags: merge-trunktag-bobdev_news-1, merge-trunktag-bobdev_news-2, merge-trunktag-bodev_news-3
Changes since 1.7: +42 -4 lines
Diff to previous 1.7
Moved vacuum method from DBrtns to DBKernel. Changed so that it also does an analysis in MySQL.

Revision 1.7 - (view) (download) (as text) (annotate) - [select for diffs]
Thu Jun 23 23:19:52 2005 UTC (14 years, 4 months ago) by parrello
Branch: MAIN
Changes since 1.6: +12 -5 lines
Diff to previous 1.6
Improved the documentation for the reload_table method.
Changed pre-indexing to a configurable parameter instead of a condition based on the DBMS type.

Revision 1.6 - (view) (download) (as text) (annotate) - [select for diffs]
Thu Jun 23 21:47:59 2005 UTC (14 years, 4 months ago) by parrello
Branch: MAIN
Changes since 1.5: +5 -5 lines
Diff to previous 1.5
Fixed error in post-load indexing.

Revision 1.5 - (view) (download) (as text) (annotate) - [select for diffs]
Wed Jun 22 20:54:03 2005 UTC (14 years, 4 months ago) by parrello
Branch: MAIN
Changes since 1.4: +288 -80 lines
Diff to previous 1.4
Replaced tabs with spaces to make indenting device-independent.

Revision 1.4 - (view) (download) (as text) (annotate) - [select for diffs]
Wed Jun 15 16:28:04 2005 UTC (14 years, 5 months ago) by olson
Branch: MAIN
CVS Tags: Root-bobdev_news
Branch point for: Branch-bobdev_news
Changes since 1.3: +5 -1 lines
Diff to previous 1.3
Feh. host specifier for DBI is different in mysql and postgres.

Revision 1.3 - (view) (download) (as text) (annotate) - [select for diffs]
Wed Jun 15 16:24:37 2005 UTC (14 years, 5 months ago) by olson
Branch: MAIN
Changes since 1.2: +18 -4 lines
Diff to previous 1.2
Add support for specification of a database host.

Revision 1.2 - (view) (download) (as text) (annotate) - [select for diffs]
Thu Jun 9 18:34:16 2005 UTC (14 years, 5 months ago) by parrello
Branch: MAIN
Changes since 1.1: +24 -15 lines
Diff to previous 1.1
*** empty log message ***

Revision 1.1 - (view) (download) (as text) (annotate) - [select for diffs]
Thu Jun 9 05:36:30 2005 UTC (14 years, 5 months ago) by parrello
Branch: MAIN
*** empty log message ***

This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, select a symbolic revision name using the selection box, or choose 'Use Text Field' and enter a numeric revision.

  Diffs between and
  Type of Diff should be a

Sort log by:

MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3