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
127
128
|
/*
* Copyright (C) 2010-2012 Jeremy Lainé
* Contact: http://code.google.com/p/qdjango/
*
* This file is part of the QDjango Library.
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library 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
* Lesser General Public License for more details.
*/
#include <QtTest>
#include "QDjangoScript.h"
#include "auth-models.h"
#include "main.h"
#include "script.h"
Q_DECLARE_METATYPE(QDjangoQuerySet<User>)
void TestScript::cleanupTestCase()
{
metaModel.dropTable();
delete engine;
}
void TestScript::initTestCase()
{
metaModel = QDjango::registerModel<User>();
QCOMPARE(metaModel.createTable(), true);
engine = new QScriptEngine(this);
QDjangoScript::registerWhere(engine);
QDjangoScript::registerModel<User>(engine);
}
void TestScript::testWhereConstructor()
{
QScriptValue result;
QDjangoWhere where;
// equals
result = engine->evaluate("Q({'username': 'foobar'})");
where = engine->fromScriptValue<QDjangoWhere>(result);
CHECKWHERE(where, QLatin1String("username = ?"), QVariantList() << "foobar");
// less than
result = engine->evaluate("Q({'username__lt': 'foobar'})");
where = engine->fromScriptValue<QDjangoWhere>(result);
CHECKWHERE(where, QLatin1String("username < ?"), QVariantList() << "foobar");
// less than or equal to
result = engine->evaluate("Q({'username__lte': 'foobar'})");
where = engine->fromScriptValue<QDjangoWhere>(result);
CHECKWHERE(where, QLatin1String("username <= ?"), QVariantList() << "foobar");
// greater than
result = engine->evaluate("Q({'username__gt': 'foobar'})");
where = engine->fromScriptValue<QDjangoWhere>(result);
CHECKWHERE(where, QLatin1String("username > ?"), QVariantList() << "foobar");
// greater than or equal to
result = engine->evaluate("Q({'username__gte': 'foobar'})");
where = engine->fromScriptValue<QDjangoWhere>(result);
CHECKWHERE(where, QLatin1String("username >= ?"), QVariantList() << "foobar");
// starts with
result = engine->evaluate("Q({'username__startswith': 'foobar'})");
where = engine->fromScriptValue<QDjangoWhere>(result);
CHECKWHERE(where, QLatin1String("username LIKE ?"), QVariantList() << "foobar%");
// ends with
result = engine->evaluate("Q({'username__endswith': 'foobar'})");
where = engine->fromScriptValue<QDjangoWhere>(result);
CHECKWHERE(where, QLatin1String("username LIKE ?"), QVariantList() << "%foobar");
// contains
result = engine->evaluate("Q({'username__contains': 'foobar'})");
where = engine->fromScriptValue<QDjangoWhere>(result);
CHECKWHERE(where, QLatin1String("username LIKE ?"), QVariantList() << "%foobar%");
// in
result = engine->evaluate("Q({'username__in': ['foobar', 'wiz']})");
where = engine->fromScriptValue<QDjangoWhere>(result);
CHECKWHERE(where, QLatin1String("username IN (?, ?)"), QVariantList() << "foobar" << "wiz");
// double constructor
result = engine->evaluate("Q(Q({'username': 'foobar'}))");
where = engine->fromScriptValue<QDjangoWhere>(result);
CHECKWHERE(where, QLatin1String("username = ?"), QVariantList() << "foobar");
}
void TestScript::testWhereOperators()
{
QScriptValue result;
QDjangoWhere where;
// AND operator
result = engine->evaluate("Q({'username': 'foobar'}).and(Q({'password': 'foopass'}))");
where = engine->fromScriptValue<QDjangoWhere>(result);
CHECKWHERE(where, QLatin1String("username = ? AND password = ?"), QVariantList() << "foobar" << "foopass");
// OR operator
result = engine->evaluate("Q({'username': 'foobar'}).or(Q({'password': 'foopass'}))");
where = engine->fromScriptValue<QDjangoWhere>(result);
CHECKWHERE(where, QLatin1String("username = ? OR password = ?"), QVariantList() << "foobar" << "foopass");
}
void TestScript::testModel()
{
// create model instance
QScriptValue result = engine->evaluate("user = User();");
User *user = qobject_cast<User*>(result.toQObject());
QVERIFY(user != 0);
// set properties
engine->evaluate("user.username = 'foobar';");
QCOMPARE(user->username(), QLatin1String("foobar"));
}
|
