Ihe mgbakwunye ihe nrụpụta ngwaọrụ na InterSystems IRIS

Otu panel nke ngwaọrụ ndị ọzọ maka nleba anya na nyocha njehie na ngwa na ntinye aka na ntanetị data InterSystems IRIS, ikpo okwu ntinye nke Ensemble na Caché DBMS, ma ọ bụ akụkọ nke igwe igwe ọzọ.

N'isiokwu a, achọrọ m ikwu maka ngwa ahụ, yana ngwá ọrụ nchịkwa ọkọlọtọ, m na-eji kwa ụbọchị iji nyochaa ngwa na ngwọta ntinye na InterSystems IRIS ikpo okwu ma chọta njehie mgbe ha mere.
Ngwọta ahụ gụnyere ikiri na dezie usoro zuru ụwa ọnụ, ajụjụ na-agba ọsọ (gụnyere JDBC/ODBC), izipu nsonaazụ ọchụchọ site na email dị ka faịlụ XLS zippped. Lelee ihe klaasị nwere ike idezi. Ọtụtụ eserese dị mfe maka usoro protocol.

Nke a bụ ngwa CSP dabere na jQuery-UI, chaatị.js, jsgrid.js
Ọ bụrụ na ị nwere mmasị, biko hụ n'okpuru na n'ime ebe nchekwa.

Ọ malitere site n'ịmụ ajụjụ banyere otu esi etinye mgbanwe na ihe dị na InterSystems IRIS, Ensemble na Caché DBMS.

Mgbe agụchara magburu onwe isiokwu banyere nke a, m fork ọrụ ahụ. wee malite imecha ya maka mkpa ya.

A na-emejuputa ihe ngwọta dị ka panel panel nke% CSP.Util.Pane, nke nwere windo iwu isi na bọtịnụ Run, gbakwunyere nhazi nhazi iwu.

Mgbe ị banyere "?" anyị na-enweta nkọwa nkenke nke iwu ndị a:

Gburugburu ụwa

Iwu m na-ahụkarị bụ ilele ụwa niile. Dị ka a na-achị, nke a bụ ụkpụrụ zuru ụwa ọnụ mgbe ị na-arụ ọrụ nke gị ma ọ bụ onye ọzọ. Ị nwere ike ịlele ya n'usoro ọzọ, yana site n'itinye nzacha na njikọ na data. Enwere ike dezie ma hichapụ ọnụ ọnụ ndị achọtara:

Ị nwere ike ihichapụ ihe niile zuru ụwa ọnụ site na itinye mwepu ^logMSW- na iwu mgbe aha.
Mana otu a ị nwere ike ihichapụ naanị globals malite na ^log (protocol globals), ya bụ. Emejuputala mmachi megide ihichapụ mberede.

Ọ bụrụ na itinye "*" mgbe aha ahụ gasịrị, ị ga-enweta ndepụta nke ụwa nwere njirimara ndị ọzọ. Nke abụọ "*" ga-agbakwunyere ubi ọhụrụ "Alocated MB", akara mmuke ọzọ ga-abụ "Jiri MB" Nchikota akụkọ abụọ a na nkewa n'ime "asterisks" na-eme ka a na-ekesa akụkọ na-emekarị ogologo oge n'ime blọk ejiri. nke nnukwu globals.

Site na tebụl a ị nwere ike iso njikọ na-arụ ọrụ iji lelee ụwa n'onwe ya ma ọ bụ ka ịlele / dezie ya n'ụzọ ọkọlọtọ site na njikwa njikwa site na ịpị R ma ọ bụ W na ngalaba ikike.

Arịrịọ

Na-atụgharị akụkọ ka ọ bụrụ usoro Excel

Ọrụ nke abụọ a na-ejikarị eme ihe bụ mkpochapụ ajụjụ. Iji mee nke a, tinye nkwupụta sql dị ka iwu.

Isi ihe na-ezuru m na ọkọlọtọ Sistem Management Portal bụ na-emezu ajụjụ na isi mmalite JDBC/ODBC ahaziri na DBMS wee wepụta nsonaazụ ya na usoro XLS, ịchekwa na izipu faịlụ site na email. Iji mee nke a, na ngwá ọrụ m, tupu ịme iwu ahụ, ịkwesịrị ịme ka igbe nlele "Download to Excel file".

Njirimara a na-azọpụta m ọtụtụ oge n'ime ihe omume m na-eme kwa ụbọchị, ana m ejikọta modul ndị a kwadoro na ngwa ọhụrụ na ngwọta ntinye.

Ma iji mee nke a, ị ga-ebu ụzọ hazie ụzọ maka ịmepụta faịlụ na ihe nkesa na nzere nke onye ọrụ na ihe nkesa ozi maka nke a, n'aka nke ya, ịkwesịrị idezi ọnụ nke ntọala mmemme zuru ụwa ọnụ ^% App.Setting .

Na-echekwa akụkọ zuru ụwa ọnụ

Ọtụtụ mgbe, ọ dị mkpa ịchekwa nsonaazụ nke mkpesa n'ụwa niile. Iji mee nke a, m na-eji usoro ndị a:

Maka JDBC:
##klas(App.sys).SqlToDSN

Maka ODBC:
##klas(App.sys).SaveGateway

Maka okwu SQL:
##klas(App.sys) .SaveSQL

Maka ajụjụ:
##klas(App.sys).SaveQuery

Dịka ọmụmaatụ, ọ bụrụ na panel iwu
xec do ##class(App.sys).SaveQuery("%SYSTEM.License:Counts","^GN",0)
Ka anyị chekwaa nsonaazụ nke arịrịọ ịgụ akwụkwọ ikike na ^GN array, ma ị nwere ike ịhụ ihe echekwara na panel site na iwu: result ^GN("%SYSTEM.License:Counts",0)

Modul arụmọrụ agbakwunyere

Na nkwalite nke abụọ, nke mere ka ọrụ m dị mfe ma na-akpaghị aka, bụ mmejuputa ikike nke ịme modul edere aha mgbe ị na-emepụta ahịrị ajụjụ ọ bụla. N'ụzọ dị otú a, m nwere ike iwulite ọrụ ọhụrụ n'ime akụkọ na ofufe na otu ngafe, dịka ọmụmaatụ, njikọ na-arụ ọrụ maka ọrụ ndị ọzọ na data.

Ọmụmatụ 1: Iji klas App.Parameter arụ ọrụ

Mepụta paramita site na iji “Table Navigator”

Dezie paramita site na "Nhọrọ"

Ọmụmaatụ 2: Ilele ụwa niile site na njikọ "Akụkọ".

Chart

Site na edemede [9] na iji anya nke uche hụ uto nke ọdụ data, e mepụtara ibe nke na-egosipụta eserese kwa ọnwa nke nha nchekwa data emepụtara site na faịlụ iris.log (console.log) site na iji ndekọ “gbasaa” azụ azụ site n'ụbọchị dị ugbu a.

Dịka ọmụmaatụ, emepụtakwara eserese mmemme na InterSystems IRIS, nke ewepụtara na faịlụ protocol:

Njikọ na akụrụngwa:

[1] usoro ntinye osisi na Kasha
[2] Ngwa ngwa ngwa ngwa-eme CRUD na Caché iji jqGrid
[3] Ndị njikwa SQL ọzọ maka Caché DBMS
[4] Ọmụmaatụ nke imepụta na izipu ozi-e site na iji Caché DBMS
[5] Cache + jQuery. Mmalite ngwa ngwa
[6] Nkwanye ngwa
[7] Nkwado UDL
[8] Na-elele ụwa niile na Portal Management Caché
[9] Prometheus nwere cache
[10] Nhazi obodo na Caché DBMS

Ekele dịrị ndị dere akụkọ ndị a na ndị ọzọ nyeere m aka ịmepụta ngwá ọrụ a.

PS Ọrụ a na-etolite na ọtụtụ echiche emebebeghị. N'ọdịnihu dị nso, m na-eme atụmatụ ime:

1. Ngwa ndebiri na framework uikit
2. Auto-akwụkwọ nke koodu usoro Doxegen na ntinye n'ime CStudio

isi: www.habr.com