Sounds like a mission impossible given the number of inner joins. However, what are you _actually_ trying to do? Are you trying to reindex the data? Do you actually have the data to reindex?
Regards, Alex. ---- Solr Analyzers, Tokenizers, Filters, URPs and even a newsletter: http://www.solr-start.com/ On 19 October 2015 at 06:41, fabigol <fabien.stou...@vialtis.com> wrote: > 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.
