</key1>
<key2>
<path>/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:PJ/@added:generated-id</path>
- </key2>
+ </key2>
+ <key3>
+ <path>/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012</path>
+ </key3>
<table type="document" base-name="EDMN_2012_ETATEDMN_DOCUMENTS" version="1">
CREATE TABLE IF NOT EXISTS ${base-name} (
<!-- LIASSES -->
<sql-index id="nodeIdLiasse" table="T2" column="NODEID" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:NumLiasseNationale/n:Liasse/@added:generated-id" datatype="string"/>
<sql-index id="numLiasseCentrale" table="T2" column="NUM_LIASSE" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:NumLiasseNationale/n:Liasse/@national" datatype="string" format="uppercase"/>
- <sql-index id="liasseAnneeGestion" table="T2" column="ANNEE_GESTION" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:AnneeBudget/@V" datatype="integer" use-in-criteria="false"/>
+ <sql-index id="liasseAnneeGestion" table="T2" column="ANNEE_GESTION" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/@Annee" datatype="integer" reset-on="key3"/>
<!-- PJ -->
<sql-index id="nodeIdPj" table="T3" column="NODEID" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:PJ/@added:generated-id" datatype="string"/>
</layer>
<layer name="oracle" persistence-model="xemelios-sql">
- <document id="edmn" repository-import-xslt-file="">
+ <document id="edmn2012" repository-import-xslt-file="">
<table base-name="EDMN_2012_SPECIAL_KEYS" type="special-key" version="1">
<sql xml:space="preserve">
CREATE TABLE ${base-name} (
<sql>CREATE INDEX ${base-name}_AN ON ${base-name} (ARCHIVE_NAME)</sql>
</table>
- <etat id="etatEdmn" import-xslt-file="edmn-2012/edmn-import-mysql.xsl">
+ <etat id="etatEdmn2012" import-xslt-file="edmn-2012/edmn-import-mysql.xsl">
<key1>
<path>/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:NumLiasseNationale/n:Liasse/@added:generated-id</path>
</key1>
<key2>
<path>/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:PJ/@added:generated-id</path>
</key2>
+ <key3>
+ <path>/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012</path>
+ </key3>
<table base-name="EDMN_2012_ETAT_DOCS" type="document" version="1">
<sql xml:space="preserve">
</table>
<table base-name="EDMN_2012_ETAT" id="T1" type="index" main="true" version="2">
<sql xml:space="preserve">
- CREATE TABLE IF NOT EXISTS ${base-name} (
+ CREATE TABLE ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
DOC_ID VARCHAR(100) NOT NULL,
</table>
<table id="T3" base-name="EDMN_2012_ETAT_PJ" type="index" version="1" based-on="key2">
<sql xml:space="preserve">
- CREATE TABLE IF NOT EXISTS ${base-name} (
+ CREATE TABLE ${base-name} (
COLLECTIVITE VARCHAR(15) NOT NULL,
BUDGET VARCHAR(24) NOT NULL,
DOC_ID VARCHAR(100) NOT NULL,
<!-- LIASSES -->
<sql-index id="nodeIdLiasse" table="T2" column="NODEID" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:NumLiasseNationale/n:Liasse/@added:generated-id" datatype="string"/>
<sql-index id="numLiasseCentrale" table="T2" column="NUM_LIASSE" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:NumLiasseNationale/n:Liasse/@national" datatype="string" format="uppercase"/>
- <sql-index id="liasseAnneeGestion" table="T2" column="ANNEE_GESTION" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/@Annee" datatype="integer" use-in-criteria="false"/>
+ <sql-index id="liasseAnneeGestion" table="T2" column="ANNEE_GESTION" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/@Annee" datatype="integer" reset-on="key3"/>
<!-- PJ -->
<sql-index id="nodeIdPj" table="T3" column="NODEID" path="/n:Edmn2012/n:EtatEdmn2012/n:LigneEdmn2012/n:PJ/@added:generated-id" datatype="string"/>
domFactory = FactoryProvider.getDocumentBuilderFactory();
domFactory.setNamespaceAware(true);
transformerFactory = FactoryProvider.getTransformerFactory();
- initializeQueryProvider();
+ initializeQueryProvider2012();
}
@Override
while (line != null && line.length() > 0) {
String[] els = line.split(";");
for (int i = 0; i < 12; i++)
- ps.setString(i + 1, els[i]);
- // logger.debug("inserting ["+els[0]+","+els[1]+","+els[2]+","+els[3]+","+els[4]+","+els[5]+"]");
+ if(i==4){ // code ministere
+ ps.setString(i + 1, new StringBuilder("MIN").append(els[i]).toString());
+ } else {
+ ps.setString(i + 1, els[i]);
+ }
+ logger.debug("inserting ["+els[0]+","+els[1]+","+els[2]+","+els[3]+","+els[4]+","+els[5]+"]");
ps.executeUpdate();
line = br.readLine();
}
if (rsLiasses.next()) {
String comptable = rsLiasses.getString(1);
String imputation = rsLiasses.getString(2);
- String ministere = rsLiasses.getString(3).replace("MIN",""); // Suppression du MIN contenu dans le code ministere
+ String ministere = new StringBuilder("MIN").append(rsLiasses.getString(3)).toString(); // TODO : Ajout du MIN au code ministere du patch
String annee = rsLiasses.getString(4);
String trimestre = rsLiasses.getString(5);
String numLiasseDeb = rsLiasses.getString(6);
createTableIndexPatch=\
CREATE TABLE IF NOT EXISTS INDEX_PATCH_2012 ( \
- IND_ANNEE_GEST VARCHAR(2) not null, \
+ IND_ANNEE_GEST VARCHAR(4) 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_MINISTERE VARCHAR(5) not null, \
IND_COMPTESPE VARCHAR(5) not null, \
IND_LOCALE VARCHAR(4) not null, \
- IND_ANNEE_TRSP VARCHAR(2) not null, \
+ IND_ANNEE_TRSP VARCHAR(4) not null, \
IND_TRI_TRSP VARCHAR(1) not null, \
IND_SECTION_BUDG VARCHAR(2), \
IND_CPTESPENAT VARCHAR(5) not null, \
createTableIndexPatch=\
begin \
execute immediate 'CREATE TABLE INDEX_PATCH_2012 ( \
- IND_ANNEE_GEST VARCHAR(2) not null, \
+ IND_ANNEE_GEST VARCHAR(4) 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_MINISTERE VARCHAR(5) not null, \
IND_COMPTESPE VARCHAR(5) not null, \
IND_LOCALE VARCHAR(4) not null, \
- IND_ANNEE_TRSP VARCHAR(2) not null, \
+ IND_ANNEE_TRSP VARCHAR(4) not null, \
IND_TRI_TRSP VARCHAR(1) not null, \
IND_SECTION_BUDG VARCHAR(2), \
IND_CPTESPENAT VARCHAR(5) not null, \
SELECT \
edmn.COMPTABLE, \
edmn.IMPUTATION, \
- edmn.MINISTERE, \
- edmn.ANNEE_BUDG, \
+ edmn.MINISTEREBUDGETAIRE, \
+ edmn.ANNEE, \
edmn.TRIMESTRE, \
- edmn.NUM_LIASSE_DEB, \
- edmn.NUM_LIASSE_FIN \
+ edmn.NUMLIASSEDEB, \
+ edmn.NUMLIASSEFIN \
FROM EDMN_2012_ETAT edmn \
WHERE edmn.COLLECTIVITE = ? \
AND edmn.BUDGET = ? \