SequelizeのPaginationで苦労した話

Transcript

1. Sequelizeͷ PaginationͰ ۤ࿑ͨ͠࿩ kskn / 2018.06.28 @Roppongi.js #4
2. ࣗݾ঺հ ɾKeisuke Nakatane (@kskn) ɾORSO Inc. ৽نࣄۀ։ൃࣨ ɾαʔόɿΞϓϦɿϑϩϯτ ʹɹ̓ɹɿɹ̍ɹɿɹ̎ɹɹ͘Β͍ ɾલ৬͸ژ౎ͷήʔϜ԰Ͱਓࣄ
3. ߏ੒͸ͬ͘͟Γ͜Μͳײ͡ ʢ؅ཧπʔϧʣ ʢΞϓϦʣ ʢAPIαʔόʣ
4. What’s Sequelizeʁ
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. How to Paginate
8. Pagination ɾOffset ɹ- ࠷ॳ͔Β nϨίʔυΛಡΈඈ͹͢ ɹɹˠ ख͚ܰͩͲύϑΥʔϚϯεͱਫ਼౓ ❌ ɾCursor ɹ- SELECT ͷ։࢝ҐஔΛࢦఆ ɹɹˠ ͬͪ͜Ͱ΍Γ͍ͨ
9. Pagination ɾOffset ɹ- ࠷ॳ͔Β nϨίʔυΛಡΈඈ͹͢ ɹɹˠ ख͚ܰͩͲύϑΥʔϚϯεͱਫ਼౓ ɾCursor ʢࣺͯΔʣ ʢಡ·ͳ͍ʣ
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. Pagination / multi cursor ɾෳ਺ΧϥϜͰιʔτ͢Δ৔߹Ͳ͏ͳΔ͔ʁ ɹˠ ߦ஋ࣜ SELECT * FROM users ɹWHERE (age, id) > (20, 30) ɹORDER BY age, id ɹLIMIT 10
12. by Sequelizeʁ
13. by Sequelize ɾ୯ҰΧϥϜͷ৔߹ ɹ- $gt ͸ ʮ > ʯ(greater than) User.findAll({ ɹwhere: { id: { $gt: 30 } }, ɹorder: [['id', 'ASC']], ɹlimit: 10, })
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. Summary ɾ࣮ࡍ͸൚༻ϞδϡʔϧԽΛ໨ࢦͨ݁͠Ռɺ ɹຐվ଄ؾຯ… ɹ- GraphQLͱͷབྷΈ ɹ- GROUP BYͱซ༻Ͱ͖ΔΑ͏ʹ ɹ- DATEܕͷ৔߹CASTͨ͠Γ ɾGarphQLରԠࠐΈͰϥΠϒϥϦԽͰ͖ͨΒ ɹधཁ͋Δʁ ɾSequelizeɺѱ͘ͳ͍ͱࢥ͏Αʂ
16. Thank you for listeningʂ