もぶぴーについて

Transcript

1. ΋Ϳͽʔʹ͍ͭͯ

2. ୭

3. ୭ ☞ Twitter: cohalz ☞ Github: cohalz ☞ Ingress: cohalz

   ☞ ӺϝϞ: cohalz ☞ άϧίε(ΞϓϦ൛): cohalzio ͋ͱͳΜ͔͋Γ·͚ͨͬ͠

4. ΋Ϳͽʔͱ͸

5. Ϛϧίϑ࿈࠯Ͱಈ͘Twitter bot

6. None

7. takuti/twitter-botͷFork

8. ओͳಛ௃

9. IgoͰ͸ͳ͘MeCabΛ༻͍ͯܗଶ ૉղੳ ☞ ࠓྲྀߦΓͷmecab-ipadic-NEologd͕࢖͑Δ ☞ ͍ͯ͏͔ͦ΋ͦ΋Igoಈ͔ͳ͔͔ͬͨΒࠩ͠ସ͑ͨ

10. Ϛϧίϑ࿈࠯ ☞ จষΛ3~4ͭ૊ʹॱʹ෼͚ɼ͋Δจষͷ࢝·Γ͕લͷจষͷऴ ΘΓͱҰக͢Δ΋ͷΛͱͬͯܨ͛Δ ☞ ୯ʹDBʹ1,2,3,4൪໨ͷςʔϒϧΛ༻ҙͯ͠ݕࡧͯ͠ܨ͛ͯΔͩ ͚ ☞ ૠೖ͸ܗଶૉʹ෼͚ͯ1ͭͣͭॱ൪ͣΒͯ͠ૠೖ

11. mysql> select * from fourorder limit 15; +-----------------+-----------------+--------+--------+ | first

    | second | third | fourth | +-----------------+-----------------+--------+--------+ | ϫϯμϑϧ | ( | U | ´ | | ( | U | ´ | Д | | U | ´ | Д | `) | | ´ | Д | `) | | | ΋Ϳͽʔ | ͱ͔͍͏ | ΍ͭ | ͳ | | ͱ͔͍͏ | ΍ͭ | ͳ | Μ | | ΍ͭ | ͳ | Μ | ͩ | | ͳ | Μ | ͩ | | | ެࣜ | Ϛείοτ | ͬͯ | ୭ | | Ϛείοτ | ͬͯ | ୭ | ͕ | | ͬͯ | ୭ | ͕ | ೝΊ | | ୭ | ͕ | ೝΊ | ͨ | | ͕ | ೝΊ | ͨ | Μ | | ೝΊ | ͨ | Μ | ͩ | | ͨ | Μ | ͩ | Α | +-----------------+-----------------+--------+--------+

12. Ϧϓͷ಺༰ʹ൓Ԡ

13. Ϧϓͷ಺༰ʹ൓Ԡ ☞ ϦϓϥΠͷจࣈྻ͔ΒMeCabΛ༻໊͍ͯࢺͱه߸ͷΈൈ͖ग़͢ ☞ ൈ͖ग़͞Εͨ΋ͷ͔ΒϥϯμϜʹҰͭબΜͰDB΁ ☞ DB͕ۭͷ݁Ռฦͨ͠ΒϥϯμϜʹϨίʔυΛҰͭબΜͰଓ͚Δ

14. ϥϯμϜੑͱ଎౓

15. order by rand()͸ΊͪΌ஗͍

16. order by rand()͸ΊͪΌ஗͍ ☞ ͔֬ʹϥϯμϜʹ͸ͳΔ͚Ͳશ݅औಘ ☞ Ϛϧίϑ࿈࠯͸͔ͳΓͷճ਺ΫΤϦΛ౤͛Δ ☞ where rand()

    < 0.05 limit 40ͱٖͯ͠ࣅతʹ

17. ࣗಈ࠶ىಈ ☞ cronͰ20෼ຖʹىಈ ☞ طʹىಈͯ͠σʔϞϯԽ͍ͯ͠ΔϓϩηεΛ࣍ͷىಈ࣌ʹࡴ͢

18. ͖ͬ͞ެ։͠·ͨ͠ https://github.com/cohalz/MOBP

19. None