$SZTUBMʹ࠶ͼ 3BJMTͷເΛݟΔ "NCFSฤ .BTBZVLJ6DIJB!NTLZ ౦ژ$SZTUBMษڧձ

UXJUUFS!NTLZ HJUIVC!NTLZ

$SZTUBMษڧձ IUUQTXXXTMJEFTIBSFOFUFUNOLDSZTUBMSBJMT

w ͜ͷࠒݟ͍ͯͨເ w 'SPTU w ΍͸Γॳظͷഁյతมߋʹ߅͑ͳ͍ w ݱࡏͷόʔδϣϯͰ͸ϏϧυΛ௨͢ͷ΋ࠔ೉

"NCFS IUUQTBNCFSGSBNFXPSLPSH

(FUUJOH4UBSUFEʹै͏ w CSFXJOTUBMMBNCFS w $SZTUBM͸YYܥ͕͋Δલఏ w BNCFSOFXpSTUBNCFSENZTRMUFDS w E%#ࢦఆʢσϑΥϧτ͸1PTUHSF42-ʣ w UςϯϓϨʔτࢦఆʢσϑΥϧτ͸TMBOHʣ

(FUUJOH4UBSUFEଓ͖ w DEpSTUBNCFS w TIBSETJOTUBMM w BNCFSHTDB⒎PME"SUJDMFUJUMFTUSJOHDPOUFOUTUSJOH w BNCFSECDSFBUFNJHSBUF w BNCFSXBUDI

ೝূͷྫ w BNCFSHBVUI6TFS w BNCFSECNJHSBUF

3PVUFS "NCFS4FSWFSDPOpHVSFEPcBQQc SPVUFTXFCEP HFUQSPpMF 6TFS$POUSPMMFS TIPX HFUQSPpMFFEJU 6TFS$POUSPMMFS FEJU QBUDIQSPpMF 6TFS$POUSPMMFS VQEBUF HFUTJHOJO 4FTTJPO$POUSPMMFS OFX QPTUTFTTJPO 4FTTJPO$POUSPMMFS DSFBUF HFUTJHOPVU 4FTTJPO$POUSPMMFS EFMFUF HFUTJHOVQ 3FHJTUSBUJPO$POUSPMMFS OFX QPTUSFHJTUSBUJPO 3FHJTUSBUJPO$POUSPMMFS DSFBUF SFTPVSDFTQFUT 1FU$POUSPMMFS HFU )PNF$POUSPMMFS JOEFY FOE FOE

03.(SBOJUF class Post < Granite::Base adapter mysql field name : String field body : String timestamps end

(SBOJUFଓ͖ w OBNFE5VQMF1PTUOFX OBNF/BNF CPEZ*BNUIF CPEZz w IBTI1PTUOFX \OBNF/BNF CPEZ*BNUIF CPEZ^UP@I w GSPN+TPO1PTUGSPN@KTPO +40/QBSTF \OBNF/BNF CPEZ*BNUIFCPEZz^ BT 1PTU w KTPO"SSBZ1PTUGSPN@KTPO +40/QBSTF <\OBNF 1PTU CPEZ*BNUIFCPEZGPSQPTU^ \OBNF1PTU CPEZ*BNUIFCPEZGPSQPTU^> BT "SSBZ 1PTU

3FMBUJPOTIJQ class User < Granite::Base adapter mysql has_many :posts field email : String field name : String timestamps end

3FMBUJPOTIJQ class Post < Granite::Base adapter mysql belongs_to :user field title : String timestamps end

.BOZUPNBOZ class User < Granite::Base has_many :participants field name : String end class Participant < Granite::Base belongs_to :user belongs_to :room end class Room < Granite::Base has_many :participants field name : String end

.JHSBUJPO w IUUQTHJUIVCDPNBNCFSGSBNFXPSLNJDSBUF dependencies: micrate: github: amberframework/micrate

.JDSBUF w CJONJDSBUF #! /usr/bin/env crystal # Require your database's adapter # require "pg" # require "mysql" # require "sqlite3" require "micrate" Micrate::Cli.run

.JDSBUF w &Y NJDSBUFDSFBUFBEE@VTFST@UBCMF -- +micrate Up -- SQL in section 'Up' is executed when this migration is applied -- +micrate Down -- SQL section 'Down' is executed when this migration is rolled back

.JDSBUF w NJDSBUFVQ -- +micrate Up CREATE TABLE users(id INT PRIMARY KEY, email VARCHAR NOT NULL); -- +micrate Down DROP TABLE users;

ͦͷଞಛघͳػೳ w 3FDJQFT w "NCFSOFXͰग़ྗ͢ΔςϯϓϨʔτΛΧελϜઃఆ ͨ͠΋ͷ w IUUQTHJUIVCDPNBNCFSGSBNFXPSLSFDJQFT

ͦͷଞಛघͳػೳ w 1JQFMJOFT w ֤63-ຖʹ)UUQͷϋϯυϥΛઃఆͰ͖Δ Amber::Server.configure do |app| pipeline :web do # Plug is the method to use connect a pipe (middleware) # A plug accepts an instance of HTTP::Handler # plug Amber::Pipe::Params.new plug Amber::Pipe::Logger.new plug Amber::Pipe::Flash.new plug Amber::Pipe::Session.new plug Amber::Pipe::CSRF.new end

ࡶײ w ૝૾Ҏ্ʹଟػೳ w TQFDͰṖͷΤϥʔ w ΤϥʔνΣοΫͷՕॴΛߦίϝϯτΞ΢τͨ͠Βಈ͍ ͨͷͰΤϥʔνΣοΫͷͱ͜Ζʹ໰୊͋Γʁ w BVUIͷଟॏઃఆͰΤϥʔ w Ͳ͏͍͏ಈ͖͕ظ଴௨Γͳͷ͔͸ٞ࿦ͷඞཁ͋Γ

·ͱΊ w ͜Ε͸ߦ͚Δ͔΋͠Εͳ͍ʂ w όάΛݟ͚ͭͨΒԶ͕௚͢ɺͷؾ࣋ͪʢ࠶