From 6b73fd9678b5b4570edc3722fda467a82b3c7ccb Mon Sep 17 00:00:00 2001 From: Oliver Smith Date: Wed, 6 Mar 2019 13:49:05 +0100 Subject: db_hlr.c: add db_subscr_exists_by_imsi() Check if a subscriber exists without generating an error log entry if it does not. This is cheaper than db_subscr_get_by_imsi(), as it does not fetch the subscriber entry. subscriber-create-on-demand will use this function. Related: OS#2542 Change-Id: I63818c0dd4fd22b41dadeeba2a07a651b5454c54 --- src/db.c | 1 + 1 file changed, 1 insertion(+) (limited to 'src/db.c') diff --git a/src/db.c b/src/db.c index 770c3a4..9cad263 100644 --- a/src/db.c +++ b/src/db.c @@ -79,6 +79,7 @@ static const char *stmt_sql[] = { " VALUES($subscriber_id, $algo_id_3g, $k, $op, $opc, $ind_bitlen)", [DB_STMT_AUC_3G_DELETE] = "DELETE FROM auc_3g WHERE subscriber_id = $subscriber_id", [DB_STMT_SET_LAST_LU_SEEN] = "UPDATE subscriber SET last_lu_seen = datetime($val, 'unixepoch') WHERE id = $subscriber_id", + [DB_STMT_EXISTS_BY_IMSI] = "SELECT 1 FROM subscriber WHERE imsi = $imsi", }; static void sql3_error_log_cb(void *arg, int err_code, const char *msg) -- cgit v1.2.3