Index: /trunk/fmgVen/etc/test-db/test-db-changelog.xml =================================================================== --- /trunk/fmgVen/etc/test-db/test-db-changelog.xml (revision 24) +++ /trunk/fmgVen/etc/test-db/test-db-changelog.xml (revision 24) @@ -0,0 +1,478 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + SERIAL'ler serilerin sonuna _seq ekliyor, ama kodda oldugu gibi cagirabiliyoruz + + ALTER TABLE aa_authorization_parameter_no_seq RENAME TO aa_authorization_parameter_no; + ALTER TABLE aa_group_no_seq RENAME TO aa_group_no; + ALTER TABLE user_attribute_no_seq RENAME TO user_attribute_no; + ALTER TABLE user_attribute_user_no_seq RENAME TO user_no; + ALTER TABLE user_operation_no_seq RENAME TO user_operation_no; + + + + + Default Data + + INSERT INTO aa_group ("no", name, description) VALUES (1, 'Signomat Base Users', 'Signomat Base Users, have basic usage rights'); + INSERT INTO aa_group ("no", name, description) VALUES (2, 'SignArt Client Users', 'SignArt Client Users, have access to CSP mobile signing facilities'); + INSERT INTO aa_group ("no", name, description) VALUES (3, 'Workspace Users', 'Workspace Users, have access to /workspace web pages'); + INSERT INTO aa_group ("no", name, description) VALUES (4, 'Dox Users', 'Dox Users, have access to /dox web pages'); + INSERT INTO aa_group ("no", name, description) VALUES (5, 'Admin Users', 'Admin Users have access to /admin web pages'); + INSERT INTO aa_group ("no", name, description) VALUES (6, 'Demo Users', 'Demo Users have limited access, no access to DoX, and no timestamp facilities in signing portal'); + + + INSERT INTO aa_group_authorization (auth_name, group_no, param_no, "rule") VALUES ('PageAccessAuth', 1, NULL, 1); + INSERT INTO aa_group_authorization (auth_name, group_no, param_no, "rule") VALUES ('PageAccessAuth', 2, NULL, 2); + INSERT INTO aa_group_authorization (auth_name, group_no, param_no, "rule") VALUES ('PageAccessAuth', 3, NULL, 3); + INSERT INTO aa_group_authorization (auth_name, group_no, param_no, "rule") VALUES ('PageAccessAuth', 4, NULL, 4); + INSERT INTO aa_group_authorization (auth_name, group_no, param_no, "rule") VALUES ('PageAccessAuth', 5, NULL, 5); + INSERT INTO aa_group_authorization (auth_name, group_no, param_no, "rule") VALUES ('PageAccessAuth', 6, NULL, 3); + INSERT INTO aa_group_authorization (auth_name, group_no, param_no, "rule") VALUES ('SignAuth', 3, NULL, 1); + INSERT INTO aa_group_authorization (auth_name, group_no, param_no, "rule") VALUES ('SignAuth', 6, NULL, 2); + + + INSERT INTO user_attribute (attribute, value, "type", priority) VALUES ('username', 'admin', '00_id', 0); + INSERT INTO user_attribute (user_no, attribute, value, "type", priority) VALUES ((select user_no from user_attribute where attribute = 'username' and value='admin'), 'citizenshipNumber', '12345', '00_id', 0); + INSERT INTO user_authentication (username, "password") VALUES ('12345', '21232f297a57a5a743894a0e4a801fc3'); + + + INSERT INTO aa_user_group (username, group_no, "order") VALUES ((select user_no from user_attribute where attribute = 'username' and value='admin'), 1, 1); + INSERT INTO aa_user_group (username, group_no, "order") VALUES ((select user_no from user_attribute where attribute = 'username' and value='admin'), 3, 2); + INSERT INTO aa_user_group (username, group_no, "order") VALUES ((select user_no from user_attribute where attribute = 'username' and value='admin'), 4, 3); + INSERT INTO aa_user_group (username, group_no, "order") VALUES ((select user_no from user_attribute where attribute = 'username' and value='admin'), 5, 4); + + + + + Function to delete all data from all tables. Can be updated later (runAlways is set) + 0 THEN CONTINUE; END IF; + table_list := table_list || quote_ident(mtable.tablename) || '', ''; + END LOOP; + + table_list := substring(table_list from 0 for length(table_list)-1); + + EXECUTE ''TRUNCATE TABLE '' || table_list; + + RETURN table_list; + END;'; + ]]> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + to keep track of attachment size, and tell to the browser while downloading + + + + change on delete cascade to on delete restrict of some foreign key constraints, since referencing tables does not belong to referenced tables + e.g. Msg. attachment does not belong to content, if a msg attch. exists, referenced content cannot be deleted. + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Index: /trunk/fmgVen/lib/nblibraries.properties =================================================================== --- /trunk/fmgVen/lib/nblibraries.properties (revision 23) +++ /trunk/fmgVen/lib/nblibraries.properties (revision 24) @@ -6,5 +6,6 @@ ${base}/CopyLibs/org-netbeans-modules-java-j2seproject-copylibstask.jar libs.Test.classpath=\ - ${base}/test/postgresql-8.4-701.jdbc3.jar + ${base}/test/postgresql-8.4-701.jdbc3.jar;\ + ${base}/test/liquibase-1.9.5.jar libs.Ven.classpath=\ ${base}/ven/spring-beans.jar;\ Index: /trunk/fmgVen/nbproject/project.properties =================================================================== --- /trunk/fmgVen/nbproject/project.properties (revision 23) +++ /trunk/fmgVen/nbproject/project.properties (revision 24) @@ -39,5 +39,6 @@ ${javac.classpath}:\ ${build.classes.dir}:\ - ${libs.junit.classpath} + ${libs.junit.classpath}:\ + ${libs.Test.classpath} javadoc.additionalparam= javadoc.author=false Index: /trunk/fmgVen/test/com/fmguler/ven/sample/Sample.java =================================================================== --- /trunk/fmgVen/test/com/fmguler/ven/sample/Sample.java (revision 23) +++ /trunk/fmgVen/test/com/fmguler/ven/sample/Sample.java (revision 24) @@ -20,6 +20,14 @@ import com.fmguler.ven.Ven; import com.fmguler.ven.sample.domain.SomeDomainObject; +import java.sql.SQLException; +import java.util.Locale; import javax.sql.DataSource; +import liquibase.FileSystemFileOpener; +import liquibase.exception.JDBCException; +import liquibase.exception.LiquibaseException; import org.springframework.jdbc.datasource.DriverManagerDataSource; +import liquibase.Liquibase; +import liquibase.database.Database; +import liquibase.database.DatabaseFactory; /** @@ -29,5 +37,7 @@ public class Sample { public static void main(String[] args) { + buildDatabase(); test1(); + //rollbackDatabase(); } @@ -51,6 +61,41 @@ ds.setUsername("postgres"); ds.setPassword("qwerty"); - ds.setUrl("jdbc:postgresql://127.0.0.1:5432/vendb"); + ds.setUrl("jdbc:postgresql://127.0.0.1:5432/ven-test"); return ds; } + + private static void buildDatabase() { + try { + Locale currLocale = Locale.getDefault(); + Locale.setDefault(Locale.ENGLISH); + Database database = DatabaseFactory.getInstance().findCorrectDatabaseImplementation(getDataSource().getConnection()); + Liquibase liquibase = new Liquibase("etc/test-db/test-db-changelog.xml", new FileSystemFileOpener(), database); + liquibase.update(""); + Locale.setDefault(currLocale); + } catch (SQLException ex) { + ex.printStackTrace(); + } catch (JDBCException ex) { + ex.printStackTrace(); + } catch (LiquibaseException ex) { + ex.printStackTrace(); + } + } + + private static void rollbackDatabase() { + try { + Locale currLocale = Locale.getDefault(); + Locale.setDefault(Locale.ENGLISH); + Database database = DatabaseFactory.getInstance().findCorrectDatabaseImplementation(getDataSource().getConnection()); + Liquibase liquibase = new Liquibase("etc/test-db/test-db-changelog.xml", new FileSystemFileOpener(), database); + //liquibase.rollback(51, ""); + liquibase.rollback("0", ""); + Locale.setDefault(currLocale); + } catch (SQLException ex) { + ex.printStackTrace(); + } catch (JDBCException ex) { + ex.printStackTrace(); + } catch (LiquibaseException ex) { + ex.printStackTrace(); + } + } }