1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58
|
#include <cgreen/cgreen.h>
#include <stdlib.h>
#include <mysql/mysql.h>
#include "person.h"
static MYSQL *connection;
static void create_schema() {
mysql_query(connection, "create table people (name, varchar(255) unique)");
}
static void drop_schema() {
mysql_query(connection, "drop table people");
}
Ensure(can_add_person_to_database) {
Person *person = create_person();
set_person_name(person, "Fred");
save_person(person);
Person *found = find_person_by_name("Fred");
assert_that(get_person_name(person), is_equal_to_string("Fred"));
}
Ensure(cannot_add_duplicate_person) {
Person *person = create_person();
set_person_name(person, "Fred");
assert_that(save_person(person), is_null);
Person *duplicate = create_person();
set_person_name(duplicate, "Fred");
assert_that(save_person(duplicate), is_null);
}
void open_connection() {
connection = mysql_init(NULL);
mysql_real_connect(connection, "localhost", "me", "secret", "test", 0, NULL, 0);
}
void close_connection() {
mysql_close(connection);
}
TestSuite *person_tests() {
TestSuite *suite = create_test_suite();
set_setup(suite, create_schema);
set_teardown(suite, drop_schema);
add_test(suite, can_add_person_to_database);
add_test(suite, cannot_add_duplicate_person);
TestSuite *fixture = create_named_test_suite("Mysql");
add_suite(fixture, suite);
set_setup(fixture, open_connection);
set_teardown(fixture, close_connection);
return fixture;
}
int main(int argc, char **argv) {
return run_test_suite(person_tests(), create_text_reporter());
}
|