/[eiffelstudio]/branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql
ViewVC logotype

Log of /branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql

View Directory Listing Directory Listing


Sticky Revision:
(Current path doesn't exist after revision 88968)

Revision 88965 - Directory Listing
Modified Fri Jun 22 10:01:37 2012 UTC (7 years, 3 months ago) by romanschmocker
Refactored the METADATA classes

Revision 88957 - Directory Listing
Modified Thu Jun 21 19:21:39 2012 UTC (7 years, 3 months ago) by romanschmocker
added a test to reproduce the sqlite error

Revision 88956 - Directory Listing
Modified Thu Jun 21 19:05:36 2012 UTC (7 years, 3 months ago) by romanschmocker
Prettified and refactored the database wrappers

Revision 88954 - Directory Listing
Modified Thu Jun 21 11:03:35 2012 UTC (7 years, 3 months ago) by romanschmocker
SQLite backend is working now, although with disabled connection and transaction handling.

Revision 88950 - Directory Listing
Modified Wed Jun 20 14:00:17 2012 UTC (7 years, 4 months ago) by romanschmocker
Added SQLite backend and a corresponding test class. The new backend compiles but fails the tests, because the SQL syntax of SQLite is quite different from MySQL. Luckily, the SQL strings are all collected in a single class by now, so I probably just have to rewrite that.

Revision 88949 - Directory Listing
Modified Wed Jun 20 11:43:07 2012 UTC (7 years, 4 months ago) by romanschmocker
The SQL backend now uses the SQL strings class as an object, instead of inheriting from it. This allows more easily to swap some strings for incompatible databases while still keeping the backend unchanged. Also added some comments to the database wrapper classes, as a preparation to introduce the SQLite backend

Revision 88948 - Directory Listing
Modified Wed Jun 20 09:14:46 2012 UTC (7 years, 4 months ago) by romanschmocker
Moved all SQL strings into their own class. Refactored the SQL Key manager a little. Initial implementation for transaction isolation levels. Also added conversion routines from PS_PAIR to TUPLE (to get rid of PS_PAIR at some time)

Revision 88930 - Directory Listing
Modified Tue Jun 19 11:24:23 2012 UTC (7 years, 4 months ago) by romanschmocker
Reimplemented collection support in the retrieval manager: All CRUD tests pass now

Revision 88917 - Directory Listing
Modified Mon Jun 18 06:53:12 2012 UTC (7 years, 4 months ago) by romanschmocker
added rescue clauses for all features that deal with important data structures. The transaction tests now pass, just the cleanup part is not yet implemented

Revision 88876 - Directory Listing
Modified Thu Jun 14 22:52:10 2012 UTC (7 years, 4 months ago) by romanschmocker
Major overhaul of the GENERIC_LAYOUT_SQL_KEY_MANAGER. It now only uses the management connection. This simplifies transaction management a lot, but it has the drawback that metadata changes are invisible for other active transactions. The solution to the problem is that metadata tables should not be queried via SQL, but instead by asking the manager directly

Revision 88875 - Directory Listing
Modified Thu Jun 14 15:43:28 2012 UTC (7 years, 4 months ago) by romanschmocker
Solved the query commit problem: a query with implicit transaction handling is now auto-commited after every single retrieve operation. This can bring some inconsistencies during retrieval, but that's usually acceptable (otherwise you can still use explicit transactions). There's also a first milestone: All anomalies (lost update etc...) are detected correctly, resulting in a lock timeout by the mysql server and therefore an exception in ABEL.

Revision 88873 - Directory Listing
Modified Thu Jun 14 14:07:06 2012 UTC (7 years, 4 months ago) by romanschmocker
First version that does have some explicit transaction handling

Revision 88872 - Directory Listing
Modified Thu Jun 14 10:57:13 2012 UTC (7 years, 4 months ago) by romanschmocker
More changes to support transaction and error handling: Added initial infrastructure to translate error codes to PS_ERROR, added some commit and rollback features, and changed the default transaction handling in the database to 'no autocommit'

Revision 88871 - Directory Listing
Modified Wed Jun 13 21:11:43 2012 UTC (7 years, 4 months ago) by romanschmocker
First step to transaction support: The two important data structures - the object to POID mapping table and the POID to primary_key mapping table - got an API change to be able to handle transactions

Revision 88867 - Directory Listing
Modified Wed Jun 13 12:53:53 2012 UTC (7 years, 4 months ago) by romanschmocker
added some tests and changed the MySQL database to a local one running on my computer, because tests are running really long otherwise...

Revision 88860 - Directory Listing
Modified Mon Jun 11 16:38:23 2012 UTC (7 years, 4 months ago) by romanschmocker
disabled old in-memory tests and grouped insert statements in the sql backend to increase performance

Revision 88859 - Directory Listing
Modified Mon Jun 11 15:18:06 2012 UTC (7 years, 4 months ago) by romanschmocker
SQL backend now supports all CRUD operations on all objects except SPECIAL (-> feature parity with in-memory database)

Revision 88848 - Directory Listing
Modified Sun Jun 10 21:38:05 2012 UTC (7 years, 4 months ago) by romanschmocker
started to work on generic layout sql backend

Revision 88847 - Directory Listing
Added Sun Jun 10 15:34:56 2012 UTC (7 years, 4 months ago) by romanschmocker
started with the SQL backend for a generic database layout

  ViewVC Help
Powered by ViewVC 1.1.23