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