This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| private void Process(IGetChangeLog chng, ChangeLogTableData changeData) { | |
| mLog.VerboseFormat("Process: {0}", chng); | |
| CheckIsInheritedFinished(chng.CHL_OPER); | |
| TableData td=null; | |
| TableData tmp; | |
| int sign=0; | |
| switch(chng.CHL_OPER) { | |
| case LogOperations.Insert: | |
| case LogOperations.AppendLogOnly: | |
| case LogOperations.InsertV: |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --==================================================================================== | |
| --==================================================================================== | |
| /*MeteoSensors*/; | |
| /*Датчики*/; | |
| create table MeteoSensors( | |
| SENS_ID integer not null, | |
| SENS_Key STR_OBJID, | |
| SENS_Name STR_NAME, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select | |
| AccTrns_Dept AccTrns_Dept, min(NO_NAME) DEPT_NAME, | |
| AccTrns_OffBalance AccTrns_OffBalance, | |
| GETDATEDETAIL(AccTrns_Date,?) dDATE, case | |
| when DHalf.ACCTRNSHALF_INVERSE=1 and | |
| KHalf.ACCTRNSHALF_INVERSE=1 then 1 | |
| when DHalf.ACCTRNSHALF_INVERSE=-1 and | |
| KHalf.ACCTRNSHALF_INVERSE=1 then 2 | |
| when DHalf.ACCTRNSHALF_INVERSE=-1 and | |
| KHalf.ACCTRNSHALF_INVERSE=-1 then 3 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| (defn- do-configure-program | |
| [] | |
| (let [rootLogger (.. LogManager getRootLogger) | |
| replLogger (LogManager/getLogger "user") | |
| layout (org.apache.log4j.PatternLayout. "%d %-4r [%t] (%F:%L) %-5p %c %x - %m%n") | |
| shortLayout (org.apache.log4j.PatternLayout. "[%t] (%F:%L) %-5p %c %x - %m%n") | |
| errorAppender (org.apache.log4j.FileAppender. layout "error.log" true) | |
| debugAppender (org.apache.log4j.FileAppender. layout "debug.log" true) | |
| infoAppender (org.apache.log4j.FileAppender. layout "info.log" true) | |
| testsAppender (org.apache.log4j.FileAppender. shortLayout "tests.log" true) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| M[info] Resolving io.spray#spray-servlet;1.1-M7 ... | |
| M[info] Resolving io.spray#spray-http;1.1-M7 ... | |
| M[info] Resolving org.parboiled#parboiled-scala_2.10.0-RC5;1.1.4 ... | |
| M[info] Resolving org.parboiled#parboiled-core;1.1.4 ... | |
| M[info] Resolving io.spray#spray-util;1.1-M7 ... |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| with recursive FullAccounts as | |
| (select 0 ACCNT_XMLOBJ_ID, null ACCNT_PARENT_ID, null ACCNT_NUM, null ACCNT_Group from RDB$DATABASE | |
| union | |
| select ACCNT_XMLOBJ_ID, ACCNT_PARENT_ID, ACCNT_NUM, ACCNT_Group from Accounts | |
| ), | |
| AccountParents as | |
| (select ACCNT_XMLOBJ_ID CHILD_ID, ACCNT_XMLOBJ_ID, ACCNT_PARENT_ID, ACCNT_NUM, ACCNT_Group from FullAccounts | |
| union all | |
| select AH.CHILD_ID CHILD_ID, ACCNT_XMLOBJ_ID, ACCNT_PARENT_ID, ACCNT_NUM, ACCNT_Group from FullAccounts | |
| join AccountParents ah on ACCNT_XMLOBJ_ID=ah.ACCNT_PARENT_ID |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| with recursive AccountHier as | |
| ( select ACCNT_XMLOBJ_ID, ACCNT_NUM, ACCNT_PARENT_ID, | |
| ACCNT_NAME, ACCNT_DESC, | |
| 1 ALevel, | |
| cast(Accnt_INum as varchar(20)) SortPath, | |
| ACCNT_GROUP, | |
| ACCNT_ACTPASS, | |
| ACCNT_ACTPASSCODE, ACCNT_DETAILLEVEL from Accounts | |
| where ACCNT_PARENT_ID=0 | |
| union all |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select sum(case Main.AccTrnsHalf_Half* | |
| case | |
| when :OneHalfMode=1 then Main.AccTrnsHalf_Inverse | |
| else 1 | |
| end | |
| when 1 then Main.AccTrnsHalf_Half*AccTrns_MainTotal | |
| else 0 | |
| end) DTotal, | |
| sum(case Main.AccTrnsHalf_Half* | |
| case |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| with q1 | |
| as | |
| (select case :NeedDept | |
| when 1 then AccTrns_Dept | |
| else 0 | |
| end AccTrns_Dept, | |
| Main.AccTrnsHalf_Half MainHalf, | |
| coalesce(MainAttrs.ACA_ID,Main.ACCTRNSHALF_Accnt_ID) MainAcc, | |
| MainCode1.AccAnICode_ICode MC1, | |
| MainCode2.AccAnICode_ICode MC2, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Statement 60026: | |
| ------------------------------------------------------------------------------- | |
| select * from Accounts where Accnt_ID=? | |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | |
| PLAN (ACCOUNTS INDEX (PK_ACCOUNTS)) | |
| 0 ms | |
| 2013-03-28T20:27:53.2150 (9620:012CD9E8) EXECUTE_STATEMENT_START | |
| operdendb (ATT_1071, SVCUSER:CLOJURESVC, NONE, TCPv4:192.168.1.2) | |
| (TRA_256633, READ_COMMITTED | REC_VERSION | WAIT | READ_WRITE) |