2 * Copyright 2008 Google Inc.
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
8 * http://www.apache.org/licenses/LICENSE-2.0
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.
20 #define snprintf _snprintf
23 DatabaseConnection* connect_to_customer_database(void);
24 unsigned int get_customer_id_by_name(
25 DatabaseConnection * const connection,
26 const char * const customer_name);
28 /* Connect to the database containing customer information. */
29 DatabaseConnection* connect_to_customer_database(void) {
30 return connect_to_database("customers.abcd.org", 321);
33 /* Find the ID of a customer by his/her name returning a value > 0 if
34 * successful, 0 otherwise. */
35 unsigned int get_customer_id_by_name(
36 DatabaseConnection * const connection,
37 const char * const customer_name) {
38 char query_string[256];
39 int number_of_results;
41 snprintf(query_string, sizeof(query_string),
42 "SELECT ID FROM CUSTOMERS WHERE NAME = %s", customer_name);
43 number_of_results = connection->query_database(connection, query_string,
46 if (number_of_results != 1) {
50 return (unsigned int)*((int *)results);