github.com/benoitkugler/goacve@v0.0.0-20201217100549-151ce6e55dc8/server/core/rawdata/composites/auto_test.go (about)

     1  package composites
     2  
     3  import (
     4  	"fmt"
     5  	"testing"
     6  
     7  	"github.com/benoitkugler/goACVE/logs"
     8  	"github.com/benoitkugler/goACVE/server/core/rawdata"
     9  )
    10  
    11  func TestComposite(t *testing.T) {
    12  	db, err := rawdata.ConnectDB(logs.DBDev)
    13  	if err != nil {
    14  		t.Fatal(err)
    15  	}
    16  	defer db.Close()
    17  	row := db.QueryRow("SELECT equipiers.*,personnes.*  FROM equipiers JOIN personnes ON equipiers.id_personne = personnes.id LIMIT 1")
    18  	c, err := ScanEquipierPersonne(row)
    19  	if err != nil {
    20  		t.Fatal(err)
    21  	}
    22  	fmt.Println(c.NomPrenom())
    23  
    24  	rows, err := db.Query("SELECT equipiers.*,personnes.*  FROM equipiers JOIN personnes ON equipiers.id_personne = personnes.id")
    25  	if err != nil {
    26  		t.Fatal(err)
    27  	}
    28  	cs, err := ScanEquipierPersonnes(rows)
    29  	if err != nil {
    30  		t.Fatal(err)
    31  	}
    32  	fmt.Println(len(cs))
    33  
    34  	rows, err = db.Query(`SELECT aides.*, participants.*, factures.*, personnes.* FROM aides 
    35  		JOIN participants ON aides.id_participant = participants.id
    36  		JOIN factures ON participants.id_facture= factures.id
    37  		JOIN personnes ON factures.id_personne = personnes.id`)
    38  	if err != nil {
    39  		t.Fatal(err)
    40  	}
    41  	fs, err := ScanAideParticipantFacturePersonnes(rows)
    42  	if err != nil {
    43  		t.Fatal(err)
    44  	}
    45  	fmt.Println(len(fs))
    46  }