Moni! Tiyeni tiwone zatsopano mu - . Tikukumbutseni kuti magwiridwe antchito a DataGrip akuphatikizidwa mu ma IDE athu ena olipidwa, kupatula WebStorm.
Thandizo lazosungira zatsopano
Pakutulutsa uku, ma database anayi adalandira chithandizo chovomerezeka pazida zathu:
Mng'oma wa Apache - Dongosolo loyang'anira database kutengera nsanja ya Hadoop.
Greenplum - DBMS yowunikira kwa malo osungiramo data kutengera PostgreSQL.
Vertica - Nawonso database yayikulu pakusanthula kwakukulu kwa data.
Snowflake - kusungidwa kwa data pamtambo. Ngati tilankhula za nkhokwe zaubale, ndiye Snowflake . Pakutulutsa uku tidangothandizira SQL, tidzatulutsa malangizowo pambuyo pake.
Chophatikizira
Tapanga zosintha pabokosi lolumikizana ndi database: tidayesetsa kumveketsa bwino komanso kosavuta.
General
Tsambali nthawi zambiri lasinthidwa.
m'munda Mtundu wolumikizana ankatchedwa Mtundu wa URL ndipo iyo inali pansi. Koma, popeza mtengo m'munda uno umatsimikizira njira yowonjezera, tsopano ili pamwamba.
m'munda Nawonso achichepere zoyikidwa mutalowa malowedwe anu ndi mawu achinsinsi, chifukwa kutsimikizika kumafunika kuti muwonetse mndandanda wazosungidwa ndi Ctrl/Cmd+Space.
Mu ndemanga ku positi yapitayi kusunga mawu achinsinsi. Tinawonjezera zosankha zatsopano ndikupanga mndandanda wotsitsa. Makhalidwe a mndandandawu ndi awa:
- Osasunga mawu achinsinsi.
- Sungani mpaka DataGrip iyambitsidwenso (m'mbuyomu umu ndi momwe njira ya "osasunga" idagwirira ntchito).
- Sungani gawo: mpaka mutasiya kulumikizana ndi gwero la data.
- Limbikitsani.
Kuti mupewe chisokonezo, lowetsani mawu achinsinsi opanda kanthu kudzera mu menyu yankhaniyo.
Zotsatira Connection Test tsopano akuwonetsedwa pawindo lokha, palibe kudina kowonjezera kapena kukambirana.
Ndipo ngati madalaivala sanatsitsidwe, DataGrip ipereka kutero. Kale batani Connection Test idaletsedwa pankhaniyi, zomwe zidasokoneza ogwiritsa ntchito.
Zosintha
Zokonda zasunthidwa pano kuchokera pa General tab Werengani yekha, Kulunzanitsa zokha, Kuwongolera kochita.
Chatsopano:
- Thamangani funso losunga moyo pamasekondi aliwonse a N: idzagwedeza gwero la deta ndi ndodo masekondi aliwonse a N. Pama database omwe sitigwirizana nawo, mutha kulemba nokha pempho kuti mukhale ndi moyo. Izi zimachitika muzokonda zoyendetsa.
- Zosinthasinthani pambuyo pa masekondi a N: Mtengo mumasekondi omwe alowetsedwa apa udzauza DataGrip patatha nthawi yayitali kuti ituluke kuchokera kugwero la data.
- Script yoyambira: Apa mutha kuyika funso lomwe lizichitika nthawi iliyonse pomwe kulumikizana kupangidwa. Tikumbukenso kuti ngati Kulumikizana kumodzi
mode sikuyatsidwa, kulumikizana kwatsopano kumapangidwa pamtundu uliwonse watsopano.
Schemas
Zosefera za zinthu zomwe zawonetsedwa mumtengo zasunthira apa.
Kuyenda ndi kusaka
Mndandanda wa malo aposachedwa
Zenera latsopano la Malo Aposachedwa likuwonetsa komwe mwakhalako posachedwa. Mndandandanda ndi tizidutswa tating'ono ta code tomwe mwasintha kapena kuwona posachedwa. Izi ndizothandiza ngati mukukumbukira nkhaniyo koma osakumbukira dzina la fayilo. Izi zimachitika kwambiri mu DataGrip chifukwa zotonthoza zonse zimatchedwa chimodzimodzi :) Njira yachidule ya kiyibodi ndi:
Ctrl/Cmd+Shift+E.
Ngati mudagwiritsapo ntchito njira yachidule ya kiyibodi iyi kuti muwonetse mndandanda wamafayilo osinthidwa posachedwapa, dinani kawiri Ctrl/Cmd+E.
Sakani ndi njira
Tachotsa zosankha zosafunikira zomwe "tidapeza" papulatifomu: gawo ΠΈ Project. Tsopano mwachisawawa Pezani m'njira DataGrip imasaka kulikonse. Tawonjezeranso malo atsopano osaka Mauthenga Ophatikizidwa - imaphatikizapo mafayilo ndi zikwatu zokha kuchokera pagawo la Mafayilo.
Zochita kuchokera muzotsatira zakusaka
Zotsatira zoyendayenda tsopano zimapereka zochitika zomwe zimagwira ntchito pamtundu kapena mtengo. Mwachitsanzo, mukuyang'ana tebulo. Nazi zomwe mungachite kuchokera pazotsatira zenera.
- Onani DDL: Ctrl/Cmd+B.
- Tsegulani data: F4.
- Tsegulani zenera la Modify Table: Ctrl/Cmd+F6.
- Onetsani munkhani ina: Alt + F1 (mwachitsanzo, onetsani mumtengo).
- Onani zambiri: Ctrl+Q/F1.
- Pangani SQL: Ctrl/Cmd+Alt+G.
Kugwira ntchito ndi code
Zinthu zophatikizika pakumalizitsa
chifukwa CREATE ΠΈ DROP autocomplete imapereka zosankha zophatikiza.
Musaiwale za acronyms.
Kuyendera kwatsopano
DataGrip ikuchenjezani ngati mukugwiritsa ntchito cholozera chomwe sichinatseguke.
Zoyendera ziwiri zotsatirazi ndizozimitsidwa mwachisawawa, koma ena angafunike.
Ngati mugwiritsa ntchito mikangano yosatchulidwa mayina, izi zidzawonetsedwa.
Kuwunika komwe kumadandaula za mawu a GOTO.
Kugwira ntchito ndi mafayilo
Anawonjezera zochunira za chikwatu cha polojekiti. Mapulojekiti atsopano apangidwa mufodayi.
zotsatira Sungani ngati... kwa console tsopano:
- Ikuwonetsa chikwatu cha polojekiti.
- Kumbukirani chisankho chomaliza.
Chochita chawonjezedwa pamtengo wamafayilo Chotsani Directory: Chotsani chikwatu. M'mbuyomu, kuti muchotse chikwatu (ndiko kuti, osachiwonetsa mumtengo uwu), mumayenera kudina Chotsani, ndipo DataGrip inafunsa: mukufuna kuchotsa kapena kuchotsa? Zinali zovuta komanso zosamveka :)
Mtengo wa database
Tinalemba zowunikira zathu za DB2. Izi zikutanthauza kuti timapeza zidziwitso za zinthu za database pogwiritsa ntchito mafunso, osati kudzera pa driver wa JDBC, monga kale. Choncho, zinthu zinawonekera mumtengo umene sunalipo kale: zoyambitsa, mitundu, njira, ma modules, counters, maudindo ndi ena.
Mtengowo umasunga nkhani: dzina la gwero la data limakhazikika pamwamba.
Zithunzi zajambulidwa kuti zisungidwe zosagwiritsidwa ntchito: omwe ali ndi magwero a data omwe adapangidwa kuti azisungitsa zotere sadzasokonezedwanso.
Tidajambulanso zithunzi zosamveka zomwe zingagwiritsidwe ntchito pazokonda zoyendetsa.
Mpumulo
Mitu yamakonda
Ogwiritsa ntchito DataGrip tsopano ali ndi kuthekera kopanga mtundu uliwonse wamtundu womwe akufuna. Chiwembu chatsopano ndi pulogalamu yowonjezera yomwe iyenera kukhazikitsidwa kuchokera pagawo Mapulagini mumakonzedwe.
Werengani za momwe mungapangire mitu yanu apa:
.
Tinayesa kupanga ena angapo tokha. Zikuwoneka motere:
Cyan
Wofiirira wakuda
Mkonzi wa data
Zosefera zikuwonetsa zamtengo wapatali kuchokera pa clipboard.
Zonse!
- Maimelo timawerenga: [imelo ndiotetezedwa]
- Ndemanga zomwe timawerenga βββ
Gulu la DataGrip
Source: www.habr.com