summaryrefslogtreecommitdiffstats
path: root/datarouter-prov/src/test/resources/create.sql
diff options
context:
space:
mode:
authorRam Koya <rk541m@att.com>2018-09-07 01:14:57 +0000
committerGerrit Code Review <gerrit@onap.org>2018-09-07 01:14:57 +0000
commit26311ae5220efa4460c03284d0a47b2def420ecb (patch)
tree8c033fcf195944f23451b827ae02cfe2584bac16 /datarouter-prov/src/test/resources/create.sql
parent5cbbe749bfb23c1ab24aec01fdd3f3f4b2e36ce9 (diff)
parent1d9710279b4d9bffacc0f8e360922119bb12e347 (diff)
Merge "unit test for StastisticsServlet with db"
Diffstat (limited to 'datarouter-prov/src/test/resources/create.sql')
-rwxr-xr-xdatarouter-prov/src/test/resources/create.sql11
1 files changed, 10 insertions, 1 deletions
diff --git a/datarouter-prov/src/test/resources/create.sql b/datarouter-prov/src/test/resources/create.sql
index 9ae11cb6..2f9d3d9c 100755
--- a/datarouter-prov/src/test/resources/create.sql
+++ b/datarouter-prov/src/test/resources/create.sql
@@ -164,4 +164,13 @@ 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
+VALUES (2,0);
+
+insert into LOG_RECORDS(RECORD_ID,TYPE,EVENT_TIME,PUBLISH_ID,FEEDID,REQURI,METHOD,CONTENT_TYPE,CONTENT_LENGTH,FEED_FILEID,REMOTE_ADDR,USER,STATUS,DELIVERY_SUBID,DELIVERY_FILEID,RESULT,ATTEMPTS,REASON)
+VALUES(1,'pub',2536159564422,'ID',1,'URL','GET','application/vnd.att-dr.log-list; version=1.0',100,1,'172.0.0.8','user',204,1,1,204,0,'other');
+
+CREATE ALIAS IF NOT EXISTS `SUBSTRING_INDEX` AS $$
+ String Function(String one, String two, String three){
+ return "url";
+ }
+$$; \ No newline at end of file