もぶぴーについて

PMOBの話すやつ #1

Transcript

1. ΋Ϳͽʔʹ͍ͭͯ
3. ୭ ☞ Twitter: cohalz ☞ Github: cohalz ☞ Ingress: cohalz ☞ ӺϝϞ: cohalz ☞ άϧίε(ΞϓϦ൛): cohalzio ͋ͱͳΜ͔͋Γ·͚ͨͬ͠
4. ΋Ϳͽʔͱ͸
5. Ϛϧίϑ࿈࠯Ͱಈ͘Twitter bot
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