mycli: Yakanakisa Terminal yeMySQL ine AutoComplete uye syntax inosimbisa

MySQL, MariaDB y percona ivo vatatu dhatabhesi anoshandiswa zvakanyanya nhasi, maviri ekutanga akabatanidzwa mune yakakura muzana yezvisviniro zvekushandisa zviripo nhasi. Ichi chikonzero nei zvakakosha kuve ne chinongedzo cheMySQL, MariaDB uye Percona izvo zvinotibvumidza isu kunyatso kubata aya madhatabhesi, kubva kunyaradzo uye kuita izvo iyo koni inotipa.

Ino nguva isu tichave tichiziva mycli, dhatabhesi terminal iyo ine hunhu hunodiwa kuti inyatso gadzirisa dhatabhesi, tisingashandise zvakawandisa zviwanikwa uye nemabhuku akazara atinogona.

Chii chinonzi mycli?

mycli chishandiso chakavhurika sosi, yakagadzirirwa mukati Python, iyo inotibvumidza isu kubata uye kuita MySQL, MariaDB, uye Percona mirairo nenzira inokurumidza, yakazvigadzirira uye inoshanda. Chishandiso chine advanced autocompletion system yemitauro yataurwa pamusoro, nenzira imwecheteyo, inosimbisa syntax nenzira yakajairika, iyo inotibatsira kubata matabhesi edu nenzira yakasununguka kubva kune iyo terminal.

Iyo ine yakaisirwa ipfupi yekumisikidza uye yekudzidza mutsetse, iyo yakawedzera kune ayo akanaka maitiro inoita kuti ive inonakidza kwazvo imwe nzira kune maturusi akatsaurirwa kune dhatabhesi manejimendi, kunyanya nekuda kwekushandisa kwayo kwakaderera zviwanikwa uye yayo yakakurumidza mhinduro nguva.

Kushandiswa kwakadzama kwechishandiso kunogona kuonekwa mune inotevera gif yakaburitswa nevagadziri vechishandiso:

Mycli maficha

• Yakazara yakavhurwa sosi, yakagadzirwa mu python uye ine yakanakisa zvinyorwa.
• Auto-yakazara seSQL kiyi mazwi akanyorwa, pamwe nematafura e database, maonero, uye makoramu.
• Yakanaka syntax inoratidzira kutenda kune Mapato.
• Smart auto-kupedzisa (iyo inogoneswa nekutadza), iyo inongopa chete zvinongedzo zvine chekuita nemamiriro.
  • SELECT * FROM <tab> zvinongo ratidza chete mazita ematafura.
  • SELECT * FROM users WHERE <tab> inongo ratidza chete mazita emakoramu.
• Tsigiro yemibvunzo inosanganisira inopfuura imwechete tambo.
• Iyo inobvumidza kuchengeta iyo yakanyanya kushandiswa mibvunzo, nekuti izvi zvakakwana kuchengetedza mubvunzo uchishandisa  \fs alias query uye shandisa unotevera kuraira \f alias paunenge uchida kuimhanya zvakare.
• Yakasimba uye yakapusa yekumisikidza faira, iyo inogadzirwa otomatiki mudhairekitori ~/.myclirc
• Iyo ine yakawandisa log system, kana tichida kuchengetedza nhoroondo yemirairo yakaitwa.
• Lets tishandise iyo Nice induction.
• Kuburitswa kwedata kwakarongeka uye kunonakidza, inoratidzwa mumakoramu ane mabhatani akapatsanurwa.
• Iyo ine rutsigiro rwe SSL kubatana.
• Zvinyorwa zvakadzama kana uchimhanya nerubatsiro rwechishandiso $ mycli --help
• Vamwe vazhinji zvakare.

Maitiro ekuisa mycli

Tinogona kuisa mycli pane chero Linux distro yekutenda kune python, kune izvi isu tinongofanirwa kunge takaiswa pombi nekuita unotevera kuraira:

$ sudo pip install -U mycli

Vashandisi veDebian uye ubuntu vanogona kuisa chishandiso zvakananga kubva kumahofisi epamutemo nekumhanya

$ sudo apt-get install mycli

Saizvozvo, Arch Linux nevashandisi vanowana vanogona kunakidzwa nechishandiso ichi nekuda kweAUR repositories, kuti uite izvi, ita unotevera kuraira:

$ yaourt -S mycli

Kupedzisa, ini ndoda kusimbisa kuti mumiyedzo yakaitwa, chishandiso chakazvibata zvakanyanya nekukurumidza uye zano rayo kana zvasvika kune auto-yakakwana iri rakanakisa. Ini ndinotofunga kuti chishandiso ichi chakangofanana neMySQL Navigator ine mukana wekuti inoshandisa zviwanikwa zvishoma, kana iwe uri mudikani weconsole uyezve shandisa mamwe ematatu dhatabhesi ayo anowirirana nawo, usazeze kuyedza ichi chishandiso chikuru uye tiudze zvaunofunga nezve.