52 lines
1.7 KiB
C
52 lines
1.7 KiB
C
|
/*
|
||
|
|
* Copyright 2008 Google Inc.
|
||
|
|
*
|
||
|
|
* Licensed under the Apache License, Version 2.0 (the "License");
|
||
|
|
* you may not use this file except in compliance with the License.
|
||
|
|
* You may obtain a copy of the License at
|
||
|
|
*
|
||
|
|
* http://www.apache.org/licenses/LICENSE-2.0
|
||
|
|
*
|
||
|
|
* Unless required by applicable law or agreed to in writing, software
|
||
|
|
* distributed under the License is distributed on an "AS IS" BASIS,
|
||
|
|
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
|
||
|
|
* See the License for the specific language governing permissions and
|
||
|
|
* limitations under the License.
|
||
|
|
*/
|
||
|
|
#include <stddef.h>
|
||
|
|
#include <stdio.h>
|
||
|
|
#include <database.h>
|
||
|
|
#ifdef _WIN32
|
||
|
|
#define snprintf _snprintf
|
||
|
|
#endif /* _WIN32 */
|
||
|
|
|
||
|
|
DatabaseConnection* connect_to_customer_database(void);
|
||
|
|
unsigned int get_customer_id_by_name(
|
||
|
|
DatabaseConnection * const connection,
|
||
|
|
const char * const customer_name);
|
||
|
|
|
||
|
|
/* Connect to the database containing customer information. */
|
||
|
|
DatabaseConnection* connect_to_customer_database(void) {
|
||
|
|
return connect_to_database("customers.abcd.org", 321);
|
||
|
|
}
|
||
|
|
|
||
|
|
/* Find the ID of a customer by his/her name returning a value > 0 if
|
||
|
|
* successful, 0 otherwise. */
|
||
|
|
unsigned int get_customer_id_by_name(
|
||
|
|
DatabaseConnection * const connection,
|
||
|
|
const char * const customer_name) {
|
||
|
|
char query_string[256];
|
||
|
|
int number_of_results;
|
||
|
|
void **results;
|
||
|
|
snprintf(query_string, sizeof(query_string),
|
||
|
|
"SELECT ID FROM CUSTOMERS WHERE NAME = %s", customer_name);
|
||
|
|
number_of_results = connection->query_database(connection, query_string,
|
||
|
|
&results);
|
||
|
|
|
||
|
|
if (number_of_results != 1) {
|
||
|
|
return -1;
|
||
|
|
}
|
||
|
|
|
||
|
|
return (unsigned int)*((int *)results);
|
||
|
|
}
|