1 /*
2 * Copyright 2008 Google Inc.
3 *
4 * Licensed under the Apache License, Version 2.0 (the "License");
5 * you may not use this file except in compliance with the License.
6 * You may obtain a copy of the License at
7 *
8 * http://www.apache.org/licenses/LICENSE-2.0
9 *
10 * Unless required by applicable law or agreed to in writing, software
11 * distributed under the License is distributed on an "AS IS" BASIS,
12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 * See the License for the specific language governing permissions and
14 * limitations under the License.
15 */
16 #include <stddef.h>
17 #include <stdio.h>
18 #include <database.h>
19 #ifdef _WIN32
20 #define snprintf _snprintf
21 #endif // _WIN32
22
23 // Connect to the database containing customer information.
connect_to_customer_database()24 DatabaseConnection* connect_to_customer_database() {
25 return connect_to_database("customers.abcd.org", 321);
26 }
27
28 /* Find the ID of a customer by his/her name returning a value > 0 if
29 * successful, 0 otherwise. */
get_customer_id_by_name(DatabaseConnection * const connection,const char * const customer_name)30 unsigned int get_customer_id_by_name(
31 DatabaseConnection * const connection,
32 const char * const customer_name) {
33 char query_string[256];
34 int number_of_results;
35 void **results;
36 snprintf(query_string, sizeof(query_string),
37 "SELECT ID FROM CUSTOMERS WHERE NAME = %s", customer_name);
38 number_of_results = connection->query_database(connection, query_string,
39 &results);
40 if (number_of_results != 1) {
41 return -1;
42 }
43 return (unsigned int)results[0];
44 }
45