diff options
Diffstat (limited to 'src/db.c')
-rw-r--r-- | src/db.c | 10 |
1 files changed, 10 insertions, 0 deletions
@@ -119,6 +119,7 @@ int db_prepare() { "id INTEGER PRIMARY KEY AUTOINCREMENT, " "created TIMESTAMP NOT NULL, " "updated TIMESTAMP NOT NULL, " + "name TEXT, " "imei NUMERIC UNIQUE NOT NULL" ")" ); @@ -219,6 +220,15 @@ struct gsm_subscriber *db_get_subscriber(enum gsm_subscriber_field field, const ); free(quoted); break; + case GSM_SUBSCRIBER_EXTENSION: + dbi_conn_quote_string_copy(conn, id, "ed); + result = dbi_conn_queryf(conn, + "SELECT * FROM Subscriber " + "WHERE extension = %s ", + quoted + ); + free(quoted); + break; default: printf("DB: Unknown query selector for Subscriber.\n"); return NULL; |