New in v19 R Releases Part 4

Transcript

1. W E B I N A R W E E K 4 4D v19 R Release
2. ORDA
3. ORDAͰ BLOBΛ࢖༻͢Δ
4. ORDA - ORDAͰBlobΛ࢖༻͢Δ $IMAPTransporter:=4D.IMAPTransporter.new($parameters) $blob:=$IMAPTransporter.getMIMEAsBlob() $archive:=ds.EmailArchives.new() $archive.Date:=Timestamp $archive.save() $id:=$archive.ID QUERY([EmailArchives]; [EmailArchives]ID=$id) [EmailArchives]Blob:=$blob SAVE RECORD([EmailArchives]) //Blob͸ORDAܦ༝ͰอଘͰ͖ͳ͔ͬͨ !
5. $IMAPTransporter:=4D.IMAPTransporter.new($parameters) $blob:=$IMAPTransporter.getMIMEAsBlob() $archive:=ds.EmailArchives.new() $archive.Date:=Timestamp $archive.Blob:=$blob //ORDAܦ༝ͰBlobΛอଘͰ͖Δʂ $archive.save() ORDA - ORDAͰBlobΛ࢖༻͢Δ "#
6. ORDA - ORDAͰBlobΛ࢖༻͢Δ
7. ORDA - ORDAͰBlobΛ࢖༻͢Δ
8. RESTϦΫΤετͷ ίϯςΩετΛ؅ཧ
9. ORDA - RESTϦΫΤετͷίϯςΩετΛ؅ཧ
10. ORDA - RESTϦΫΤετͷίϯςΩετΛ؅ཧ $ ໊લϑΟʔϧυͱ ෦ॺϑΟʔϧυ͔͠ ࢖༻͍ͯ͠ͳ͍ ͜ͱΛʮֶशʯ͢Δ
11. Form.context1:=New object("context"; "simpleList") Form.context2:=New object("context"; "allList") //"simpleList"ͷίϯςΩετΛࢦఆͯ͠ΤϯςΟςΟηϨΫγϣϯΛऔಘ Form.dataSource:=ds.People.all(Form.context1) ORDA - RESTϦΫΤετͷίϯςΩετΛ؅ཧ ίϯςΩετʹϥϕϧΛ͚ͭͯ ࠶ར༻͕Մೳ $
12. ORDA - RESTϦΫΤετͷίϯςΩετΛ؅ཧ ίϯςΩετΛ໌ࣔతʹखಈͰࢦఆՄೳʹʂ setRemoteContextInfo // ϦϞʔτσʔλετΞΛ։࢝ Form.myDS:=Open datastore(New object("hostname"; "www.myserver.com"); "myDS") // ίϯςΩετΛखಈͰઃఆ Form.context1:=New object("context"; "simpleList") Form.myDS.setRemoteContextInfo("simpleList"; Form.myDS.People; "fullName") // ΤϯςΟςΟηϨΫγϣϯΛऔಘ Form.dataSource:=Form.myDS.People.all(Form.context1) simpleListίϯςΩετͰ͸ PeopleσʔλΫϥεͷ fullNameଐੑͷΈ࢖༻ɺͱࢦఆ
13. var $ds : 4D.DataStoreImplementation $ds:=Open datastore(New object("hostname"; "www.myserver.com"); "myDS") $ds.setRemoteContextInfo("recentData"; $ds.Sales;\ "Timestamp, amount,total, salesPerson.name"; "main"; 30) ORDA - RESTϦΫΤετͷίϯςΩετΛ؅ཧ ίϯςΩετΛ໌ࣔతʹखಈͰࢦఆՄೳʹʂ setRemoteContextInfo recentDataίϯςΩετͰ͸ SalesσʔλΫϥε͔Β ͜ΕΒͷଐੑΛ30݅ͷΈ࢖༻ɺͱࢦఆ
14. ORDA - RESTϦΫΤετͷίϯςΩετΛ؅ཧ σʔλ͕ͲͷΑ͏ʹඞཁʹͳΔ͔ ஌͍ͬͯΔͷ͸σϕϩούʔࣗ਎ʂ →ྲྀΕΛ؅ཧͯ͠଎౓Λམͱ͞ͳ͍
15. ORDA - RESTϦΫΤετͷίϯςΩετΛ؅ཧ //ϦΫΤετϩάΛ༗ޮԽ ds.startRequestLog($file)
16. ORDA - RESTϦΫΤετͷίϯςΩετΛ؅ཧ //ϦΫΤετϩάΛ༗ޮԽ ds.startRequestLog($file) ࠷ޙͷ ] ΛखಈͰ ͚ͭΔඞཁ͕ ͋Δ఺ʹ஫ҙʂ
17. ܭࢉଐੑ ʙܭࢉ͸͢Δ͕ଐੑͰ͋Δʙ
18. ܭࢉͰऔಘ͢Δ͜ͱ͸Մೳ͕ͩɺ ్୺ʹ࢖͍উख͕ѱ͘ͳͬͯ͠·͏ ORDA - ܭࢉଐੑʹ͍ͭͯ ஀ੜ೔ ݩ߸ ࿨ྐྵ
19. ORDA - ܭࢉଐੑʹ͍ͭͯ
20. ORDA - ܭࢉଐੑʹ͍ͭͯ
21. ORDA - ܭࢉଐੑʹ͍ͭͯ
22. ORDA - ܭࢉଐੑʹ͍ͭͯ ࣜΛׂΓ౰ͯͨΧϥϜ͸ ϔομʔΛΫϦοΫͯ͠΋ ࣗಈιʔτ͕ߦΘΕͳ͘ͳΔʂ This.lastname+" "+This.firstname
23. ORDA - ܭࢉଐੑʹ͍ͭͯ ܭࢉଐੑ Λ࢖͑͹͜ͷΑ͏ͳ δϨϯϚΛղܾͰ͖Δʂ
24. ORDA - ܭࢉଐੑʹ͍ͭͯ • طଘͷଐੑ(ϑΟʔϧυ)͔Βܭࢉͯ͠ಘΒΕΔ৽͍͠஋ • ଞͷଐੑಉ༷ʹ࢖༻͢Δ͜ͱ͕Ͱ͖Δ • get / set / query / orderBy ͷ4छྨ͕͋Δ ܭࢉଐੑͱ͸
25. ORDA - ܭࢉଐੑʹ͍ͭͯ Class extends Entity Function get fullName()->$result : Text $result:=This.lastname+" "+This.firstname get • ஋Λऔಘ͢ΔͨΊͷܭࢉଐੑ • ܭࢉଐੑΛ࢖༻࢝͠ΊΔͨΊͷτϦΨʔͰ΋͋Δ
 ݴ͍׵͑Δͱɺܭࢉଐੑʹ͓͍ͯgetͷ࢖༻͸ඞਢ
26. ORDA - ܭࢉଐੑʹ͍ͭͯ set • ॻ͖ࠐΈΛߦ͏ͨΊͷܭࢉଐੑ • ఆٛ͠ͳ͔ͬͨ৔߹͸ܭࢉଐੑ͸ϦʔυΦϯϦʔͱͳΔ • ϑΟʔϧυʹॻ͖ࠐΈΛߦ͏ͷͰɺద੾ͳ؅ཧ͕ඞཁ Class extends Entity //get ͸ඞਢ Function set fullName($value : Text)
27. ORDA - ܭࢉଐੑʹ͍ͭͯ query / orderBy • ܭࢉଐੑʹର͢ΔΫΤϦ/ιʔτ͸ΤϯςΟςΟ͝ͱʹ
 ຖճܭࢉ͕ߦΘΕΔ • ܭࢉଐੑ͸͍Θ͹شൃੑͷଐੑɺΠϯσοΫε͸ͳ͍ • $event ΦϒδΣΫτΛड͚औͬͯ؅ཧ͢Δ Function query age($event : Object)->$result : Object Function orderBy age($event : Object)
28. ORDA - ܭࢉଐੑʹ͍ͭͯ • ܭࢉଐੑ͸ORDAಛ༗ͷ΋ͷͰ͸ͳ͘ɺ
 ϢʔβʔΫϥεͰ΋࢖༻Ͱ͖Δʂ • ϑΟʔϧυΛແବʹ૿΍͢͜ͱͳ͘
 σʔλͷ৘ใྔΛ૿΍͢͜ͱ͕Ͱ͖Δ • ஀ੜ೔͔Βݩ߸/࿨ྐྵΛܭࢉɺৗʹਖ਼͍͠೥ྸΛܭࢉɺ
 ࠓ݄ͷച্/௚ۙ90೔ͷച্ͳͲ΋ܭࢉͰ༰қʹऔಘՄೳ
29. ORDA - ܭࢉଐੑͱΤΠϦΞε Alias bossName myboss.fullName //্࢘ͷ໊લΛऔಘ Alias superBoss myboss.myboss //্࢘ͷ্࢘ʹର͢ΔΤϯςΟςΟΛऔಘ
30. NULL஋Λ࢖͏ ʙۭͰ΋0Ͱ΋ͳ͍ʙ
31. ORDA - Null஋Λ࢖͏ͱ͍͏͜ͱ
32. ORDA - Null஋Λ࢖͏ͱ͍͏͜ͱ
33. ORDA - Null஋Λ࢖͏ͱ͍͏͜ͱ 100 Average: 100
34. ORDA - Null஋Λ࢖͏ͱ͍͏͜ͱ 100 0 0 0 0 Average: 20 ͸σʔλͷܽམΛද͢ Null
35. Is field value Null ORDA - Null஋Λ࢖͏ͱ͍͏͜ͱ Null Null
36. ORDA - Null஋Λ࢖͏ͱ͍͏͜ͱ Null # ORDA Null # "" Null False
37. ORDAͱ4D Write Pro ʙՄೳੑ͸ແݶେʙ
38. ORDA - ORDAͱ4D Write Pro ΧϨϯτϨίʔυ ΧϨϯτηϨΫγϣϯ
39. ORDA - ORDAͱ4D Write Pro FormίϚϯυ ThisίϚϯυ
40. This.data ORDA - ORDAͱ4D Write Pro WP SET DATA CONTEXT Write ProυΩϡϝϯτ ΁ͷࠩ͠ࠐΈҹ࡮͕Մೳʹʂ
41. ORDA - ORDAͱ4D Write Pro • ද૊ػೳΛ࢖༻͢Ε͹ɺΤϯςΟςΟηϨΫγϣϯ΍
 ίϨΫγϣϯΛදͰද͢͜ͱ΋Մೳ • 4Dσʔλϕʔεͱ௚͍݁ͯ͠ΔͨΊɺҹ࡮/อଘ/ૹ৴ͳͲ
 ࣗࡏʹѻ͏͜ͱ͕Ͱ͖Δ • ORDAͷ࢖͍΍͢͞ͱWrite ProͷΫΦϦςΟͷ
 ૊Έ߹Θͤ͸ɺ࢖͍ํͷՄೳੑ͸ແݶେʂ
42. Thank you!