5. High Level Functions

Designed to be used inside Janet scripts.

5.1. Add Page

void weewiki_add_page(weewiki_d *ww,
                      const char *key,
                      const char *val);

void weewiki_add_page(weewiki_d *ww,
                      const char *key,
                      const char *val)
{
    sqlite3 *db;
    sqlite3_stmt *stmt;
    int rc;

    db = ww->db;

    sqlite3_prepare_v2(db,
                       "INSERT INTO wiki"
                       "(key, value)\n"
                       "VALUES(?1, ?2);",
                       -1,
                       &stmt,
                       NULL);
    sqlite3_bind_text(stmt, 1, key, -1, NULL);
    sqlite3_bind_text(stmt, 2, val, -1, NULL);
    rc = sqlite3_step(stmt);

    if (rc != SQLITE_DONE) {
        fprintf(stderr, "Error: %s\n", sqlite3_errmsg(db));
        rc = 1;
    }

    sqlite3_finalize(stmt);
}

5.2. Link Page

void weewiki_add_link(weewiki_d *ww,
                      const char *key,
                      const char *fname);

void weewiki_add_link(weewiki_d *ww,
                      const char *key,
                      const char *fname)
{
    sqlite3 *db;
    sqlite3_stmt *stmt;
    int rc;

    db = ww->db;

    sqlite3_prepare_v2(db,
                       "INSERT INTO wikilinks"
                       "(key, filename)\n"
                       "VALUES(?1, ?2);",
                       -1,
                       &stmt,
                       NULL);
    sqlite3_bind_text(stmt, 1, key, -1, NULL);
    sqlite3_bind_text(stmt, 2, fname, -1, NULL);
    rc = sqlite3_step(stmt);

    if (rc != SQLITE_DONE) {
        fprintf(stderr, "Error: %s\n", sqlite3_errmsg(db));
        rc = 1;
    }

    sqlite3_finalize(stmt);
}

5.3. Sync

int weewiki_sync(weewiki_d *ww);

static void update_mtime(weewiki_d *ww,
                         const char *fname,
                         const char *key)
{
    sqlite3 *db;
    sqlite3_stmt *stmt;
    struct stat st;
    unsigned int mtime;

    db = ww->db;
    sqlite3_prepare_v2(db,
                       "UPDATE wikilinks SET mtime=?1 "
                       "WHERE (key==?2);",
                       -1,
                       &stmt,
                       NULL);

    stat(fname, &st);
    mtime = st.st_mtime;

    sqlite3_bind_int(stmt, 1, mtime);
    sqlite3_bind_text(stmt, 2, key, -1, NULL);

    sqlite3_step(stmt);
    sqlite3_finalize(stmt);
}

static int sync_file(weewiki_d *ww, sqlite3_stmt *stmt)
{
    int rc;
    const char *fname;
    const char *key;
    unsigned int int_mtime;
    unsigned int ext_mtime;
    struct stat st;

    rc = sqlite3_step(stmt);

    if (rc != SQLITE_ROW) return 0;
    key = (const char *)sqlite3_column_text(stmt, 0);
    fname = (const char *)sqlite3_column_text(stmt, 1);
    int_mtime = sqlite3_column_int(stmt, 2);

    if (access(fname, F_OK) == -1) {
        ext_mtime = 0;
    } else {
        stat(fname, &st);
        ext_mtime = st.st_mtime;
    }

    if (int_mtime == ext_mtime) {
        printf("SKIP %s\n", key);
    } else if (ext_mtime > int_mtime) {
        printf("PUSH %s %s\n", fname, key);
        weewiki_push(ww, fname, key);
        update_mtime(ww, fname, key);
    } else if (int_mtime > ext_mtime) {
        printf("PULL %s %s\n", key, fname);
        weewiki_pull(ww, key, fname);
    }

    return 1;
}

int weewiki_sync(weewiki_d *ww)
{
    sqlite3 *db;
    sqlite3_stmt *stmt;
    int rc;

    rc = 0;
    db = ww->db;

    sqlite3_prepare_v2(db,
                       "SELECT key, filename, mtime "
                       "FROM wikilinks;",
                       -1,
                       &stmt,
                       NULL);

    while (1) {
        if (!sync_file(ww, stmt)) {
            break;
        }
    }

    sqlite3_finalize(stmt);
    return rc;
}

5.4. Clear

void weewiki_clear(weewiki_d *ww);

When working with a massive zet, I began noticing that my SQLite database was getting larger and larger, even after I removed all tables. This is because tables are marked for removal, but aren't necessarily removed.

The solution to this is: VACUUM.

void weewiki_clear(weewiki_d *ww)
{
    sqlite3_exec(ww->db, "BEGIN;\n", NULL, NULL, NULL);
    sqlite3_exec(ww->db,
                "DELETE FROM wiki WHERE 1;\n",
                NULL,
                NULL,
                NULL);
    sqlite3_exec(ww->db,
                "DELETE FROM wikilinks WHERE 1;\n",
                NULL,
                NULL,
                NULL);
    sqlite3_exec(ww->db,
                "DELETE FROM wikizet WHERE 1;\n",
                NULL,
                NULL,
                NULL);
    sqlite3_exec(ww->db,
                "VACUUM;\n",
                NULL,
                NULL,
                NULL);
    sqlite3_exec(ww->db, "COMMIT;\n", NULL, NULL, NULL);
}

5.5. Parsing

See the Export section. That's where all the action is happening related to orgparse.

---

prev | home | next