/[eiffelstudio]/branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/backends/generic_database_layout/ps_generic_layout_sql_backend.e
ViewVC logotype

Log of /branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/backends/generic_database_layout/ps_generic_layout_sql_backend.e

Parent Directory Parent Directory | Revision Log Revision Log


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

Revision 88969 - (view) (annotate) - [select for diffs]
Modified Fri Jun 22 11:53:00 2012 UTC (7 years, 3 months ago) by romanschmocker
File length: 17210 byte(s)
Copied from: branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql/ps_generic_layout_sql_backend.e revision 88965
Diff to previous 88965
Changed structure in the ABEL library repository - e.g. pre-built backends are now collected in their own cluster

Revision 88965 - (view) (annotate) - [select for diffs]
Modified Fri Jun 22 10:01:37 2012 UTC (7 years, 3 months ago) by romanschmocker
Original Path: branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql/ps_generic_layout_sql_backend.e
File length: 17210 byte(s)
Diff to previous 88956
Refactored the METADATA classes

Revision 88956 - (view) (annotate) - [select for diffs]
Modified Thu Jun 21 19:05:36 2012 UTC (7 years, 3 months ago) by romanschmocker
Original Path: branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql/ps_generic_layout_sql_backend.e
File length: 17228 byte(s)
Diff to previous 88954
Prettified and refactored the database wrappers

Revision 88954 - (view) (annotate) - [select for diffs]
Modified Thu Jun 21 11:03:35 2012 UTC (7 years, 3 months ago) by romanschmocker
Original Path: branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql/ps_generic_layout_sql_backend.e
File length: 17259 byte(s)
Diff to previous 88950
SQLite backend is working now, although with disabled connection and transaction handling.

Revision 88950 - (view) (annotate) - [select for diffs]
Modified Wed Jun 20 14:00:17 2012 UTC (7 years, 3 months ago) by romanschmocker
Original Path: branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql/ps_generic_layout_sql_backend.e
File length: 17249 byte(s)
Diff to previous 88949
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 - (view) (annotate) - [select for diffs]
Modified Wed Jun 20 11:43:07 2012 UTC (7 years, 3 months ago) by romanschmocker
Original Path: branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql/ps_generic_layout_sql_backend.e
File length: 17202 byte(s)
Diff to previous 88948
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 - (view) (annotate) - [select for diffs]
Modified Wed Jun 20 09:14:46 2012 UTC (7 years, 3 months ago) by romanschmocker
Original Path: branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql/ps_generic_layout_sql_backend.e
File length: 16865 byte(s)
Diff to previous 88930
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 - (view) (annotate) - [select for diffs]
Modified Tue Jun 19 11:24:23 2012 UTC (7 years, 3 months ago) by romanschmocker
Original Path: branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql/ps_generic_layout_sql_backend.e
File length: 18143 byte(s)
Diff to previous 88917
Reimplemented collection support in the retrieval manager: All CRUD tests pass now

Revision 88917 - (view) (annotate) - [select for diffs]
Modified Mon Jun 18 06:53:12 2012 UTC (7 years, 3 months ago) by romanschmocker
Original Path: branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql/ps_generic_layout_sql_backend.e
File length: 17810 byte(s)
Diff to previous 88876
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 - (view) (annotate) - [select for diffs]
Modified Thu Jun 14 22:52:10 2012 UTC (7 years, 4 months ago) by romanschmocker
Original Path: branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql/ps_generic_layout_sql_backend.e
File length: 17490 byte(s)
Diff to previous 88875
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 - (view) (annotate) - [select for diffs]
Modified Thu Jun 14 15:43:28 2012 UTC (7 years, 4 months ago) by romanschmocker
Original Path: branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql/ps_generic_layout_sql_backend.e
File length: 17022 byte(s)
Diff to previous 88873
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 - (view) (annotate) - [select for diffs]
Modified Thu Jun 14 14:07:06 2012 UTC (7 years, 4 months ago) by romanschmocker
Original Path: branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql/ps_generic_layout_sql_backend.e
File length: 16059 byte(s)
Diff to previous 88872
First version that does have some explicit transaction handling

Revision 88872 - (view) (annotate) - [select for diffs]
Modified Thu Jun 14 10:57:13 2012 UTC (7 years, 4 months ago) by romanschmocker
Original Path: branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql/ps_generic_layout_sql_backend.e
File length: 13107 byte(s)
Diff to previous 88871
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 - (view) (annotate) - [select for diffs]
Modified Wed Jun 13 21:11:43 2012 UTC (7 years, 4 months ago) by romanschmocker
Original Path: branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql/ps_generic_layout_sql_backend.e
File length: 12885 byte(s)
Diff to previous 88867
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 - (view) (annotate) - [select for diffs]
Modified Wed Jun 13 12:53:53 2012 UTC (7 years, 4 months ago) by romanschmocker
Original Path: branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql/ps_generic_layout_sql_backend.e
File length: 12742 byte(s)
Diff to previous 88860
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 - (view) (annotate) - [select for diffs]
Modified Mon Jun 11 16:38:23 2012 UTC (7 years, 4 months ago) by romanschmocker
Original Path: branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql/ps_generic_layout_sql_backend.e
File length: 12740 byte(s)
Diff to previous 88859
disabled old in-memory tests and grouped insert statements in the sql backend to increase performance

Revision 88859 - (view) (annotate) - [select for diffs]
Modified Mon Jun 11 15:18:06 2012 UTC (7 years, 4 months ago) by romanschmocker
Original Path: branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql/ps_generic_layout_sql_backend.e
File length: 12138 byte(s)
Diff to previous 88848
SQL backend now supports all CRUD operations on all objects except SPECIAL (-> feature parity with in-memory database)

Revision 88848 - (view) (annotate) - [select for diffs]
Modified Sun Jun 10 21:38:05 2012 UTC (7 years, 4 months ago) by romanschmocker
Original Path: branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql/ps_generic_layout_sql_backend.e
File length: 7388 byte(s)
Diff to previous 88847
started to work on generic layout sql backend

Revision 88847 - (view) (annotate) - [select for diffs]
Added Sun Jun 10 15:34:56 2012 UTC (7 years, 4 months ago) by romanschmocker
Original Path: branches/eth/eve/Src/library/abel/libraries/ethz/src/abel/relational/sql/ps_generic_layout_sql_backend.e
File length: 5387 byte(s)
started with the SQL backend for a generic database layout

This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, enter a numeric revision.

  Diffs between and
  Type of Diff should be a

  ViewVC Help
Powered by ViewVC 1.1.23