Esempio n. 1
0
func TestColumnDict(t *testing.T) {
	table, err := crud.NewTable(Foo{})
	assert.Nil(t, err)

	columnDict := table.SQLColumnDict()
	assert.Equal(t, columnDict["id"], "Id")
	assert.Equal(t, columnDict["api_key"], "APIKey")
	assert.Equal(t, columnDict["yolo"], "YOLO")
	assert.Equal(t, columnDict["beast"], "Beast")

	table, err = crud.NewTable(&Foo{})
	assert.Nil(t, err)

	columnDict = table.SQLColumnDict()
	assert.Equal(t, columnDict["id"], "Id")
	assert.Equal(t, columnDict["api_key"], "APIKey")
	assert.Equal(t, columnDict["yolo"], "YOLO")
	assert.Equal(t, columnDict["beast"], "Beast")

	/*var f *Foo
	table, err = crud.NewTable(f)
	assert.Nil(t, err)

	columnDict = table.SQLColumnDict()
	assert.Equal(t, columnDict["id"], "Id")
	assert.Equal(t, columnDict["api_key"], "APIKey")
	assert.Equal(t, columnDict["yolo"], "YOLO")
	assert.Equal(t, columnDict["beast"], "Beast")*/
}
Esempio n. 2
0
func TestNewTable(t *testing.T) {
	table, err := crud.NewTable(UserProfile{})
	assert.Nil(t, err)
	assert.Equal(t, table.Name, "UserProfile")
	assert.Equal(t, table.SQLName, "user_profile")
	assert.Equal(t, len(table.Fields), 4)
	assert.Equal(t, table.Fields[0].Name, "Id")
	assert.Equal(t, table.Fields[0].SQL.Name, "id")
	assert.Equal(t, table.Fields[0].SQL.Type, "int")
	assert.Equal(t, table.Fields[0].SQL.Length, 11)
	assert.Equal(t, table.Fields[0].SQL.AutoIncrement, 1)
	assert.Equal(t, table.Fields[0].SQL.IsPrimaryKey, true)
	assert.Equal(t, table.Fields[0].SQL.IsRequired, true)
	assert.Equal(t, table.Fields[1].Name, "Name")
	assert.Equal(t, table.Fields[1].SQL.Name, "name")
	assert.Equal(t, table.Fields[1].SQL.Type, "varchar")
	assert.Equal(t, table.Fields[1].SQL.Length, 255)
	assert.Equal(t, table.Fields[1].SQL.IsUnique, true)
	assert.Equal(t, table.Fields[1].SQL.IsRequired, true)
	assert.Equal(t, table.Fields[2].Name, "Bio")
	assert.Equal(t, table.Fields[2].SQL.Name, "bio")
	assert.Equal(t, table.Fields[2].SQL.Type, "text")
	assert.Equal(t, table.Fields[2].SQL.Length, -1)
	assert.Equal(t, table.Fields[3].Name, "Email")
	assert.Equal(t, table.Fields[3].SQL.Name, "email")
	assert.Equal(t, table.Fields[3].SQL.Type, "varchar")
	assert.Equal(t, table.Fields[3].SQL.Length, 255)
}
Esempio n. 3
0
func TestColumnDictOfSlices(t *testing.T) {
	table, err := crud.NewTable([]Foo{})
	assert.Nil(t, err)

	columnDict := table.SQLColumnDict()
	assert.Equal(t, columnDict["id"], "Id")
	assert.Equal(t, columnDict["api_key"], "APIKey")
	assert.Equal(t, columnDict["yolo"], "YOLO")
	assert.Equal(t, columnDict["beast"], "Beast")

	table, err = crud.NewTable(FooSlice{})
	assert.Nil(t, err)

	columnDict = table.SQLColumnDict()
	assert.Equal(t, columnDict["id"], "Id")
	assert.Equal(t, columnDict["api_key"], "APIKey")
	assert.Equal(t, columnDict["yolo"], "YOLO")
	assert.Equal(t, columnDict["beast"], "Beast")

	table, err = crud.NewTable(&FooSlice{})
	assert.Nil(t, err)

	columnDict = table.SQLColumnDict()
	assert.Equal(t, columnDict["id"], "Id")
	assert.Equal(t, columnDict["api_key"], "APIKey")
	assert.Equal(t, columnDict["yolo"], "YOLO")
	assert.Equal(t, columnDict["beast"], "Beast")

	table, err = crud.NewTable(FooPTRSlice{})
	assert.Nil(t, err)

	columnDict = table.SQLColumnDict()
	assert.Equal(t, columnDict["id"], "Id")
	assert.Equal(t, columnDict["api_key"], "APIKey")
	assert.Equal(t, columnDict["yolo"], "YOLO")
	assert.Equal(t, columnDict["beast"], "Beast")

	table, err = crud.NewTable(&FooPTRSlice{})
	assert.Nil(t, err)

	columnDict = table.SQLColumnDict()
	assert.Equal(t, columnDict["id"], "Id")
	assert.Equal(t, columnDict["api_key"], "APIKey")
	assert.Equal(t, columnDict["yolo"], "YOLO")
	assert.Equal(t, columnDict["beast"], "Beast")
}