Editing handlers.go

Add one new property to the Chatt struct in handlers.go:

type Chatt struct {
    // . . .
    Audio  *string    `json:"audio"`
}

To the back-end database, the audio data is just a string. Since the audio string optional, we set the type to *string, which can take on a null pointer, nil in Go.

To handle audio data uploads, make a copy of your postchatt() function inside your handlers.go file and name the copy postaudio(). Replace the call to chatterDB.Exec() with:

chatterDB.Exec(background, `INSERT INTO chatts (username, message, id, audio) VALUES ($1, $2, gen_random_uuid(), $3)`, chatt.Username, chatt.Message, chatt.Audio)

which extracts the audio data from the JSON object and insert it into the chatts table, along with the rest of its associated chatt.

Next, make a copy of your getchatts() function inside your handlers.go file and name the copy getaudio(). Replace the SELECT statement with `SELECT username, message, id, time, audio FROM chatts ORDER BY time DESC`. This statement will retrieve all data, including our new audio string from the PostgreSQL database.

Still in getaudio(), replace the rows.Scan() call in the for rows.Next() {} block with:

        rows.Scan(&chatt.Username, &chatt.Message, &chatt.Id, &chatt.Timestamp, &chatt.Audio)

and if the returned err is not nil:

        chattArr = append(chattArr, []any{chatt.Username, chatt.Message, chatt.Id, chatt.Timestamp, chatt.Audio})

In addition to the original columns, we added reading the audio column and included it in the chatt data returned to the front end.

Save and exit handlers.go.

Routing for new URLs

For the newly added getaudio() and postaudio() functions, add the following new routes to the routes array in main.go:

var routes = []Route {
    // . . .
    {"GET", "/getaudio/", getaudio},
    {"POST", "/postaudio/", postaudio},
}

Save and exit main.go.

Go is a compiled language, like C/C++ and unlike Python, which is an interpreted language. This means you must run go build each and every time you made changes to your code, for the changes to show up in your executable.

Rebuild and restart chatterd:

server$ go build
server$ sudo systemctl restart chatterd

Editing handlers.ts

Add one new property to the Chatt interface in handlers.ts:

interface Chatt {}
    // . . .
    audio: string | null

To the back-end database, the audio data is just a string.

To handle audio data uploads, make a copy of your postchatt() function inside your handlers.ts file and name the copy postaudio(). Replace the line with the INSERT statement with:

        await chatterDB`INSERT INTO chatts (username, message, id, audio) VALUES (${chatt.username}, ${chatt.message}, ${randomUUID()}, ${chatt.audio})`

which extracts the audio data from the JSON object and insert it into the chatts table, along with the rest of its associated chatt.

Next, make a copy of your getchatts() function inside your handlers.ts file and name the copy getaudio(). Replace the declaration of chatts with:

        const chatts = await chatterDB`SELECT username, message, id, time, audio FROM chatts ORDER BY time DESC`.values()

This will retrieve all data, including our new audio string from the PostgreSQL database.

Save and exit handlers.ts.

Routing for new URLs

For the newly added getaudio() and postaudio() functions, add the following new routes to the Express app instantiation in main.ts:

      .get('/getaudio/', handlers.getaudio)
      .post('/postaudio/', handlers.postaudio)

Save and exit main.ts. Rebuild and restart chatterd:

server$ npx tsc
server$ sudo systemctl restart chatterd

Editing handlers.py

Add one new property to the Chatt struct in handlers.py:

class Chatt:
    // . . .
    audio: Optional[str] = None

To the back-end database, the audio data is just a string.

To handle audio data uploads, make a copy of your postchatt() function inside your handlers.py file and name the copy postaudio(). Replace the call to cursor.execute() with:

            await cursor.execute('INSERT INTO chatts (username, message, id, audio) VALUES '
                                 '(%s, %s, gen_random_uuid(), %s);', (chatt.username, chatt.message, chatt.audio))

which extracts the audio data from the JSON object and insert it into the chatts table, along with the rest of its associated chatt.

Next, make a copy of your getchatts() function inside your handlers.py file and name the copy getaudio(). Replace the SELECT statement with 'SELECT username, message, id, time, audio FROM chatts ORDER BY time DESC;'. This statement will retrieve all data, including our new audio string from the PostgreSQL database.

Save and exit handlers.py.

Routing for new URLs

For the newly added getaudio() and postaudio() functions, add the following new routes to the routes array in main.py:

    Route('/getaudio/', handlers.getaudio, methods=['GET']),
    Route('/postaudio/', handlers.postaudio, methods=['POST']),

Save and exit main.py and restart chatterd:

server$ sudo systemctl restart chatterd

Editing handlers.rs

Add one new property to the Chatt struct in handlers.rs:

pub struct Chatt {
    // . . .
    audio: Option<String>,
}

To the back-end database, the audio data is just a string.

To handle audio data uploads, make a copy of your postchatt() function inside your handlers.rs file and name the copy postaudio(). Replace the parameters in the call to chatterDB.execute() with:

            "INSERT INTO chatts (username, message, id, audio) VALUES ($1, $2, gen_random_uuid(), $3)",
            &[&chatt.username, &chatt.message, &chatt.audio],

which extracts the audio from the JSON object and insert it into the chatts table, along with the rest of its associated chatt.

Next, make a copy of your getchatts() function inside your handlers.rs file and name the copy getaudio(). Replace the SELECT statement with: "SELECT username, message, id, time, audio FROM chatts ORDER BY time DESC". This statement will retrieve all data, including our new audio data from the PostgreSQL database.

Still in getaudio(), replace the chattArr.push(/*...*/); line with:

        chattArr.push(vec![
            row.get(0),
            row.get(1),
            Some(row.get::<usize, Uuid>(2).to_string()),
            Some(row.get::<usize, DateTime<Local>>(3).to_string()),
            row.get(4),
        ]); 

In addition to the original columns, we added reading the audio column and included it in the chatt data returned to the front end.

Save and exit handlers.rs.

Routing for new URLs

For the newly added getaudio() and postaudio() functions, add the following new routes to the Router instantiation of the router variable in main.rs, before the .layer(/*...*/) line:

        .route("/getaudio/", get(handlers::getaudio))
        .route("/postaudio/", post(handlers::postaudio))

Save and exit main.rs. Rebuild and restart chatterd:

server$ cargo build --release
server$ sudo systemctl restart chatterd