aboutsummaryrefslogtreecommitdiffstats
path: root/test/base/database.cpp
blob: 72b440940804d5c3ad6cb5c54aef3db0fef39ee5 (plain) (blame)
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
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
/*
 * UltraStar Deluxe - Karaoke Game
 *
 * UltraStar Deluxe is the legal property of its developers, whose names
 * are too numerous to list here. Please refer to the COPYRIGHT
 * file distributed with this source distribution.
 *
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 2
 * of the License, or (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; see the file COPYING. If not, write to
 * the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
 * Boston, MA 02110-1301, USA.
 *
 * $URL$
 * $Id$
 */

#define STAT_DATABASE_TEST

#include "database.hpp"
#include <cppunit/extensions/HelperMacros.h>
#include <ctime>
#include <cstring>

namespace usdx
{
	class StatDatabaseTest : public CppUnit::TestFixture {
		CPPUNIT_TEST_SUITE(StatDatabaseTest);
		CPPUNIT_TEST(testNotNull);
		CPPUNIT_TEST(testGetVersion);
		CPPUNIT_TEST(testSetAndGetVersion);
		CPPUNIT_TEST(testSizeOfTime_t);
		CPPUNIT_TEST(testGetStatReset);
		CPPUNIT_TEST(testFormatDate);
		CPPUNIT_TEST(testTableExists);
		CPPUNIT_TEST(testTableNotExists);
		CPPUNIT_TEST(testTableColumnExists);
		CPPUNIT_TEST(testTableColumnNotExists);
		CPPUNIT_TEST(testTableColumnTableNotExists);
		CPPUNIT_TEST_SUITE_END();
	private:
		StatDatabase *db;
	public:
		void setUp()
		{
			StatDatabase::init("../game/Ultrastar.db");
		}

		void tearDown()
		{
			delete StatDatabase::get_instance();
		}

		void testNotNull()
		{
			CPPUNIT_ASSERT( NULL != StatDatabase::get_instance() );
		}

		void testGetVersion()
		{
			CPPUNIT_ASSERT( 1 == StatDatabase::get_instance()->get_version() );
		}

		void testSetAndGetVersion()
		{
			CPPUNIT_ASSERT( 1 == StatDatabase::get_instance()->get_version() );
			StatDatabase::get_instance()->set_version(0);
			CPPUNIT_ASSERT( 0 == StatDatabase::get_instance()->get_version() );
			StatDatabase::get_instance()->set_version(1);
			CPPUNIT_ASSERT( 1 == StatDatabase::get_instance()->get_version() );
		}

		void testSizeOfTime_t()
		{
			CPPUNIT_ASSERT( sizeof(time_t) == sizeof(long) );
		}

		void testGetStatReset()
		{
			CPPUNIT_ASSERT( 1000000000 < StatDatabase::get_instance()->get_stat_reset() );
		}

		void testFormatDate()
		{
			char buf[9];
			StatDatabase::get_instance()->format_date(buf, 9, 1262433600);
			CPPUNIT_ASSERT( strcmp(buf, "13.02.09") );
		}

		void testTableExists()
		{
			CPPUNIT_ASSERT( true == StatDatabase::get_instance()->sqlite_table_exists("us_songs") );
		}

		void testTableNotExists()
		{
			CPPUNIT_ASSERT( false == StatDatabase::get_instance()->sqlite_table_exists("abc") );
		}

		void testTableColumnExists()
		{
			CPPUNIT_ASSERT( true == StatDatabase::get_instance()->sqlite_table_contains_column("us_songs", "Title") );
		}

		void testTableColumnNotExists()
		{
			CPPUNIT_ASSERT( false == StatDatabase::get_instance()->sqlite_table_contains_column("us_songs", "title") );
		}

		void testTableColumnTableNotExists()
		{
			CPPUNIT_ASSERT( false == StatDatabase::get_instance()->sqlite_table_contains_column("abc", "Title") );
		}
	};

	CPPUNIT_TEST_SUITE_REGISTRATION(StatDatabaseTest);
};