Changes between Version 6 and Version 7 of S2S_PERSISTENCE_COMMONS_R0


Ignore:
Timestamp:
11/24/08 17:26:06 (16 years ago)
Author:
meddle
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • S2S_PERSISTENCE_COMMONS_R0

    v6 v7  
    88 
    99== Overview == 
    10   * There will be layer that uses JDBC directly, "Database" layer or "JDBC" layer.  
    11   * There will be Data Access Objects that represent the persistence layer in higher level.  
    12   * The primal scheme of the database must be created.. 
    13   * Some of the queries will be created. And a way for keeping them will be developed in later revision. 
     10New module of the sophie2 project, used as an API to access a database from the server module. Will provide interface to the "server core" layer to persist, save to the database, search for and delete data. 
    1411 
    1512== Task requirements == 
    16   * Create the JDBC layer using Derby( JavaDB ). 
    17   * Create the DAOs (Data Access Objects) representing the persistence layer.  
    18   * Create the database schema to the extend needed by the other tasks in R0. 
    19   * Think of a way to store the queries; may be in configuration files? 
     13 * Write the server persistence module to the extend needed by the other tasks in Revision 0.  
     14 * Write good JUnit test that test all of the logic written. 
     15 * Write a flexible interface to the database API, that can be changed easily. 
     16 * Write the basic schema of the database and think of a way to store the creation logic in a good place. 
    2017 
    2118== Task result == 
    22 The end result will be interface for communication with the database. The DAO objects will be our API for accessing the DB. There will be basic database. 
     19The result will be a database module in initial state, which will be able to store and retrieve the data needed by the server core's security services. 
     20JUnit tests. Initial schema of the database. 
    2321 
    2422== Implementation idea == 
    25 The DAOs will execute queries to the database using the JDBC(Database) layer. 
     23The persistence module will contain Data Access managers with methods like : 
     24{{{ 
     25void saveEntity(Entity myEntity) {...} 
     26void getEntityByField(String field) {...} 
     27void persistEntity(Entity myEntity) 
     28}}} 
     29etc.. 
     30The managers will query the database directly using Database Access provider written for the purpose, that will be changeable. 
     31The API will be work with the generated Database Schema to the extend it is written. 
    2632 
    2733== Related == 
    … …  
    3036 
    3137== How to demo == 
    32 There will be JUnit tests for that task. 
     38See that the written logic connects to the database properly and creates the Database Schema. The module can successfully persist, update, delete and search for data in the chosen database. 
    3339 
    3440= Design =