Function ExampleDB_Model_createTable

example_test.go:230–263

()

}

func ExampleDB_Model_createTable() {
	type Model1 struct {
		Id int
	}

	type Model2 struct {
		Id   int
		Name string

		Model1Id int     `pg:"on_delete:RESTRICT,on_update: CASCADE"`
		Model1   *Model1 `pg:"rel:has-one"`
	}

	for _, model := range []interface{}{&Model1{}, &Model2{}} {
		err := pgdb.Model(model).CreateTable(&orm.CreateTableOptions{
			Temp:          true, // create temp table
			FKConstraints: true,
		})
		panicIf(err)
	}

	var info []struct {
		ColumnName string
		DataType   string
	}
	_, err := pgdb.Query(&info, `
		SELECT column_name, data_type
		FROM information_schema.columns
		WHERE table_name = 'model2'
	`)
	panicIf(err)
	fmt.Println(info)
	// Output: [{id bigint} {name text} {model1_id bigint}]
}

func ExampleInts() {
	var nums pg.Ints