diff options
author | Vadim Yanitskiy <axilirator@gmail.com> | 2019-03-30 17:03:42 +0700 |
---|---|---|
committer | Oliver Smith <osmith@sysmocom.de> | 2019-05-13 08:55:24 +0200 |
commit | c13599dc696fcab64219eba99afd0a2da9d0eec5 (patch) | |
tree | 9c8ac1ff6ecc794cc7dc0e82a71e2ca90738099e /src/db.c | |
parent | 6b73fd9678b5b4570edc3722fda467a82b3c7ccb (diff) |
db_hlr.c: add db_subscr_exists_by_msisdn()
Check if a subscriber exists without generating an error log entry if
it does not. This is cheaper than db_subscr_get_by_msisdn(), as it
does not fetch the subscriber entry.
subscriber-create-on-demand will use this function to generate
a random unique MSISDN for new subscribers.
Related: OS#2542
Change-Id: Ibfbc408c966197682ba2b12d166ade4bfeb7abc2
Diffstat (limited to 'src/db.c')
-rw-r--r-- | src/db.c | 1 |
1 files changed, 1 insertions, 0 deletions
@@ -80,6 +80,7 @@ static const char *stmt_sql[] = { [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", + [DB_STMT_EXISTS_BY_MSISDN] = "SELECT 1 FROM subscriber WHERE msisdn = $msisdn", }; static void sql3_error_log_cb(void *arg, int err_code, const char *msg) |