github.com/benoitkugler/goacve@v0.0.0-20201217100549-151ce6e55dc8/server/shared/contraintes_defaut_test.go (about)

     1  package shared
     2  
     3  import (
     4  	"fmt"
     5  	"testing"
     6  
     7  	rd "github.com/benoitkugler/goACVE/server/core/rawdata"
     8  
     9  	"github.com/benoitkugler/goACVE/logs"
    10  )
    11  
    12  func TestContraintesDefaut(t *testing.T) {
    13  	db, err := rd.ConnectDB(logs.DBDev)
    14  	if err != nil {
    15  		t.Fatal(err)
    16  	}
    17  	tx, err := db.Begin()
    18  	if err != nil {
    19  		t.Fatal(err)
    20  	}
    21  	defer tx.Rollback()
    22  
    23  	rows, err := tx.Query("SELECT * FROM contraintes WHERE builtin <> '' AND builtin <> $1", rd.CTestNautique)
    24  	if err != nil {
    25  		t.Fatal(err)
    26  	}
    27  	contraintes, err := rd.ScanContraintes(rows)
    28  	if err != nil {
    29  		t.Fatal(err)
    30  	}
    31  	r := tx.QueryRow("SELECT * FROM equipiers LIMIT 1")
    32  	equipier, err := rd.ScanEquipier(r)
    33  	if err != nil {
    34  		t.Fatal(err)
    35  	}
    36  	// on supprime les contraintes actuelles si jamais
    37  	_, err = rd.DeleteEquipierContraintesByIdEquipiers(tx, equipier.Id)
    38  	if err != nil {
    39  		t.Fatal(err)
    40  	}
    41  
    42  	cts, err := AddEquipierDefautContraintes(tx, contraintes, equipier)
    43  	if err != nil {
    44  		t.Fatal(err)
    45  	}
    46  	fmt.Println(cts)
    47  }