--- /dev/null
+createTableIndexPatch=\
+ CREATE TABLE IF NOT EXISTS INDEX_PATCH ( \
+ IND_ANNEE_GEST VARCHAR(2) not null, \
+ IND_TRI_GEST VARCHAR(1) not null, \
+ IND_COMPTABLE VARCHAR(6) not null, \
+ IND_IMPUTATION VARCHAR(1) not null, \
+ IND_MINISTERE VARCHAR(2) not null, \
+ IND_COMPTESPE VARCHAR(5) not null, \
+ IND_LOCALE VARCHAR(4) not null, \
+ IND_ANNEE_TRSP VARCHAR(2) not null, \
+ IND_TRI_TRSP VARCHAR(1) not null, \
+ IND_SECTION_BUDG VARCHAR(2), \
+ IND_CPTESPENAT VARCHAR(5) not null, \
+ IND_NATIONALE VARCHAR(6), \
+ INDEX IX_INDEX (IND_ANNEE_GEST,IND_TRI_GEST,IND_COMPTABLE,IND_IMPUTATION,IND_MINISTERE,IND_LOCALE) \
+ )
+
+request=\
+ SELECT edmn.COLLECTIVITE, edmn.BUDGET, edmn.DOC_ID \
+ FROM EDMN_ETATEDMN_INDEX_EDMN edmn \
+ LEFT OUTER JOIN EDMN_ETATEDMN_IX_EDMN_LIASSES liasse ON edmn.COLLECTIVITE=liasse.COLLECTIVITE AND edmn.BUDGET=liasse.BUDGET AND edmn.DOC_ID=liasse.DOC_ID \
+ GROUP BY edmn.COLLECTIVITE, edmn.BUDGET, edmn.DOC_ID HAVING count(liasse.DOC_ID) = 0
+
+requestCount=\
+ SELECT COUNT(*) from ( \
+ SELECT edmn.COLLECTIVITE, edmn.BUDGET, edmn.DOC_ID \
+ FROM EDMN_ETATEDMN_INDEX_EDMN edmn \
+ LEFT OUTER JOIN EDMN_ETATEDMN_IX_EDMN_LIASSES liasse ON edmn.COLLECTIVITE=liasse.COLLECTIVITE AND edmn.BUDGET=liasse.BUDGET AND edmn.DOC_ID=liasse.DOC_ID \
+ GROUP BY edmn.COLLECTIVITE, edmn.BUDGET, edmn.DOC_ID \
+ HAVING count(liasse.DOC_ID) = 0 \
+ ) as toto
+
+truncateTableIndexPatch=TRUNCATE TABLE INDEX_PATCH
+
+insertIndexPatch=\
+ INSERT INTO INDEX_PATCH ( \
+ IND_ANNEE_GEST, \
+ IND_TRI_GEST, \
+ IND_COMPTABLE, \
+ IND_IMPUTATION, \
+ IND_MINISTERE, \
+ IND_COMPTESPE, \
+ IND_LOCALE, \
+ IND_ANNEE_TRSP, \
+ IND_TRI_TRSP, \
+ IND_SECTION_BUDG, \
+ IND_CPTESPENAT, \
+ IND_NATIONALE \
+ ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?)
+
+
+selectLiasseLocale=\
+ SELECT \
+ edmn.COMPTABLE, \
+ edmn.IMPUTATION, \
+ edmn.MINISTERE, \
+ edmn.ANNEE_BUDG, \
+ edmn.TRIMESTRE, \
+ edmn.NUM_LIASSE_DEB, \
+ edmn.NUM_LIASSE_FIN \
+ FROM EDMN_ETATEDMN_INDEX_EDMN edmn \
+ WHERE edmn.COLLECTIVITE = ? \
+ AND edmn.BUDGET = ? \
+ AND edmn.DOC_ID = ?
+
+selectIndexPatch=\
+ SELECT \
+ IND_ANNEE_GEST, \
+ IND_TRI_GEST, \
+ IND_COMPTABLE, \
+ IND_IMPUTATION, \
+ IND_MINISTERE, \
+ IND_COMPTESPE, \
+ IND_LOCALE, \
+ IND_ANNEE_TRSP, \
+ IND_TRI_TRSP, \
+ IND_SECTION_BUDG, \
+ IND_CPTESPENAT, \
+ IND_NATIONALE \
+ FROM INDEX_PATCH \
+ WHERE IND_ANNEE_GEST = ? \
+ AND IND_TRI_GEST = ? \
+ AND IND_COMPTABLE = ? \
+ AND IND_IMPUTATION=? \
+ AND IND_MINISTERE=? \
+ AND IND_LOCALE IN {:liasse} \
+ ORDER BY IND_LOCALE
+
+insertLiasse=INSERT INTO EDMN_ETATEDMN_IX_EDMN_LIASSES (COLLECTIVITE,BUDGET,DOC_ID,NUM_LIASSE,ANNEE_GESTION) VALUES(?,?,?,?,?)
+
+selectEdmn=SELECT DOC, ENCODING FROM EDMN_ETATEDMN_DOCUMENTS WHERE COLLECTIVITE = ? AND BUDGET = ? AND DOC_ID = ?
+
+updateEdmn=UPDATE EDMN_ETATEDMN_DOCUMENTS SET DOC = ? WHERE COLLECTIVITE = ? AND BUDGET = ? AND DOC_ID = ?