commit 9c564b85e65623ab99a3c3ba7c490740592bd149
author Holger Freyther <zecke@selfish.org> Mon Feb 09 23:39:20 2009 +0000
committer Holger Freyther <zecke@selfish.org> Mon Feb 09 23:39:20 2009 +0000
tree 0b5323b103d82e5962b5844b7dfa02f38c7debc8
parent cbc7b065345d41e077069bcee1519b8557f70fed

introduce lookup of subscribers based on their extension number

src/db.c

diff --git a/src/db.c b/src/db.c
index 50459cf..b538d5d 100644
--- a/src/db.c
+++ b/src/db.c
@@ -119,6 +119,7 @@
 		"id INTEGER PRIMARY KEY AUTOINCREMENT, "
 		"created TIMESTAMP NOT NULL, "
 		"updated TIMESTAMP NOT NULL, "
+		"name TEXT, "
 		"imei NUMERIC UNIQUE NOT NULL"
 		")"
 	);
@@ -219,6 +220,15 @@
 		);
 		free(quoted);
 		break;
+	case GSM_SUBSCRIBER_EXTENSION:
+		dbi_conn_quote_string_copy(conn, id, &quoted);
+		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;