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

SQLFormatter written in Go

E10d51de51c08e913216385be87dc1ca?s=47 pongzu
May 18, 2019

SQLFormatter written in Go

SQLを整形するツールを作った経緯やその実装手順についてまとめました。

E10d51de51c08e913216385be87dc1ca?s=128

pongzu

May 18, 2019
Tweet

Transcript

  1. 42-'PSNBUUFS XSJUUFOJO(P QPOH[V

  2. NF w /BNF:V5BOBLB w 5XJUUFS!@QPOH[V w (JU)VCIUUQTHJUIVCDPNQPOH[V w $PNQBOZ,BONV *OD


     TPGUXBSFFOHJOFFSJOUFSO
  3. XIBUJTHPTRMGNUʁ w IUUQTHJUIVCDPNLBONVHPTRMGNU w (PϑΝΠϧ಺ͷ42-จΛ౷Ұͨ͠ϑΥʔϚοτʹ੔ܗ w 1PTUHSF42-ʹରԠ

  4. #BDLHSPVOE w ΧϯϜͰ͸ɺٕज़બఆͷ݁Ռɺ"1*αʔόͷ%#ΞΫηεͷ ࣮૷Ͱɺ௚઀42-Λॻ͘

  5. #BDLHSPVOE w ݟͨ໨ʹ౷Ұײ͕ͳ͍ w ͲͷϑΥʔϚοτϧʔϧʹै͏͔ߟ͑Δ͕࣌ؒແବʹͳΔ

  6. %FNP

  7. IPX w 42-จΛݟ͚ͭΔ w UPLFOJ[F͢Δ w QBSTF͢Δ w JOEFOU͢Δ

  8. 42-Λݟ͚ͭΔ

  9. UPLFOJ[F w จࣈྻΛจࣈͣͭεΩϟϯ
 w ҙຯͷ͋Δࣝผࢠ͝ͱʹUPLFOJ[F͢Δ
 ྫʣ4&-&$5 '30.  

  10. QBSTF w Πϯσϯτ͢Δ୯ҐͰ͋Δ42-۟͝ͱʹτʔΫϯΛ෼཭ ʢάϧʔϐϯάʣ͢Δɻ
 ྫʣ4&-&$5͕ݱΕͨΒɺ'30.͕ݱΕΔ·Ͱͷτʔ ΫϯΛ4&-&$5άϧʔϓͱ͢Δ
 w άϧʔϓ಺ͰߋʹΩʔϫʔυ͕ݱΕͨ৔߹͸࠶ؼతʹॲཧ Λ͠ɺωετ͞Εͨ42-ʹ΋ରԠ͢Δ

  11. JOEFOU

  12. 5IBOLZPV☺