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
129
130
131
132
133
134
135
|
/*****************************************************************************
* This file is a part of QStarDict, a StarDict clone written with using Qt *
* swac.cpp - Plugin for words audio collections SWAC *
* Copyright (C) 2008 Nicolas Vion <nico@picapo.net> *
* *
* 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; if not, write to the Free Software Foundation, Inc., *
* 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. *
*****************************************************************************/
#include "swac.h"
#include <QMessageBox>
#include <QStringList>
#include <QSqlDatabase>
#include <QSqlQuery>
#include <QString>
#include <QVariant>
Swac::Swac(QObject *parent) : QObject(parent)
{
db = new QSqlDatabase();
*db = QSqlDatabase::addDatabase("QSQLITE", QLatin1String("swac"));
db->setDatabaseName(QDir::homePath() + "/.swac/swac.db");
db->open();
}
Swac::~Swac()
{
db->close();
delete db;
QSqlDatabase::removeDatabase("swac");
}
QStringList Swac::availableDicts() const
{
QStringList result;
QSqlQuery query = db->exec("SELECT packid FROM packages;");
while (query.next())
{
result << query.value(0).toString();
}
return result;
}
void Swac::setLoadedDicts(const QStringList &dicts)
{
QStringList available = Swac::availableDicts();
m_loadedDicts.clear();
for (QStringList::const_iterator i = dicts.begin(); i != dicts.end(); ++i)
{
if (available.contains(*i))
m_loadedDicts << *i;
}
}
Swac::DictInfo Swac::dictInfo(const QString &dict)
{
QSqlQuery query = db->exec("SELECT name, format, version, organization, readme FROM packages WHERE packid = \'" + dict + "\' LIMIT 1;");
if (query.first())
return DictInfo(query.value(0).toString(), dict, query.value(3).toString(), "<pre>" + query.value(4).toString() + "</pre>");
else
return DictInfo("", dict, "", "");
}
QSqlQuery Swac::search(const QString &dict, const QString &word, const QString &fields, const int limit) {
QSqlQuery query(*db);
query.prepare(
"SELECT " + fields + " "
+ "FROM alphaidx" + " "
+ "INNER JOIN sounds ON alphaidx.sounds_idx = sounds.idx "
+ "INNER JOIN packages ON sounds.packages_idx = packages.idx "
+ "WHERE packages.packid = ?1 AND alphaidx.str = ?2 "
+ "LIMIT " + QString::number(limit) +";"
);
query.addBindValue(dict);
query.addBindValue(word);
query.exec();
return query;
}
bool Swac::isTranslatable(const QString &dict, const QString &word)
{
QSqlQuery query = search(dict, word, "SWAC_TEXT", 1);
return query.first();
}
Swac::Translation Swac::translate(const QString &dict, const QString &word)
{
QSqlQuery query = search(dict, word, "SWAC_TEXT, packages.path, filename, SWAC_SPEAK_NAME", 128);
QString article("");
int i = 0;
while (query.next())
{
if (i > 0)
article += "<br/>\n";
article += "<img src=':/icons/sound.png'/> <a href=\"" + query.value(1).toString() + query.value(2).toString() + "\">" + query.value(0).toString() + "</a>";
i++;
}
return Translation(word, dict, article);
}
QStringList Swac::findSimilarWords(const QString &dict, const QString &word)
{
return QStringList();
}
int Swac::execSettingsDialog(QWidget *parent)
{
return QMessageBox::information(parent, "SWAC Plugin for QStarDict",
"To install new packages, please, use the <b>swac-get</b> command line program.\n"
"More information about swac-get is available on <a href='http://shtooka.net/'>Shtooka Project Homepage</A>." );
}
#if QT_VERSION < 0x050000
Q_EXPORT_PLUGIN2(swac, Swac)
#endif
// vim: tabstop=4 softtabstop=4 shiftwidth=4 expandtab cindent textwidth=120 formatoptions=tc
|
