continuum-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From car...@apache.org
Subject svn commit: r432782 - in /maven/continuum/branches/continuum-acegi/continuum-security/continuum-security-acegi: pom.xml src/main/resources/org/apache/maven/continuum/security/acegi/acl/acegi-acl-derby.sql
Date Sat, 19 Aug 2006 02:20:03 GMT
Author: carlos
Date: Fri Aug 18 19:20:02 2006
New Revision: 432782

URL: http://svn.apache.org/viewvc?rev=432782&view=rev
Log:
[CONTINUUM-822] First pass to test ACL database creation

Modified:
    maven/continuum/branches/continuum-acegi/continuum-security/continuum-security-acegi/pom.xml
    maven/continuum/branches/continuum-acegi/continuum-security/continuum-security-acegi/src/main/resources/org/apache/maven/continuum/security/acegi/acl/acegi-acl-derby.sql

Modified: maven/continuum/branches/continuum-acegi/continuum-security/continuum-security-acegi/pom.xml
URL: http://svn.apache.org/viewvc/maven/continuum/branches/continuum-acegi/continuum-security/continuum-security-acegi/pom.xml?rev=432782&r1=432781&r2=432782&view=diff
==============================================================================
--- maven/continuum/branches/continuum-acegi/continuum-security/continuum-security-acegi/pom.xml
(original)
+++ maven/continuum/branches/continuum-acegi/continuum-security/continuum-security-acegi/pom.xml
Fri Aug 18 19:20:02 2006
@@ -61,6 +61,26 @@
           </execution>
         </executions>
       </plugin>
+      <plugin>
+        <groupId>org.codehaus.mojo</groupId>
+        <artifactId>sql-maven-plugin</artifactId>
+        <dependencies>
+          <dependency>
+            <groupId>org.apache.derby</groupId>
+            <artifactId>derby</artifactId>
+            <version>10.1.2.1</version>
+          </dependency>
+        </dependencies>
+        <configuration>
+          <url>jdbc:derby:${basedir}/target/database;create=true</url>
+          <driver>org.apache.derby.jdbc.EmbeddedDriver</driver>
+          <username>sa</username>
+          <password></password>
+          <srcFiles>
+            <srcFile>src/main/resources/org/apache/maven/continuum/security/acegi/acl/acegi-acl-derby.sql</srcFile>
+          </srcFiles>
+        </configuration>
+      </plugin>
     </plugins>
   </build>
 

Modified: maven/continuum/branches/continuum-acegi/continuum-security/continuum-security-acegi/src/main/resources/org/apache/maven/continuum/security/acegi/acl/acegi-acl-derby.sql
URL: http://svn.apache.org/viewvc/maven/continuum/branches/continuum-acegi/continuum-security/continuum-security-acegi/src/main/resources/org/apache/maven/continuum/security/acegi/acl/acegi-acl-derby.sql?rev=432782&r1=432781&r2=432782&view=diff
==============================================================================
--- maven/continuum/branches/continuum-acegi/continuum-security/continuum-security-acegi/src/main/resources/org/apache/maven/continuum/security/acegi/acl/acegi-acl-derby.sql
(original)
+++ maven/continuum/branches/continuum-acegi/continuum-security/continuum-security-acegi/src/main/resources/org/apache/maven/continuum/security/acegi/acl/acegi-acl-derby.sql
Fri Aug 18 19:20:02 2006
@@ -1,7 +1,7 @@
-DROP TABLE acl_object_identity;
+CREATE SCHEMA sa;
 
 CREATE TABLE acl_object_identity (
-     id INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY CONSTRAINT acl_object_identity_PK PRIMARY
KEY,
+     id INTEGER NOT NULL CONSTRAINT acl_object_identity_PK PRIMARY KEY,
      object_identity VARCHAR(250) NOT NULL,
      parent_object INTEGER,
      acl_class VARCHAR(250) NOT NULL,
@@ -9,8 +9,6 @@
      FOREIGN KEY (parent_object) REFERENCES acl_object_identity(id)
 );
 
-DROP TABLE acl_object_identity;
-
 CREATE TABLE acl_permission (
      id INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY CONSTRAINT acl_permission_PK PRIMARY
KEY,
      acl_object_identity INTEGER NOT NULL,
@@ -20,15 +18,15 @@
      FOREIGN KEY (acl_object_identity) REFERENCES acl_object_identity(id)
 );
 
-INSERT INTO acl_object_identity VALUES (1, 'corp.DomainObject:1', null, 'org.acegisecurity.acl.basic.SimpleAclEntry');
-INSERT INTO acl_object_identity VALUES (2, 'corp.DomainObject:2', 1, 'org.acegisecurity.acl.basic.SimpleAclEntry');
-INSERT INTO acl_object_identity VALUES (3, 'corp.DomainObject:3', 1, 'org.acegisecurity.acl.basic.SimpleAclEntry');
-INSERT INTO acl_object_identity VALUES (4, 'corp.DomainObject:4', 1, 'org.acegisecurity.acl.basic.SimpleAclEntry');
-INSERT INTO acl_object_identity VALUES (5, 'corp.DomainObject:5', 3, 'org.acegisecurity.acl.basic.SimpleAclEntry');
-INSERT INTO acl_object_identity VALUES (6, 'corp.DomainObject:6', 3, 'org.acegisecurity.acl.basic.SimpleAclEntry');
+INSERT INTO acl_object_identity VALUES (1, 'org.apache.maven.continuum.model.project.Project:1',
null, 'org.acegisecurity.acl.basic.SimpleAclEntry');
+INSERT INTO acl_object_identity VALUES (2, 'org.apache.maven.continuum.model.project.Project:2',
1, 'org.acegisecurity.acl.basic.SimpleAclEntry');
+INSERT INTO acl_object_identity VALUES (3, 'org.apache.maven.continuum.model.project.Project:3',
1, 'org.acegisecurity.acl.basic.SimpleAclEntry');
+INSERT INTO acl_object_identity VALUES (4, 'org.apache.maven.continuum.model.project.Project:4',
1, 'org.acegisecurity.acl.basic.SimpleAclEntry');
+INSERT INTO acl_object_identity VALUES (5, 'org.apache.maven.continuum.model.project.Project:5',
3, 'org.acegisecurity.acl.basic.SimpleAclEntry');
+INSERT INTO acl_object_identity VALUES (6, 'org.apache.maven.continuum.model.project.Project:6',
3, 'org.acegisecurity.acl.basic.SimpleAclEntry');
 
-INSERT INTO acl_permission VALUES (null, 1, 'ROLE_SUPERVISOR', 1);
-INSERT INTO acl_permission VALUES (null, 2, 'ROLE_SUPERVISOR', 0);
-INSERT INTO acl_permission VALUES (null, 2, 'marissa', 2);
-INSERT INTO acl_permission VALUES (null, 3, 'scott', 14);
-INSERT INTO acl_permission VALUES (null, 6, 'scott', 1);
+INSERT INTO acl_permission (acl_object_identity, recipient, mask) VALUES (1, 'ROLE_ADMIN',
1);
+INSERT INTO acl_permission (acl_object_identity, recipient, mask) VALUES (2, 'ROLE_ADMIN',
0);
+INSERT INTO acl_permission (acl_object_identity, recipient, mask) VALUES (2, 'marissa', 2);
+INSERT INTO acl_permission (acl_object_identity, recipient, mask) VALUES (3, 'scott', 14);
+INSERT INTO acl_permission (acl_object_identity, recipient, mask) VALUES (6, 'scott', 1);



Mime
View raw message