PMOBの話すやつ #1
Ϳͽʔʹ͍ͭͯ
View Slide
୭
୭☞ Twitter: cohalz☞ Github: cohalz☞ Ingress: cohalz☞ ӺϝϞ: cohalz☞ άϧίε(ΞϓϦ൛): cohalzio͋ͱͳΜ͔͋Γ·͚ͨͬ͠
Ϳͽʔͱ
Ϛϧίϑ࿈Ͱಈ͘Twitter bot
takuti/twitter-botͷFork
ओͳಛ
IgoͰͳ͘MeCabΛ༻͍ͯܗଶૉղੳ☞ ࠓྲྀߦΓͷmecab-ipadic-NEologd͕͑Δ☞ ͍ͯ͏͔ͦͦIgoಈ͔ͳ͔͔ͬͨΒࠩ͠ସ͑ͨ
Ϛϧίϑ࿈☞ จষΛ3~4ͭʹॱʹ͚ɼ͋Δจষͷ࢝·Γ͕લͷจষͷऴΘΓͱҰக͢ΔͷΛͱͬͯܨ͛Δ☞ ୯ʹDBʹ1,2,3,4൪ͷςʔϒϧΛ༻ҙͯ͠ݕࡧͯ͠ܨ͛ͯΔ͚ͩ☞ ૠೖܗଶૉʹ͚ͯ1ͭͣͭॱ൪ͣΒͯ͠ૠೖ
mysql> select * from fourorder limit 15;+-----------------+-----------------+--------+--------+| first | second | third | fourth |+-----------------+-----------------+--------+--------+| ϫϯμϑϧ | ( | U | ´ || ( | U | ´ | Д || U | ´ | Д | `) || ´ | Д | `) | || Ϳͽʔ | ͱ͔͍͏ | ͭ | ͳ || ͱ͔͍͏ | ͭ | ͳ | Μ || ͭ | ͳ | Μ | ͩ || ͳ | Μ | ͩ | || ެࣜ | Ϛείοτ | ͬͯ | ୭ || Ϛείοτ | ͬͯ | ୭ | ͕ || ͬͯ | ୭ | ͕ | ೝΊ || ୭ | ͕ | ೝΊ | ͨ || ͕ | ೝΊ | ͨ | Μ || ೝΊ | ͨ | Μ | ͩ || ͨ | Μ | ͩ | Α |+-----------------+-----------------+--------+--------+
Ϧϓͷ༰ʹԠ
Ϧϓͷ༰ʹԠ☞ ϦϓϥΠͷจࣈྻ͔ΒMeCabΛ༻໊͍ͯࢺͱه߸ͷΈൈ͖ग़͢☞ ൈ͖ग़͞Εͨͷ͔ΒϥϯμϜʹҰͭબΜͰDB☞ DB͕ۭͷ݁Ռฦͨ͠ΒϥϯμϜʹϨίʔυΛҰͭબΜͰଓ͚Δ
ϥϯμϜੑͱ
order by rand()ΊͪΌ͍
order by rand()ΊͪΌ͍☞ ͔֬ʹϥϯμϜʹͳΔ͚Ͳશ݅औಘ☞ Ϛϧίϑ࿈͔ͳΓͷճΫΤϦΛ͛Δ☞ where rand() < 0.05 limit 40ͱٖͯ͠ࣅతʹ
ࣗಈ࠶ىಈ☞ cronͰ20ຖʹىಈ☞ طʹىಈͯ͠σʔϞϯԽ͍ͯ͠ΔϓϩηεΛ࣍ͷىಈ࣌ʹࡴ͢
͖ͬ͞ެ։͠·ͨ͠https://github.com/cohalz/MOBP