Editing views.go

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

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

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

chatterDB.Exec(ctx, `INSERT INTO chatts (username, message, audio) VALUES ($1, $2, $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. To the back-end database, the audio data is just a string.

Next, make a copy of your GetChatts() function inside your views.go file and name the copy GetAudio(). Replace the SELECT statement with `SELECT username, message, time, COALESCE(audio, '') FROM chatts ORDER BY time DESC` and replace the two lines in the for rows.Next() {} block with these:

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

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

Save and exit views.go.

Routing for new URLs

For the newly added GetAudio() and PostAudio() functions, add the following new routes to the routes array in router/router.go:

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

Save and exit router.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 views.py

Let’s edit your views.py to handle audio uploads. Make a copy of your postchatt() function inside your views.py file and name the copy postaudio(). Add code to your postaudio() to extract the audio data from the JSON object and insert it into the chatts table, along with the rest of its associated chatt. To the back-end database, the audio data is just a string.

Next, make a copy of your getchatts() function inside your views.py file and name the copy getaudio(). Replace the SELECT statement with 'SELECT username, message, time, audio FROM chatts ORDER BY time DESC;'.

Save and exit views.py.

Routing for new urls

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

    path('getaudio/', views.getaudio, name='getaudio'),
    path('postaudio/', views.postaudio, name='postaudio'),

Save and exit urls.py and restart Gunicorn.

Editing handlers.rs

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

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

Now 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, audio) VALUES ($1, $2, $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. To the back-end database, the audio data is just a string.

Next, make a copy of your getchatts() function inside your handlers.rs file and name the copy getaudio(). In getaudio(),

1. replace the declaration of chattArr to:

   let mut chattArr: Vec<Vec<Option<String>>> = Vec::new();
   

2. replace the SELECT statement with the following: "SELECT username, message, time, audio FROM chatts ORDER BY time DESC". This statement will retrieve all data, including the new audio data from the PostgreSQL database.

3. replace the chattArr.push(/*...*/); line with:

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

   In addition to the original three 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 .with_state(pgpool); 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