老舗15年のwebメディアをAPIサーバー化した話

Transcript

1. ࿝ฮ೥ͷXFCϝσΟΞΛ
 "1*αʔόʔԽͨ͠࿩ %FW-07&
   
 ӽڥ$0/
   
 !NBDPUBTV

2. ࣗݾ঺հ

3. 
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   !NBDPUBTV
 HJUIVC
   .BDP5BTV
 UXJUUFS
   IUUQTUXJUUFSDPN.BDP@5BTV
 

   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   DIJFGFOHJOFFS


4. BOJNBUF
   5JNFT ೥͔Β৘ใΛൃ৴͍ͯ͠ΔXFCϝσΟΞ
   ੠༏Ξχϝχϡʔε
   Ξχϝಈը
   ੠༏ϥδΦ
   17഑৴
   
   νέοτ
   FUDʜ
   Ξχϝ৘ใΛຖ೔ൃ৴ɺಡऀʹ͓ಧ͚͍ͯ͠Δ
   

5. IUUQXXXBOJNBUFUJNFTDPN

6. ࡢ೥݄ʹΞϓϦΛϦϦʔε

7. ຊ୊ "1*Խ͢ΔͨΊͷΞϓϩʔν

8. ࡢ೥݄̓ʹ্͔Β͓ୡ͕͋͠Γ·ͨ͠ ΞϓϦԽͷܦҢ

9. Њ
   ʮΞχϝΠτλΠϜζͷΞϓϦΛ࡞ͬͯ ΄͍͠ɻ݄຤ϦϦʔε໨ඪͰ΍ͬͯΈͯʯ ΞϓϦԽͷܦҢ

10. ЊЊЊ
    
    ͳɺͳΜͩͬͯʔʂʁ ΞϓϦԽͷܦҢ

11. ݱঢ়ͷαΠτΑΓշదʹ࢖͑Δ ΞϓϦԽͰͷϛογϣϯ

12. w XFCWJFXͩͱαΠτΛεϚϗͷϒϥ΢βͰΈΔͷͱมΘΒͳ͍
    w ΞϓϦͰͷදࣔ଎౓͕XFCWJFXͷ࣌ͱ"1*ͰKTPOͰΛฦͨ͠৔ ߹Ͱഒ଎౓͕ҧͬͨ
 IUUQEFWFMPQFSBOJNBUFMBCDPNFOUSZ  ΑΓշదʹ ΍ͬͺΓXFCWJFX͡Όͳͯ͘"1*͡Όͳ͖Όշదʹ ͸ͳΒͳ͍Ͷ

13. ೥͔Βಈ͍͍ͯΔͷͰΘΓͱʁϨΨγʔ ΞχϝΠτλΠϜζͷݱঢ় w Ṗͳίʔυ͕ͨ͘͞Μ
    w /P'SBNFXPSLͰࢄΒ͹͍ͬͯΔQIQϑΝΠϧ
    w ࿝ٺԽͨ͠αʔόʔ
    w ։ൃ؀ڥ͕ͳ͍ʹ౳͍͠
    

    w FUD

14. ͜ͷ؀ڥʹ࡞Ζ͏ͱ͢Δͱ
 ຤ʹऴΘΒͳ͍ͷͰ͸ʁ

15. ࡞ઓ XFCϝσΟΞຊମͱ"1*͸ผΞϓϦͱͯ͠ੈքΛ෼͚Δ

16. ੈքΛ෼͚ΔϝϦοτσϝϦοτ w ຊମ؀ڥͷঢ়ଶΛؾʹͤͣʹ࣮૷Ͱ͖Δ
    w ΞΫηε͕૿͑ͨ࣌ʹ྆ܥ͕ࢮ͵ͷΛආ͚Δ
    w Ұ͔Β࡞ΔͷͰɺṖͷଟ͍ίʔυͷղੳʹ࣌ؒΛ࢖ Θͣɺ"1*Λ࡞Δ͜ͱʹઐ೦Ͱ͖Δ
    ϝϦοτ
    σϝϦοτ

    w ͪΐͬͱ͓͔͔ۚΔ
    w ӡ༻ίετ΋૿͑Δ

17. "1*αʔόʔͷಈ࡞؀ڥ w MBOHVBHF
    3VCZ
    
    w TFSWFS
    QVNB
    w GSBNFXPSL
    HSBQF

18. w ϝσΟΞຊମ͔Βੜ੒͞ΕͨσʔλΛࢀর͢Δ
 w औಘͨ͠هࣄσʔλΛKTPOʹͯ͠ฦ͢
 "1*Խʹඞཁͳ͜ͱ

19. "1*Խʹඞཁͳ͜ͱ w ϝσΟΞຊମ͔Βੜ੒͞ΕͨσʔλΛࢀর͢Δ
 w औಘͨ͠هࣄσʔλΛKTPOʹͯ͠ฦ͢


20. "1*Խʹඞཁͳ͜ͱ w ϝσΟΞຊମ͔Βੜ੒͞ΕͨσʔλΛࢀর͢Δ
 w औಘͨ͠هࣄσʔλΛKTPOʹͯ͠ฦ͢


21. هࣄσʔλΛࢀর͢Δ

22. هࣄσʔλΛࢀর͢Δ CREATE TABLE `article` ( `id` int(10) NOT NULL, `body_1`

    text NOT NULL, `body_2` longtext, `public_flag` int(1) NOT NULL DEFAULT '0', `start_at` datetime NOT NULL, `end_at` datetime NOT NULL, `category_a` int(10) NOT NULL, `category_b` int(10) NOT NULL, `category_c` int(10) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), ) ENGINE=MyISAM DEFAULT CHARSET=utf8; هࣄσʔλͷςʔϒϧ

23. هࣄσʔλΛࢀর͢Δ CREATE TABLE `article` ( `id` int(10) NOT NULL, `body_1`

    text NOT NULL, `body_2` longtext, `public_flag` int(1) NOT NULL DEFAULT '0', `start_at` datetime NOT NULL, `end_at` datetime NOT NULL, `category_a` int(10) NOT NULL, `category_b` int(10) NOT NULL, `category_c` int(10) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), ) ENGINE=MyISAM DEFAULT CHARSET=utf8; هࣄσʔλͷςʔϒϧ )5.-͕ͦͷ·· ͸͍ͬͯΔ

24. هࣄσʔλΛࢀর͢Δ CREATE TABLE `article` ( `id` int(10) NOT NULL, `body_1`

    text NOT NULL, `body_2` longtext, `public_flag` int(1) NOT NULL DEFAULT '0', `start_at` datetime NOT NULL, `end_at` datetime NOT NULL, `category_a` int(10) NOT NULL, `category_b` int(10) NOT NULL, `category_c` int(10) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), ) ENGINE=MyISAM DEFAULT CHARSET=utf8; هࣄσʔλͷςʔϒϧ ΧςΰϦʔ͕
 ̏ͭೖΔ

25. ͱ͋ΔهࣄͷΧςΰϦʔ

26. ΧϥϜ͕̏ͭͳͷʹͭҎ্ΧςΰϦʔ ͕͋Δͧʁ

27. هࣄσʔλΛࢀর͢Δ هࣄʹؔ࿈͢ΔΧςΰϦʔ͕͸͍Δςʔϒϧ͕·ͩ͋ͬͨ CREATE TABLE `article_attribute` ( `id` int(11) NOT NULL

    COMMENT 'article id', `key` varchar(30) NOT NULL COMMENT 'category', `key_int` int(11) NOT NULL COMMENT ‘category id', KEY (`id`,`key`), ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

28. هࣄσʔλΛࢀর͢Δ CREATE TABLE `category` ( `id` int(11) NOT NULL, `name`

    varchar(30) NOT NULL, PRIMARY KEY (`id`), ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

29. "1*ଆͰςʔϒϧߏ଄Λมߋ͢Δ

30. "1*ଆͰςʔϒϧߏ଄Λมߋ͢Δ ຊମଆ͔ΒσʔλΛࢀর͠ɺਖ਼نԽͯ͠Ω ϨΠʹͨ͠ঢ়ଶͰผͷ%#ʹೖΕΔ

31. ςʔϒϧߏ଄ͷมߋ CREATE TABLE `article` ( `id` int(10) NOT NULL, `headline`

    text NOT NULL, `body` longtext, `public_flag` int(1) NOT NULL DEFAULT '0', `start_at` datetime NOT NULL, `end_at` datetime NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

32. CREATE TABLE `article_categories` ( `article_id` int(11) NOT NULL, `category_id` int(11)

    NOT NULL, PRIMARY KEY (`category_id`,`article_id`), ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ςʔϒϧߏ଄ͷมߋ

33. ෛ࠴Λͭড়Խͨͧ͠

34. "1*Ͱͷهࣄύʔε

35. هࣄσʔλΛύʔε͢Δ

36. ύʔε࣌ʹٻΊΒΕΔ͜ͱ w ෆཁͳλά৘ใ͸ফ͢
 CςΩετC
    
    
    ςΩετ
    w ඞཁͳଐੑΛ͚ͭͯฦ͢
 ˙λΠτϧ
    
    খݟग़͠จࣈ
 ZPVUVCFϦϯΫ
    
    ಈը
 JNH
    
    ը૾
    w

    )5.-Λ+40/ʹ͢Δ

37. [ { "type": "headline", "value": “title dayo" }, { "type":

    "image", "value": “https://…” }, { "type": "link", "value": “https://…” },
 … ]

38. 1BSTFS
 HFUUBMPOHLSBNEPXO

39. 1BSTFS ਤࢀরIUUQTLSBNEPXOHFUUBMPOHPSH

40. LSBNEPXO w ,SBNEPXO1BSTFS#BTF
    ,SBNEPXO$POWFSUFS#BTFΛܧঝ͢Δ͜ͱͰ ύʔε΍ɺग़ྗͷ֦ு͕Ͱ͖Δ
    w ந৅ߏจ໦Λग़ྗͰ͖Δ
 LSBNEPXO
    UP
    +40/ͷॲཧ͕Ͱ͖ͦ͏

41. ݹ͍ϝσΟΞ͋Δ͋Δ <b><span class="txt_blue">title</span></b> ྫ
    খݟग़͠ w $.4ͷೖྗαϙʔτػೳ͕ऑ͘ɺਓʹΑͬͯඍົ ʹIUNMͷॻ͖ํ͕ҧ͏

42. ݹ͍ϝσΟΞ͋Δ͋Δ w $.4ͷೖྗαϙʔτػೳ͕ऑ͘ɺਓʹΑͬͯඍົ ʹIUNMͷॻ͖ํ͕ҧ͏ <b><span class="txt_blue">title</span></b> 
 <span class="txt_blue">title</span> ྫ

    
    খݟग़͠

43. ݹ͍ϝσΟΞ͋Δ͋Δ <b><span class="txt_blue">title</span></b> 
 <span class="txt_blue">title</span> 
 <font color="blue">title</font> ྫ

    
    খݟग़͠ w $.4ͷೖྗαϙʔτػೳ͕ऑ͘ɺਓʹΑͬͯඍົ ʹIUNMͷॻ͖ํ͕ҧ͏

44. ݹ͍ϝσΟΞ͋Δ͋Δ <b><span class="txt_blue">title</span></b> 
 <span class="txt_blue">title</span> 
 <font color="blue">title</font> 


    title:
 ྫ
    খݟग़͠ w $.4ͷೖྗαϙʔτػೳ͕ऑ͘ɺਓʹΑͬͯඍົ ʹIUNMͷॻ͖ํ͕ҧ͏

45. ݹ͍ϝσΟΞ͋Δ͋Δ <b><span class="txt_blue">title</span></b> 
 <span class="txt_blue">title</span> 
 <font color="blue">title</font> 


    title:
 
 etc… ྫ
    খݟग़͠ w $.4ͷೖྗαϙʔτػೳ͕ऑ͘ɺਓʹΑͬͯඍົ ʹIUNMͷॻ͖ํ͕ҧ͏

46. 808

47. ϑΥʔϚοτ౷Ұ͠Α͏

48. ϑΥʔϚοτ౷Ұ ಡऀʹͱͬͯѹ౗తʹಡΈ΍͘͢ͳΔͷͰ΍ͬͯଛ͸ ͳ͍

49. ϑΥʔϚοτ౷Ұͷํ๏ w ϥΠλʔ͞Μʹࠓޙͷೖྗํ๏ͷมߋͷप஌
 
    ࠓޙখݟग़͠͸
    TQBO
    DMBTTlUYU@CMVFzUJUMFTQBO ʹͯ͘͠Ε·ͤΜ͔ʜ
    w աڈهࣄʹ͍ͭͯ΋ϑΟʔϚοτἧ͍͑ͨͳʜ
 
    Ұهࣄͣͭͳ͓ͯ͠௖͚·ͤΜ͔ʜ 


50. ϑΥʔϚοτ౷Ұͷํ๏ w ϥΠλʔ͞Μʹࠓޙͷೖྗํ๏ͷมߋͷप஌
 
    ࠓޙ͸
    TQBO
    DMBTTlUYU@CMVFzUJUMFTQBOʹͯ͘͠ Ε·ͤΜ͔ʜ
    w աڈهࣄʹ͍ͭͯ΋ϑΟʔϚοτἧ͍͑ͨͳʜ
 
    Ұهࣄͣͭͳ͓ͯ͠௖͚·ͤΜ͔ʜ 


    օʹͱ݈ͬͯશͳํ๏͡Όͳ͍

51. ϑΥʔϚοτ౷Ұͷํ๏ w ϥΠλʔ͞Μʹࠓޙͷೖྗํ๏ͷมߋͷप஌
 
    $.4ػೳͰೖྗαϙʔτͷڧԽ
    w աڈهࣄʹ͍ͭͯ΋ϑΥʔϚοτἧ͍͑ͨͳʜ
 
    ύʔεͰ͕Μ͹Δ ٕज़Ͱղܾ͢Δ

52. ϑΥʔϚοτ౷Ұͷํ๏ w ϥΠλʔ͞Μʹࠓޙͷೖྗํ๏ͷมߋͷप஌
 
    $.4ػೳͰೖྗαϙʔτͷڧԽ
    w աڈهࣄʹ͍ͭͯ΋ϑΟʔϚοτἧ͍͑ͨͳʜ
 
    ύʔεͰ͕Μ͹Δ ٕज़Ͱղܾ͢Δ

53. ύʔεͰ͕Μ͹Δ
    
    ෼ྨ෼͚͢Δ <b><span class="txt_blue">title</span></b>
 <span class="txt_blue">title</span> 
 
 
 
 


    <font color="blue">title</font>
 title:
 etc… খݟग़͠ ࠇจࣈςΩετ

54. ,SBNEPXOͰύʔε ਖ਼نදݱͰখݟग़͠Λ൑ผ BOLD_HEADLINE_START # When this matches, type=headline = /^(?:<b>)?<span\s+class=(?<quote>["']?)txt_blue\k<quote+0>>/i


    BOLD_HEADLINE_MATCH # select text = %r{^(?:<b>)?(?<text><span\s+class=(? <quote>["']?)txt_blue\k<quote+0>>((?:.|\n)+?)</span>)(?:</b>)?\n}i { "type": "headline", "value": "title" }

55. ,SBNEPXOͰύʔε ਖ਼نදݱͰԿʹ΋Ϛον͠ͳ͍IUNMλά
 ͸௨ৗͷςΩετʹ͢Δ { "type": "text", "value": "title" } 3"8@)5.-@5"(@45"35
    
    

    UBH@OBNF aT 

56. ,SBNEPXOͰύʔε w Bλά
    w JNHλά
    w ZPVUVCF
    w UXJUUFS
    w

    খݟग़͠
    w ৭෇͖ݟग़͠
    w ͦͷଞ͸ͨͩͷจࣈྻ ࡞ͬͨओͳ෼ྨΘ͚ͷఆٛ

57. ࢥͬͨΑΓҧ࿨ײ͕ͳ͍
 ݟͨ໨ͷهࣄʹͳͬͨ

58. ݁Ռ͸ΞϓϦͰΈͯΈͶ

59. "1*αʔόʔԽͨ͠Ըܙ w ൚༻"1*αʔόʔͱͯ͠࡞ͬͨͷͰ৭ʑͳ͜ͱʹ࢖ ͑Δ༨஍͕Ͱ͖ͨ
 
    ࠓ·Ͱຊମͷѻ͍ʹ͍͘σʔλͷ͍ͤͰɺͰ͖ͳ ͔ͬͨ͜ͱ΋"1*αʔόʔ࢖͏͜ͱͰ࣮ݱ͠΍͘͢ ͳͬͨ
    ࣮ࡍʹԣͷαʔϏεͰ͔ͭ͏࿩΋Ͱ͍ͯΔ

60. ·ͱΊ w ຊମͱ"1*ͰੈքΛ෼͚Δ͜ͱͰɺݱঢ়ҡ࣋ͭͭ͠ ৽͍͜͠ͱ͕͠΍͘͢ͳͬͨ
    w "1*αʔόʔΛ࡞͓͔ͬͨ͛ͰαʔϏεʹ͍Ζ͍Ζ ͳՄೳੑ͕Ͱ͖ͨ
    w "1*αʔόʔԽͷաఔͰɺٕज़తෛ࠴ɾӡ༻໘ͷෛ ࠴ͳͲ੔ཧ͠޲͖߹͍ɺαʔϏεͷ඼࣭޲্ʹ΋ͭ

    ͳ͕ͬͨ

61. -FU`T
    "1*Խ

62. ͝੩ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠