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