Kyauta Mai Tsara & Kyautata SQL

Yadda Yake Aiki

Wannan mai tsara SQL an gina shi gaba ɗaya daga wani mai tsara alamomi da mai tsara da aka rubuta da hannu — babu ɗakin karatu na waje da ake amfani da shi. Tsarawa da haske na syntax suna gudana nan take a burauza yayin da kake bugawa, babu uwar garke da abin ya shafa.

1. 1
   Mai tsara alamomi yana raba SQL

   Wani mai tsara alamomi harafi-bayan-harafi yana tafiya shigarwarka kuma yana raba ta zuwa alamomi masu tsari: harafi na ambaton (yana sarrafa duka backslash escapes da salon ambaton-biyu na SQL), sharhin layi (--), sharhin block (/* */), operators, baka, masu ganewa, da lambobi. Ana rushe farin sarari zuwa alama guda ta sarari.
2. 2
   An haɗa kalmomin haɗe-haɗe

   Bayan tsara alamomi, wata wucewa ta biyu tana haɗa alamomin kusa da junansu waɗanda suke gina kalmomin-haɗe masu kalma-da-yawa — don haka 'LEFT' da 'JOIN' ke biye ta zama alamar 'LEFT JOIN' guda ɗaya, kuma 'GROUP' da 'BY' ke biye ta zama 'GROUP BY'. Wannan shine yake barin mai tsara ya tsara su a matsayin abubuwan tsari guda ɗaya.
3. 3
   Tsarin block ko minification

   A yanayin tsarawa, kalmomin da suke fara block (SELECT, FROM, WHERE, JOIN, da sauransu) ana sanya su a layinsu tsayayye a sifili-tazara, kuma dukkan abin da yake biye ana tazarawa. AND/OR suna tilasta wani sabon layin da aka tazarawa. Waƙafi a matakin baka na sama suma suna zuwa layi na gaba. A yanayin minify, dukkan sabbin layuka da farin sarari mara-amfani ana rushe su zuwa jeri mai sarari-guda-daya.
4. 4
   Haske na syntax ta regex

   Ana wucewa fitarwa da aka tsara ta wani regex guda ɗaya wanda yake daidaita sharhi, harafi na ambaton, lambobi, da masu ganewa a wucewa guda. Ana lulluɓe kowace daidaituwa a wani span na React tare da wani aji na launi — sharhi a lankwasa marar-ƙarfi, harafi a amber, lambobi a purple, da kalmomin SQL (an duba su da cikakken saitin kalmomi) a teal — yana samar da panel na fitarwa mai launi.

Kayan Aiki Masu Alaƙa