SequelizeのPaginationで苦労した話

Transcript

1. 1.

   Sequelizeͷ PaginationͰ ۤ࿑ͨ͠࿩ kskn / 2018.06.28 @Roppongi.js #4

2. 2.

   ࣗݾ঺հ ɾKeisuke Nakatane (@kskn) ɾORSO Inc. ৽نࣄۀ։ൃࣨ ɾαʔόɿΞϓϦɿϑϩϯτ ʹɹ̓ɹɿɹ̍ɹɿɹ̎ɹɹ͘Β͍ ɾલ৬͸ژ౎ͷήʔϜ԰Ͱਓࣄ

3. 3.

   ߏ੒͸ͬ͘͟Γ͜Μͳײ͡ ʢ؅ཧπʔϧʣ ʢΞϓϦʣ ʢAPIαʔόʣ

4. 4.

   What’s Sequelizeʁ

5. 5.

   None
6. 6.

   Sequelize ɾNode.js ༻ͷOR Mapper ɹ- http://docs.sequelizejs.com/ ɹ- Rails Ͱ͍͏Active Record

   ɾҰ൪ϝδϟʔͰ΍Γ͍ͨ͜ͱ͸Ͱ͖ͦ͏ ɾݹ͍৘ใ΋ώοτ͢ΔͷͰ஫ҙ (ver 3.x) ɹ- ࠷৽͸ ver 4.38 ͱ ver 5 Beta (2018/06/24)
7. 7.

   How to Paginate

8. 8.

   Pagination ɾOffset ɹ- ࠷ॳ͔Β nϨίʔυΛಡΈඈ͹͢ ɹɹˠ ख͚ܰͩͲύϑΥʔϚϯεͱਫ਼౓ ❌ ɾCursor ɹ-

   SELECT ͷ։࢝ҐஔΛࢦఆ ɹɹˠ ͬͪ͜Ͱ΍Γ͍ͨ
9. 9.

   Pagination ɾOffset ɹ- ࠷ॳ͔Β nϨίʔυΛಡΈඈ͹͢ ɹɹˠ ख͚ܰͩͲύϑΥʔϚϯεͱਫ਼౓ ɾCursor ʢࣺͯΔʣ ʢಡ·ͳ͍ʣ

10. 10.

    Pagination ɾOffset ɹ- ࠷ॳ͔Β nϨίʔυΛಡΈඈ͹͢ ɹɹˠ ख͚ܰͩͲύϑΥʔϚϯεͱਫ਼౓ ɾCursor SELECT *

    FROM users ɹORDER BY id LIMIT 10 OFFSET 30 SELECT * FROM users ɹWHERE id > 30 ORDER BY id LIMIT 10
11. 11.

    Pagination / multi cursor ɾෳ਺ΧϥϜͰιʔτ͢Δ৔߹Ͳ͏ͳΔ͔ʁ ɹˠ ߦ஋ࣜ SELECT * FROM

    users ɹWHERE (age, id) > (20, 30) ɹORDER BY age, id ɹLIMIT 10
12. 12.

    by Sequelizeʁ

13. 13.

    by Sequelize ɾ୯ҰΧϥϜͷ৔߹ ɹ- $gt ͸ ʮ > ʯ(greater than)

    User.findAll({ ɹwhere: { id: { $gt: 30 } }, ɹorder: [['id', 'ASC']], ɹlimit: 10, })
14. 14.

    by Sequelize / multi cursor ɾΧϥϜʹ (age, id) Έ͍ͨͳࢦఆ͸Ͱ͖ͳ͍ ɾsequelize.literal('

    SQLจ ‘) Ͱ௚઀ॻ͚Δ User.findAll({ ɹwhere: ɹɹsequelize.literal('(age, id) > (20, 30)'), ɹorder: [['age', 'ASC'], ['id', 'ASC']], ɹlimit: 10, })
15. 15.

    Summary ɾ࣮ࡍ͸൚༻ϞδϡʔϧԽΛ໨ࢦͨ݁͠Ռɺ ɹຐվ଄ؾຯ… ɹ- GraphQLͱͷབྷΈ ɹ- GROUP BYͱซ༻Ͱ͖ΔΑ͏ʹ ɹ- DATEܕͷ৔߹CASTͨ͠Γ

    ɾGarphQLରԠࠐΈͰϥΠϒϥϦԽͰ͖ͨΒ ɹधཁ͋Δʁ ɾSequelizeɺѱ͘ͳ͍ͱࢥ͏Αʂ
16. 16.

    Thank you for listeningʂ