connection: ""

# include all the views
include: "/views/**/*.view"

datagroup: universite_default_datagroup {
  # sql_trigger: SELECT MAX(id) FROM etl_log;;
  max_cache_age: "24 hour"
}

persist_with: universite_default_datagroup


explore: cat {}

explore: marchandise {}

explore: marchandise_cat {}

explore: livreur {}

explore: boutique {}

explore: groupe {}

explore: secteur {}

explore: section {}

explore: ss_section {}

explore: case {}


explore: ventes {

  join: marchandise {
    type: left_outer
    relationship: many_to_one
    sql_on: ${ventes.id_marchandise}=${marchandise.id_marchandise} ;;
  }

  join: livreur {
    type: left_outer
    relationship: many_to_one
    sql_on: ${marchandise.id_fourn}=${livreur.id_fourn} ;;
  }

  join: groupe {
    type: left_outer
    relationship: many_to_one
    sql_on: ${marchandise.id_groupe}=${groupe.id_groupe} ;;
  }

  join: marchandise_cat {
    type: left_outer
    relationship: one_to_many
    sql_on: ${marchandise.id_marchandise}=${marchandise_cat.id_marchandise} ;;
  }

  join: cat {
    type: left_outer
    relationship: many_to_one
    sql_on: ${marchandise_cat.id_cat}=${cat.id_cat} ;;
  }

  join: case {
    type: left_outer
    relationship: many_to_one
    sql_on: ${marchandise_cat.id_case_case}=${case.id_case_case};;
  }

  join: n3_ss_section {
    type: left_outer
    relationship: many_to_one
    sql_on: ${case.id_sssection}=${ss_section.id_sssection};;
  }

  join: section {
    type: left_outer
    relationship: many_to_one
    sql_on: ${ss_section.id_section}=${section.id_section};;
  }

  join: secteur {
    type: left_outer
    relationship: many_to_one
    sql_on: ${section.id_secteur}=${secteur.id_secteur};;
  }

  join: boutique {
    type: left_outer
    relationship: many_to_one
    sql_on: ${ventes.id_boutique}=${boutique.id_boutique} ;;
  }

}

explore: commandes {

  join: clients {
    type: inner
    relationship: one_to_many
    sql_on: ${commandes.code_client} = cast(${clients.code_client} as string);;
  }

  join: nos_boutiques {
    type: inner
    relationship: one_to_many
    sql_on: ${commandes.code_boutique} = ${nos_boutiques.code_boutique};;
  }

 join: produits_commandes {
    type: inner
    relationship: one_to_many
    sql_on: ${commandes.code_commande} = ${produits_commandes.code_commande};;
  }

  join: ventes {
    type: inner
    relationship: many_to_one
    sql_on: ${ventes.id_boutique}=${boutique.id_boutique} ;;
  }

  join: boutique {
    type: inner
    relationship: many_to_one
    sql_on: ${commandes.code_boutique} = ${boutique.cd_boutique}  ;;
  }

}