From: INOPIAE Date: Sat, 17 Aug 2019 12:12:20 +0000 (+0200) Subject: add: add sample data and instructions for locale testing X-Git-Url: https://code.wpia.club/?p=gigi.git;a=commitdiff_plain;h=ecd765ea7c23977857d0f3509da235bcdc3d23e1 add: add sample data and instructions for locale testing Change-Id: I85dcd7e3d3c6e326c4a174b811c5f03f97986093 --- diff --git a/doc/beforeYouStart.txt b/doc/beforeYouStart.txt index 8446f058..1b9e7ff8 100644 --- a/doc/beforeYouStart.txt +++ b/doc/beforeYouStart.txt @@ -15,3 +15,8 @@ Before you start using you might want to: - on unix-like systems: to securely run on privileged ports <= 1024 build the native setuid library (run the makefile in natives/). This expects JAVA_HOME to be set. +For local testing you should: +- start util-testing/club/wpia/gigi/DevelLauncher.java and util-testing/club/wpia/gigi/util/SimpleSigner.java +- use the doc/sampleData.sql.template to create a doc/sampleData.sql file with a testing user. + If you start the local test environment with util-testing/club/wpia/gigi/DevelLauncher.java, this user is automatically logged into the system via ticket bypass. +- in the case while starting the application a database error occurs use util-testing/club/wpia/gigi/util/DatabaseManager.java to adjust the database to the current requirements diff --git a/doc/sampleData.sql.template b/doc/sampleData.sql.template new file mode 100644 index 00000000..784032f2 --- /dev/null +++ b/doc/sampleData.sql.template @@ -0,0 +1,63 @@ +--Version: 37 + +ALTER SEQUENCE `certOwners_id_seq` RESTART WITH 6; +ALTER SEQUENCE `names_id_seq` RESTART WITH 4; + +INSERT INTO `certOwners`(id) VALUES(1); +INSERT INTO `certOwners`(id) VALUES(2); + + +INSERT INTO users SET email='c@d.ef', password='86f7e437faa5a7fce15d1ddcb9eaeaea377667b8', verified='1', dob='1910-01-01', id=1, language='en', preferredName=1; +INSERT INTO "names" SET "uid"=1, "id"=1, "type"='western'; +INSERT INTO "nameParts" SET "id"=1, position=0, "value"='Kürti', "type"='first-name'; +INSERT INTO "nameParts" SET "id"=1, position=1, "value"='Müddle', "type"='first-name'; +INSERT INTO "nameParts" SET "id"=1, position=2, "value"='Hänsel', "type"='last-name'; +INSERT INTO "nameParts" SET "id"=1, position=3, "value"='Baron', "type"='suffix'; + +INSERT INTO emails SET email='c@d.ef', memid=1; +INSERT INTO "emailPinglog" SET email='c@d.ef', uid=1, `when`=CURRENT_TIMESTAMP, type='active', status='success', result='', challenge=NULL; + +INSERT INTO notary SET `from`=1, `to`=1, points=100, location='initial', `when`=CURRENT_TIMESTAMP, `date`='1950-01-01'; +INSERT INTO `cats_passed` SET user_id=1, variant_id=1; + +INSERT INTO user_groups SET `user`=1, permission='codesigning', grantedby='1'; + +INSERT INTO user_groups SET `user`=1, permission='ttp-agent', grantedby='1'; +INSERT INTO user_groups SET `user`=1, permission='supporter', grantedby='1'; +INSERT INTO `cats_passed` SET user_id=1, variant_id=3; +INSERT INTO `cats_passed` SET user_id=1, variant_id=7; + + +INSERT INTO users SET email='test1@d.ef', password='86f7e437faa5a7fce15d1ddcb9eaeaea377667b8', verified='1', dob='1910-01-01', id=2, preferredName=2; +INSERT INTO "names" SET "uid"=2, "id"=2, "type"='western'; +INSERT INTO "nameParts" SET "id"=2, position=0, "value"='First', "type"='first-name'; +INSERT INTO "nameParts" SET "id"=2, position=1, "value"='Last', "type"='last-name'; +INSERT INTO "names" SET "uid"=2, "id"=3, "type"='western'; +INSERT INTO "nameParts" SET "id"=3, position=0, "value"='First2', "type"='first-name'; +INSERT INTO "nameParts" SET "id"=3, position=1, "value"='Lasteres', "type"='last-name'; + +INSERT INTO `certOwners`(id) VALUES(3); +INSERT INTO organisations SET `id`=3, `name`='Test Ltd.', country='DE', province='BW', city='Stuttgart', contactEmail='test@ltd.lt', creator='1'; +INSERT INTO org_admin SET `orgid`=3, `memid`=1, creator=1, master='y'; + +INSERT INTO `certOwners`(id) VALUES(4); +INSERT INTO organisations SET `id`=4, `name`='Test Ltd. of First Last', country='DE', province='BW', city='Stuttgart', contactEmail='test@ltd.lt', creator='1'; +INSERT INTO org_admin SET `orgid`=4, `memid`=2, creator=1, master='y'; +INSERT INTO org_admin SET `orgid`=4, `memid`=1, creator=1, master='n'; + +INSERT INTO `cats_passed` SET user_id=1, variant_id=2; +INSERT INTO `cats_passed` SET user_id=2, variant_id=2; + +-- +-- +--INSERT INTO `certOwners`(id) VALUES(5); +--INSERT INTO organisations SET `id`=5, `name`='Test Server Management Ltd.', country='DE', province='BW', city='Stuttgart', contactEmail='test@ltd.lt', creator='1'; +--INSERT INTO org_admin SET `orgid`=5, `memid`=1, creator=1, master='y'; + +--INSERT INTO domains (id, memid, domain, created, modified, deleted) VALUES (1, 5, 'local.test.benny-baumann.de', '2016-08-26 12:38:50.19', NULL, NULL); +--ALTER SEQUENCE `domains_id_seq` RESTART WITH 2; +--INSERT INTO pingconfig (id, domainid, type, info, deleted) VALUES (1, 1, 'dns', 'qmOhuUmv:KZkT4tbkztfpUsfv', NULL); +--INSERT INTO pingconfig (id, domainid, type, info, deleted) VALUES (2, 1, 'http', 'qmOhuUmv:KZkT4tbkztfpUsfv', NULL); +--ALTER SEQUENCE `pingconfig_id_seq` RESTART WITH 3; +--INSERT INTO "domainPinglog" ("configId", state, challenge, result) VALUES (1, 'success', NULL, 'Succeeded by TestManager pass-by'); +--INSERT INTO "domainPinglog" ("configId", state, challenge, result) VALUES (2, 'success', NULL, 'Succeeded by TestManager pass-by');