void TrackerContentModule::sequencedStart()
{
QString query = getQueryText();
PERF_EVENT("before_query %d", service_->query_id_counter);
tracker_access_->startQuery(query);
connect(tracker_access_.data(), SIGNAL(queryCompleted()), SLOT(queryCompleted()));
query_id_ = service_->query_id_counter++;
debug(2, service_.data()) << "modeling query (id =" << query_id_ << "):\n"
<< query << "\n";
}
void DbObjectDdlViewer::ddlQueryCompleted(const QueryResult &result)
{
if(result.hasError){
if(result.exception.getErrorCode()==31603){
multiEditor->setInitialText(tr("--Object does not exist or you do not have permission to view it."));
}else{
QMessageBox::critical(this->window(), tr("Error retrieving table DDL"), result.exception.getErrorMessage());
}
queryCompleted();
}
}
void DbObjectDdlViewer::fetchCompleted(const QString &)
{
queryCompleted();
}
void ZealDocsetsRegistry::_runQuery(const QString& rawQuery, int queryNum)
{
if(queryNum != lastQuery) return; // some other queries pending - ignore this one
QList<ZealSearchResult> results;
ZealSearchQuery query(rawQuery);
QString preparedQuery = query.getSanitizedQuery();
bool hasDocsetFilter = query.hasDocsetFilter();
for (const ZealDocsetsRegistry::docsetEntry docset : docsets()) {
if(hasDocsetFilter && !query.docsetPrefixMatch(docset.prefix)) {
// Filter out this docset as the names don't match the docset prefix
continue;
}
QString qstr;
QSqlQuery q;
QList<QList<QVariant> > found;
bool withSubStrings = false;
// %.%1% for long Django docset values like django.utils.http
// %::%1% for long C++ docset values like std::set
// %/%1% for long Go docset values like archive/tar
QString subNames = QString(" or %1 like '%.%2%' escape '\\'");
subNames += QString(" or %1 like '%::%2%' escape '\\'");
subNames += QString(" or %1 like '%/%2%' escape '\\'");
while(found.size() < 100) {
auto curQuery = preparedQuery;
QString notQuery; // don't return the same result twice
QString parentQuery;
if(withSubStrings) {
// if less than 100 found starting with query, search all substrings
curQuery = "%"+preparedQuery;
// don't return 'starting with' results twice
if(docset.type == ZDASH) {
notQuery = QString(" and not (ztokenname like '%1%' escape '\\' %2) ").arg(preparedQuery, subNames.arg("ztokenname", preparedQuery));
} else {
if(docset.type == ZEAL) {
notQuery = QString(" and not (t.name like '%1%' escape '\\') ").arg(preparedQuery);
parentQuery = QString(" or t2.name like '%1%' escape '\\' ").arg(preparedQuery);
} else { // DASH
notQuery = QString(" and not (t.name like '%1%' escape '\\' %2) ").arg(preparedQuery, subNames.arg("t.name", preparedQuery));
}
}
}
int cols = 3;
if(docset.type == ZEAL) {
qstr = QString("select t.name, t2.name, t.path from things t left join things t2 on t2.id=t.parent where "
"(t.name like '%1%' escape '\\' %3) %2 order by length(t.name), lower(t.name) asc, t.path asc limit 100").arg(curQuery, notQuery, parentQuery);
} else if(docset.type == DASH) {
qstr = QString("select t.name, null, t.path from searchIndex t where (t.name "
"like '%1%' escape '\\' %3) %2 order by length(t.name), lower(t.name) asc, t.path asc limit 100").arg(curQuery, notQuery, subNames.arg("t.name", curQuery));
} else if(docset.type == ZDASH) {
cols = 4;
qstr = QString("select ztokenname, null, zpath, zanchor from ztoken "
"join ztokenmetainformation on ztoken.zmetainformation = ztokenmetainformation.z_pk "
"join zfilepath on ztokenmetainformation.zfile = zfilepath.z_pk where (ztokenname "
"like '%1%' escape '\\' %3) %2 order by length(ztokenname), lower(ztokenname) asc, zpath asc, "
"zanchor asc limit 100").arg(curQuery, notQuery, subNames.arg("ztokenname", curQuery));
}
q = db(docset.name).exec(qstr);
while(q.next()) {
QList<QVariant> values;
for(int i = 0; i < cols; ++i) {
values.append(q.value(i));
}
found.append(values);
}
if(withSubStrings) break;
withSubStrings = true; // try again searching for substrings
}
for(auto &row : found) {
QString parentName;
if(!row[1].isNull()) {
parentName = row[1].toString();
}
auto path = row[2].toString();
// FIXME: refactoring to use common code in ZealListModel and ZealDocsetsRegistry
if(docset.type == ZDASH) {
path += "#" + row[3].toString();
}
auto itemName = row[0].toString();
normalizeName(itemName, parentName, row[1].toString());
results.append(ZealSearchResult(itemName, parentName, path, docset.name, preparedQuery));
}
}
qSort(results);
if(queryNum != lastQuery) return; // some other queries pending - ignore this one
queryResults = results;
emit queryCompleted();
}
void ZealDocsetsRegistry::_runQuery(const QString& rawQuery, int queryNum)
{
if(queryNum != lastQuery) return; // some other queries pending - ignore this one
QList<ZealSearchResult> results;
ZealSearchQuery query(rawQuery);
QString docsetPrefix = query.getDocsetFilter();
QString preparedQuery = query.getSanitizedQuery();
bool hasPrefixFilter = !docsetPrefix.isEmpty();
for (const QString &name : names()) {
if (hasPrefixFilter && !name.contains(docsetPrefix, Qt::CaseInsensitive)) {
// Filter out this docset as the names don't match the docset prefix
continue;
}
QString qstr;
QSqlQuery q;
QList<QList<QVariant> > found;
bool withSubStrings = false;
// %.%1% for long Django docset values like django.utils.http
// %::%1% for long C++ docset values like std::set
// %/%1% for long Go docset values like archive/tar
QString subNames = QString(" or %1 like '%.%2%' escape '\\'");
subNames += QString(" or %1 like '%::%2%' escape '\\'");
subNames += QString(" or %1 like '%/%2%' escape '\\'");
while(found.size() < 100) {
auto curQuery = preparedQuery;
QString notQuery; // don't return the same result twice
QString parentQuery;
if(withSubStrings) {
// if less than 100 found starting with query, search all substrings
curQuery = "%"+preparedQuery;
// don't return 'starting with' results twice
if(types[name] == ZDASH) {
notQuery = QString(" and not (ztokenname like '%1%' escape '\\' %2) ").arg(preparedQuery, subNames.arg("ztokenname", preparedQuery));
} else {
if(types[name] == ZEAL) {
notQuery = QString(" and not (t.name like '%1%' escape '\\') ").arg(preparedQuery);
parentQuery = QString(" or t2.name like '%1%' escape '\\' ").arg(preparedQuery);
} else { // DASH
notQuery = QString(" and not (t.name like '%1%' escape '\\' %2) ").arg(preparedQuery, subNames.arg("t.name", preparedQuery));
}
}
}
int cols = 3;
if(types[name] == ZEAL) {
qstr = QString("select t.name, t2.name, t.path from things t left join things t2 on t2.id=t.parent where "
"(t.name like '%1%' escape '\\' %3) %2 order by lower(t.name) asc, t.path asc limit 100").arg(curQuery, notQuery, parentQuery);
} else if(types[name] == DASH) {
qstr = QString("select t.name, null, t.path from searchIndex t where (t.name "
"like '%1%' escape '\\' %3) %2 order by lower(t.name) asc, t.path asc limit 100").arg(curQuery, notQuery, subNames.arg("t.name", curQuery));
} else if(types[name] == ZDASH) {
cols = 4;
qstr = QString("select ztokenname, null, zpath, zanchor from ztoken "
"join ztokenmetainformation on ztoken.zmetainformation = ztokenmetainformation.z_pk "
"join zfilepath on ztokenmetainformation.zfile = zfilepath.z_pk where (ztokenname "
"like '%1%' escape '\\' %3) %2 order by lower(ztokenname) asc, zpath asc, "
"zanchor asc limit 100").arg(curQuery, notQuery, subNames.arg("ztokenname", curQuery));
}
q = db(name).exec(qstr);
while(q.next()) {
QList<QVariant> values;
for(int i = 0; i < cols; ++i) {
values.append(q.value(i));
}
found.append(values);
}
if(withSubStrings) break;
withSubStrings = true; // try again searching for substrings
}
for(auto &row : found) {
QString parentName;
if(!row[1].isNull()) {
parentName = row[1].toString();
}
auto path = row[2].toString();
// FIXME: refactoring to use common code in ZealListModel and ZealDocsetsRegistry
if(types[name] == DASH || types[name] == ZDASH) {
path = QDir(QDir(QDir("Contents").filePath("Resources")).filePath("Documents")).filePath(path);
}
if(types[name] == ZDASH) {
path += "#" + row[3].toString();
}
auto itemName = row[0].toString();
QString separators[] = {".", "::", "/"};
for(unsigned i = 0; i < sizeof separators / sizeof *separators; ++i) {
QString sep = separators[i];
if(itemName.indexOf(sep) != -1 && itemName.indexOf(sep) != 0 && row[1].isNull()) {
auto splitted = itemName.split(sep);
itemName = splitted.at(splitted.size()-1);
parentName = splitted.at(splitted.size()-2);
}
}
results.append(ZealSearchResult(itemName, parentName, path, name, preparedQuery));
}
}
qSort(results);
if(queryNum != lastQuery) return; // some other queries pending - ignore this one
queryResults = results;
emit queryCompleted();
}
