README for hyogen
=================
1. ?????c?[??????????
?@CSV?f?[?^??Excel?t?@?C???? Ruby?I?u?W?F?N?g???C?????f?[?^?`?????????????c?[???????B
?@?\?`?????f?[?^?????\?[?X?R?[?h??HTML?t?@?C?????e???????????????????????????????????W?????B
?@?\?f?[?^???\???\?????????^?O?????????????????????A?\???????p?[?X???????????R?[?h???????????? Ruby?I?u?W?F?N?g??
?@?C?????e???v???[?g?`???????????????????????????B
2. ?c?[?????J?o?[????????
?@?????c?[?????????P???\?A?????????o?????l?????????????f?[?^?W???????????????????????B???o?????K?w???????????????\?????B???????\???????????f?[?^???????????????\?????B???????A?????q?????????\?????????????B???????\???`?????????????????????q???????B
3. ?\???`??
?@?\???c?????????????????????C?????f?[?^???????i???x???j???l???\?????????B?????????A????????1???\?????????s?????????f?[?^?????x?????\?????????????B???????A???x?????????????l???W?????????\?????????????????????B???????????W???????R?[?h???????????B??1?????A?????s?A???O?s?????????????x?????????????l???W???????????A?????????R?[?h???????????B
?@?i??1?j
?@?o?????? | ???O | ???N????
?@-----------------------------------
1 | ABE | 1999/2/10
2 | ITOH | 1999/4/30
?@?\?????????x?????????????R?[?h?????????????????B???????????????????s?????????A???x?????????????i?c???????j???????????????????R?[?h???c???????i?????????j???????????B??1???????????????x?????????????????B??2?????????\???]?u?????????????????????????B
?@?i??2?j
?@?o?????? |1 | 2
???O |ABE | ITOH
???N???? |1999/2/10 | 1999/4/30
?@-----------------------------------
???R?[?h???A?????????????????g?????W?????????\???????????B
L = l_2, ..., l_n : ???x?????W??
V = v_2, ..., v_n : ?l???W??
R = v_1,), (l_2, v_2), ..., (l_n, v_n) : ???R?[?h
n: ???x??????
?@?\?????R?[?h???W???????B
T = R_2, ..., R_m : ?e?[?u??
m: ???R?[?h????
3. ?\???\?????\???^?O
?@?c?[?????\???\?????????????????K?v???????????B???l?????I???c?[?????? Java?? XLSBeans?????????????AXLSBeans?????\?????????A?e?[?V?????????????O?? XML?t?@?C?????^???????????B?????c?[???????A?\?????????\?f?[?^???????????^?O???????????????B
?@??????CSV?f?[?^?????????\???????????????????????B?\??CSV?f?[?^?s???W???????????A???????\?????????????? CSV?f?[?^?s?????\???????????B?e??????{}???^?O?????????A?s???o???????????????B
?@?@1. ?\?^?O???????s 2. ?????s {0..n
?@?@3. ???x???^?O???????s 1.1..n
?@ 4. ?l???????s 1.1..n
?@ 5. ?????s 0.0..n
?@
(1)?\???^?O
?^?O?????^?O??{}???????????B?^?O?????\?^?O?A???x???^?O???????????A???????????????????\?????u?????????????B?????????????????^?O?????????Q???????????????B
?^?O??CSV?f?[?^???Z?????????????????????????????????B???????????u???O???????????????????????B?p?[?X?????A?^?O?????????????Z?????l???????????????B??????????"???t"??????CSV?f?[?^???????^?O???????????????????B
?@ ???tTAG, 2007/4/1, 2000/1/1
?@
/*
?@?^?O???l?????????????????????B?^?O????????":"???~???l???????????B?p?[?X???A???????^?????l???g?????f?[?^???????????????????????????B?????????????????^?O??"Date"???????l???^???????????B???????????????l???????ACSV?f?[?^??????"???t"?????????????????B???????^?O???l?????????????????\?????B
?@???tTAG:Date, 2007/4/1, 2000/1/1
TAG:Date, 2007/4/1, 2000/1/1
*/
(2)?\???\?^?O HTABLE, VTABLE
CSV?f?[?^?s?????????\?^?O???????s???A?\???J?n?????????????B?\?^?O???? HTABLE, VTABLE???????????????A?????????????????x???????R?[?h???????????\?????????B???x???????????i???R?[?h???c?????j?????????????AVTABLE?^?O???g???????B?c?????????????????AVTABLE?^?O???g???????B
(3)???x???????x???^?O L
?@???x???^?O?????x???Q???J?n???u???\?????????????A???x???Q?????????????????????B
?@?????F???x?????A??????????????????????????
(4)???R?[?h
?@???R?[?h???J?n???u???A?e?[?u???^?O?????x???^?O?????????????????B?e?[?u???^?O??HTALBE???????A???x???^?O?????????????????s?????????s?????O?????????R?[?h?^?O?????????????BVTABLE???????A???x???^?O?????????????????????????????????O?????????R?[?h?^?O?????????????B
(5)???x???????^?O N
???R?[?h?????????A???x?????????????????????????A??????N?^?O???????????????B
(6)???????u?? <.+>
?@?^?O?????????????????A?^?O?????????????????????????????????u?????????????B?u?????????Z????<.*>?????????????????A?e?[?u?????A???x?????A???R?[?h???l??<>???????????????u?????????B
?@?i??3?j
HTABLE?o????,,
?@L?o??????, ???O, ???N????
1,ABE,1999/2/10
2,ITOH,1999/4/30
?@?i??4?j
VTABLE?o????,,
?@L?o??????, 1, 2
???O, ABE, ITOH
???N????, 1999/2/10, 1999/4/30
?@-----------------------------------
HTABLE?o????,,
?@itemL, ?o??????, ???O<name>, ???N????
student1, 1,ABE????,1999/2/10
student2, 2,ITOH,1999/4/30
....
????N,,
VTABLE?o????,,
????L, student1, studen2, ...., ????N,,
?@?o??????, 1, 2
???O, ABE, ITOH
???N????, 1999/2/10, 1999/4/30
4. ???G???\???\??????
(1) ???x?????????????B
(2) ?l???????????B
(3) ?K?w?????x??
VTABLE?o????,,
????1L, ????2, student1, studen2, ...., ????N,,
?@?o??????, (1), 1, 2
?@, (2), 20024, 49842
???O,, ABE, ITOH
???N????,, 1999/2/10, 1999/4/30
(4) ?z??
L,L, L
?@?o??????, (1)[], num, 1, 2
?@, , val, 3, 9
?@, (1)[], num, 20024, 49842
?@, , val, 10, 100
?z???????????????????????A?u(1)[]?v?????????L?@???????????B???????????L?@???p???????????????????????B?????????????????x?????o???????B
5. ?????????f?[?^
?@?????????f?[?^???A?\?????x???I?u?W?F?N?g?E?E?E?E
tables = [table_1, table_2, ..., table_n]
table_i = [[R_1, R_2, ..., R_n], [L_1,L_2, ..., L_n]]
R_i = [(L_1, V_i_1), (L_2, V_i_2), ..., (L_n, V_i_n)]
L_i = [[l_i_1, l_i_2, ..., l_i_n], [N_i_1, N_i_2, ..., N_i_2_n]
l_i_k: string
V_i_k : string
N_i_k : string
tables[tablename].records.first["Name"]["second"]
tables[tablename].labels.first["????"]
6. ?e???v???[?g
?@?????f?[?^?????????e???v???[?g???e?L?X?g?????????????BERB?????p?E?E?E
=begin Done
#??????CSV???????????e?[?u??
#???@?????`????
#???????W?b?N?????U?????????????????A???????N???X???W???????B
#?A?????????x???????????\??????
#???x?????????u????????
#???R?[?h???l???u????????
#?e?[?u???^?C?g???????x???????????????s??????
#?l?i?e?[?u???^?C?g???A???x???A???R?[?h?l?????j???O????????????????????
#?????^?O???T?|?[?g
#Excel?t?@?C??????????????????????????
#?e???v???[?g?????????????T?|?[?g
#?R?}???h???C??????
=begin ToDo: 1st release
#?\?[?X?t?@?C????????????????
=begin ToDo: 2nd release
#?W?v???T?|?[?g
#?f?[?^???????`?F?b?N???T?|?[?g
#C?????p?R?[?h?????????T?|?[?g
#Ruby?????p?R?[?h?????????T?|?[?g
=====?
#?A???f?[?^???z????????????????????
#?A?????????R?[?h?????????\??????
#???@???????????`????
#???G???X?L?[?}?F?????????????g????????
====ParseExcel???????H(?o?O?H)
*???????l??????????????
*?u10?v?????????????Z?????A????10???????A????10.0?????????????K?v???????H
=end
=================
1. ?????c?[??????????
?@CSV?f?[?^??Excel?t?@?C???? Ruby?I?u?W?F?N?g???C?????f?[?^?`?????????????c?[???????B
?@?\?`?????f?[?^?????\?[?X?R?[?h??HTML?t?@?C?????e???????????????????????????????????W?????B
?@?\?f?[?^???\???\?????????^?O?????????????????????A?\???????p?[?X???????????R?[?h???????????? Ruby?I?u?W?F?N?g??
?@?C?????e???v???[?g?`???????????????????????????B
2. ?c?[?????J?o?[????????
?@?????c?[?????????P???\?A?????????o?????l?????????????f?[?^?W???????????????????????B???o?????K?w???????????????\?????B???????\???????????f?[?^???????????????\?????B???????A?????q?????????\?????????????B???????\???`?????????????????????q???????B
3. ?\???`??
?@?\???c?????????????????????C?????f?[?^???????i???x???j???l???\?????????B?????????A????????1???\?????????s?????????f?[?^?????x?????\?????????????B???????A???x?????????????l???W?????????\?????????????????????B???????????W???????R?[?h???????????B??1?????A?????s?A???O?s?????????????x?????????????l???W???????????A?????????R?[?h???????????B
?@?i??1?j
?@?o?????? | ???O | ???N????
?@-----------------------------------
1 | ABE | 1999/2/10
2 | ITOH | 1999/4/30
?@?\?????????x?????????????R?[?h?????????????????B???????????????????s?????????A???x?????????????i?c???????j???????????????????R?[?h???c???????i?????????j???????????B??1???????????????x?????????????????B??2?????????\???]?u?????????????????????????B
?@?i??2?j
?@?o?????? |1 | 2
???O |ABE | ITOH
???N???? |1999/2/10 | 1999/4/30
?@-----------------------------------
???R?[?h???A?????????????????g?????W?????????\???????????B
L = l_2, ..., l_n : ???x?????W??
V = v_2, ..., v_n : ?l???W??
R = v_1,), (l_2, v_2), ..., (l_n, v_n) : ???R?[?h
n: ???x??????
?@?\?????R?[?h???W???????B
T = R_2, ..., R_m : ?e?[?u??
m: ???R?[?h????
3. ?\???\?????\???^?O
?@?c?[?????\???\?????????????????K?v???????????B???l?????I???c?[?????? Java?? XLSBeans?????????????AXLSBeans?????\?????????A?e?[?V?????????????O?? XML?t?@?C?????^???????????B?????c?[???????A?\?????????\?f?[?^???????????^?O???????????????B
?@??????CSV?f?[?^?????????\???????????????????????B?\??CSV?f?[?^?s???W???????????A???????\?????????????? CSV?f?[?^?s?????\???????????B?e??????{}???^?O?????????A?s???o???????????????B
?@?@1. ?\?^?O???????s 2. ?????s {0..n
?@?@3. ???x???^?O???????s 1.1..n
?@ 4. ?l???????s 1.1..n
?@ 5. ?????s 0.0..n
?@
(1)?\???^?O
?^?O?????^?O??{}???????????B?^?O?????\?^?O?A???x???^?O???????????A???????????????????\?????u?????????????B?????????????????^?O?????????Q???????????????B
?^?O??CSV?f?[?^???Z?????????????????????????????????B???????????u???O???????????????????????B?p?[?X?????A?^?O?????????????Z?????l???????????????B??????????"???t"??????CSV?f?[?^???????^?O???????????????????B
?@ ???tTAG, 2007/4/1, 2000/1/1
?@
/*
?@?^?O???l?????????????????????B?^?O????????":"???~???l???????????B?p?[?X???A???????^?????l???g?????f?[?^???????????????????????????B?????????????????^?O??"Date"???????l???^???????????B???????????????l???????ACSV?f?[?^??????"???t"?????????????????B???????^?O???l?????????????????\?????B
?@???tTAG:Date, 2007/4/1, 2000/1/1
TAG:Date, 2007/4/1, 2000/1/1
*/
(2)?\???\?^?O HTABLE, VTABLE
CSV?f?[?^?s?????????\?^?O???????s???A?\???J?n?????????????B?\?^?O???? HTABLE, VTABLE???????????????A?????????????????x???????R?[?h???????????\?????????B???x???????????i???R?[?h???c?????j?????????????AVTABLE?^?O???g???????B?c?????????????????AVTABLE?^?O???g???????B
(3)???x???????x???^?O L
?@???x???^?O?????x???Q???J?n???u???\?????????????A???x???Q?????????????????????B
?@?????F???x?????A??????????????????????????
(4)???R?[?h
?@???R?[?h???J?n???u???A?e?[?u???^?O?????x???^?O?????????????????B?e?[?u???^?O??HTALBE???????A???x???^?O?????????????????s?????????s?????O?????????R?[?h?^?O?????????????BVTABLE???????A???x???^?O?????????????????????????????????O?????????R?[?h?^?O?????????????B
(5)???x???????^?O N
???R?[?h?????????A???x?????????????????????????A??????N?^?O???????????????B
(6)???????u?? <.+>
?@?^?O?????????????????A?^?O?????????????????????????????????u?????????????B?u?????????Z????<.*>?????????????????A?e?[?u?????A???x?????A???R?[?h???l??<>???????????????u?????????B
?@?i??3?j
HTABLE?o????,,
?@L?o??????, ???O, ???N????
1,ABE,1999/2/10
2,ITOH,1999/4/30
?@?i??4?j
VTABLE?o????,,
?@L?o??????, 1, 2
???O, ABE, ITOH
???N????, 1999/2/10, 1999/4/30
?@-----------------------------------
HTABLE?o????,,
?@itemL, ?o??????, ???O<name>, ???N????
student1, 1,ABE????,1999/2/10
student2, 2,ITOH,1999/4/30
....
????N,,
VTABLE?o????,,
????L, student1, studen2, ...., ????N,,
?@?o??????, 1, 2
???O, ABE, ITOH
???N????, 1999/2/10, 1999/4/30
4. ???G???\???\??????
(1) ???x?????????????B
(2) ?l???????????B
(3) ?K?w?????x??
VTABLE?o????,,
????1L, ????2, student1, studen2, ...., ????N,,
?@?o??????, (1), 1, 2
?@, (2), 20024, 49842
???O,, ABE, ITOH
???N????,, 1999/2/10, 1999/4/30
(4) ?z??
L,L, L
?@?o??????, (1)[], num, 1, 2
?@, , val, 3, 9
?@, (1)[], num, 20024, 49842
?@, , val, 10, 100
?z???????????????????????A?u(1)[]?v?????????L?@???????????B???????????L?@???p???????????????????????B?????????????????x?????o???????B
5. ?????????f?[?^
?@?????????f?[?^???A?\?????x???I?u?W?F?N?g?E?E?E?E
tables = [table_1, table_2, ..., table_n]
table_i = [[R_1, R_2, ..., R_n], [L_1,L_2, ..., L_n]]
R_i = [(L_1, V_i_1), (L_2, V_i_2), ..., (L_n, V_i_n)]
L_i = [[l_i_1, l_i_2, ..., l_i_n], [N_i_1, N_i_2, ..., N_i_2_n]
l_i_k: string
V_i_k : string
N_i_k : string
tables[tablename].records.first["Name"]["second"]
tables[tablename].labels.first["????"]
6. ?e???v???[?g
?@?????f?[?^?????????e???v???[?g???e?L?X?g?????????????BERB?????p?E?E?E
=begin Done
#??????CSV???????????e?[?u??
#???@?????`????
#???????W?b?N?????U?????????????????A???????N???X???W???????B
#?A?????????x???????????\??????
#???x?????????u????????
#???R?[?h???l???u????????
#?e?[?u???^?C?g???????x???????????????s??????
#?l?i?e?[?u???^?C?g???A???x???A???R?[?h?l?????j???O????????????????????
#?????^?O???T?|?[?g
#Excel?t?@?C??????????????????????????
#?e???v???[?g?????????????T?|?[?g
#?R?}???h???C??????
=begin ToDo: 1st release
#?\?[?X?t?@?C????????????????
=begin ToDo: 2nd release
#?W?v???T?|?[?g
#?f?[?^???????`?F?b?N???T?|?[?g
#C?????p?R?[?h?????????T?|?[?g
#Ruby?????p?R?[?h?????????T?|?[?g
=====?
#?A???f?[?^???z????????????????????
#?A?????????R?[?h?????????\??????
#???@???????????`????
#???G???X?L?[?}?F?????????????g????????
====ParseExcel???????H(?o?O?H)
*???????l??????????????
*?u10?v?????????????Z?????A????10???????A????10.0?????????????K?v???????H
=end