Feature Request: Truncate collection

[jimafisk]

Summary: Bulk delete thousands of records using the Admin UI.

Details: We have a couple of collections in our PocketBase instance that have thousands of records. We'd like to be able to completely clear out these records when testing a custom data migration. Currently in the admin dashboard it shows 30 records by default and you can scroll down and load 30 more at a time. It would be nice if the bulk select at the top had the option to select the currently loaded records or all the records in the entire collection, which you then could bulk delete.

Concept for how this could look in the UI

[ganigeorgiev]

Something like this was requested previously in #560.

I think it will be confusing to have a "Select all ..." in the bulk bar UI. Instead it might be better to have a "Truncate" option in the collection settings dropdown (eg. next to the "Duplicate" option). The "Truncate" option could trigger a dedicated endpoint accessible only by admins.

I'll add it to the roadmap but for now remains a low priority.

[buldezir]

maybe someone will find it helpful:
tmp "hack" to implement it in your code "for" js sdk:

import { RecordService } from "pocketbase";

declare module "pocketbase" {
    interface RecordService {
        truncate(): Promise<void>;
    }
}

RecordService.prototype.truncate = async function () {
    const old = await this.getFullList();
    for (const oldRecord of old) {
        await this.delete(oldRecord.id);
    }
    console.log(`Truncated ${this.collectionIdOrName}`);
};

[jonshipman]

My truncate collection command

$app.rootCmd.addCommand(
  new Command({
    use: 'truncate',
    run(cmd, args) {
      if (!args[0]) return console.error('Need collection name');

      $app
        .dao()
        .db()
        .newQuery('DELETE FROM ' + args[0])
        .execute();
    }
  })
);

Does it in on sqlite query instead of how many records you have.