apisub_dataset.sql 532 Bytes
Newer Older
Stephane Crozat's avatar
Fix #9  
Stephane Crozat committed
1
2
/** Test dataset **/
DELETE FROM api;
Stephane Crozat's avatar
Stephane Crozat committed
3
4
5
DELETE FROM localuser;

INSERT INTO localuser (utclogin) VALUES ('crozatst');
Stephane Crozat's avatar
Fix #9  
Stephane Crozat committed
6
7

INSERT INTO api VALUES (
Stephane Crozat's avatar
Stephane Crozat committed
8
  TO_DATE('20190121','yyyymmdd'),1,'Poésie et ingénierie','Lorem ipsum dolor sit amet',5,24,2,'crozatst'
Stephane Crozat's avatar
Fix #9  
Stephane Crozat committed
9
10
);
INSERT INTO api VALUES (
Stephane Crozat's avatar
Stephane Crozat committed
11
  TO_DATE('20190125','yyyymmdd'),2,'Cloud big data blockchain IA','At vero eos et accusamus',3,12,1,'crozatst'
Stephane Crozat's avatar
Fix #9  
Stephane Crozat committed
12
);
Stephane Crozat's avatar
Stephane Crozat committed
13
14
15
16
17
18

SELECT * FROM vapi;
SELECT * FROM vlocaluser;
SELECT * FROM vsubscription;
SELECT * FROM vsubscription_anonymous;
SELECT * FROM vapi_count;