summaryrefslogtreecommitdiffstats
path: root/datarouter-prov/src/test/resources/create.sql
diff options
context:
space:
mode:
authorEmmett Cox <emmett.cox@ericsson.com>2018-09-03 11:43:13 +0100
committerEmmett Cox <emmett.cox@ericsson.com>2018-09-04 14:35:54 +0100
commit096e977af0f6603359311031bab1a994e1beddd5 (patch)
treebea506013b5ca02de5fd10b9dfac97f039b42495 /datarouter-prov/src/test/resources/create.sql
parente78029abb4dd73bf14e0291096d5b6762c55739b (diff)
DB reworking for PublishServletTest
Change-Id: Ie6dc40d2eb1533c1eef637ea7e2683556bb4f4a7 Signed-off-by: Emmett Cox <emmett.cox@ericsson.com> Issue-ID: DMAAP-101
Diffstat (limited to 'datarouter-prov/src/test/resources/create.sql')
-rwxr-xr-xdatarouter-prov/src/test/resources/create.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/datarouter-prov/src/test/resources/create.sql b/datarouter-prov/src/test/resources/create.sql
index 90484ab0..d2df2496 100755
--- a/datarouter-prov/src/test/resources/create.sql
+++ b/datarouter-prov/src/test/resources/create.sql
@@ -147,3 +147,15 @@ VALUES (1, 'Basic dXNlcjE6cGFzc3dvcmQx', 'Group1', 'First Group for testing', 'C
INSERT INTO SUBSCRIPTIONS(SUBID, FEEDID, DELIVERY_URL, DELIVERY_USER, DELIVERY_PASSWORD, SUBSCRIBER, SELF_LINK, LOG_LINK)
VALUES (23, 1, 'http://delivery_url', 'user1', 'somepassword', 'sub123', 'selflink', 'loglink');
+
+INSERT INTO FEEDS(FEEDID, GROUPID, NAME, VERSION, DESCRIPTION, BUSINESS_DESCRIPTION, AUTH_CLASS, PUBLISHER, SELF_LINK, PUBLISH_LINK, SUBSCRIBE_LINK, LOG_LINK)
+VALUES (1, 1,'Feed1','v0.1', 'First Feed for testing', 'First Feed for testing', 'auth_class', 'pub','self_link','publish_link','subscribe_link','log_link');
+
+insert into INGRESS_ROUTES(SEQUENCE, FEEDID , USERID, SUBNET, NODESET)
+VALUES (1,1,'user',null,2);
+
+insert into INGRESS_ROUTES(SEQUENCE, FEEDID , USERID, SUBNET, NODESET)
+VALUES (2,1,'user',null,2);
+
+insert into NODESETS(SETID, NODEID)
+VALUES (2,0); \ No newline at end of file