| Interface | Description |
|---|---|
| DBConnectionStrategy |
Database connection interface
(applying the adapter pattern)
|
| Class | Description |
|---|---|
| CellDatabase |
The cell structure for sync
|
| Console |
A console-based test class
|
| ConsoleDerbyTest | |
| ConsoleHsqlTest |
A console-based application to test the HSQL database
What this application does:
1) it creates an hsql database in the path "res/csheets/ext/database/hsql_db"
2) it creates a table called SAMPLE_TABLE with four entries
3) in order to view the data entered go to http://www.hsqldb.org and download
the latest stable release (mine is 2.2.9)
4) once you have it go to terminal, move to "hsqldb-2.2.9/hsqldb/lib" and
run the following command:
$ java -cp hsqldb.jar org.hsqldb.util.DatabaseManagerSwing
5) once launched, select the following:
TYPE: HSQL database engine standalone
DRIVER: org.hsqldb.jdbcDriver
URL: jdbc:hsqldb:file:src-resources/csheets/ext/database/embebbed_db/hsql_db
USER: user
PASS: pass
6) You should be prompted with the SAMPLE_TABLE that was created when this
program was run
(based in the code of Karl Meissner, at http://www.hsqldb.org/doc/guide/apb.html)
|
| Database |
Contains all information about a given database technology
|
| DatabaseFacade |
A class that deals with all the data going into and from the databases (UML
facade pattern)
|
| DBConnectionFactory |
A factory of database connection adapters
|
| DBCsvReader |
Reads a cvs file containing relevant information about the database
technology
|
| DerbyConnection |
Creates a new connection to a derby database
|
| HsqlDBConnection |
Creates a connection to a HSQL database
|
| ObserverMessages |
The observer messages for the merge errors
|
| ThreadExport |
The thread responsible for the export of data to a database
|
| ThreadImport |
The thread responsible for the import of data from a database
|
| ThreadImportTables |
The thread responsible for the import of table information from a database
|
| ThreadSync |
Creates a new thread for the sync function
|
| ThreadUpdate |
The thread responsible for the update of Cleansheet's content with a database
|