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);
};
|
