. ([ ],) : [Name] name1 name2 name10 ([ ]!). name1 name2 : [Name]! name (@) < >@{ < > } = [employee.name@{width=200 color=red}]! l

Size: px

Start display at page:

Download ". ([ ],) : [Name] name1 name2 name10 ([ ]!). name1 name2 : [Name]! name10 2. 3 (@) < >@{ < > } = [employee.name@{width=200 color=red}]! 2. 4 2. 4. 1 l"

ゆきこのえ
7 years ago
Views:

1 DEIM Forum 2015 C5-1 SuperSQL SSedit SuperSQL SQL SuperSQL SSedit SuperSQL SuperSQL link FOREACH 1. SuperSQL SQL SQL SQL SuperSQL HTML PHP Web SuperSQL SuperSQL SSedit SuperSQL SSedit SuperSQL 2 SuperSQL 3 SSedit SuperSQL SuperSQL SuperSQL SQL [1] [2]. SQL SELECT GENERATE< media >< TFE > GEN- ERATE. < media > HTML PDF. < TFE > Target Form Expression,, 2. 1 ( ), 3. (,). : Name Tel name tel (!). : Name! Tel (%) name tel 3. HTML. : Name % Tel name tel 2. 2 [ ]!,[ ]!,[ ]! [! [, ]! ]!

SuperSQL SQL SQL SQL SuperSQL HTML PHP Web SuperSQL SuperSQL SSedit SuperSQL SSedit SuperSQL 2 SuperSQL 3 SSedit 4 5 6 7. 2. SuperSQL SuperSQL SuperSQL SQL [1] [2].

2 . ([ ],) : [Name] name1 name2 name10 ([ ]!). name1 name2 : [Name]! name (@) < >@{ < > } = [employee.name@{width=200 color=red}]! 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 : SSedit 3. 1 SSedit SSedit GENERATE < media > FROM ; SuperSQL.ssql HTML

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]!

1 2 3 * 3. 2. 2.ssql 3. 2. 3 /preference 3.

3 1 2 3 * ssql /preference SSedit MacOS 1 Ctrl(Command)+Enter Esc or Ctrl(Command)+W SSedit Ctrl(Command)+S Ctrl(Command)+Z UNDO Ctrl(Command)+Y REDO Ctrl(Command) - +Alt(option)+ - Ctrl(Command)+D - - Ctrl(Command)+/ - Ctrl(Command)+K Ctrl(Command)+H Ctrl(Command)+F [e.id % {e.name@{color=yellow} {e.byear e.syear}}]! 4. 4 SSedit SuperSQL.(2.1,2.2 )

Ctrl(Command)+Z UNDO Ctrl(Command)+Y REDO Ctrl(Command) - +Alt(option)+ - Ctrl(Command)+D - -

TFE @{width100} (asc1) 4 5. 5. 1 5. 1. 1 1 Ctrl(Command)+F 1 5 5 5. 1. 2 5 6 5.

4 (asc1) Ctrl(Command)+F % 2 1 ( ) html 1 2 link FOREACH link FOREACH ( ) link FOREACH 1 ( ) link FOREACH 2 SuperSQL ( ) 7 link ( xxx link1-1.ssql) ( xxx foreach1-1.ssql) xxx link1-1.ssql xxx foreach1-1.ssql : % link att % 8

5 10 7 att 2 att att 2 (,). 8 att 5. 3 SuperSQL 10 simpleviewer 5. 4 SuperSQL SuperSQL FROM CSS ( ) 1 6. SuperSQL

6 SSedit SuperSQL SuperSQL SSedit SuperSQL emacs vi ssql SuperSQL 6. 1 SuperSQL SSedit SSedit SSedit SSedit SuperSQL 13 SuperSQL SuperSQL SSedit SSedit 2 SuperSQL ITC SSedit SSedit SSedit 7. SuperSQL SuperSQL SSedit SuperSQL %

2 2 12 16 1 SuperSQL 13 SuperSQL SuperSQL SSedit SSedit 2 SuperSQL 12

7 SuperSQL SSedit SSedit SuperSQL [1] SuperSQL: [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 [3] : SuperSQL Web 2009 [4] : SuperSQL 6 (DEIM) 2014 [5] pgadmin: [6] SQLiteStudio:

of ACM SIG- MOD 98 International Conference on Management of Data pp 584-586 1998 [3] : SuperSQL

([ ],), : [Name], name1 name2 name10 4, 2 SuperSQL, ([ ]!), name1 name2 : [Name]! name10 2. 3 SuperSQL,,,,,,, < < > } =,

([ ],), : [Name], name1 name2 name10 4, 2 SuperSQL, ([ ]!), name1 name2 : [Name]! name10 2. 3 SuperSQL,,,,,,, < < > } =, DEIM Forum 2014 E3-5 SuperSQL 223-8522 3-14-1 E-mail: {masato,goto}@db.ics.keio.ac.jp, toyama@ics.keio.ac.jp SuperSQL, SQL, SuperSQL ssqltool, ssqltool, SuperSQL, Viewer Viewer, SuperSQL,,,, HTML, 1. SQL,