static int db_count_replycache(timestring_t lasttokeep, u64_t *rows)
{
C c; R r; volatile int t = FALSE;
field_t to_date_str;
assert(rows != NULL);
*rows = 0;
char2date_str(lasttokeep, &to_date_str);
c = db_con_get();
TRY
r = db_query(c, "SELECT COUNT(*) FROM %sreplycache WHERE lastseen < %s", DBPFX, to_date_str);
if (db_result_next(r))
*rows = db_result_get_u64(r,0);
CATCH(SQLException)
LOG_SQLERROR;
t = DM_EQUERY;
FINALLY
db_con_close(c);
END_TRY;
return t;
}
static int db_count_iplog(TimeString_T lasttokeep, uint64_t *rows)
{
Connection_T c; ResultSet_T r; volatile int t = DM_SUCCESS;
Field_T to_date_str;
assert(rows != NULL);
*rows = 0;
char2date_str(lasttokeep, &to_date_str);
c = db_con_get();
TRY
r = db_query(c, "SELECT COUNT(*) FROM %spbsp WHERE since < %s", DBPFX, to_date_str);
if (db_result_next(r))
*rows = db_result_get_u64(r,0);
CATCH(SQLException)
LOG_SQLERROR;
t = DM_EQUERY;
FINALLY
db_con_close(c);
END_TRY;
return t;
}
static int db_cleanup_replycache(timestring_t lasttokeep)
{
field_t to_date_str;
char2date_str(lasttokeep, &to_date_str);
return db_update("DELETE FROM %sreplycache WHERE lastseen < %s", DBPFX, to_date_str);
}
static int db_cleanup_iplog(timestring_t lasttokeep)
{
field_t to_date_str;
char2date_str(lasttokeep, &to_date_str);
return db_update("DELETE FROM %spbsp WHERE since < %s", DBPFX, to_date_str);
}
