Yekuwedzera dhizaini bhari paInterSystems IRIS

Pani yezvishandiso zvekuwedzera zvekutarisa uye kuongorora zvikanganiso mumashandisirwo uye masanganiswa mhinduro paInterSystems IRIS data platform, Ensemble yekubatanidza chikuva uye Caché DBMS, kana nyaya yerimwe bhasikoro.

Muchinyorwa chino ndinoda kutaura nezve application iyo, pamwe chete neyakajairwa manejimendi maturusi, ini ndinoshandisa mazuva ese kutarisa maapplication uye ekubatanidza mhinduro paInterSystems IRIS chikuva uye kuwana zvikanganiso pazvinoitika.
Mhinduro yacho inosanganisira kuona nekugadzirisa hurongwa hwepasi rose, kubvunza mibvunzo (kusanganisira JDBC/ODBC), kutumira mitsva yekutsvaga kuburikidza neemail sezipped XLS mafaera. Ona zvinhu zvekirasi nekugona kugadzirisa. Anoverengeka akareruka magirafu emaprotocol system.

Iyi iCSP application yakavakirwa pa jQuery-UI, chart.js, jsgrid.js
Kana iwe uchida, ndapota ona pazasi uye mukati repository.

Izvo zvese zvakatanga nekudzidza mubvunzo wekuti ungaisa sei shanduko kuzvinhu muInterSystems IRIS, Ensemble uye iyo Caché DBMS.

Mushure mekuverenga yakanaka chinyorwa pamusoro peizvi, ndakarasika ronga. akatanga kuzvipedzisa pane zvaaida.

Mhedzisiro inoguma inoitwa sechikamu chidiki che %CSP.Util.Pane, iyo ine main command window uye Run bhatani, pamwe nemirairo yekunatsa marongero.

Paunopinda “?” tinowana tsananguro pfupi yemirairo iyi:

Globals

Murairo wangu wakajairika ndewekutarisa pasi rose. Sekutonga, iyi iprotocol yepasi rose kana uchigadzirisa yako kana yeumwe munhu chirongwa. Iwe unogona kuiona mune reverse order, pamwe nekushandisa sefa kune zvese zvinongedzo uye data. Node dzakawanikwa dzinogona kugadziridzwa nekudzimwa:

Unogona kudzima pasi rose nekuisa minus ^logMSW- mukuraira mushure mezita.
Asi nenzira iyi unogona chete kudzima pasi rose kutanga ne ^log (protocol globals), kureva. Kurambidza kudzima netsaona kwaitwa.

Kana iwe ukaisa "*" mushure mezita, iwe unowana runyoro rwepasirose ane mamwe maitiro. Yechipiri "*" ichawedzera munda mutsva "Allocated MB", uye imwe asterisk ichava "Used MB". Uku kusanganiswa kwemishumo miviri uye kupatsanurwa kuita "asterisk" kunoitwa kupatsanura mushumo unogara kwenguva refu kuita mabhuroko akagarwa. yemarudzi makuru enyika.

Kubva patafura iyi unogona kutevera zvinongedzo zvinoshanda kuti utarise iyo yepasirese pachayo kana kuiona/kuigadzirisa nenzira yakajairwa kubva kune manejimendi portal nekudzvanya R kana W mundima yeMvumo.

Zvikumbiro

Kushandura report kuita Excel format

Chechipiri chinowanzo shandiswa basa ndeye query execution. Kuti uite izvi, pinda chirevo che sql semurairo.

Chinhu chikuru chaive chakandikwanira mune yakajairwa System Management Portal yaive kuita mibvunzo paJDBC/ODBC masosi akagadziridzwa muDBMS uye achiburitsa mhedzisiro muXLS fomati, kuchengetedza uye kutumira iyo faira neemail. Kuti uite izvi, mumudziyo wangu, usati waita murairo, unofanirwa kugonesa "Kudhawunirodha kuExcel faira" cheki bhokisi.

Ichi chimiro chinondichengetedza nguva yakawanda mumaitiro angu ezuva nezuva, uye ini ndinobudirira kubatanidza akagadzirira-akagadzirwa mamodule mumashandisirwo matsva uye mhinduro dzekubatanidza.

Asi kuti uite izvi, iwe unofanirwa kutanga wagadzirisa nzira yekugadzira mafaira pavhavha uye zvinyorwa zvemushandisi uye mail server; .

Kuchengetedza mishumo pasi rose

Kazhinji kazhinji zvinodikanwa kuchengetedza mhedzisiro yekuitwa kweshumo pasi rose. Kuti ndiite izvi ndinoshandisa nzira dzinotevera:

ZveJDBC:
##class(App.sys).SqlToDSN

ZveODBC:
##class(App.sys).SaveGateway

Zvekutaura kweSQL:
##class(App.sys).SaveSQL

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

Semuenzaniso, kana mupaneru murairo
xec do ##class(App.sys).SaveQuery("%SYSTEM.License:Counts","^GN",0)
Ngatichengetedzei mhedzisiro yechikumbiro chekuverenga rezinesi mu ^GN array, uye iwe unogona kuona zvakachengetwa mupanera nemurairo: result ^GN("%SYSTEM.License:Counts",0)

Augmented functionality modules

Uye kuvandudzwa kwechipiri, uko kwakarerutsa zvakanyanya uye kuita otomatiki basa rangu, iko kuita kwekugona kuita akanyatso kunyorwa mamodule paunenge uchigadzira yega yega yemubvunzo. Nenzira iyi, ini ndinogona kuvaka mashandiro matsva mumushumo wenhunzi mune imwe pass, semuenzaniso, anoshanda zvinongedzo zvekuwedzera mashandiro pane data.

Muenzaniso 1: Kushanda neApp.Parameter kirasi

Gadzira parameter uchishandisa "Table Navigator"

Rongedza parameter kuburikidza ne "Sarudzo"

Muenzaniso wechipiri: Kuona pasi rose kuburikidza ne "Nhoroondo" link

Charts

Kufemerwa nechinyorwa [9] uye kuona kukura kwedhatabhesi, peji rakagadzirwa rinoratidza girafu yemwedzi nemwedzi yedatabase saizi yakagadzirwa kubva kune iris.log faira (cconsole.log) uchishandisa "Kuwedzera" marekodhi zvekare kubva pazuva razvino.

Semuenzaniso, chiitiko girafu chakagadzirwawo muInterSystems IRIS, iyo inogadzirwawo kubva kuprotocol file:

Links kune zvinhu:

[1] kutema subsystem muKasha
[2] Porridge yepakarepo - kuita CRUD muCaché uchishandisa jqGrid
[3] Alternative SQL mamaneja eiyo Caché DBMS
[4] Mienzaniso yekugadzira uye kutumira Email uchishandisa iyo Caché DBMS
[5] Cache + jQuery. Kurumidza kutanga
[6] Application Deployment
[7] UDL rutsigiro
[8] Kuona pasi rose muCaché Management Portal
[9] Prometheus neCache
[10] Nzvimbo muCaché DBMS

Ndinotenda kune vanyori veizvi nezvimwe zvinyorwa zvakandibatsira kugadzira chishandiso ichi.

PS Chirongwa ichi chiri kusimukira uye mazano mazhinji haasati aitwa. Munguva pfupi iri kutevera ndinoronga kuita:

1. Chikumbiro template pane chimiro uikit
2. Auto-documentation of code format Doxegen nekubatanidzwa muCStudio

Source: www.habr.com