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
|
import Qt 4.6
// Models a high score table.
//
// Use this component like this:
//
// HighScoreModel {
// id: highScores
// game: "MyCoolGame"
// }
//
// Then use either use the top-score properties:
//
// Text { text: "HI: " + highScores.topScore }
//
// or, use the model in a view:
//
// ListView {
// model: highScore
// delegate: Component {
// ... player ... score ...
// }
// }
//
// Add new scores via:
//
// saveScore(newScore)
//
// or:
//
// savePlayerScore(playerName,newScore)
//
// The best maxScore scores added by this method will be retained in an SQL database,
// and presented in the model and in the topScore/topPlayer properties.
//
ListModel {
id: model
property string game: ""
property int topScore: 0
property string topPlayer: ""
property int maxScores: 10
Script {
function db()
{
return openDatabaseSync("HighScoreModel", "1.0", "Generic High Score Functionality for QML", 1000000);
}
function ensureTables(tx)
{
tx.executeSql('CREATE TABLE IF NOT EXISTS HighScores(game TEXT, score INT, player TEXT)', []);
}
}
function fillModel() {
db().transaction(
function(tx) {
ensureTables(tx);
var rs = tx.executeSql("SELECT score,player FROM HighScores WHERE game=? ORDER BY score DESC", [game]);
model.clear();
if (rs.rows.length > 0) {
topScore = rs.rows.item(0).score
topPlayer = rs.rows.item(0).player
for (var i=0; i<rs.rows.length; ++i) {
if (i < maxScores)
model.append(rs.rows.item(i))
}
if (rs.rows.length > maxScores)
tx.executeSql("DELETE FROM HighScores WHERE game=? AND score <= ?",
[rs.rows.item(maxScores).score]);
}
}
)
}
function savePlayerScore(player,score) {
db().transaction(
function(tx) {
ensureTables(tx);
tx.executeSql("INSERT INTO HighScores VALUES(?,?,?)", [game,score,player]);
fillModel();
}
)
}
function saveScore(score) {
savePlayerScore("player",score);
}
function clearScores() {
db().transaction(
function(tx) {
tx.executeSql("DELETE FROM HighScores WHERE game=?", [game]);
fillModel();
}
)
}
Component.onCompleted: { fillModel() }
}
|
