apisub_dataset.sql

/** Test dataset **/
BEGIN;

DELETE FROM api;
DELETE FROM localuser;

INSERT INTO localuser (utclogin) VALUES ('crozatst');
INSERT INTO localuser (utclogin) VALUES ('prof1');
INSERT INTO localuser (utclogin) VALUES ('student1');
INSERT INTO localuser (utclogin) VALUES ('student2');
INSERT INTO localuser (utclogin) VALUES ('student3');

INSERT INTO api VALUES (
  '1e06e8dc-2178-11e9-8edb-4bc5e8f8599c',
  TO_DATE('20190121','yyyymmdd'),1,'Poésie et ingénierie','Lorem ipsum dolor sit amet',5,24,2,'crozatst'
);
INSERT INTO api VALUES (
  '2afa8472-2178-11e9-b2b0-07511495b3b2',
  TO_DATE('20190128','yyyymmdd'),2,'Cloud big data blockchain IA','At vero eos et accusamus',3,12,1,'crozatst'
);
INSERT INTO api VALUES (
  '4352b3a0-217d-11e9-aabc-037b6e1a6a16',
  TO_DATE('20190121','yyyymmdd'),3,'La TRM et la G1','Duis rhoncus turpis non libero auctor posuere.',5,50,2,'prof1'
);

INSERT INTO subscribe (utclogin,api,subdate) VALUES (
  'student1','1e06e8dc-2178-11e9-8edb-4bc5e8f8599c',TO_DATE('20190121','yyyymmdd')
);
INSERT INTO subscribe (utclogin,api,subdate) VALUES (
  'student1','2afa8472-2178-11e9-b2b0-07511495b3b2',TO_DATE('20190121','yyyymmdd')
);
INSERT INTO subscribe (utclogin,api,subdate) VALUES (
  'student1','4352b3a0-217d-11e9-aabc-037b6e1a6a16',TO_DATE('20190121','yyyymmdd')
);
INSERT INTO subscribe (utclogin,api,subdate) VALUES (
  'student2','1e06e8dc-2178-11e9-8edb-4bc5e8f8599c',TO_DATE('20190121','yyyymmdd')
);

SELECT id, normcode, name FROM vapi;
SELECT * FROM vlocaluser;
SELECT utclogin, id, normcode FROM vsubscription;
SELECT * FROM vapi_count;

COMMIT;