Function sampleForJoin

join_test.go:13–33

https://sql.sh/cours/jointures/inner-join

()

// https://sql.sh/cours/jointures/inner-join
func sampleForJoin() (*datatable.DataTable, *datatable.DataTable) {
	customers := datatable.New("Customers")
	customers.AddColumn("id", datatable.Int)
	customers.AddColumn("prenom", datatable.String)
	customers.AddColumn("nom", datatable.String)
	customers.AddColumn("email", datatable.String)
	customers.AddColumn("ville", datatable.String)
	// customers.AddColumn("concat", datatable.String, datatable.Expr("CONCAT(`prenom`,`nom`)"))
	customers.AppendRow(1, "Aimée", "Marechal", "aime.marechal@example.com", "Paris")
	customers.AppendRow(2, "Esmée", "Lefort", "esmee.lefort@example.com", "Lyon")
	customers.AppendRow(3, "Marine", "Prevost", "m.prevost@example.com", "Lille")
	customers.AppendRow(4, "Luc", "Rolland", "lucrolland@example.com", "Marseille")

	orders := datatable.New("Orders")
	orders.AddColumn("user_id", datatable.Int, datatable.Values(1, 1, 2, 3, 5))
	orders.AddColumn("date_achat", datatable.Time, datatable.Values("2013-01-23", "2013-02-14", "2013-02-17", "2013-02-21", "2013-03-02"))
	orders.AddColumn("num_facture", datatable.String, datatable.Values("A00103", "A00104", "A00105", "A00106", "A00107"))
	orders.AddColumn("prix_total", datatable.Float64, datatable.Values(203.14, 124.00, 149.45, 235.35, 47.58))

	return customers, orders
}

func TestJoinOn(t *testing.T) {
	on := datatable.On("[customers].[id]")