Module: sip-router Branch: master Commit: f0af7250822a80ed55f41216e84f1a3481413655 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f0af725… Author: Alex Hermann &lt;alex(a)speakup.nl&gt; Committer: Alex Hermann &lt;alex(a)speakup.nl&gt; Date: Thu Jul 28 16:39:17 2011 +0200 modules_k/htable: Only save/load not yet expired entries to/from database. --- modules_k/htable/ht_db.c | 33 ++++++++++++++++++++++++--------- 1 files changed, 24 insertions(+), 9 deletions(-) diff --git a/modules_k/htable/ht_db.c b/modules_k/htable/ht_db.c index 5785ecf..2a349c3 100644 --- a/modules_k/htable/ht_db.c +++ b/modules_k/htable/ht_db.c @@ -140,6 +140,7 @@ int ht_db_load_table(ht_t *ht, str *dbtable, int mode) int i; int ret; int cnt; + int now; if(ht_db_con==NULL) { @@ -195,10 +196,10 @@ int ht_db_load_table(ht_t *ht, str *dbtable, int mode) pname.s = ""; n = 0; last_ktype = 0; + now = (int)time(NULL); do { for(i=0; i<RES_ROW_N(db_res); i++) { - cnt++; /* not NULL values enforced in table definition ?!?! */ kname.s = (char*)(RES_ROWS(db_res)[i].values[0].val.string_val); if(kname.s==NULL) { @@ -206,6 +207,14 @@ int ht_db_load_table(ht_t *ht, str *dbtable, int mode) goto error; } kname.len = strlen(kname.s); + + expires.n = RES_ROWS(db_res)[i].values[4].val.int_val; + if (expires.n > 0 && expires.n < now) { + LM_DBG("skipping expired entry [%.*s] (%d)\n", kname.len, kname.s, expires.n-now); + continue; + } + + cnt++; ktype = RES_ROWS(db_res)[i].values[1].val.int_val; if(last_ktype==1) { @@ -264,14 +273,11 @@ int ht_db_load_table(ht_t *ht, str *dbtable, int mode) } /* set expiry */ - if (ht->htexpire > 0) { - expires.n = RES_ROWS(db_res)[i].values[4].val.int_val; - if (expires.n > 0) { - expires.n -= now; - if(ht_set_cell_expire(ht, &hname, 0, &expires)) { - LM_ERR("error setting expires to hash entry [%*.s]\n", hname.len, hname.s); - goto error; - } + if (ht->htexpire > 0 && expires.n > 0) { + expires.n -= now; + if(ht_set_cell_expire(ht, &hname, 0, &expires)) { + LM_ERR("error setting expires to hash entry [%*.s]\n", hname.len, hname.s); + goto error; } } } @@ -321,6 +327,7 @@ int ht_db_save_table(ht_t *ht, str *dbtable) ht_cell_t *it; str tmp; int i; + time_t now; if(ht_db_con==NULL) { @@ -337,6 +344,8 @@ int ht_db_save_table(ht_t *ht, str *dbtable) LM_DBG("save the content of hash table [%.*s] to database in [%.*s]\n", ht->name.len, ht->name.s, dbtable->len, dbtable->s); + now = time(NULL); + for(i=0; i<ht->htsize; i++) { lock_get(&ht->entries[i].lock); @@ -351,6 +360,12 @@ int ht_db_save_table(ht_t *ht, str *dbtable) it->name.len, it->name.s, it->value.n); } + if (it->expire <= now) { + LM_DBG("skipping expired entry"); + it = it->next; + continue; + } + db_vals[0].type = DB1_STR; db_vals[0].nul = 0; db_vals[0].val.str_val.s = it->name.s;