SuperSQL SuperSQL 2016 6 30 1 SuperSQL ITC 2 SuperSQL 2.1 public html/ssql 2.2 SSedit SSedit (3.1 ) postgresql (ua123456 ) 131.113.101.124 /public html/ssql SuperSQL HTML /public html/ssql http://user.keio.ac.jp/ /ssql/xxxx.html URL ua012345 test.ssql ssql http://user.keio.ac.jp/ ua012345/ssql/test.html URL 1
3 3.1 SSedit ua012345% ssedit SuperSQL config.ssql log.txt( logs.txt) SSedit SSedit 3.2 ssql Putty SSedit ua012345% ssql HTML /public html/ssql.ssql 4 SuperSQL SQL SELECT GENERATE< media >< T F E > GENERATE < media > HTML PDF Excel L A TEX HTML < T F E > Target Form Expression 2
4.1 (,) (!) (%) 3 (,) : Name, Tel name tel (!) : Name! Tel name tel (%) : Name % Tel name tel 4.2 ([ ]) ( [ ], ) : [Name], name1 name2 name10 ( [ ]! ) : [Name]! 3
name1 name2 name10 [! [, ]! ]! [ ]!, [ ]!, [ ]! 4.3 SuperSQL TFE 1 :! [Name]! name1 name10 2 : {, Name}! {, Tel} name tel 4.4 FROM SuperSQL FROM SQL FROM dept, employee e 4
5 1: dept [ d.id, d.name, d.store, d.floor, d.manager ]! FROM dept d 2: [ d.name, [ e.name ]! ]! FROM dept d, employee e WHERE d.manager=e.manager 3: {"",""}! [ d.name, e.name]! FROM dept d, employee e WHERE d.manager=e.id 4: [ d.name, e1.name, [ e2.name ]! ]! FROM dept d, employee e1, employee e2 WHERE d.manager=e2.manager and e1.id=e2.manager 6 SuperSQL 5
6.1 SuperSQL ( ) <TFE>@{ < > } =, : width (px) : width=200 : height (px) : height=20 ( ): padding (px) : padding=2 : align(left/center/right) : align left : valign(top/center/bottom) : valign= top : background-color, bgcolor( : bgcolor= red /bgcolor= FF0000 : color, font-color : color= red /color= FF0000 : size, font-size(px) : font-size=20 : font-weight : font-weight= bold : font-style : font-style= italic CSS : style : style= font-variant: small-caps; font-weight: 900 : class : class= item 6
Name@{align= center, font-color= blue, font-size=20} width 100px 200px 300px 300px [ A, B ]! [ A@{width=100}, B@{width=200}]! 300px [ {A@{width=100},B@{width=200}}@{width=300}]! 100,200px 300px : cssfile : cssfile= demo.css CSS css ; charset : charset= utf-8 : author : author= takehiko : background : background= neko.gif : tablealign : tableborder : tableborder=1 7
Q0.ssql { { [e.name@{class="name"},e.salary@{class="salary"}, e.byear@{class="birth"}]! }@{title="member"} }@{cssfile="demo.css",charset="euc-jp"} Q0 css cssfile= demo.css demo.css demo.css http://ssql.db.ics.keio.ac.jp/demo.css 6.2 image image image image(, ) path SuperSQL HTML ( /public html/ssql) image width : 200 ( Pict /public html/ssql/picture/ ) Name, image(pict,./picture )@{width=200} 6.3 link FOREACH link FOREACH (%) (%) link FOREACH link FOREACH 8
(%) Q1.ssql Q1.ssql [e.name % {e.salary, e.syear}]! link FOREACH Q2.ssql Q3.ssql Q2.ssql [link(e.name, "Q3.ssql", e.id)]! Q3.ssql FOREACH e.id [e.salary, e.syear]! Q2.ssql Q3.ssql link FOREACH link FOREACH URL ( ) html 2 ( 2 ) link FOREACH (,) FOREACH link null link FOREACH link FOREACH link link 9
Q4.ssql [link(e.name@{target="_new"}, "Q3.ssql", e.id)]! link FOREACH http://ssql.db.ics.keio.ac.jp/demo/link/index.html titles.ssql film.ssql actor.ssql theater.ssql town.ssql http://ssql.db.ics.keio.ac.jp/demo/link/titles.html link FOREACH (%) 6.4 ( ) SuperSQL asc desc (ascending order): (asc) : (asc)e.name (descending order): (desc) : (desc)e.salary Q5-1.ssql [(asc)e.name, (desc)e.salary]! 10
Q5-2.ssql [(asc1)e.name, (desc2)e.salary]! Q6.ssql Q6.ssql [ (asc)d.name, [ (desc)e.name ]! ]! FROM dept d, employee e WHERE d.manager=e.manager 6.5 Aggregate Functions Aggregate Functions (max) (min) (avg) (sum) (count) Aggregate Function max[], min[], avg[], sum[], count[] Q7.ssql avg max min Q7.ssql [ e.name ]!, avg[e.salary] 6.6 Q8.ssql e.name 3 11
[ TFE ],number! number [name],5! [ TFE ]!number, number [name]!5, [ TFE ],number% number [name],5% [ TFE ]!number% number [name]!5% [ TFE ],number1!number2% number1 [name],5!4% number2 [ TFE ]!number1,number2% number1 [name]!5,4% number2 Q8.ssql [e.name],3! Q9.ssql e.name e.employee 3 5 Q9.ssql [e.name, e.salary],3!5% 6.7 null null Q10.ssql [null((desc1)e.salary), e.name]! 6.8 anchor anchor anchor a 12
anchor( URL) a("supersql","http://ssql.db.ics.keio.ac.jp/")! image_anchor( PATH, URL ) img_a("icon/ssql.png", "http://ssql.db.ics.keio.ac.jp/") 6.9 SuperSQL /* */ ( 2 ) ( 2 ) { [e.name /*@{class="name"}*/, e.salary]! }/*@{cssfile="demo.css"}*/ --,store s 7 db-ta16@db.ics.keio.ac.jp (24-205,209) http://ssql.db.ics.keio.ac.jp/tutorial/index.html 13