3 - insert item.c

#include <stdio.h>
#include <stdlib.h>
#include <libpq-fe.h>
#include "settings.h"

int main (int argc, char *argv[])
{
    // Connect to the database.
    PGconn *conn = PQconnectdb("host=" HOSTNAME " dbname=" DATABASE " user=" USERNAME " password=" PASSWORD);

    if (PQstatus(conn) == CONNECTION_BAD) {
        fprintf(stderr, "Connection to database failed: %s\n", PQerrorMessage(conn));
        PQfinish(conn);
        exit(0);
    }

    printf("Connected!\n");

    // Insert new item.
    char *stm = 
        " INSERT INTO example ( "
        "    id,                "
        "    name               "
        " ) VALUES (            "
        "    $1, $2             "
        " );                    ";
    
    int total_items   = 2;
    char *items     []= {
        "1",
        "Test item"
    };

    PGresult *res = PQexecParams(
            conn, stm, total_items, NULL, (const char * const*) items, NULL, NULL, 0);

    if (PQresultStatus(res) != PGRES_COMMAND_OK) {
        fprintf(stderr, "Insert error, %s\n", PQerrorMessage(conn));    
        PQclear(res);
        PQfinish(conn);
        exit(0);
    }

    PQclear(res);
    printf("Item successfully inserted into the database.\n");

    // Close connection.
    PQfinish(conn);
    printf("Disconnected!\n");

    return 0;
}