Upgrade to Pro — share decks privately, control downloads, hide ads and more …

DynamoDBでQuery

jacoyutorius
February 22, 2020

 DynamoDBでQuery

Hamamatsu.js #8のLT資料です

jacoyutorius

February 22, 2020
Tweet

More Decks by jacoyutorius

Other Decks in Technology

Transcript

  1. "NB[PO%ZOBNP%#Ͱݕࡧ͢Δ
    !KBDPZVUPSJVT
    )BNBNBUTVKT

    View Slide

  2. খ໦༔ే !KBDPZVUPSJVT

    ‣ ΤΞʔζגࣜձࣾ
    ‣ +"846()BNBNBUTVSC
    ‣ 3VCZ3VCZPO3BJMT+BWBTDSJQU"84
    ࠷ۙ͸ࣗ࡞ΩʔϘʔυͱΧϨʔ࡞ΓʹϋϚ͍ͬͯΔ

    View Slide

  3. View Slide

  4. View Slide

  5. +4͸ύΠϓ໓ଟʹ࢖Θͳ͍͔Βେৎ෉ͩΖଟ෼

    View Slide

  6. "NB[PO%ZOBNP%#
    ‣ ϑϧϚωʔδυͳ/P42-σʔλϕʔε
    ‣ ߴՄ༻ੑ ͭͷ";΁ͷϨϓϦέʔγϣϯ

    ‣ ΩʔόϦϡʔετΞ
    ‣ εΩʔϚϨε
    ‣ ΩϟύγςΟϢχοτ
    ‣ ಡΈॻ͖ੑೳΛܾఆ͢Δύϥϝʔλ
    ‣ lΦϯσϚϯυzͱ͍͏Φϓγϣϯ΋͋Δɻ"NQMJGZΛ௨ͯ͠%ZOBNP%#ͷςʔϒϧ
    Λ࡞ͬͨ৔߹ɺσϑΥϧτͰͪ͜ΒͷΦϓγϣϯ͕༗ޮʹͳΔ

    View Slide

  7. %ZOBNP%#ͷݕࡧ
    ‣ RVFSZ
    ‣ TDBO
    ςʔϒϧશମΛεΩϟϯͯ͠৚݅ʹ߹க͢Δ΋ͷΛฦ͢
    ύʔςΟγϣϯΩʔιʔτΩʔΛࢦఆͯ͠৚݅ʹ߹க͢Δ΋ͷ
    Λநग़͢Δ
    ॊೈͳݕࡧ͕ՄೳͳҰํɺ%#΁ͷෛՙ͕ߴ͘ύϑΥʔϚϯε΋ྑ͘ͳ͍

    View Slide

  8. ΍Γ͔ͨͬͨ͜ͱ
    ‣ %ZOBNP%#Ͱݕࡧ
    ‣ ύʔςΟγϣϯΩʔιʔτΩʔΛ࢖͏

    View Slide

  9. ΍͍ͬͯͳ͍͜ͱ
    ‣ ΩϟύγςΟϢχοτͷࢼࢉ
    ‣ ྉۚ

    View Slide

  10. EPDLFSDPNQPTFZNM

    View Slide

  11. ‣ %ZOBNP%#"ENJO
    ‣ IUUQMPDBMIPTU
    ‣ EBUBCBTFFOEQPJOU
    ‣ IUUQMPDBMIPTU
    %ZOBNP%#ΛϩʔΧϧͰىಈ

    View Slide

  12. View Slide

  13. ॅॴ$% ౎ಓ෎ݝ$% ࢢ۠ொଜ$% ொҬ$% ༣ศ൪߸ ࣄۀॴϑϥά ഇࢭϑϥά ౎ಓ෎ݝ ౎ಓ෎ݝΧφ ࢢ۠ொଜ ࢢ۠ொଜΧφ
    ੩Ԭݝ γζΦΧέϯ ඿দࢢத۠
    ϋϚϚπγφ
    ΧΫ
    ੩Ԭݝ γζΦΧέϯ ඿দࢢத۠
    ϋϚϚπγφ
    ΧΫ
    ொҬ ொҬΧφ ொҬิ଍ ژ౎௨Γ໊ ࣈஸ໨ ࣈஸ໨Χφ ิ଍ ࣄۀॴ໊
    ࣄۀॴ໊Χ
    φ
    ࣄۀॴॅॴ ৽ॅॴ$%
    ஁໶ொ ΧδϚν
    יߐ ΧϞΤ ඿দࢢอ݈ॴ
    ϋϚϚπγϗ
    έϯδϤ
    יߐ̎ஸ໨̍
    ̍—̎
    ॅॴKQ
    IUUQKVTZPKQ

    View Slide

  14. 1,Ͱݕࡧ͢Δ
    ॅॴ$% ॅॴ ॅॴΧφ
    ੩Ԭݝ඿দࢢத۠יߐொ γζΦΧέϯϋϚϚπγφΧΫΧϞΤνϣ΢

    ੩Ԭݝ඿দࢢத۠יߐொத෦ిྗɹʢגʣɹ඿দӦۀॴיߐொ̎
    ̎—̍
    γζΦΧέϯϋϚϚπγφΧΫΧϞΤνϣ΢νϢ΢ϒσϯϦϤΫɹʢΧϒʣɹ
    ϋϚϚπΤΠΪϤ΢γϤ

    View Slide

  15. ύʔςΟγϣϯΩʔࢦఆʹΑΔݕࡧ݁Ռ

    View Slide

  16. ύʔςΟγϣϯΩʔࢦఆʹΑΔݕࡧ݁Ռ

    View Slide

  17. 1,4,Ͱݕࡧ͢Δ

    View Slide

  18. https:/
    /docs.aws.amazon.com/ja_jp/amazondynamodb/latest/developerguide/
    LegacyConditionalParameters.KeyConditions.html
    “ςʔϒϧʹର͢ΔΫΤϦͷ৔߹ɺςʔϒϧͷϓϥΠϚϦΩʔଐੑͷΈ
    ͷ৚݅Λ࣋ͭ͜ͱ͕Ͱ͖·͢ɻEQ ৚݅ͱͯ͠ύʔςΟγϣϯΩʔͷ໊
    લͱ஋Λఏڙ͢Δඞཁ͕͋Γ·͢ɻ
    ΦϓγϣϯͰɺιʔτΩʔΛࢀর͢Δ 2 ൪໨ͷ৚݅ΛࢦఆͰ͖·͢ɻ”
    RVFSZͷ੍ݶ

    View Slide

  19. https:/
    /docs.aws.amazon.com/ja_jp/amazondynamodb/latest/developerguide/
    LegacyConditionalParameters.KeyConditions.html
    KeyConditions ͷ৔߹ɺ࣍ͷൺֱԋࢉࢠͷΈ͕αϙʔτ͞Ε͍ͯ·͢ɻ
    EQ | LE | LT | GE | GT | BEGINS_WITH | BETWEEN
    RVFSZͷ੍ݶ

    View Slide

  20. IUUQTEPDTBXTBNB[[email protected][POEZOBNPECMBUFTUEFWFMPQFSHVJEF)PX*U8PSLT1BSUJUJPOTIUNM

    View Slide

  21. ࢁསݝ
    ੩Ԭݝ
    Ѫ஌ݝ
    ʜ
    ੩ԬࢢѮ۠
    ੩Ԭࢢਗ਼ਫ۠
    ʜ
    ඿দࢢத۠
    ඿দࢢ੢۠
    ʜ
    ஁໶ொ
    ࠠ԰ொ
    ʜ
    יߐ
    ݩ඿ொ
    ʜ
    FY
    TFMFDUCPYͰυϦϧμ΢ϯ͢ΔΑ͏ͳ6*

    View Slide

  22. (4*
    ‣ ςʔϒϧ࡞੒࣌ʹࢦఆ͢Δ1,4,ͱ͸ผʹఆٛͰ͖ΔΠϯσοΫε
    ‣ Ұͭͷςʔϒϧʹ͖ͭɺ࠷େͭͷ(4*͕ొ࿥Մೳ
    ‣ (4*͝ͱʹΩϟύγςΟϢχοτͷઃఆ͕ඞཁ
    ‣ (4*͸ςʔϒϧͷࣹӨɻϨίʔυͷొ࿥௚ޙʹ(4*΁ݕࡧΛ͔͚ͯ΋͙͢ʹ
    ൓ө͞Ε͍ͯͳ͍৔߹͕͋Δ
    άϩʔόϧηΧϯμϦΠϯσοΫε

    View Slide

  23. ॅॴ$%
    ౎ಓ෎ݝ
    $%
    ࢢ۠ொଜ
    $%
    ொҬ$% ༣ศ൪߸
    ࣄۀॴϑϥ
    ά
    ഇࢭϑϥά ౎ಓ෎ݝ
    ౎ಓ෎ݝΧ
    φ
    ࢢ۠ொଜ
    ࢢ۠ொଜΧ
    φ
    ொҬ ொҬΧφ



    ੩Ԭݝ
    γζΦΧέ
    ϯ
    ඿দࢢத۠
    ϋϚϚπγ
    φΧΫ
    יߐ ΧϞΤ
    DBUFHPSZ WBMVF
    DJUZ ඿দࢢத۠
    DBUFHPSZ WBMVF
    QSFGFDUVSF ੩Ԭݝ
    DBUFHPSZ WBMVF
    UPXO יߐ

    View Slide

  24. ॅॴ$% DBUFHPSZ [email protected] ౎ಓ෎ݝ ࢢ۠ொଜ ொҬ
    QSFGFDUVSF ੩Ԭݝ ੩Ԭݝ
    DJUZ ੩Ԭݝ඿দࢢத۠ ඿দࢢத۠
    UPXO ੩Ԭݝ඿দࢢத۠יߐ יߐ
    1, 4,
    ॅॴ$%
    ౎ಓ෎ݝ
    $%
    ࢢ۠ொଜ
    $%
    ொҬ$% ༣ศ൪߸
    ࣄۀॴϑϥ
    ά
    ഇࢭϑϥά ౎ಓ෎ݝ
    ౎ಓ෎ݝΧ
    φ
    ࢢ۠ொଜ
    ࢢ۠ொଜΧ
    φ
    ொҬ ொҬΧφ



    ੩Ԭݝ
    γζΦΧέ
    ϯ
    ඿দࢢத۠
    ϋϚϚπγ
    φΧΫ
    יߐ ΧϞΤ

    View Slide

  25. ॅॴ$% DBUFHPSZ [email protected] ౎ಓ෎ݝ ࢢ۠ொଜ ொҬ
    QSFGFDUVSF ੩Ԭݝ ੩Ԭݝ
    DJUZ ੩Ԭݝ඿দࢢத۠ ඿দࢢத۠
    UPXO ੩Ԭݝ඿দࢢத۠יߐ יߐ
    1, 4,
    1, 4,
    ॅॴ$% DBUFHPSZ [email protected] ౎ಓ෎ݝ ࢢ۠ொଜ ொҬ
    QSFGFDUVSF ੩Ԭݝ ੩Ԭݝ
    DJUZ ੩Ԭݝ඿দࢢத۠ ඿দࢢத۠
    UPXO ੩Ԭݝ඿দࢢத۠יߐ יߐ
    (4*

    View Slide

  26. (4*ύʔςΟγϣϯΩʔࢦఆʹΑΔݕࡧ݁Ռ

    View Slide

  27. (4*ύʔςΟγϣϯΩʔιʔτΩʔࢦఆʹΑΔ
    લํҰகݕࡧ݁Ռ

    View Slide

  28. (4*ύʔςΟγϣϯΩʔιʔτΩʔࢦఆʹΑΔݕࡧ݁Ռ

    View Slide

  29. ࢁསݝ
    ੩Ԭݝ
    Ѫ஌ݝ
    ʜ
    ੩ԬࢢѮ۠
    ੩Ԭࢢਗ਼ਫ۠
    ʜ
    ඿দࢢத۠
    ඿দࢢ੢۠
    ʜ
    ஁໶ொ
    ࠠ԰ொ
    ʜ
    יߐ
    ݩ඿ொ
    ʜ
    FY
    TFMFDUCPYͰυϦϧμ΢ϯ͢ΔΑ͏ͳ6*

    View Slide

  30. %ZOBNP%#σʔλϞσϦϯάދͷר
    IUUQNBSDZIBUFOBCMPHDPNFOUSZ
    ͷ΅Γʔ͞ΜͷΫϥ΢υΠϯϑϥ1PEDBTUʰ5SBDLরҪ͞Μͷ
    4FSWFSMFTTΞʔΩςΫτࢦೆͱɺ1BUSFPOొ࿥ͷ͓஌ΒͤʱͷϝϞ
    IUUQTDMPVEJOGSBBVEJPUSBDLEGFD
    %ZOBNP%#Λ࢖༻ͨ͠ઃܭͱΞʔΩςΫνϟͷઃܭʹؔ͢ΔϕετϓϥΫςΟε
    IUUQTEPDTBXTBNB[[email protected][POEZOBNPECMBUFTUEFWFMPQFSHVJEFCFTU
    QSBDUJDFTIUNM

    View Slide

  31. View Slide

  32. View Slide

  33. View Slide

  34. "84&YQFSU0OMJOF+"846(඿দ"84ษڧձ
    IUUQTKBXTVHIBNBNBUTVEPPSLFFQFSKQFWFOUT
    +"846(඿দ"84ษڧձ
    IUUQTKBXTVHIBNBNBUTVEPPSLFFQFSKQFWFOUT
    +"84%":4
    IUUQTKBXTEBZTKBXTVHKQ

    View Slide