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 }