CRUD Generation

Note

The delete operation is not currently supported, but will be added in a future release.

Creating the same CRUD operations for each Model can be tedious. Cloesce provides a way to automatically generate these operations based on your Model definitions and Data Source configurations.

Each CRUD operation corresponds to an ORM method that is generated for your Models. You can choose to generate any combination of the following operations:

Get

The get operation retrieves a single record by its primary key and key fields. For example:

[use db]
[crud get]
model Person {
    primary {
        id: int
    }

    keyfield {
        name: string
    }
}

source Custom for Person {
    include {}

    sql get(special_id: int) {
        "
        ...
        "
    }
}

The above schema will generate two API methods:

• GET /Person/$get: Accepts arguments id and name, hydrates with the Default Data Source, and returns a Person instance if a record is found

• GET /Person/$get_Custom: Accepts arguments id, name, and special_id, hydrates with the Custom Data Source, and returns a Person instance if a record is found

List

Important

The list operation can only be used if your Model does not have any key fields.

The list operation retrieves multiple records. By default, it will use a seek based pagination strategy. For example:

[use db]
[crud list]
model Person {
    primary {
        id: int
    }
}

source OffsetPagination for Person {
    include {}

    sql list(offset: int, limit: int) {
        "
        ...
        "
    }
}

The above schema will generate two API methods:

• GET /Person/$list: Accepts arguments limit and lastSeen_id, hydrates with the Default Data Source, and returns a paginated list of Person instances

• GET /Person/$list_OffsetPagination: Accepts arguments offset and limit, hydrates with the Custom Data Source, and returns a paginated list of Person instances

Save

The save operation creates or updates any record within a Data Source’s include tree.

The only parameter save accepts is a partial Model instance, which is an object that may contain a subset of the Model’s fields. For example:

[use db]
[crud save]
model Person {
    primary {
        id: int
    }

    keyfield {
        name: string
    }
}

The client could then invoke a method like:

export class Person {
  // ...
  static async $save(model: DeepPartial<Person>): Promise<HttpResult<Person>> {
    // ...
  }
}

const result = await Person.$save({
  id: 1,
  name: "Alice",
});

R2 Fields

If your Model contains an R2 field, the save operation will not be able to accept any data for that field, since the ORM is designed only for JSON serializable data. To work around this, you can define a custom instance method on your Model that accepts a stream parameter:

model Person {
    primary {
        id: int
    }

    r2 (bucket, "key/{id}") {
        photo
    }
}

api Person {
    [inject bucket]
    post upload_photo(self, photo: stream)
}

import * as clo from "@cloesce/backend.js";

export const Person = clo.Person.impl({
  async upload_photo(self, env, photo) {
    const key = this.Key.photo(self.id);
    await env.bucket.put(key, photo);
  },
});