DEIM Forum 2016 D4-4 SStest: SuperSQL 223-8522 3-14-1 E-mail: {rima,goto,masato}@db.ics.keio.ac.jp, toyama@ics.keio.ac.jp SuperSQL SQL SuperSQL,., SuperSQL,, (SStest). SStest GUI SuperSQL, SuperSQL. GUI, SuperSQL. 1. SQL, SuperSQL, RegressionTest SuperSQL, SQL SQL,, SuperSQL, SuperSQL, HTML PHP Web,., SuperSQL,, SuperSQL, SuperSQL,, SuperSQL, SuperSQL (SStest) SStest, GUI SuperSQL SStest,, SuperSQL. GUI, SuperSQL., 2 SuperSQL, 3 SuperSQL., 4 SStest, 5., 6, 7. 2. SuperSQL GENERATE< media >< TFE > GENERATE. < media >, HTML, PDF < TFE > Target Form Expression,, 2. 1 ( ), 3. (,) : Name, Age name age (!) : Name! Age (%) name age 3 HTML : Name % Age name age 2. 2.,, SuperSQL. SuperSQL, SQL, [1] [2]. SQL SELECT [ ]!,[ ]!,[ ]!,
, [! [, ]! ]!,,., ([ ],). : [Name], name1 name2 name10 ([ ]!). name1 name2 : [Name]! name10 2. 3 SuperSQL,,,,,,, (@) < >@{ < > } =., [employee.name@{width=200, color=red}]! 2. 4 2. 4. 1 link ( HTML ) link, FOREACH., link FOREACH. link, FOREACH.. Q1.ssql GENERATE HTML [e.name % {e.salary, e.syear}]! FROM employee e link FOREACH, Q2.ssql Q3.ssql. Q2.ssql GENERATE HTML [link(e.name, file="q3.ssql", att=e.id)]! FROM employee e Q3.ssql FOREACH e.id GENERATE HTML [e.salary, e.syear]! FROM employee e link FOREACH file=., link att= FORE- ACH. URL, (), 2 ( 2 ), link att1 att2 att3..., FOREACH (,) 3. SuperSQL SuperSQL,, SuperSQL., SuperSQL, SuperSQL.,, SuperSQL., SuperSQL,,, SuperSQL,,,,,,,., SuperSQL,,., SuperSQL, SuperSQL, SuperSQL (SStest), SuperSQL. SStest, SuperSQL, SuperSQL., GUI,, SStest,,
1 3 2 4 4. SStest 4. 1 SStest Java Java. SStest, SuperSQL GUI. 5,,,, 1, 1. 4. 2 SStest TestRun, TestCaseList, TagList, Preference 4 1, 2, 3, 4 4. 2. 1 TestRun,,.. (Execute),,.,,,.,.,,. 5 4. 2. 2 TestCaseList,. (Delete),
(Detail).,. SuperSQL,,, HTML. 4. 2. 3 TagList,,,,,, (Detail), 4. 3. 2 7 SStest, SuperSQL. SuperSQL,,.,.,.,,.,, 4. 2. 4 /preference, SuperSQL,,,,,. 7 4. 3 SStest 4. 3. 1 6,, SStest,.,,,., SuperSQL, SuprtSQL. 4. 3. 3 8, SStest (replace),, SStest,,,,,. 8 5. SuperSQL.,, SuperSQL, SuperSQL,,. 6
5. 1 SuperSQL, SuperSQL,,,, 5. 2 SuperSQL SuperSQL 9 GENER- ATE HTML, HTML, SuperSQL 1, HTML JavaScript CSS.,. 10,,,,, 5. 4 SuperSQL,, HTML.,. 5. 5,.,,,. diff,,,. ( 11) 9 SuperSQL 11 10 SuperSQL 5. 3 SuperSQL SuperSQL, SuperSQL, SuperSQL SuperSQL 2. SuperSQL, SuperSQL,. SuperSQL,,.,,,.,. replace, 6. (SStest), 2 1, SuperSQL 2. 6. 1 SStest, SuperSQL,.,,.
SuperSQL SuperSQL GUI,. 6. 2 6. 2. 1 SuperSQL, PostgreSQL [3] PostgreSQL PostgreSQL, SQL,, PostgreSQL. 1 1 PostgreSQL SStest GUI (, ) ( ) diff,, PostgreSQL, SStest GUI.,, PostgreSQL,,.,,, SuperSQL,,.,,., diff,, diff, SStest GUI, diff, diff, SStest,, PostgreSQL,,, SStest GUI 6. 2. 2 SStest., TestLink [4] Redmine [5] impasse [6]. 2. 2 TestLink impasse SStest () / /, (),,, TestLink.,,. SStest,, SuperSQL,,,, TestLink impasse. SStest,,..,,, SStest,,,, SStest, SuperSQL,,
7., SuperSQL. SuperSQL,,,,.,, [1] SuperSQL: http://supersql.db.ics.keio.ac.jp/ [2] M. Toyama: SuperSQL: An Extended SQL for Database Publishing and Presentation, Proceedings of ACM SIG- MOD 98 International Conference on Management of Data, pp. 584-586, 1998 [3] PostgreSQL http://www.postgresql.org [4] TestLink http://testlink.org [5] Redmine http://www.redmine.org [6] impasse https://www.redmine.org/plugins/impasse