Function insertGroup

packages/core/src/db/group-queries.ts:31–63

(input: {
  id?: string;
  name: string;
  sortOrder?: number;
})

}

export async function insertGroup(input: {
  id?: string;
  name: string;
  sortOrder?: number;
}): Promise<BookGroup> {
  const database = await getDB();
  const deviceId = await getDeviceId();
  const syncVersion = await nextSyncVersion(database, "book_groups");
  const now = Date.now();
  const group: BookGroup = {
    id: input.id ?? generateId(),
    name: input.name.trim(),
    sortOrder: input.sortOrder ?? now,
    createdAt: now,
    updatedAt: now,
  };

  await database.execute(
    `INSERT INTO book_groups (id, name, sort_order, created_at, updated_at, sync_version, last_modified_by)
     VALUES (?, ?, ?, ?, ?, ?, ?)`,
    [
      group.id,
      group.name,
      group.sortOrder,
      group.createdAt,
      group.updatedAt,
      syncVersion,
      deviceId,
    ],
  );

  return group;
}

export async function updateGroup(
  id: string,