Hi,
i catch an old Solr Project that i would configur.
I have the xml file for each entity but i don't have the database.
Is there a way to find the table schema?
do it exist Tools to generate the table from xml file?
Here a file:
<dataConfig>
<dataSource name="myvialtis" driver="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/myvialtis" user="postgres"
password="postgres" readOnly="true" autoCommit="false"
batchSize="100000"
transactionIsolation="TRANSACTION_READ_COMMITTED"
holdability="CLOSE_CURSORS_AT_COMMIT" />
<document>
<entity rootEntity="true" name="conso" dataSource="myvialtis"
transformer="RegexTransformer"
query="select *
from bi_solr_transaction
inner join bi_solr_tiers on tiers_id_client =
conso_id_client
inner join bi_solr_contrat on contrat_id_contrat =
conso_id_contrat
left join bi_solr_carte on carte_id_carte =
conso_id_carte
left join bi_solr_invoice on
invoice_numero_facture=conso_numero_facture
where conso_type_transaction is null or
conso_type_transaction != '1'">
<field name="ID" column="conso_id" />
<field name="DOC_TYPE" column="conso_doc_type" />
<field name="ID_CARTE" column="conso_id_carte" />
<field name="NUM_CARTE" column="conso_numero_carte" />
<field name="IMMATRICULATION"
column="conso_immatriculation" />
<field name="CLASSE_VEHICULE"
column="conso_classe_vehicule" />
<field name="NOM_FLOTTE" column="conso_nom_flotte" />
<field name="CARTE_ACTIVE" column="carte_carte_active"
/>
<field name="ID_CONSO" column="conso_id_conso" />
<field name="NOM_GARE_ORIGINE"
column="conso_gare_entree" />
<field name="NOM_GARE_CIBLE" column="conso_gare_sortie"
/>
<field name="NOM_AUTO_ORIGINE"
column="conso_autoroute_entree" />
<field name="NOM_AUTO_CIBLE"
column="conso_autoroute_sortie" />
<field name="NOM_SCA_ORIGINE" column="conso_sca_entree"
/>
<field name="NOM_SCA_CIBLE" column="conso_sca_sortie" />
<field name="DATE_PREST_ORIGINE"
column="conso_date_entree" />
<field name="DATE_PREST_CIBLE"
column="conso_date_sortie" />
<field name="TOTAL_HT1" column="conso_montant_ht1" />
<field name="TOTAL_HT2" column="conso_montant_ht2" />
<field name="TOTAL_TTC" column="conso_montant_ttc" />
<field name="TAUX_TVA" column="conso_taux_tva" />
<field name="QUANTITE" column="conso_quantite" />
<field name="KM_SERVICE" column="conso_distance" />
<field name="STATUT_CONSO" column="conso_statut" />
<field name="PAYS_SERVICE" column="conso_pays" />
<field name="ID_DEVISE" column="conso_id_devise" />
<field name="DATE_PRESTATION_DD_MM_YYYY"
column="conso_date_ddmmyyyy" />
<field name="DATE_PRESTATION_MM_YYYY"
column="conso_date_mmyyyy" />
<field name="DATE_PRESTATION_HH24_MI"
column="conso_date_hh24mi" />
<field name="DATE_PRESTATION_DOW"
column="conso_date_dow" />
<field name="PKM_ENTREE" column="conso_gare_pkm_entree"
/>
<field name="PKM_SORTIE" column="conso_gare_pkm_sortie"
/>
<field name="CLASSE_TARIF" column="conso_classe_tarif"
/>
<field name="CODE_OBS" column="conso_code_obs" />
<field name="TYPE_TRANSACTION"
column="conso_type_transaction" />
<field name="SOUS_PRODUIT" column="conso_sous_produit"
/>
<field name="ID_CLIENT" column="tiers_id_client" />
<field name="NOM_CLIENT" column="tiers_nom_client" />
<field name="ID_PARENT" column="tiers_id_parent"
splitBy="," />
<field name="ID_PAYS_CLIENT"
column="tiers_id_pays_client" />
<field name="ID_SEGMENT" column="tiers_id_segment" />
<field name="ID_SALE" column="tiers_id_sale" />
<field name="NOM_SALE" column="tiers_nom_sale" />
<field name="ID_TYPE_SERVICE"
column="contrat_id_type_service" />
<field name="ID_CONTRAT" column="contrat_id_contrat" />
<field name="ID_CONTRAT_CADRE"
column="contrat_id_contrat_cadre" />
<field name="ID_STATUT_CONTRAT"
column="contrat_id_statut_contrat" />
<field name="ID_PRODUIT" column="contrat_id_produit" />
<field name="NOM_PRODUIT" column="contrat_nom_produit"
/>
<field name="ID_BENEFICIAIRE_CONSO"
column="contrat_id_beneficiaire_conso" />
<field name="ID_BENEFICIAIRE_HONO"
column="contrat_id_beneficiaire_hono"
/>
<field name="ID_PAYEUR_CONSO"
column="contrat_id_payeur_conso" />
<field name="ID_PAYEUR_HONO"
column="contrat_id_payeur_hono" />
<field name="ID_PARTENAIRE"
column="contrat_id_partenaire" />
<field name="NOM_PARTENAIRE"
column="contrat_nom_partenaire" />
<field name="TYPE_PARTENAIRE"
column="contrat_type_partenaire" />
<field name="ID_FILIALE" column="contrat_id_filiale" />
<field name="NOM_FILIALE" column="contrat_nom_filiale"
/>
<field name="COMPTE_WEB_POSSIBLE"
column="contrat_compte_web_possible" />
<field name="REF_CONTRAT_TVA"
column="contrat_ref_contrat_tva" />
<field name="PAYS_DEPOT_TVA"
column="contrat_pays_depot_tva" />
<field name="NUMERO_FACTURE"
column="invoice_numero_facture" />
<field name="ID_BENEFICIAIRE"
column="invoice_id_beneficiaire" />
<field name="ID_PAYEUR" column="invoice_id_payeur" />
<field name="DATE_EMISSION"
column="invoice_date_emission" />
<field name="DATE_EMISSION_DD_MM_YYYY"
column="invoice_date_emission_dd_mm_yyyy" />
<field name="DATE_EMISSION_MM_YYYY"
column="invoice_date_emission_mm_yyyy" />
<field name="DATE_EMISSION_YYYY"
column="invoice_date_emission_yyyy" />
<field name="DEVISE" column="invoice_devise" />
<field name="INVOICE_TOTAL_HT"
column="invoice_total_ht" />
<field name="INVOICE_TOTAL_TVA"
column="invoice_total_tva" />
<field name="INVOICE_TOTAL_TTC"
column="invoice_total_ttc" />
<field name="U_ID_CARTE" column="conso_id_carte" />
<field name="U_NUM_CARTE" column="conso_numero_carte" />
<field name="U_IMMATRICULATION"
column="conso_immatriculation" />
<field name="U_CLASSE_VEHICULE"
column="conso_classe_vehicule" />
<field name="U_NOM_FLOTTE" column="conso_nom_flotte" />
<field name="U_CARTE_ACTIVE"
column="carte_carte_active" />
<field name="U_ID_CONSO" column="conso_id_conso" />
<field name="U_NOM_GARE_ORIGINE"
column="conso_gare_entree" />
<field name="U_NOM_GARE_CIBLE"
column="conso_gare_sortie" />
<field name="U_NOM_AUTO_ORIGINE"
column="conso_autoroute_entree" />
<field name="U_NOM_AUTO_CIBLE"
column="conso_autoroute_sortie" />
<field name="U_NOM_SCA_ORIGINE"
column="conso_sca_entree" />
<field name="U_NOM_SCA_CIBLE" column="conso_sca_sortie"
/>
<field name="U_DATE_PREST_ORIGINE"
column="conso_date_entree" />
<field name="U_DATE_PREST_CIBLE"
column="conso_date_sortie" />
<field name="U_TOTAL_HT1" column="conso_montant_ht1" />
<field name="U_TOTAL_HT2" column="conso_montant_ht2" />
<field name="U_TOTAL_TTC" column="conso_montant_ttc" />
<field name="U_TAUX_TVA" column="conso_taux_tva" />
<field name="U_QUANTITE" column="conso_quantite" />
<field name="U_KM_SERVICE" column="conso_distance" />
<field name="U_STATUT_CONSO" column="conso_statut" />
<field name="U_PAYS_SERVICE" column="conso_pays" />
<field name="U_ID_DEVISE" column="conso_id_devise" />
<field name="U_DATE_PRESTATION_DD_MM_YYYY"
column="conso_date_ddmmyyyy"
/>
<field name="U_DATE_PRESTATION_MM_YYYY"
column="conso_date_mmyyyy" />
<field name="U_DATE_PRESTATION_HH24_MI"
column="conso_date_hh24mi" />
<field name="U_DATE_PRESTATION_DOW"
column="conso_date_dow" />
<field name="U_PKM_ENTREE"
column="conso_gare_pkm_entree" />
<field name="U_PKM_SORTIE"
column="conso_gare_pkm_sortie" />
<field name="U_CLASSE_TARIF"
column="conso_classe_tarif" />
<field name="U_CODE_OBS" column="conso_code_obs" />
<field name="U_TYPE_TRANSACTION"
column="conso_type_transaction" />
<field name="U_SOUS_PRODUIT"
column="conso_sous_produit" />
<field name="U_ID_CLIENT" column="tiers_id_client" />
<field name="U_NOM_CLIENT" column="tiers_nom_client" />
<field name="U_ID_PARENT" column="tiers_id_parent"
splitBy="," />
<field name="U_ID_PAYS_CLIENT"
column="tiers_id_pays_client" />
<field name="U_ID_SEGMENT" column="tiers_id_segment" />
<field name="U_ID_SALE" column="tiers_id_sale" />
<field name="U_NOM_SALE" column="tiers_nom_sale" />
<field name="U_ID_TYPE_SERVICE"
column="contrat_id_type_service" />
<field name="U_ID_CONTRAT" column="contrat_id_contrat"
/>
<field name="U_ID_CONTRAT_CADRE"
column="contrat_id_contrat_cadre" />
<field name="U_ID_STATUT_CONTRAT"
column="contrat_id_statut_contrat" />
<field name="U_ID_PRODUIT" column="contrat_id_produit"
/>
<field name="U_NOM_PRODUIT"
column="contrat_nom_produit" />
<field name="U_ID_BENEFICIAIRE_CONSO"
column="contrat_id_beneficiaire_conso" />
<field name="U_ID_BENEFICIAIRE_HONO"
column="contrat_id_beneficiaire_hono" />
<field name="U_ID_PAYEUR_CONSO"
column="contrat_id_payeur_conso" />
<field name="U_ID_PAYEUR_HONO"
column="contrat_id_payeur_hono" />
<field name="U_ID_PARTENAIRE"
column="contrat_id_partenaire" />
<field name="U_NOM_PARTENAIRE"
column="contrat_nom_partenaire" />
<field name="U_TYPE_PARTENAIRE"
column="contrat_type_partenaire" />
<field name="U_ID_FILIALE" column="contrat_id_filiale"
/>
<field name="U_NOM_FILIALE"
column="contrat_nom_filiale" />
<field name="U_COMPTE_WEB_POSSIBLE"
column="contrat_compte_web_possible"
/>
<field name="U_REF_CONTRAT_TVA"
column="contrat_ref_contrat_tva" />
<field name="U_PAYS_DEPOT_TVA"
column="contrat_pays_depot_tva" />
<field name="U_NUMERO_FACTURE"
column="invoice_numero_facture" />
<field name="U_ID_BENEFICIAIRE"
column="invoice_id_beneficiaire" />
<field name="U_ID_PAYEUR" column="invoice_id_payeur" />
<field name="U_DATE_EMISSION"
column="invoice_date_emission" />
<field name="U_DATE_EMISSION_DD_MM_YYYY"
column="invoice_date_emission_dd_mm_yyyy" />
<field name="U_DATE_EMISSION_MM_YYYY"
column="invoice_date_emission_mm_yyyy" />
<field name="U_DATE_EMISSION_YYYY"
column="invoice_date_emission_yyyy" />
<field name="U_DEVISE" column="invoice_devise" />
<field name="U_INVOICE_TOTAL_HT"
column="invoice_total_ht" />
<field name="U_INVOICE_TOTAL_TVA"
column="invoice_total_tva" />
<field name="U_INVOICE_TOTAL_TTC"
column="invoice_total_ttc" />
</entity>
</document>
</dataConfig>
--
View this message in context:
http://lucene.472066.n3.nabble.com/Configuration-tp4235163.html
Sent from the Solr - User mailing list archive at Nabble.com.
