B4J Library [Web]PocketBase Hooks Collection

Hi Fam

This will be a collection of useful hooks to use with pocketbase.

The hooks should be saved in the pb_hooks folder of your pocketbase server. Create js files with the respective routes and restart the server.

What is PocketBase?

PocketBase - Open Source backend in 1 file

Open Source backend in 1 file with realtime database, authentication, file storage and admin dashboard

pocketbase.io

Related Content

[Web] Using PocketBase as a Framework: Lets create a REST API

Ola. Its amazing with the latest version of PocketBase one can extend it with JavaScript / Go. So I tested creating some REST API handlers. You can unzip the attached file to your pocketbase folder. It should create a pb_hooks folder. You can then call the handler via the browser after...

www.b4x.com

 

[Mashiane]

1. Send An Email via REST API with GMail or Other

One is able to send emails using pocketbase & gmail for example. Any other SMTP based configuration can be used.

To use GMail, follow the instructions here...

gmail test mail timeout · pocketbase pocketbase · Discussion #458

I still don't know if this is a bug. When trying to setup gmail as smtp.gmail.com the UI throws a Test email send timeout. error. I've created an App password for mail in a google account and teste...

github.com

Unzip and copy the attached script to your pb_hooks directory inside pocketbase folder.
You will need to restart your app after.

routerAdd("POST", "/api/sendemail", (c) => {
    try {
        // read the body via the cached request object
        const data = $apis.requestInfo(c).data
        const message = new MailerMessage({
            from: {
                address: $app.settings().meta.senderAddress,
                name: $app.settings().meta.senderName,
            },
            to: [{ address: data.to }],
            subject: data.subject,
            html: data.message
        })
        $app.newMailClient().send(message)
        return c.json(200, { "email": "Success" })
    } catch (err) {
        return c.json(200, { "email": "Failure", "error": err })
    }
}, $apis.activityLogger($app))

This code receives a JSON via REST API (body) with {to, subject, message}

Execute a POST using

http://127.0.0.1:9090/api/sendemail

 

[Mashiane]

2. Delete All Records in a Table

Deletion of all records in a table is currently NOT YET supported. To delete all the records, one has to get all the record IDs and then delete EACH one individually. This hook enables one to pass the name of the table to "truncate" and delete all the records.

This is open to SQL attacks, so be careful and use with caution.

OPTION 1, add middleware to ensure that deletion happens by an admin user.

routerAdd("POST", "/api/deleteallauth", (c) => {
    try {
        const data = $apis.requestInfo(c).data
        const tablename = data.tablename
        if (tablename.length > 0) {
            $app.dao().db()
                .newQuery("DELETE FROM " + tablename)
                .execute()
            return c.json(200, { "deleteall": "Success" })
        } throw new BadRequestError("The tablename has not been specified!")
    } catch (err) {
        return c.json(400, { "deleteall": "Failure", "error": err })
    }
}, $apis.activityLogger($app),$apis.requireAdminAuth())

OPTION 2, ...

routerAdd("POST", "/api/deleteall", (c) => {
    try {
        const data = $apis.requestInfo(c).data
        const tablename = data.tablename
        if (tablename.length > 0) {
            $app.dao().db()
                .newQuery("DELETE FROM " + tablename)
                .execute()
            return c.json(200, { "deleteall": "Success" })
        } throw new BadRequestError("The tablename has not been specified!")
    } catch (err) {
        return c.json(400, { "deleteall": "Failure", "error": err })
    }
}, $apis.activityLogger($app))

The body should be a JSON with

{
    "tablename":"components"
}

Where for example "components" is your table name.

Execute a POST using

http://127.0.0.1:9090/api/deleteall

http://127.0.0.1:9090/api/deleteallauth

 

[Mashiane]

Get the server date time

This code returns the current server date time as a string

routerAdd("GET", "/api/servertime", (c) => {
    const now = new Date()
    const year = now.getFullYear()
    const month = String(now.getMonth() + 1).padStart(2, '0')
    const day = String(now.getDate()).padStart(2, '0')
    const hours = String(now.getHours()).padStart(2, '0')
    const minutes = String(now.getMinutes()).padStart(2, '0')
    const formattedDateTime = `${year}-${month}-${day} ${hours}:${minutes}`
    return c.string(200, formattedDateTime)
}, $apis.activityLogger($app))

To call it:

http://127.0.0.1:1001/api/servertime

Result:

2024-07-27 22:11

 

[Mashiane]

PocketBase - RawSelect (A route/handler to execute SELECT SQL Commands)

Hi Fam Compatibility: v22.35 and below In b4j we have a way of adding routes and writing handler code, same with PocketBase. In PocketBase, one is able to create handlers via javascript and then publish these in the pb_hooks directory and then restart the app to make them live. So, to execute...

www.b4x.com

 

[Mashiane]

PocketBase - RawInsert (A route/handler to execute INSERT SQL Commands)

Hi Fam.. Background With this route / handler, you are able to execute inserts in your database using parameterized sql command. You can also specify which fields should be returned from the record that was added. Copy the attached file to your pb_hooks directory and restart the app. Example...

www.b4x.com

 

[Mashiane]

PocketBase - RawUpdate (A route/handler to execute UPDATE SQL Commands)

Hi Fam Background RawUpdate is a new addition to the pocketbase routes. Its purpose is to help anyone execute UPDATE SQL Commands directly to their pocketbase back-end. You need to drop the file to your pb_hooks directly and you are able to execute the update commands Here you pass the...

www.b4x.com