Author: hoffmann
Date: Sat Dec  2 16:14:35 2006
New Revision: 481671

URL: http://svn.apache.org/viewvc?view=rev&rev=481671
Log:
made the tests of fulcrum-security-torque OS and DB independent. See TRB-36

Added:
    
jakarta/turbine/fulcrum/trunk/security/torque/src/test/fulcrum-schema-idtable-init.sql
    jakarta/turbine/fulcrum/trunk/security/torque/src/test/fulcrum-schema.sql
    jakarta/turbine/fulcrum/trunk/security/torque/src/test/id-table-schema.sql
    
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/HsqlDB.java
Modified:
    jakarta/turbine/fulcrum/trunk/security/torque/project.properties
    jakarta/turbine/fulcrum/trunk/security/torque/project.xml
    jakarta/turbine/fulcrum/trunk/security/torque/src/test/Torque.properties
    
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorqueGroupManagerTest.java
    
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorquePermissionManagerTest.java
    
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorqueRoleManagerTest.java
    
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorqueUserManagerTest.java
    
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/basic/TorqueBasicModelManagerTest.java
    
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/dynamic/TorqueDynamicModelManagerTest.java
    
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/turbine/TorqueTurbineModelManagerTest.java

Modified: jakarta/turbine/fulcrum/trunk/security/torque/project.properties
URL: 
http://svn.apache.org/viewvc/jakarta/turbine/fulcrum/trunk/security/torque/project.properties?view=diff&rev=481671&r1=481670&r2=481671
==============================================================================
--- jakarta/turbine/fulcrum/trunk/security/torque/project.properties (original)
+++ jakarta/turbine/fulcrum/trunk/security/torque/project.properties Sat Dec  2 
16:14:35 2006
@@ -60,7 +60,7 @@
 #   mysql, oracle, postgresql, sapdb, sybase
 # -------------------------------------------------------------------
 
-torque.database = mysql
+torque.database = hypersonic
 
 
 # -------------------------------------------------------------------
@@ -142,12 +142,12 @@
 #   and columns to be the same as SQL name.
 # -------------------------------------------------------------------
 
-torque.database.driver = org.gjt.mm.mysql.Driver
-torque.database.createUrl = jdbc:mysql://localhost:3306/mysql
-torque.database.buildUrl = jdbc:mysql://localhost:3306/fulcrum
-torque.database.url = jdbc:mysql://localhost:3306/fulcrum
-torque.database.user = root
+torque.database.driver = org.hsqldb.jdbcDriver
+torque.database.createUrl = jdbc:hsqldb:.
+torque.database.buildUrl = jdbc:hsqldb:.
+torque.database.url = jdbc:hsqldb:.
+torque.database.user = sa
 torque.database.password = 
-torque.database.host = localhost
+torque.database.host = .
 
 torque.sameJavaName = false

Modified: jakarta/turbine/fulcrum/trunk/security/torque/project.xml
URL: 
http://svn.apache.org/viewvc/jakarta/turbine/fulcrum/trunk/security/torque/project.xml?view=diff&rev=481671&r1=481670&r2=481671
==============================================================================
--- jakarta/turbine/fulcrum/trunk/security/torque/project.xml (original)
+++ jakarta/turbine/fulcrum/trunk/security/torque/project.xml Sat Dec  2 
16:14:35 2006
@@ -102,9 +102,9 @@
     </dependency>
 
     <dependency>
-      <artifactId>mysql-connector-java</artifactId>
-      <groupId>mysql</groupId>
-      <version>3.1.12</version>
+      <artifactId>hsqldb</artifactId>
+      <groupId>hsqldb</groupId>
+      <version>1.8.0.7</version>
     </dependency> 
 
   </dependencies>

Modified: 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/Torque.properties
URL: 
http://svn.apache.org/viewvc/jakarta/turbine/fulcrum/trunk/security/torque/src/test/Torque.properties?view=diff&rev=481671&r1=481670&r2=481671
==============================================================================
--- jakarta/turbine/fulcrum/trunk/security/torque/src/test/Torque.properties 
(original)
+++ jakarta/turbine/fulcrum/trunk/security/torque/src/test/Torque.properties 
Sat Dec  2 16:14:35 2006
@@ -19,13 +19,13 @@
 #
 
 torque.database.default = fulcrum
-torque.database.fulcrum.adapter = mysql
+torque.database.fulcrum.adapter = hypersonic
 
 #Using commons-dbcp
 torque.dsfactory.fulcrum.factory = 
org.apache.torque.dsfactory.SharedPoolDataSourceFactory
-torque.dsfactory.fulcrum.connection.driver = org.gjt.mm.mysql.Driver
-torque.dsfactory.fulcrum.connection.url = jdbc:mysql://localhost:3306/fulcrum
-torque.dsfactory.fulcrum.connection.user = root
+torque.dsfactory.fulcrum.connection.driver = org.hsqldb.jdbcDriver
+torque.dsfactory.fulcrum.connection.url = jdbc:hsqldb:.
+torque.dsfactory.fulcrum.connection.user = sa
 torque.dsfactory.fulcrum.connection.password =
 
 torque.dsfactory.bookstore.pool.validationQuery = SELECT 1

Added: 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/fulcrum-schema-idtable-init.sql
URL: 
http://svn.apache.org/viewvc/jakarta/turbine/fulcrum/trunk/security/torque/src/test/fulcrum-schema-idtable-init.sql?view=auto&rev=481671
==============================================================================
--- 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/fulcrum-schema-idtable-init.sql
 (added)
+++ 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/fulcrum-schema-idtable-init.sql
 Sat Dec  2 16:14:35 2006
@@ -0,0 +1,11 @@
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (101, 
'FULCRUM_PERMISSION', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (102, 
'FULCRUM_ROLE', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (103, 
'FULCRUM_GROUP', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (104, 
'FULCRUM_USER', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (105, 
'BASIC_USER_GROUP', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (106, 
'DYNAMIC_ROLE_PERMISSION', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (107, 
'DYNAMIC_USER_GROUP', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (108, 
'DYNAMIC_GROUP_ROLE', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (109, 
'DYNAMIC_USER_DELEGATES', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (110, 
'TURBINE_ROLE_PERMISSION', 1000, 10);
+insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (111, 
'TURBINE_USER_GROUP_ROLE', 1000, 10);

Added: jakarta/turbine/fulcrum/trunk/security/torque/src/test/fulcrum-schema.sql
URL: 
http://svn.apache.org/viewvc/jakarta/turbine/fulcrum/trunk/security/torque/src/test/fulcrum-schema.sql?view=auto&rev=481671
==============================================================================
--- jakarta/turbine/fulcrum/trunk/security/torque/src/test/fulcrum-schema.sql 
(added)
+++ jakarta/turbine/fulcrum/trunk/security/torque/src/test/fulcrum-schema.sql 
Sat Dec  2 16:14:35 2006
@@ -0,0 +1,150 @@
+SET IGNORECASE TRUE
+
+-----------------------------------------------------------------------------
+-- FULCRUM_PERMISSION
+-----------------------------------------------------------------------------
+drop table FULCRUM_PERMISSION if exists;
+
+CREATE TABLE FULCRUM_PERMISSION
+(
+    PERMISSION_ID INTEGER NOT NULL,
+    PERMISSION_NAME VARCHAR(64) NOT NULL,
+    PRIMARY KEY(PERMISSION_ID),
+    UNIQUE (PERMISSION_NAME)
+);
+
+
+-----------------------------------------------------------------------------
+-- FULCRUM_ROLE
+-----------------------------------------------------------------------------
+drop table FULCRUM_ROLE if exists;
+
+CREATE TABLE FULCRUM_ROLE
+(
+    ROLE_ID INTEGER NOT NULL,
+    ROLE_NAME VARCHAR(64) NOT NULL,
+    PRIMARY KEY(ROLE_ID),
+    UNIQUE (ROLE_NAME)
+);
+
+
+-----------------------------------------------------------------------------
+-- FULCRUM_GROUP
+-----------------------------------------------------------------------------
+drop table FULCRUM_GROUP if exists;
+
+CREATE TABLE FULCRUM_GROUP
+(
+    GROUP_ID INTEGER NOT NULL,
+    GROUP_NAME VARCHAR(64) NOT NULL,
+    PRIMARY KEY(GROUP_ID),
+    UNIQUE (GROUP_NAME)
+);
+
+
+-----------------------------------------------------------------------------
+-- FULCRUM_USER
+-----------------------------------------------------------------------------
+drop table FULCRUM_USER if exists;
+
+CREATE TABLE FULCRUM_USER
+(
+    USER_ID INTEGER NOT NULL,
+    LOGIN_NAME VARCHAR(64) NOT NULL,
+    PASSWORD_VALUE VARCHAR(16) NOT NULL,
+    PRIMARY KEY(USER_ID),
+    UNIQUE (LOGIN_NAME)
+);
+
+
+-----------------------------------------------------------------------------
+-- BASIC_USER_GROUP
+-----------------------------------------------------------------------------
+drop table BASIC_USER_GROUP if exists;
+
+CREATE TABLE BASIC_USER_GROUP
+(
+    USER_ID INTEGER NOT NULL,
+    GROUP_ID INTEGER NOT NULL,
+    PRIMARY KEY(USER_ID,GROUP_ID)
+);
+
+
+-----------------------------------------------------------------------------
+-- DYNAMIC_ROLE_PERMISSION
+-----------------------------------------------------------------------------
+drop table DYNAMIC_ROLE_PERMISSION if exists;
+
+CREATE TABLE DYNAMIC_ROLE_PERMISSION
+(
+    ROLE_ID INTEGER NOT NULL,
+    PERMISSION_ID INTEGER NOT NULL,
+    PRIMARY KEY(ROLE_ID,PERMISSION_ID)
+);
+
+
+-----------------------------------------------------------------------------
+-- DYNAMIC_USER_GROUP
+-----------------------------------------------------------------------------
+drop table DYNAMIC_USER_GROUP if exists;
+
+CREATE TABLE DYNAMIC_USER_GROUP
+(
+    USER_ID INTEGER NOT NULL,
+    GROUP_ID INTEGER NOT NULL,
+    PRIMARY KEY(USER_ID,GROUP_ID)
+);
+
+
+-----------------------------------------------------------------------------
+-- DYNAMIC_GROUP_ROLE
+-----------------------------------------------------------------------------
+drop table DYNAMIC_GROUP_ROLE if exists;
+
+CREATE TABLE DYNAMIC_GROUP_ROLE
+(
+    GROUP_ID INTEGER NOT NULL,
+    ROLE_ID INTEGER NOT NULL,
+    PRIMARY KEY(GROUP_ID,ROLE_ID)
+);
+
+
+-----------------------------------------------------------------------------
+-- DYNAMIC_USER_DELEGATES
+-----------------------------------------------------------------------------
+drop table DYNAMIC_USER_DELEGATES if exists;
+
+CREATE TABLE DYNAMIC_USER_DELEGATES
+(
+    DELEGATOR_USER_ID INTEGER NOT NULL,
+    DELEGATEE_USER_ID INTEGER NOT NULL,
+    PRIMARY KEY(DELEGATOR_USER_ID,DELEGATEE_USER_ID)
+);
+
+
+-----------------------------------------------------------------------------
+-- TURBINE_ROLE_PERMISSION
+-----------------------------------------------------------------------------
+drop table TURBINE_ROLE_PERMISSION if exists;
+
+CREATE TABLE TURBINE_ROLE_PERMISSION
+(
+    ROLE_ID INTEGER NOT NULL,
+    PERMISSION_ID INTEGER NOT NULL,
+    PRIMARY KEY(ROLE_ID,PERMISSION_ID)
+);
+
+
+-----------------------------------------------------------------------------
+-- TURBINE_USER_GROUP_ROLE
+-----------------------------------------------------------------------------
+drop table TURBINE_USER_GROUP_ROLE if exists;
+
+CREATE TABLE TURBINE_USER_GROUP_ROLE
+(
+    USER_ID INTEGER NOT NULL,
+    GROUP_ID INTEGER NOT NULL,
+    ROLE_ID INTEGER NOT NULL,
+    PRIMARY KEY(USER_ID,GROUP_ID,ROLE_ID)
+);
+

Added: 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/id-table-schema.sql
URL: 
http://svn.apache.org/viewvc/jakarta/turbine/fulcrum/trunk/security/torque/src/test/id-table-schema.sql?view=auto&rev=481671
==============================================================================
--- jakarta/turbine/fulcrum/trunk/security/torque/src/test/id-table-schema.sql 
(added)
+++ jakarta/turbine/fulcrum/trunk/security/torque/src/test/id-table-schema.sql 
Sat Dec  2 16:14:35 2006
@@ -0,0 +1,18 @@
+
+-----------------------------------------------------------------------------
+-- ID_TABLE
+-----------------------------------------------------------------------------
+drop table ID_TABLE if exists;
+
+CREATE TABLE ID_TABLE
+(
+    ID_TABLE_ID INTEGER NOT NULL,
+    TABLE_NAME VARCHAR(255) NOT NULL,
+    NEXT_ID INTEGER,
+    QUANTITY INTEGER,
+    PRIMARY KEY(ID_TABLE_ID),
+    UNIQUE (TABLE_NAME)
+);
+
+
+

Added: 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/HsqlDB.java
URL: 
http://svn.apache.org/viewvc/jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/HsqlDB.java?view=auto&rev=481671
==============================================================================
--- 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/HsqlDB.java
 (added)
+++ 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/HsqlDB.java
 Sat Dec  2 16:14:35 2006
@@ -0,0 +1,152 @@
+package org.apache.fulcrum.security.torque;
+
+/*
+ * Copyright 2001-2005 The Apache Software Foundation.
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License")
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+import java.io.File;
+import java.io.FileReader;
+import java.net.URL;
+
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.SQLException;
+import java.sql.Statement;
+
+import org.apache.commons.lang.StringUtils;
+import org.apache.commons.logging.Log;
+import org.apache.commons.logging.LogFactory;
+
+import org.hsqldb.jdbcDriver;
+
+/**
+ * This Class provides a nice Setup for a Hypersonic SQL Server,
+ * which will only be held in Memory. 
+ * 
+ * It allows loading of .sql Files, to setup Tests easily.
+ * 
+ * @author <a href="[EMAIL PROTECTED]">J&#252;rgen Hoffmann</a>
+ */
+public class HsqlDB
+{
+    private Connection connection = null;
+
+    private static Log log = LogFactory.getLog(HsqlDB.class);
+
+    public HsqlDB(String uri, String loadFile) throws Exception
+    {
+        Class.forName(jdbcDriver.class.getName());
+
+        this.connection = DriverManager.getConnection(uri, "sa", "");
+
+        if(StringUtils.isNotEmpty(loadFile))
+        {
+            loadSqlFile(loadFile);
+        }
+    }
+
+    public HsqlDB(String uri, URL loadFile) throws Exception
+    {
+        this(uri, new File(loadFile.toURI()));
+    }
+
+    public HsqlDB(String uri, File loadFile) throws Exception
+    {
+        this(uri, loadFile.getAbsolutePath());
+    }
+
+    public Connection getConnection()
+    {
+        return connection;
+    }
+
+    public void close()
+    {
+        try
+        {
+            connection.close();
+        }
+        catch (Exception e)
+        {
+        }
+    }
+
+    private void loadSqlFile(String fileName) throws Exception
+    {
+        Statement statement = null;
+        try
+        {
+            statement = connection.createStatement();
+            String commands = getFileContents(fileName);
+
+            for (int targetPos = commands.indexOf(';'); targetPos > -1; 
targetPos = commands.indexOf(';'))
+            {
+                String cmd = commands.substring(0, targetPos + 1);
+                try
+                {
+                    statement.execute(cmd);
+                }
+                catch (SQLException sqle)
+                {
+                    log.warn("Statement: " + cmd + ": " + sqle.getMessage());
+                }
+
+                commands = commands.substring(targetPos + 2);
+            }
+        }
+        finally
+        {
+            if(statement != null)
+            {
+                statement.close();
+            }
+        }
+    }
+
+    private String getFileContents(String fileName) throws Exception
+    {
+        System.out.println(fileName);
+        FileReader fr = new FileReader(fileName);
+
+        char fileBuf[] = new char[1024];
+        StringBuffer sb = new StringBuffer(1000);
+        int res = -1;
+
+        while ((res = fr.read(fileBuf, 0, 1024)) > -1)
+        {
+            sb.append(fileBuf, 0, res);
+        }
+        fr.close();
+        return sb.toString();
+    }
+
+    public void addSQL(String sqlFile) throws Exception
+    {
+        if(StringUtils.isNotEmpty(sqlFile))
+        {
+            loadSqlFile(sqlFile);
+        }
+    }
+
+    public void addSQL(URL sqlFile) throws Exception
+    {
+        this.addSQL(new File(sqlFile.toURI()));
+    }
+
+    public void addSQL(File sqlFile) throws Exception
+    {
+        this.addSQL(sqlFile.getAbsolutePath());
+    }
+}

Modified: 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorqueGroupManagerTest.java
URL: 
http://svn.apache.org/viewvc/jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorqueGroupManagerTest.java?view=diff&rev=481671&r1=481670&r2=481671
==============================================================================
--- 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorqueGroupManagerTest.java
 (original)
+++ 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorqueGroupManagerTest.java
 Sat Dec  2 16:14:35 2006
@@ -34,10 +34,16 @@
  */
 public class TorqueGroupManagerTest extends AbstractGroupManagerTest
 {
+    protected static HsqlDB hsqlDB = null;
+
     public void setUp()
     {
         try
         {
+            this.hsqlDB = new HsqlDB("jdbc:hsqldb:.", 
"src/test/fulcrum-schema.sql");
+            hsqlDB.addSQL("src/test/id-table-schema.sql");
+            hsqlDB.addSQL("src/test/fulcrum-schema-idtable-init.sql");
+
             this.setRoleFileName("src/test/DynamicTorqueRoleConfig.xml");
             
this.setConfigurationFileName("src/test/DynamicTorqueComponentConfig.xml");
             securityService = (SecurityService) lookup(SecurityService.ROLE);

Modified: 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorquePermissionManagerTest.java
URL: 
http://svn.apache.org/viewvc/jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorquePermissionManagerTest.java?view=diff&rev=481671&r1=481670&r2=481671
==============================================================================
--- 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorquePermissionManagerTest.java
 (original)
+++ 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorquePermissionManagerTest.java
 Sat Dec  2 16:14:35 2006
@@ -30,12 +30,18 @@
 
 /**
  * @author <a href="mailto:[EMAIL PROTECTED]">Thomas Vandahl</a>
+ * @author <a href="[EMAIL PROTECTED]">J&#252;rgen Hoffmann</a>
  * @version $Id:$
  */
 public class TorquePermissionManagerTest extends AbstractPermissionManagerTest
 {
+    protected static HsqlDB hsqlDB = null;
+
     public void setUp() throws Exception
     {
+        this.hsqlDB = new HsqlDB("jdbc:hsqldb:.", 
"src/test/fulcrum-schema.sql");
+        hsqlDB.addSQL("src/test/id-table-schema.sql");
+        hsqlDB.addSQL("src/test/fulcrum-schema-idtable-init.sql");
 
         this.setRoleFileName("src/test/DynamicTorqueRoleConfig.xml");
         
this.setConfigurationFileName("src/test/DynamicTorqueComponentConfig.xml");

Modified: 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorqueRoleManagerTest.java
URL: 
http://svn.apache.org/viewvc/jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorqueRoleManagerTest.java?view=diff&rev=481671&r1=481670&r2=481671
==============================================================================
--- 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorqueRoleManagerTest.java
 (original)
+++ 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorqueRoleManagerTest.java
 Sat Dec  2 16:14:35 2006
@@ -31,14 +31,20 @@
 
 /**
  * @author <a href="mailto:[EMAIL PROTECTED]">Thomas Vandahl</a>
+ * @author <a href="[EMAIL PROTECTED]">J&#252;rgen Hoffmann</a>
  * @version $Id:$
  */
 public class TorqueRoleManagerTest extends AbstractRoleManagerTest
 {
+    protected static HsqlDB hsqlDB = null;
+
     public void setUp()
     {
         try
         {
+            this.hsqlDB = new HsqlDB("jdbc:hsqldb:.", 
"src/test/fulcrum-schema.sql");
+            hsqlDB.addSQL("src/test/id-table-schema.sql");
+            hsqlDB.addSQL("src/test/fulcrum-schema-idtable-init.sql");
             this.setRoleFileName("src/test/DynamicTorqueRoleConfig.xml");
             
this.setConfigurationFileName("src/test/DynamicTorqueComponentConfig.xml");
             securityService = (SecurityService) lookup(SecurityService.ROLE);

Modified: 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorqueUserManagerTest.java
URL: 
http://svn.apache.org/viewvc/jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorqueUserManagerTest.java?view=diff&rev=481671&r1=481670&r2=481671
==============================================================================
--- 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorqueUserManagerTest.java
 (original)
+++ 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/TorqueUserManagerTest.java
 Sat Dec  2 16:14:35 2006
@@ -30,14 +30,22 @@
 
 /**
  * @author <a href="mailto:[EMAIL PROTECTED]">Thomas Vandahl</a>
+ * @author <a href="[EMAIL PROTECTED]">J&#252;rgen Hoffmann</a>
+ * 
  * @version $Id:$
  */
 public class TorqueUserManagerTest extends AbstractUserManagerTest
 {
+    protected static HsqlDB hsqlDB = null;
+
     public void setUp()
     {
         try
         {
+            this.hsqlDB = new HsqlDB("jdbc:hsqldb:.", 
"src/test/fulcrum-schema.sql");
+            hsqlDB.addSQL("src/test/id-table-schema.sql");
+            hsqlDB.addSQL("src/test/fulcrum-schema-idtable-init.sql");
+
             this.setRoleFileName("src/test/DynamicTorqueRoleConfig.xml");
             
this.setConfigurationFileName("src/test/DynamicTorqueComponentConfig.xml");
             securityService = (SecurityService) lookup(SecurityService.ROLE);

Modified: 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/basic/TorqueBasicModelManagerTest.java
URL: 
http://svn.apache.org/viewvc/jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/basic/TorqueBasicModelManagerTest.java?view=diff&rev=481671&r1=481670&r2=481671
==============================================================================
--- 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/basic/TorqueBasicModelManagerTest.java
 (original)
+++ 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/basic/TorqueBasicModelManagerTest.java
 Sat Dec  2 16:14:35 2006
@@ -1,4 +1,5 @@
 package org.apache.fulcrum.security.torque.basic;
+
 /*
  *  Copyright 2001-2004 The Apache Software Foundation
  *
@@ -19,6 +20,7 @@
 import org.apache.fulcrum.security.entity.User;
 import org.apache.fulcrum.security.model.basic.entity.BasicUser;
 import org.apache.fulcrum.security.model.basic.test.AbstractModelManagerTest;
+import org.apache.fulcrum.security.torque.HsqlDB;
 import org.apache.fulcrum.security.torque.om.TorqueBasicUserGroupPeer;
 import org.apache.fulcrum.security.torque.om.TorqueGroupPeer;
 import org.apache.fulcrum.security.torque.om.TorqueUserPeer;
@@ -27,25 +29,35 @@
 
 /**
  * @author <a href="mailto:[EMAIL PROTECTED]">Thomas Vandahl</a>
+ * @author <a href="[EMAIL PROTECTED]">J&#252;rgen Hoffmann</a>
  * @version $Id:$
  */
 public class TorqueBasicModelManagerTest extends AbstractModelManagerTest
 {
+    protected static HsqlDB hsqlDB = null;
+
     public void setUp() throws Exception
     {
+        if(hsqlDB == null)
+        {
+            this.hsqlDB = new HsqlDB("jdbc:hsqldb:.", 
"src/test/fulcrum-schema.sql");
+            hsqlDB.addSQL("src/test/id-table-schema.sql");
+            hsqlDB.addSQL("src/test/fulcrum-schema-idtable-init.sql");
+        }
         this.setRoleFileName("src/test/BasicTorqueRoleConfig.xml");
         
this.setConfigurationFileName("src/test/BasicTorqueComponentConfig.xml");
+
         securityService = (SecurityService) lookup(SecurityService.ROLE);
         super.setUp();
     }
-    
-       public void testRevokeAllUser() throws Exception
+
+    public void testRevokeAllUser() throws Exception
     {
-           super.testRevokeAllUser();
-               User user = userManager.getUserInstance("Clint2");
-               assertEquals(0, ((BasicUser) user).getGroups().size());
-       }
-    
+        super.testRevokeAllUser();
+        User user = userManager.getUserInstance("Clint2");
+        assertEquals(0, ((BasicUser) user).getGroups().size());
+    }
+
     public void tearDown()
     {
         // cleanup tables
@@ -55,11 +67,11 @@
             criteria.add(TorqueBasicUserGroupPeer.GROUP_ID, 0, 
Criteria.GREATER_THAN);
             criteria.add(TorqueBasicUserGroupPeer.USER_ID, 0, 
Criteria.GREATER_THAN);
             TorqueBasicUserGroupPeer.doDelete(criteria);
-            
+
             criteria.clear();
             criteria.add(TorqueUserPeer.USER_ID, 0, Criteria.GREATER_THAN);
             TorqueUserPeer.doDelete(criteria);
-            
+
             criteria.clear();
             criteria.add(TorqueGroupPeer.GROUP_ID, 0, Criteria.GREATER_THAN);
             TorqueGroupPeer.doDelete(criteria);
@@ -74,7 +86,7 @@
 
     /**
      * Constructor for TorqueBasicModelManagerTest.
-     *
+     * 
      * @param arg0
      */
     public TorqueBasicModelManagerTest(String arg0)

Modified: 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/dynamic/TorqueDynamicModelManagerTest.java
URL: 
http://svn.apache.org/viewvc/jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/dynamic/TorqueDynamicModelManagerTest.java?view=diff&rev=481671&r1=481670&r2=481671
==============================================================================
--- 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/dynamic/TorqueDynamicModelManagerTest.java
 (original)
+++ 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/dynamic/TorqueDynamicModelManagerTest.java
 Sat Dec  2 16:14:35 2006
@@ -1,4 +1,5 @@
 package org.apache.fulcrum.security.torque.dynamic;
+
 /*
  *  Copyright 2001-2004 The Apache Software Foundation
  *
@@ -17,6 +18,7 @@
 
 import org.apache.fulcrum.security.SecurityService;
 import 
org.apache.fulcrum.security.model.dynamic.test.AbstractDynamicModelManagerTest;
+import org.apache.fulcrum.security.torque.HsqlDB;
 import org.apache.fulcrum.security.torque.om.TorqueDynamicGroupRolePeer;
 import org.apache.fulcrum.security.torque.om.TorqueDynamicRolePermissionPeer;
 import org.apache.fulcrum.security.torque.om.TorqueDynamicUserDelegatesPeer;
@@ -30,15 +32,21 @@
 
 /**
  * @author <a href="mailto:[EMAIL PROTECTED]">Thomas Vandahl</a>
+ * @author <a href="[EMAIL PROTECTED]">J&#252;rgen Hoffmann</a>
  * @version $Id:$
  */
-public class TorqueDynamicModelManagerTest
-    extends AbstractDynamicModelManagerTest
+public class TorqueDynamicModelManagerTest extends 
AbstractDynamicModelManagerTest
 {
+    protected static HsqlDB hsqlDB = null;
+
     public void setUp()
     {
         try
         {
+            this.hsqlDB = new HsqlDB("jdbc:hsqldb:.", 
"src/test/fulcrum-schema.sql");
+            hsqlDB.addSQL("src/test/id-table-schema.sql");
+            hsqlDB.addSQL("src/test/fulcrum-schema-idtable-init.sql");
+
             this.setRoleFileName("src/test/DynamicTorqueRoleConfig.xml");
             
this.setConfigurationFileName("src/test/DynamicTorqueComponentConfig.xml");
             securityService = (SecurityService) lookup(SecurityService.ROLE);
@@ -58,11 +66,11 @@
             Criteria criteria = new Criteria();
             criteria.add(TorqueDynamicUserGroupPeer.USER_ID, 0, 
Criteria.GREATER_THAN);
             TorqueDynamicUserGroupPeer.doDelete(criteria);
-            
+
             criteria.clear();
             criteria.add(TorqueDynamicGroupRolePeer.GROUP_ID, 0, 
Criteria.GREATER_THAN);
             TorqueDynamicGroupRolePeer.doDelete(criteria);
-            
+
             criteria.clear();
             criteria.add(TorqueDynamicRolePermissionPeer.ROLE_ID, 0, 
Criteria.GREATER_THAN);
             TorqueDynamicRolePermissionPeer.doDelete(criteria);
@@ -74,7 +82,7 @@
             criteria.clear();
             criteria.add(TorqueUserPeer.USER_ID, 0, Criteria.GREATER_THAN);
             TorqueUserPeer.doDelete(criteria);
-            
+
             criteria.clear();
             criteria.add(TorqueGroupPeer.GROUP_ID, 0, Criteria.GREATER_THAN);
             TorqueGroupPeer.doDelete(criteria);
@@ -82,7 +90,7 @@
             criteria.clear();
             criteria.add(TorqueRolePeer.ROLE_ID, 0, Criteria.GREATER_THAN);
             TorqueRolePeer.doDelete(criteria);
-            
+
             criteria.clear();
             criteria.add(TorquePermissionPeer.PERMISSION_ID, 0, 
Criteria.GREATER_THAN);
             TorquePermissionPeer.doDelete(criteria);
@@ -97,7 +105,7 @@
 
     /**
      * Constructor for TorqueDynamicModelManagerTest.
-     *
+     * 
      * @param arg0
      */
     public TorqueDynamicModelManagerTest(String arg0)

Modified: 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/turbine/TorqueTurbineModelManagerTest.java
URL: 
http://svn.apache.org/viewvc/jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/turbine/TorqueTurbineModelManagerTest.java?view=diff&rev=481671&r1=481670&r2=481671
==============================================================================
--- 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/turbine/TorqueTurbineModelManagerTest.java
 (original)
+++ 
jakarta/turbine/fulcrum/trunk/security/torque/src/test/org/apache/fulcrum/security/torque/turbine/TorqueTurbineModelManagerTest.java
 Sat Dec  2 16:14:35 2006
@@ -17,6 +17,7 @@
 
 import org.apache.fulcrum.security.SecurityService;
 import 
org.apache.fulcrum.security.model.turbine.test.AbstractTurbineModelManagerTest;
+import org.apache.fulcrum.security.torque.HsqlDB;
 import org.apache.fulcrum.security.torque.om.TorqueGroupPeer;
 import org.apache.fulcrum.security.torque.om.TorquePermissionPeer;
 import org.apache.fulcrum.security.torque.om.TorqueRolePeer;
@@ -28,17 +29,23 @@
 
 /**
  * @author <a href="mailto:[EMAIL PROTECTED]">Thomas Vandahl</a>
+ * @author <a href="[EMAIL PROTECTED]">J&#252;rgen Hoffmann</a>
  * @version $Id:$
  */
 public class TorqueTurbineModelManagerTest
     extends AbstractTurbineModelManagerTest
 {
+    protected static HsqlDB hsqlDB = null;
 
     public void setUp() throws Exception
     {
 
         try
         {
+            this.hsqlDB = new HsqlDB("jdbc:hsqldb:.", 
"src/test/fulcrum-schema.sql");
+            hsqlDB.addSQL("src/test/id-table-schema.sql");
+            hsqlDB.addSQL("src/test/fulcrum-schema-idtable-init.sql");
+
             this.setRoleFileName("src/test/TurbineTorqueRoleConfig.xml");
             
this.setConfigurationFileName("src/test/TurbineTorqueComponentConfig.xml");
             securityService = (SecurityService) lookup(SecurityService.ROLE);



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to