2021-4-27 アウトプットサークル発表会

Transcript

1. ਎ۙͳSQL 2021/4/27 Έ΄
2. ࠓ೔ͷ಺༰ • SQLͱ͸Կ͔ʁ • SQLͰͰ͖Δ͜ͱ • SQLͷߏจ • RailsͱSQL • ਎ۙͳSQL • ·ͱΊ
3. ࠓ೔ͷ಺༰ • SQLͱ͸Կ͔ʁ • SQLͰͰ͖Δ͜ͱ • SQLͷߏจ • RailsͱSQL • ਎ۙͳSQL • ·ͱΊ
4. SQLͱ͸Կ͔ʁ • SQL͸Structured Query LanguageͷུͰɺ௚༁͢Δͱ ʮߏ଄Խ໰߹ͤݴޠʯɻϓϩάϥϛϯάݴޠͰ͸ͳ͘ɺ RDB(ϦϨʔγϣφϧσʔλϕʔε)Λૢ࡞͢Δ΋ͷɻ • RDBͱ͸ɿೋ࣍ݩͷදܗࣜͰද͢ࣄ͕Ͱ͖ͯɺϦϨʔ γϣϯʢ݁߹ʣ͕Մೳͳσʔλϕʔεͷ͜ͱɻ • σʔλϕʔεͰࢦࣔΛग़͢ݴޠ͸ʮSQLจʯͱݴ͍ɺ໋ ྩจΛ૊Έ߹ΘͤͯॲཧΛ࣮ߦ͢Δɻ
5. ࠓ೔ͷ಺༰ • SQLͱ͸Կ͔ʁ • SQLͰͰ͖Δ͜ͱ • SQLͷߏจ • RailsͱSQL • ਎ۙͳSQL • ·ͱΊ
6. SQLͰͰ͖Δ͜ͱ • σʔλͷ৚݅ݕࡧ • σʔλͷऔಘɾߋ৽ɾొ࿥ɾ࡟আ • ςʔϒϧͷ࡞੒ɾ࡟আɾมߋɹɹɹɹɹɹɹ ※ςʔϒϧɿσʔλΛ֨ೲ͢Δදͷ͜ͱ
7. ࠓ೔ͷ಺༰ • SQLͱ͸Կ͔ʁ • SQLͰͰ͖Δ͜ͱ • SQLͷߏจ • RailsͱSQL • ਎ۙͳSQL • ·ͱΊ
8. SQLͷߏจʢྫɿ஋Λऔಘ͢Δʣ SELECT name FROM cars WHERE category = ‘εϙʔπ’ ; SELECT ΧϥϜ໊ FROM ςʔϒϧ໊ WHERE ৚݅ ; ΧϥϜͷ஋Λදࣔ͢Δ ςʔϒϧ͔ΒσʔλΛऔಘ͢Δ CategoryΧϥϜ͕ ʮʓʓʢ৚݅ʣʯͷ ϨίʔυΛݕࡧ͢Δ ʮcarsʯςʔϒϧ͔ΒʮcategoryʯΧϥϜ͕ʮεϙʔπʯͷϨίʔυΛݕࡧ͠ɺͦͷϨίʔυͷ ʮnameʯΧϥϜͷ஋Λදࣔ͢Δ จ຤͸ηϛίϩϯ
9. SQLͷߏจʢྫɿ஋Λऔಘ͢Δʣ SELECT name FROM cars WHERE category = ‘εϙʔπ’ ; ʮcarsʯςʔϒϧ͔ΒʮcategoryʯΧϥϜ͕ʮεϙʔπʯͷϨίʔυΛݕࡧ͠ɺͦͷϨίʔυͷ ʮnameʯΧϥϜͷ஋Λදࣔ͢Δ OBNF DBUFHPSZ DPNQBOZ ZFBS ˒ εϙʔπ ϑΝϛϦʔ Carsςʔϒϧ(excelͷදʹ૬౰͢Δɻ)γʔτʹྫ͑ͯ࢖͏͜ͱ΋ ΧϥϜʢྻʹ૬౰͢Δʣ Ϩίʔυʢσʔλͦͷ΋ͷɻ ߦͱ͍͏ҙຯͰ࢖͏͜ͱ΋ʣ
10. ࠓ೔ͷ಺༰ • SQLͱ͸Կ͔ʁ • SQLͰͰ͖Δ͜ͱ • SQLͷߏจ • RailsͱSQL • ਎ۙͳSQL • ·ͱΊ
11. RailsͱSQL ʮ͋ΕɺͰ΋ීஈSQLจॻ͍ͯͳ͍Αʁʯ ੜͷSQLΛॻ͔ͳͯ͘΋ActiveRecordΛ ׆༻͢Δ͜ͱͰɺσʔλͷநग़͕Ͱ͖Δɻ class Car < ApplicationRecord @car = Car.where(category: ‘εϙʔπ’) end ActiveRecordΛܧঝ carϞσϧʹApplicationRecordΛܧঝ ΧςΰϦʔ͕εϙʔπͷ৚݅ͷσʔλΛશͯऔಘ
12. ࠓ೔ͷ಺༰ • SQLͱ͸Կ͔ʁ • SQLͰͰ͖Δ͜ͱ • SQLͷߏจ • RailsͱSQL • ਎ۙͳSQL • ·ͱΊ
13. ਎ۙͳSQL ΞϧόΠτઌͰดళ࡞ۀதʹϨδ୺຤Λγϟοτμ΢ϯ ͢ΔͱɺʮSQLαʔόʔͷఀࢭʯͱදࣔ͞Ε͍ͯͨɻ ਎ۙͳͱ͜ΖͰ׆༻͞Ε͍ͯΔʂ ɾച্෼ੳػೳ ɾސ٬؅ཧػೳ ɾࡏݿ؅ཧػೳ ͳͲ
14. ࠓ೔ͷ಺༰ • SQLͱ͸Կ͔ʁ • SQLͰͰ͖Δ͜ͱ • SQLͷߏจ • RailsͱSQL • ਎ۙͳSQL • ·ͱΊ
15. ·ͱΊ • SQLͰ͸σʔλͷऔಘ΍ߋ৽ͳͲ༷ʑͳࣄ͕ Ͱ͖Δ • RailsͰ͸ActiveRecordΛ༻͍ΔࣄͰSQLจΛ ॻ͔ͣʹσʔλΛநग़Ͱ͖Δ • ਎ۙͳͱ͜ΖͰSQL͕׆༻͞Ε͍ͯΔ
16. ࢀߟจݙ • WebɿUdemy, ೖ໳ऀͰ΋Θ͔ΔSQLΛ࢖ͬͯදΛ࡞ͬͯΈΑ͏ʂʲSQLจͷॻ͖ํ෇͖ʳ, 2020-03, Ӿཡ೔ 2021-4-22,https://udemy.benesse.co.jp/development/system/intro-sql.html • ॻ੶ɿେ৔ೡࢠଞ, ݱ৔Ͱ࢖͑ΔRuby on Rails5଎म࣮ફΨΠυ, ϚΠφϏग़൛, 2018. • Webɿͦ΋ͦ΋ɺϦϨʔγϣφϧσʔλϕʔεͱ͸Կ͔, 2016-7-5, Ӿཡ೔ 2021-4-22, https://www.atmarkit.co.jp/ait/articles/0807/16/news149.html • WebɿRailsΨΠυv6.1-Active Record ΫΤϦΠϯλʔϑΣΠε, Ӿཡ೔ 2021-4-22, https:// railsguides.jp/active_record_querying.html • Webɿʲॳ৺ऀ޲͚ʳRailsͷActive Recordͷղઆ&ϝιου·ͱΊ, Ӿཡ೔ 2021-4-23, https://qiita.com/ryokky59/items/a1d0b4e86bacbd7ef6e8 • WebɿϢϏϨδ, Ӿཡ೔ 2021-4-23, https://ubiregi.com/ja/pos-regi
17. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ