Revision 94 - (view) (annotate) - [selected]
Modified Mon May 29 15:22:13 2006 UTC (18 years, 4 months ago) by duarte
File length: 21088 byte(s)
Diff to previous 93

Simplified the code for dealing with text/numerical keys.
Now there's no more double methods Integer/String, rather the methos use a generic Object[] that stores either String[] or Integer[] depending on the case.
Thus modified a few methods in DataDistributer, DataDistribution and MySQLConnection.

Revision 93 - (view) (annotate) - [select for diffs]
Modified Wed May 24 15:44:25 2006 UTC (18 years, 4 months ago) by duarte
File length: 20127 byte(s)
Diff to previous 84 , to selected 94

Now split of data also working with text-based keys as well as numerical
MySQLConnection:
- method getAllIds4KeyAndTable now splitted into two methods one for numerical ids and another for text ids
- new methods getColumnType and isKeyNumerical
DataDistribution:
- method getIdSetsFromNodes splitted into two one for numerical ids one for text ids
DataDistributer:
- new methods: splitIdsIntoSets now splitted into two methods one numerical, one text
- change methods: splitTableToCluster, splitTable, insertIdsToKeyMaster, removePK, addPK, createNewKeyMasterTbl, removeZeros, loadSplitData, dumpSplitData to make them work for both text and numeric keys. Introduced generic type T in some of them
- some bugs corrected:
-- an important one in createNewKeyMasterTbl, was introducing record in dbs_keys with srcDb instead of destDb as it should have been
-- some bugs in loadSplitData and dumpSplitData to account for cases in which there are less ids than number of nodes and thus some nodes don't get any data. Wasn't counting with this before.

Revision 84 - (view) (annotate) - [select for diffs]
Modified Thu Apr 20 10:42:38 2006 UTC (18 years, 5 months ago) by duarte
File length: 18106 byte(s)
Diff to previous 83 , to selected 94

Fixed bug in getTables4Db. Was closing the connection. Shouldn't do this!
Add method getAllIds4KeyAndTables, moved from DataDistribution. It makes more sense to have it here.

Revision 83 - (view) (annotate) - [select for diffs]
Modified Wed Apr 19 14:02:35 2006 UTC (18 years, 5 months ago) by duarte
File length: 17351 byte(s)
Diff to previous 80 , to selected 94

Got rid of getTables4Db in DataDistribution
Add method getTables4Db to MySQLConnection. Makes a lot more sense.
Changed accordingly the only call to the method in DataDistribution's method chkCounts

Revision 80 - (view) (annotate) - [select for diffs]
Modified Wed Apr 12 14:59:37 2006 UTC (18 years, 5 months ago) by duarte
File length: 16310 byte(s)
Diff to previous 64 , to selected 94

Introduced better javadoc comments in constructors.

Revision 64 - (view) (annotate) - [select for diffs]
Modified Thu Apr 6 14:47:09 2006 UTC (18 years, 5 months ago) by duarte
File length: 16015 byte(s)
Diff to previous 63 , to selected 94

Added method getCreateIndex4Table

Revision 63 - (view) (annotate) - [select for diffs]
Modified Thu Apr 6 12:18:18 2006 UTC (18 years, 5 months ago) by duarte
File length: 14400 byte(s)
Diff to previous 62 , to selected 94

Fixed bug in getAllIndexes4Table, the SELECT needed a DISTINCT

Revision 62 - (view) (annotate) - [select for diffs]
Modified Thu Apr 6 12:15:37 2006 UTC (18 years, 5 months ago) by duarte
File length: 14391 byte(s)
Diff to previous 61 , to selected 94

Got rid of method dbExists. Was useless and not working.

Revision 61 - (view) (annotate) - [select for diffs]
Modified Thu Apr 6 10:07:22 2006 UTC (18 years, 5 months ago) by duarte
File length: 15633 byte(s)
Diff to previous 60 , to selected 94

Added method setSqlMode, to set sql_mode server variable

Revision 60 - (view) (annotate) - [select for diffs]
Modified Thu Apr 6 09:24:28 2006 UTC (18 years, 5 months ago) by duarte
File length: 15009 byte(s)
Diff to previous 59 , to selected 94

Added method dbExists to check whether database exists in server, used in constructor that passes a dbName
Moved all the private methods to the beginning of methods section

Revision 59 - (view) (annotate) - [select for diffs]
Modified Thu Apr 6 08:24:15 2006 UTC (18 years, 5 months ago) by duarte
File length: 13690 byte(s)
Diff to previous 58 , to selected 94

Changed comments in constructors
Changed in method readConnectionFile:
- variable to count mandatory parameters to paramCount
- number of mandatory parameters now 4, dbname is also mandatory

Revision 58 - (view) (annotate) - [select for diffs]
Modified Wed Apr 5 08:45:23 2006 UTC (18 years, 5 months ago) by duarte
File length: 13503 byte(s)
Diff to previous 57 , to selected 94

Now executeSQL method throws exception instead of catching it. Thought it was better than the calling class deals with these exceptions.

Revision 57 - (view) (annotate) - [select for diffs]
Modified Wed Apr 5 07:38:32 2006 UTC (18 years, 5 months ago) by duarte
File length: 12564 byte(s)
Diff to previous 55 , to selected 94

Added getConnectionObject
Added printDbSizeInfo and 2 getRange methods from utils4DB
Made private the loadMySQLDriver and readConnectionFile methods

Revision 55 - (view) (annotate) - [select for diffs]
Added Tue Apr 4 15:27:49 2006 UTC (18 years, 5 months ago) by duarte
File length: 8697 byte(s)
Diff to selected 94

Initial commit.
Class to create a connection to mysql db with basic functionality.
Cann take parameters for connection as argument in constructor or from connection file (passing the filename to the constructor)
Using code from both DBConnection (henning) and mySQLConnect (ioannis)