#define _POSIX_C_SOURCE 200809L

#include "db.h"
#include <sqlite3.h>
#include <stddef.h>
#include <stdio.h>
#include <stdlib.h>

void db_post_free(struct db_post *const p)
{
    if (!p)
        return;

    free(p->text);
}

int db_post(sqlite3 *const db, sqlite3_stmt *const stmt, struct db_post *const p)
{
    char *text = NULL;
    unsigned long long id, uid, topid;
    long long creat;

    if (db_biguint(db, stmt, "id", &id))
    {
        fprintf(stderr, "%s: failed to get id\n", __func__);
        goto failure;
    }
    else if (db_biguint(db, stmt, "topid", &topid))
    {
        fprintf(stderr, "%s: failed to get topic id\n", __func__);
        goto failure;
    }
    else if (db_biguint(db, stmt, "uid", &uid))
    {
        fprintf(stderr, "%s: failed to user id\n", __func__);
        goto failure;
    }
    else if (db_bigint(db, stmt, "creat", &creat))
    {
        fprintf(stderr, "%s: failed to get creation time\n", __func__);
        goto failure;
    }
    else if (!(text = db_str(db, stmt, "text")))
    {
        fprintf(stderr, "%s: failed to get text\n", __func__);
        goto failure;
    }

    *p = (const struct db_post)
    {
        .topid = topid,
        .creat = creat,
        .text = text,
        .uid = uid,
        .id = id
    };

    return 0;

failure:
    free(text);
    return -1;
}