查询和更新

我们先在可测试示例中创建一个 Todo。我们将以下代码添加到来完成这项工作：

执行 go test，它应该是能通过测试的。

正如你看到的，我们的 Todo 只有一个 ID 字段，什么事也做不了。让我们来改进它，在 todo/ent/schema/todo.go 中给它增加一些字段：

func (Todo) Fields() []ent.Field {
    return []ent.Field{
        field.Text("text").
            NotEmpty(),
        field.Time("created_at").
            Default(time.Now).
            Immutable(),
        field.Enum("status").
            NamedValues(
                "InProgress", "IN_PROGRESS",
                "Completed", "COMPLETED",
            ).
            Default("IN_PROGRESS"),
        field.Int("priority").
            Default(0),
    }
}

你可能注意到了，除了 text 字段，其他字段在创建时都有一个默认值，唯独它必须由用户提供。让我们修改 example_test.go 来适配刚刚的变动：

很好！我们在数据库中成功创建了一张表，包含了 5 列 (id, text, created_at, status, )，并且通过插入了两行数据到表中；即我们创建了两个任务到我们的 Todo list 中。

Let’s change our schema again in todo/ent/schema/todo.go:

func (Todo) Edges() []ent.Edge {
    return []ent.Edge{
        edge.To("parent", Todo.Type).
            Unique().
            From("children"),
    }
}

After adding these edges, we need to run the code-generation as before:

go generate ./ent

We continue our edges example, by updating the 2 todo items we just created. We define that item-2 (“Add Tracing Example”) depends on item-1 (“Add GraphQL Example”).

After connecting item-2 to item-1, we’re ready to start querying our todo list.

Query all todo items:

func Example_Todo() {
    // ...
    // Query all todo items.
    items, err := client.Todo.Query().All(ctx)
    if err != nil {
        log.Fatalf("failed querying todos: %v", err)
    }
    for _, t := range items {
        fmt.Printf("%d: %q\n", t.ID, t.Text)
    }
    // Output:
    // 1: "Add GraphQL Example"
    // 2: "Add Tracing Example"
}

Query all todo items that depend on other items:

func Example_Todo() {
    items, err := client.Todo.Query().Where(todo.HasParent()).All(ctx)
    if err != nil {
        log.Fatalf("failed querying todos: %v", err)
    }
    for _, t := range items {
        fmt.Printf("%d: %q\n", t.ID, t.Text)
    }
    // Output:
    // 2: "Add Tracing Example"
}

Query all todo items that don’t depend on other items and have items that depend on them:

Query parent through its children:

func Example_Todo() {
    // ...
    // Get a parent item through its children and expect the
    // query to return exactly one item.
    parent, err := client.Todo.Query(). // Query all todos.
        Where(todo.HasParent()).        // Filter only those with parents.
        QueryParent().                  // Continue traversals to the parents.
        Only(ctx)                       // Expect exactly one item.
    if err != nil {
        log.Fatalf("failed querying todos: %v", err)
    }
    fmt.Printf("%d: %q\n", parent.ID, parent.Text)
    // Output:
    // 1: "Add GraphQL Example"