sol_test.go

package sol

import (
	"time"

	"github.com/aodin/sol/types"
)

// Valid schemas should not panic
var users = Table("users",
	Column("id", types.Integer()),
	Column("email", types.Varchar().Limit(256).NotNull()), // TODO unique
	Column("name", types.Varchar().Limit(32).NotNull()),
	Column("password", types.Varchar()),
	Column("created_at", types.Timestamp()),
	PrimaryKey("id"),
	Unique("email"),
)

var contacts = Table("contacts",
	Column("id", types.Integer()),
	ForeignKey("user_id", users),
	Column("key", types.Varchar()),
	Column("value", types.Varchar()),
	PrimaryKey("id"),
	Unique("user_id", "key"),
)

var messages = Table("messages",
	Column("id", types.Integer()),
	ForeignKey("user_id", users.C("id")),
	SelfForeignKey("parent_id", "id"),
	Column("text", types.Text()),
)

type user struct {
	ID        uint64 `db:",omitempty"`
	Email     string
	Name      string
	CreatedAt time.Time `db:",omitempty"`
}

type contact struct {
	ID         int64 `db:"id"`
	UserID     int64 `db:"user_id"`
	Key, Value string
}