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); }