Function kvGet

sqlite_wrap.c:263–277

Get the specified key and return it as an SDS string. If the value is * expired or does not exist NULL is returned. */

/* Get the specified key and return it as an SDS string. If the value is
 * expired or does not exist NULL is returned. */
sds kvGet(sqlite3 *dbhandle,const char *key) {
    sds value = NULL;
    sqlRow row;
    sqlSelect(dbhandle,&row,"SELECT expire,value FROM KeyValue WHERE key=?s",key);
    if (sqlNextRow(&row)) {
        int64_t expire = row.col[0].i;
        if (expire && expire < time(NULL)) {
            sqlQuery(dbhandle,"DELETE FROM KeyValue WHERE key=?s",key);
        } else {
            value = sdsnewlen(row.col[1].s,row.col[1].i);
        }
    }
    sqlEnd(&row);
    return value;
}

/* Delete the key if it exists. */
void kvDel(sqlite3 *dbhandle, const char *key) {