flyway-play

Transcript

1. qZXBZQMBZ &BTZ
   %BUBCBTF
   .JHSBUJPO
   GPS
   1MBZ
   TDBMBؔ੢
   4VNNJU
   
2. %BUBCBTF
   NJHSBUJPO
   JT
   EJGpDVMU
3. %# w .VUBCMF
   w MJLF
   B
   HMPCBM
   WBSJBCMFTUBUF
4. %&7
   TBZT w l4FUVQ
   EBUBCBTF
   NBOVBMMZ z
   w l)PX
   UP
   SFWJFX
   DIBOHFT z
   w l8IP
   DIBOHFE
   UIJT
   TDIFNB z
   w l*G
   UFTU
   EC
   EJGGFST
   GSPN
   QSPE
   QSPE
   JT
   UIF
   SFBMz
5. %#"
   TBZT w l*
   EPO`U
   LOPX
   NVDI
   BCPVU
   BQQz
   w l)FZ
   %&7
   HJWF
   NF
   "-5&3
   TDSJQUz
6. %BUBCBTF
   NJHSBUJPO
   JT
   EJGpDVMU
7. (PBM w $PPQFSBUJPO
   CFUXFFO
   %&7
   BOE
   %#"
   w .BOBHF
   EBUBCBTF
   DIBOHFT
8. 'MZXBZ
   NBEF
   JU
   FBTZ
9. 8IBU
   JT
   'MZXBZ
10. 'MZXBZ w 0QFOTPVSDF
    EBUBCBTF
    NJHSBUJPO
    UPPM
    w 8SJUUFO
    JO
    +BWB
    w ;FSP
    SFRVJSFE
    EFQFOEFODJFT
    PUIFS
    UIBO
    +BWB
    
    BOE
    +%#$
    w 4VQQPSU
    42-CBTFE
    
    +BWBCBTFE
    NJHSBUJPO
    w 1PSUBCMF
11. 4VQQPSUFE
    EBUBCBTFT w 0SBDMF
    w .Z42-
    w 1PTUHSF42-
    w %#
    w )
    w TPMJE%#
    w 42-
    4FSWFS
    w .BSJB
    %# w 7FSUJDB
    w %#
    [04
    w )TRM
    w 42-
    "[VSF
    w (PPHMF
    $MPVE
    42-
    w "84
    3FETIJGU
    w %FSCZ
    w 42-JUF
12. 1PSUBCMF w .BWFO
    w TCU
    w (SBEMF
    w "OU
    w $PNNBOE
    -JOF
    
    w +BWB
    "1*
13. $PNNBOET w NJHSBUF
    w DMFBO
    w SFQBJS
    w JOGP
    w WBMJEBUF
    w CBTFMJOF
14. 42-CBTFE
    .JHSBUJPO create table language (
 id integer primary key,
 name varchar(100) not null
 );
15. +BWBCBTFE
    .JHSBUJPO package db.migration.java
 
 import java.sql.Connection
 
 import org.flywaydb.core.api.migration.jdbc.JdbcMigration
 
 class V1__Create_language_table extends JdbcMigration {
 override def migrate(conn: Connection): Unit = {
 
 conn.createStatement().executeUpdate(
 """create table language (
 | id integer primary key,
 | name varchar(100) not null
 |);""".stripMargin)
 }
 }
16. IUUQXXXUIPVHIUXPSLTDPNSBEBSUPPMTqZXBZ ⚫"EPQU
17. 8&# %#
    13&44
    7PM +BWBͷ຺߭ʲୈճʳ
    'MZXBZʹΑΔޮ཰తͳ%#εΩʔϚ؅ཧ
18. 8IBU
    JT
    qZXBZQMBZ
19. qZXBZQMBZ w 'MZXBZ
    NPEVMF
    GPS
    1MBZ
    
    w QMBZqZXBZ
    JT
    BWBJMBCMF
    GPS
    
    
20. libraryDependencies ++= Seq(
 "org.flywaydb" %% "flyway-play" % "2.1.0"
 ) play.modules.enabled += "org.flywaydb.play.PlayModule" CVJMETCU BQQMJDBUJPODPOG
21. 8IZ
    OPU
    QMBZFWPMVUJPOT
22. QMBZFWPMVUJPOT w EFQFOET
    PO
    1MBZ
    w JT XBT
    OPU
    DBQBCMF
    PG
    JOUFHSBUJOH
    XJUI
    TPNF
    EBUBCBTF
    MJCSBSJFT
    UIBU
    EPO`U
    EFQFOE
    PO
    QMBZBQJEC
    w JT
    OPU
    TP
    qFYJCMF
23. %JGGFSFODF
    GSPN
    QMBZFWPMVUJPOT
24. w 6QT
    
    %PXOT
    w .BSLFS
    DPNNFOU QMBZFWPMVUJPOT
25. qZXBZQMBZ w /P
    b%PXOT`
    QBSU
    w 1MBJO
    42-
26. QMBZFWPMVUJPOT w TRM
    TRM
    TRM
    ʜ
27. qZXBZQMBZ w 0OF
    PS
    NPSF
    OVNFSJD
    QBSUT
    w 4FQBSBUFE
    CZ
    B
    EPU
    
    PS
    BO
    VOEFSTDPSF
    @
    w 6OEFSTDPSFT
    BSF
    SFQMBDFE
    CZ
    EPUT
    BU
    SVOUJNF
    w -FBEJOH
    [FSPFT
    BSF
    JHOPSFE
    JO
    FBDI
    QBSU "
    WFSTJPO
    NVTU
    IBWF
    
    
    
    
    UIF
    GPMMPXJOH
    TUSVDUVSF
28. qZXBZQMBZ w 
    w 
    w 
    w @
    
    BU
    SVOUJNF
    w 
    w 
    w 
    w 
    w  &YBNQMFT
    PG
    WBMJE
    WFSTJPO
29. QMBZFWPMVUJPOT TRM TRM DPOqJDU
    
    NFSHF TRM
30. QMBZFWPMVUJPOT
31. QMBZFWPMVUJPOT 7@@ʜʜTRM 7@@ʜʜTRM 7@@ʜʜTRM OP
    DPOqJDUT
32. 5JQT
    
    VTFDBTFT
33. &NCFE
    JO
    ZPVS
    BQQ w 'MZXBZ
    IBT
    +BWB
    "1*
    w &BTZ
    UP
    FNCFE
    JO
    BQQ
    UFTU val flyway = new Flyway
 flyway.setDataSource(dataSource)
 flyway.migrate()

34. &YJTUJOH
    EBUBCBTF
    TFUVQ 
    qZXBZ
    CBTFMJOF
    %qZXBZCBTFMJOF7FSTJPO
    %qZXBZCBTFMJOF%FTDSJQUJPO#BTF
    WFSTJPO IUUQqZXBZECPSHEPDVNFOUBUJPOFYJTUJOHIUNM
35. 'SPN
    $-* w 4CU
    .BWFO
    (SBEMF
    JO
    EFW
    FOWJSPONFOU
    w $-*
    UPPM
    JO
    QSPE
36. XJUI
    TMJDLDPEFHFO w QJUGBMM
    qZXBZQMBZ
    EPFTO`U
    XPSL
    XJUI
    TMJDLDPEFHFO
    w qZXBZQMBZ
    FGGFDUT
    PO
    TUBSUJOH
    UIF
    QMBZ
    BQQ
    
    w TMJDLDPEFHFO
    FGGFDUT
    JO
    DPNQJMFUJNF
    w 6TF
    TCUQMVHJO
    JOTUFBE
37. XJUI
    TMJDLDPEFHFO w IUUQTHJUIVCDPNUPUPUPTIJTCUTMJDLDPEFHFOFYBNQMF
38. 4VNNBSZ
39. w 'MZXBZ
    NBLFT
    EC
    NJHSBUJPO
    FBTZ
    w TJNQMF
    QPSUBCMF
    BOE
    QPXFSGVM
    w 5SZ
    JG
    ZPV
    BSF
    JO
    USPVCMF
    XJUI
    QMBZ FWPMVUJPOT