Ibha yamathuluzi kanjiniyela eyengeziwe ku-InterSystems IRIS

Iphaneli lamathuluzi engeziwe okuqapha nokuphenya amaphutha kuzinhlelo zokusebenza nezixazululo zokuhlanganisa kuplathifomu yedatha ye-InterSystems IRIS, inkundla yokuhlanganisa ye-Ensemble kanye ne-Caché DBMS, noma indaba yelinye ibhayisikili.

Kulesi sihloko ngifuna ukukhuluma ngohlelo lokusebenza ukuthi, kanye namathuluzi okuphatha ajwayelekile, ngisebenzisa nsuku zonke ukuqapha izinhlelo zokusebenza kanye nezixazululo zokuhlanganisa endaweni yesikhulumi se-InterSystems IRIS futhi ngithole amaphutha uma kwenzeka.
Isixazululo sihlanganisa ukubuka nokuhlela izinhlelo zomhlaba wonke, ukusebenzisa imibuzo (okuhlanganisa i-JDBC/ODBC), ukuthumela imiphumela yosesho nge-imeyili njengamafayela e-XLS azip. Buka izinto zekilasi ezinekhono lokuhlela. Amagrafu ambalwa alula amaphrothokholi esistimu.

Lolu uhlelo lokusebenza lwe-CSP olusekelwe I-jQuery-UI, chart.js, jsgrid.js
Uma unentshisekelo, sicela ubheke ngezansi nangaphakathi inqolobane.

Konke kwaqala ngokutadisha umbuzo wokuthi ungangena kanjani izinguquko ezintweni eziku-InterSystems IRIS, i-Ensemble kanye ne-Caché DBMS.

Ngemva kokufunda isihloko esihle kakhulu mayelana nalokhu, ngemfoloko iphrojekthi. waqala ukuyiqeda ngezidingo zakhe.

Isixazululo esiwumphumela sisetshenziswa njengephaneli yesigaba esingaphansi se-%CSP.Util.Pane, enefasitela lomyalo omkhulu kanye nenkinobho ethi Run, kanye nezilungiselelo zokuthuthukisa umyalo.

Uma ufaka “?” sithola incazelo emfushane yale miyalo:

Umhlaba jikelele

Umyalo wami ovame kakhulu ukubuka umhlaba jikelele. Njengomthetho, lokhu kuyiphrothokholi yomhlaba wonke lapho ulungisa iphutha lakho noma iphrojekthi yomunye umuntu. Ungayibuka ngokulandelana okuphambene, kanye nokusebenzisa isihlungi kukho kokubili isixhumanisi nedatha. Amanodi atholiwe angahlelwa futhi asuswe:

Ungasusa umhlaba wonke ngokufaka ukususa ^logMSW- kumyalo ngemva kwegama.
Kodwa ngale ndlela ungakwazi ukususa kuphela ama-globals kuqala ngokuthi ^log (protocol globals), i.e. Umkhawulo wokususa ngephutha usetshenzisiwe.

Uma ufaka u-“*” ngemva kwegama, uzothola uhlu lwama-globals anezici ezengeziwe. Eyesibili ethi “*” izokwengeza inkambu entsha ethi “Allocated MB”, futhi enye inkanyezi izoba “Used MB”. Le nhlanganisela yemibiko emibili kanye nokwehlukaniswa kube “inkanyezi” yenzelwa ukuhlukanisa umbiko ovame ukwakha isikhathi eside ube amabhulokhi okuhlala abantu. zomhlaba ezinkulu.

Kuleli thebula ungalandela izixhumanisi ezisebenzayo ukuze ubuke okomhlaba ngokwawo noma ukukubuka/ukuhlela ngendlela evamile ukusuka kuphothali yabaphathi ngokuchofoza u-R noma u-W kunkambu Yemvume.

Izicelo

Iguqulela umbiko ube yifomethi ye-Excel

Umsebenzi wesibili osetshenziswa kakhulu uwukusayinda imibuzo. Ukuze wenze lokhu, faka isitatimende se-sql njengomyalo.

Into esemqoka eyanele kimina Kuphothali Yokulawulwa Kwesistimu evamile kwakuwukusebenzisa imibuzo emithonjeni ye-JDBC/ODBC elungiselelwe ku-DBMS futhi ikhipha imiphumela ngefomethi ye-XLS, igcina kungobo yomlando futhi ithumela ifayela nge-imeyili. Ukuze wenze lokhu, ethuluzini lami, ngaphambi kokukhipha umyalo, udinga ukunika amandla ibhokisi lokuhlola elithi “Landa kufayela le-Excel”.

Lesi sici singisindisa isikhathi esiningi esimisweni sami sansuku zonke, futhi ngihlanganisa ngempumelelo amamojula enziwe ngomumo ezinhlelweni ezintsha nezixazululo zokuhlanganisa.

Kodwa ukwenza lokhu, okokuqala udinga ukulungisa indlela yokudala amafayela kuseva kanye nemininingwane yomsebenzisi neseva yemeyili, ukuze wenze lokhu, nawe udinga ukuhlela amanodi ezilungiselelo zohlelo lomhlaba wonke ^%App.Setting .

Ilondoloza imibiko emhlabeni jikelele

Kaningi kudingekile ukulondoloza imiphumela yokwenziwa kombiko emhlabeni jikelele. Ukwenza lokhu ngisebenzisa izinqubo ezilandelayo:

Okwe-JDBC:
##class(App.sys).SqlToDSN

Okwe-ODBC:
##class(App.sys).SaveGateway

Ngezinkulumo ze-SQL:
##class(App.sys).SaveSQL

Ngombuzo:
##class(App.sys).SaveQuery

Isibonelo, uma kuphaneli umyalo
xec do ##class(App.sys).SaveQuery("%SYSTEM.License:Counts","^GN",0)
Masigcine umphumela wesicelo sokubala ukusetshenziswa kwelayisensi kuhlelo lwe-^GN, futhi ungabona okulondolozwe kuphaneli ngomyalo: result ^GN("%SYSTEM.License:Counts",0)

Amamojula okusebenza athuthukisiwe

Futhi ukuthuthukiswa kwesibili, okwenze kwaba lula kakhulu futhi kwawenza umsebenzi wami ngokuzenzakalela, ukuqaliswa kwekhono lokwenza amamojula abhalwe ngokukhethekile lapho kukhiqizwa umugqa wombuzo ngamunye. Ngale ndlela ngingakwazi ukwakha ukusebenza okusha embikweni wokundiza ngephasi eyodwa, isibonelo, izixhumanisi ezisebenzayo zemisebenzi eyengeziwe kudatha.

Isibonelo 1: Ukusebenza nekilasi le-App.Parameter

Dala ipharamitha usebenzisa “I-Table Navigator”

Hlela ipharamitha ngokusebenzisa "Izinketho"

Isibonelo sesi-2: Ukubuka umhlaba jikelele ngesixhumanisi "somlando".

Amagrafu

Igqugquzelwe i-athikili [9] kanye nokubona ngeso lengqondo ukukhula kolwazi, kwadalwa ikhasi elibonisa igrafu yanyanga zonke yosayizi besizindalwazi abadalwe kusukela kufayela le-iris.log (cconsole.log) kusetshenziswa amarekhodi okuthi “Nweba” ngokulandela emuva kusukela osukwini lwamanje.

Njengesibonelo, igrafu yomcimbi nayo idaliwe ku-InterSystems IRIS, nayo ekhiqizwa kusukela kufayela lephrothokholi:

Izixhumanisi zezinto:

[1] uhlelo olungaphansi lokungena eKasha
[2] Iphalishi elisheshayo - ukwenza i-CRUD ku-Cache usebenzisa i-jqGrid
[3] Abanye abaphathi be-SQL be-Cache DBMS
[4] Izibonelo zokukhiqiza nokuthumela i-imeyili kusetshenziswa i-Cache DBMS
[5] Inqolobane + jQuery. Ukuqala okusheshayo
[6] Ukuthunyelwa Kohlelo
[7] Ukusekelwa kwe-UDL
[8] Ukubuka umhlaba wonke ku-Cache Management Portal
[9] I-Prometheus nge-Cache
[10] Ukwenziwa kwasendaweni ku-Cache DBMS

Ngibonga ababhali balezi zihloko kanye nezinye abangisizile ngenza leli thuluzi.

PS Le phrojekthi iyathuthuka futhi imibono eminingi ayikaqaliswa. Esikhathini esizayo esiseduze ngihlela ukwenza:

1. Isifanekiso sohlelo lokusebenza kuhlaka uikit
2. Ukubhalwa ngokuzenzakalelayo kwefomethi yekhodi I-Doxegen ngokuhlanganiswa ku-CStudio

Source: www.habr.com