Directory Agmial2/ca_manager/sql/

Lines of Code

Developers

Most Recent Commits

vloux 2007-10-24 11:47

CAM Model modifications for homology storage.
Added CAM_HOMOLOGY_RESULT

101 lines of code changed in:

• Agmial2/ca_manager/sql: contigdb_creation.sql (+101 -2)

vloux 2006-03-23 14:51

sql commands for changing indexes tablespace

17 lines of code changed in:

• Agmial2/ca_manager/sql: indexes_tbsp_change.sql (new 17)

vloux 2005-09-22 17:11

BugFixes

1 lines of code changed in:

• Agmial2/ca_manager/sql: contigdb_creation.sql (+1)

vloux 2005-08-23 16:59

CAM Summer Cleaning !

+ Database Pooling with apache dbcp (Database Connection Pools <http://jakarta.apache.org/commons/dbcp/>) served via jni to the servlet. Added a context.xmlfile with all the parameters for the connection.

+ Users and Roles are no longer stored in an xml file. Management via a dedicated database, served via jni to the servlets.

CAM refactoring :
moving all select/update/insert statement into contigdb package :

admin/ContigStoreAdminImpl.java OK (2)
admin/MonitorBatchTasks.java OK (1)(2)
admin/MonitorContigTasks.java OK (2)
admin/MonitorFeatureTasks.java OK (2)
admin/MonitorProjectTasks.java OK (2)
admin/MonitorTasks.java OK (2)
admin/ShowAddBatch.java OK (2)
admin/ShowAdminBatches.java OK (2)
admin/ShowUpdateContig.java OK (2)
admin/ShowUpdateProfile.java OK (2)

control/BatchActionMotivation.java OK(2)
control/BatchActionQueue.java OK(2)
control/BatchCalcAction.java OK(2)
control/ContigActionMotivation.java OK(2)
control/ContigActionQueue.java OK(2)
control/FeatureActionQueue.java OK(2)(3)
control/ProjectActionQueue.java OK(2)
control/ProjectMotivation.java OK(2)
control/QueryFeatureMotivation.java OK(2)

reader/ContigStoreQueryImpl.java OK
reader/EditFeature.java OK(2)
reader/MugenPanel.java TODO
reader/ProfileStoreQueryImpl.java OK(2)


(1) CAMActionList creation
(2) new methods in ContigDB
(3) CAMFeature creation

New policy for database accession :
All db accession is made via classes from the contigdb package.

For each object , two classes : CAMObject is the POJO
object.CAMOjectSchema is the Data Transfer Object and make the link
between the database and the POJO.
The CAMObjectSchema has at least two methods : add(CAMObjectSchema)
and update CAMObjectSchema();
ContigDB provide methods to interact with the object, mainly
getters/setters that call the corresponding methods in CAMObjectSchema.


--> reader/MugenPanel.java TODO

3 lines of code changed in:

• Agmial2/ca_manager/sql: contigdb_creation.sql (+3)

vloux 2005-03-02 16:28

Modifs sur en tete GPL
Correction du build.xml
Bugfix contextlistener.java
Ajout lien vers MuGenPanel dans ProteinPanel

1 lines of code changed in:

• Agmial2/ca_manager/sql: contigdb_creation.sql (+1 -1)

vloux 2005-02-10 10:24

Preambule GPL

18 lines of code changed in:

• Agmial2/ca_manager/sql: contigdb_creation.sql (+18)

rbossy 2004-09-29 16:40

Initial revision

391 lines of code changed in:

• Agmial2/ca_manager/sql: contigdb_creation.sql (new 391)