Create, Query, Update, and Relate Archery Data Models

class Role extends Model with InstanceDatabaseOps<Role> {
  late String name;
  String? description;

  Role.fromJson(Map<String, dynamic> json) : super.fromJson(json) {
    name = json['name'];
    description = json['description'];
  }

  static Map<String, String> columnDefinitions = {
    'name': 'TEXT NOT NULL UNIQUE',
    'description': 'TEXT',
  };

  @override
  Map<String, dynamic> toJson() => {
    'name': name,
    'description': description,
  };

  @override
  Map<String, dynamic> toMetaJson() => {
    'id': id,
    ...toJson(),
  };
}

final roles = await Model.all<Role>();
final role = await Model.find<Role>(id: 1, disk: .sqlite);
final admin = await Model.firstWhere<Role>(
  field: 'name',
  value: 'admin',
);

final created = await Model.create<Role>(
  fromJson: {'name': 'editor'},
);

await created?.update(withJson: {'description': 'Edits content'});
await created?.delete();