diff options
author | Trygve Laugstøl <trygvis@inamo.no> | 2012-11-19 18:04:49 +0100 |
---|---|---|
committer | Trygve Laugstøl <trygvis@inamo.no> | 2012-11-19 18:05:27 +0100 |
commit | af92579129943acac73542f4e05e1c7faeda0994 (patch) | |
tree | efa76694deade25434fdfb359c130b278d6b608f /src/main/resources | |
parent | 389b8373b7f04a5bdb039b9b690daa12a50fb144 (diff) | |
download | esper-testing-af92579129943acac73542f4e05e1c7faeda0994.tar.gz esper-testing-af92579129943acac73542f4e05e1c7faeda0994.tar.bz2 esper-testing-af92579129943acac73542f4e05e1c7faeda0994.tar.xz esper-testing-af92579129943acac73542f4e05e1c7faeda0994.zip |
o Adding logic to stop fetching pages when Gitorious returns non-XML response.
o Adding support for self-signed certificates with https.
o Moving client code to GitoriousClient.
o Adding Nexus client and an importer that fetches all artifacts.
o A nexus client that actually fetches the entire set of artifacts.
Diffstat (limited to 'src/main/resources')
-rwxr-xr-x[-rw-r--r--] | src/main/resources/ddl-core.sql | 7 | ||||
-rwxr-xr-x[-rw-r--r--] | src/main/resources/ddl-gitorious.sql | 3 | ||||
-rwxr-xr-x | src/main/resources/ddl-nexus.sql | 23 | ||||
-rwxr-xr-x | src/main/resources/gitorious.org.sql | 11 |
4 files changed, 36 insertions, 8 deletions
diff --git a/src/main/resources/ddl-core.sql b/src/main/resources/ddl-core.sql index 662ed10..8201c31 100644..100755 --- a/src/main/resources/ddl-core.sql +++ b/src/main/resources/ddl-core.sql @@ -10,11 +10,8 @@ CREATE TABLE subscriber ( CREATE TABLE subscription_gitorious_repository ( subscriber_name VARCHAR(100) REFERENCES subscriber (name), gitorious_repository_project_slug VARCHAR(100), - gitorious_repository_name VARCHAR(100) --- CONSTRAINT subscription_gitorious_repository_2_gitorious_repository FOREIGN KEY (gitorious_repository_project_slug, gitorious_repository_name) REFERENCES gitorious_repository (project_slug, name) + gitorious_repository_name VARCHAR(100), + CONSTRAINT gitorious_repository FOREIGN KEY (gitorious_repository_project_slug, gitorious_repository_name) REFERENCES gitorious_repository (project_slug, name) ); -INSERT INTO subscriber VALUES ('trygvis'); -INSERT INTO subscription_gitorious_repository VALUES ('trygvis','esper-test-project', 'esper-test-project'); - COMMIT; diff --git a/src/main/resources/ddl-gitorious.sql b/src/main/resources/ddl-gitorious.sql index 929a326..121a4ff 100644..100755 --- a/src/main/resources/ddl-gitorious.sql +++ b/src/main/resources/ddl-gitorious.sql @@ -37,7 +37,4 @@ CREATE TABLE gitorious_event ( commit_count INTEGER ); -INSERT INTO gitorious_project VALUES ('esper-test-project'); -INSERT INTO gitorious_repository VALUES ('esper-test-project', 'esper-test-project', 'https://gitorious.org/esper-test-project/esper-test-project.atom'); - COMMIT; diff --git a/src/main/resources/ddl-nexus.sql b/src/main/resources/ddl-nexus.sql new file mode 100755 index 0000000..eaa0938 --- /dev/null +++ b/src/main/resources/ddl-nexus.sql @@ -0,0 +1,23 @@ +BEGIN; + +DROP TABLE IF EXISTS nexus_event; +DROP TABLE IF EXISTS nexus_repository; + +CREATE TABLE nexus_repository ( + id VARCHAR(1000) PRIMARY KEY, + discovered_date TIMESTAMP, + last_update TIMESTAMP, + last_successful_update TIMESTAMP +); + +CREATE TABLE nexus_event ( + repository_id VARCHAR(1000) NOT NULL, + + groupId VARCHAR(100), + artifactId VARCHAR(100), + version VARCHAR(100), + files VARCHAR(100), + CONSTRAINT nexus_repository_fk FOREIGN KEY (repository_id) REFERENCES nexus_repository (id) +); + +COMMIT; diff --git a/src/main/resources/gitorious.org.sql b/src/main/resources/gitorious.org.sql new file mode 100755 index 0000000..51a015b --- /dev/null +++ b/src/main/resources/gitorious.org.sql @@ -0,0 +1,11 @@ +-- Test data for my projects at gitorious.org +BEGIN; + +INSERT INTO gitorious_project VALUES ('esper-test-project'); +INSERT INTO gitorious_repository VALUES ('esper-test-project', 'esper-test-project', 'https://gitorious.org/esper-test-project/esper-test-project.atom'); + +INSERT INTO subscriber VALUES ('trygvis'); +INSERT INTO subscription_gitorious_repository VALUES ('trygvis', 'esper-test-project', 'esper-test-project'); + +COMMIT; +- |