Attachment #889 for bug #1262

By default, Bugzilla does not search the list of RESOLVED bugs.
You can force it to do so by putting the upper-case word ALL in front of your search query, e.g.: ALL tdelibs
We recommend searching for bugs this way, as you may discover that your bug has already been resolved and fixed in a later release. View | Details | Raw Unified | Return to bug 1262
Collapse All | Expand All




            TQDataBase db = TQSqlDatabase::addDatabase(SQLTYPE,_key);
            db->setDatabaseName(m_BasePath+"/maindb.db");
            if (!db->open()) {
                qWarning("%s", (TQString("Failed to open main database: " + db->lastError().text())).ascii());
            } else {
                m_mainDB.setLocalData(new ThreadDBStore);
                m_mainDB.localData()->key = _key;

#endif
    TQDataBase mainDB = m_CacheData->getMainDB();
    if (!mainDB || !mainDB->open()) {
        qWarning("%s", ("Failed to open main database: " + (mainDB?mainDB->lastError().text():"No database object.")).ascii());
    } else {
        TQSqlQuery q(TQString(), mainDB);
        mainDB->transaction();
        if (!q.exec("CREATE TABLE IF NOT EXISTS \""+TQString(SQLMAINTABLE)+"\" (\"reposroot\" TEXT,\"id\" INTEGER PRIMARY KEY NOT NULL);")) {
            qWarning("%s", ("Failed create main database: " + mainDB->lastError().text()).ascii());
        }
        mainDB->commit();
    }

    TQSqlQuery cur(TQString(),mainDB);
    cur.prepare(s_q);
    if (!cur.exec()) {
        qDebug("%s", (TQString(cur.lastError().text().TOUTF8().data())).ascii());
        throw svn::cache::DatabaseException(TQString("Could not retrieve values: ")+cur.lastError().text());
        return _res;
    }




    TQString q("select revision from 'logentries' order by revision DESC limit 1");
    TQSqlQuery _q(TQString(), m_Database);
    if (!_q.exec(q)) {
        qDebug("%s", (TQString(_q.lastError().text().TOUTF8().data())).ascii());
        return svn::Revision::UNDEFINED;
    }
    int _r;

        //qDebug("Sel result: %s",_q.value(0).toString().TOUTF8().data());
        _r = _q.value(0).toInt();
    } else {
        qDebug("%s", (TQString(_q.lastError().text().TOUTF8().data())).ascii());
        return svn::Revision::UNDEFINED;
    }
    return _r;

    bcount.bindValue(0,TQ_LLONG(end.revnum()));
    bcount.bindValue(1,TQ_LLONG(start.revnum()));
    if (!bcount.exec()) {
        qDebug("%s", (TQString(bcount.lastError().text().TOUTF8().data())).ascii());
        throw svn::cache::DatabaseException(TQString("Could not retrieve count: ")+bcount.lastError().text());
        return false;
    }

    bcur.bindValue(1,TQ_LLONG(start.revnum()));

    if (!bcur.exec()) {
        qDebug("%s", (TQString(bcur.lastError().text().TOUTF8().data())).ascii());
        throw svn::cache::DatabaseException(TQString("Could not retrieve values: ")+bcur.lastError().text());
        return false;
    }

        revision = bcur.value(0).toLongLong();
        cur.bindValue(0,revision);
        if (!cur.exec()) {
            qDebug("%s", (TQString(cur.lastError().text().TOUTF8().data())).ascii());
            throw svn::cache::DatabaseException(TQString("Could not retrieve values: ")+cur.lastError().text()
                    ,cur.lastError().number());
            return false;

    TQSqlQuery query("select revision,date from logentries order by revision desc limit 1",m_Database);

    if (query.lastError().type()!=TQSqlError::None) {
        qDebug("%s", (TQString(query.lastError().text().TOUTF8().data())).ascii());
    }
    bool must_remote=!noNetwork;
    if (query.next()) {

    query.bindValue(0,TQ_LLONG(aRev.date()));
    query.exec();
    if (query.lastError().type()!=TQSqlError::None) {
        qDebug("%s", (TQString(query.lastError().text().TOUTF8().data())).ascii());
    }
    if (query.next()) {
        return query.value(0).toInt();

    if (!_q.exec()) {
        m_Database->rollback();
        qDebug("Could not insert values: %s",_q.lastError().text().TOUTF8().data());
        qDebug("%s", (TQString(_q.lastQuery().TOUTF8().data())).ascii());
        throw svn::cache::DatabaseException(TQString("Could not insert values: ")+_q.lastError().text(),_q.lastError().number());
    }
    _q.prepare(qPathes);

        if (!_q.exec()) {
            m_Database->rollback();
            qDebug("Could not insert values: %s",_q.lastError().text().TOUTF8().data());
            qDebug("%s", (TQString(_q.lastQuery().TOUTF8().data())).ascii());
            throw svn::cache::DatabaseException(TQString("Could not insert values: ")+_q.lastError().text(),_q.lastError().number());
        }
    }

    _q.prepare(query_string);
    if (!_q.exec()) {
        qDebug("Could not select values: %s",_q.lastError().text().TOUTF8().data());
        qDebug("%s", (TQString(_q.lastQuery().TOUTF8().data())).ascii());
        throw svn::cache::DatabaseException(TQString("Could not select values: ")+_q.lastError().text(),_q.lastError().number());
    }
    while(_q.next()) {

Return to bug 1262

Lines 187-193 Link Here

(-)kdesvn/src/svnqt/cache/LogCache.cpp.stringliteral (-4 / +4 lines)
187	TQDataBase db = TQSqlDatabase::addDatabase(SQLTYPE,_key);	187	TQDataBase db = TQSqlDatabase::addDatabase(SQLTYPE,_key);
188	db->setDatabaseName(m_BasePath+"/maindb.db");	188	db->setDatabaseName(m_BasePath+"/maindb.db");
189	if (!db->open()) {	189	if (!db->open()) {
190	qWarning("Failed to open main database: " + db->lastError().text());	190	qWarning("%s", (TQString("Failed to open main database: " + db->lastError().text())).ascii());
191	} else {	191	} else {
192	m_mainDB.setLocalData(new ThreadDBStore);	192	m_mainDB.setLocalData(new ThreadDBStore);
193	m_mainDB.localData()->key = _key;	193	m_mainDB.localData()->key = _key;
Lines 269-280 Link Here
269	#endif	269	#endif
270	TQDataBase mainDB = m_CacheData->getMainDB();	270	TQDataBase mainDB = m_CacheData->getMainDB();
271	if (!mainDB \|\| !mainDB->open()) {	271	if (!mainDB \|\| !mainDB->open()) {
272	qWarning("Failed to open main database: " + (mainDB?mainDB->lastError().text():"No database object."));	272	qWarning("%s", ("Failed to open main database: " + (mainDB?mainDB->lastError().text():"No database object.")).ascii());
273	} else {	273	} else {
274	TQSqlQuery q(TQString(), mainDB);	274	TQSqlQuery q(TQString(), mainDB);
275	mainDB->transaction();	275	mainDB->transaction();
276	if (!q.exec("CREATE TABLE IF NOT EXISTS \""+TQString(SQLMAINTABLE)+"\" (\"reposroot\" TEXT,\"id\" INTEGER PRIMARY KEY NOT NULL);")) {	276	if (!q.exec("CREATE TABLE IF NOT EXISTS \""+TQString(SQLMAINTABLE)+"\" (\"reposroot\" TEXT,\"id\" INTEGER PRIMARY KEY NOT NULL);")) {
277	qWarning("Failed create main database: " + mainDB->lastError().text());	277	qWarning("%s", ("Failed create main database: " + mainDB->lastError().text()).ascii());
278	}	278	}
279	mainDB->commit();	279	mainDB->commit();
280	}	280	}
Lines 321-327 Link Here
321	TQSqlQuery cur(TQString(),mainDB);	321	TQSqlQuery cur(TQString(),mainDB);
322	cur.prepare(s_q);	322	cur.prepare(s_q);
323	if (!cur.exec()) {	323	if (!cur.exec()) {
324	qDebug(cur.lastError().text().TOUTF8().data());	324	qDebug("%s", (TQString(cur.lastError().text().TOUTF8().data())).ascii());
325	throw svn::cache::DatabaseException(TQString("Could not retrieve values: ")+cur.lastError().text());	325	throw svn::cache::DatabaseException(TQString("Could not retrieve values: ")+cur.lastError().text());
326	return _res;	326	return _res;
327	}	327	}

Lines 68-74 Link Here

(-)kdesvn/src/svnqt/cache/ReposLog.cpp.ORI (-10 / +10 lines)
68	TQString q("select revision from 'logentries' order by revision DESC limit 1");	68	TQString q("select revision from 'logentries' order by revision DESC limit 1");
69	TQSqlQuery _q(TQString(), m_Database);	69	TQSqlQuery _q(TQString(), m_Database);
70	if (!_q.exec(q)) {	70	if (!_q.exec(q)) {
71	qDebug(_q.lastError().text().TOUTF8().data());	71	qDebug("%s", (TQString(_q.lastError().text().TOUTF8().data())).ascii());
72	return svn::Revision::UNDEFINED;	72	return svn::Revision::UNDEFINED;
73	}	73	}
74	int _r;	74	int _r;
Lines 76-82 Link Here
76	//qDebug("Sel result: %s",_q.value(0).toString().TOUTF8().data());	76	//qDebug("Sel result: %s",_q.value(0).toString().TOUTF8().data());
77	_r = _q.value(0).toInt();	77	_r = _q.value(0).toInt();
78	} else {	78	} else {
79	qDebug(_q.lastError().text().TOUTF8().data());	79	qDebug("%s", (TQString(_q.lastError().text().TOUTF8().data())).ascii());
80	return svn::Revision::UNDEFINED;	80	return svn::Revision::UNDEFINED;
81	}	81	}
82	return _r;	82	return _r;
Lines 197-203 Link Here
197	bcount.bindValue(0,TQ_LLONG(end.revnum()));	197	bcount.bindValue(0,TQ_LLONG(end.revnum()));
198	bcount.bindValue(1,TQ_LLONG(start.revnum()));	198	bcount.bindValue(1,TQ_LLONG(start.revnum()));
199	if (!bcount.exec()) {	199	if (!bcount.exec()) {
200	qDebug(bcount.lastError().text().TOUTF8().data());	200	qDebug("%s", (TQString(bcount.lastError().text().TOUTF8().data())).ascii());
201	throw svn::cache::DatabaseException(TQString("Could not retrieve count: ")+bcount.lastError().text());	201	throw svn::cache::DatabaseException(TQString("Could not retrieve count: ")+bcount.lastError().text());
202	return false;	202	return false;
203	}	203	}
Lines 211-217 Link Here
211	bcur.bindValue(1,TQ_LLONG(start.revnum()));	211	bcur.bindValue(1,TQ_LLONG(start.revnum()));
212		212
213	if (!bcur.exec()) {	213	if (!bcur.exec()) {
214	qDebug(bcur.lastError().text().TOUTF8().data());	214	qDebug("%s", (TQString(bcur.lastError().text().TOUTF8().data())).ascii());
215	throw svn::cache::DatabaseException(TQString("Could not retrieve values: ")+bcur.lastError().text());	215	throw svn::cache::DatabaseException(TQString("Could not retrieve values: ")+bcur.lastError().text());
216	return false;	216	return false;
217	}	217	}
Lines 220-226 Link Here
220	revision = bcur.value(0).toLongLong();	220	revision = bcur.value(0).toLongLong();
221	cur.bindValue(0,revision);	221	cur.bindValue(0,revision);
222	if (!cur.exec()) {	222	if (!cur.exec()) {
223	qDebug(cur.lastError().text().TOUTF8().data());	223	qDebug("%s", (TQString(cur.lastError().text().TOUTF8().data())).ascii());
224	throw svn::cache::DatabaseException(TQString("Could not retrieve values: ")+cur.lastError().text()	224	throw svn::cache::DatabaseException(TQString("Could not retrieve values: ")+cur.lastError().text()
225	,cur.lastError().number());	225	,cur.lastError().number());
226	return false;	226	return false;
Lines 264-270 Link Here
264	TQSqlQuery query("select revision,date from logentries order by revision desc limit 1",m_Database);	264	TQSqlQuery query("select revision,date from logentries order by revision desc limit 1",m_Database);
265		265
266	if (query.lastError().type()!=TQSqlError::None) {	266	if (query.lastError().type()!=TQSqlError::None) {
267	qDebug(query.lastError().text().TOUTF8().data());	267	qDebug("%s", (TQString(query.lastError().text().TOUTF8().data())).ascii());
268	}	268	}
269	bool must_remote=!noNetwork;	269	bool must_remote=!noNetwork;
270	if (query.next()) {	270	if (query.next()) {
Lines 283-289 Link Here
283	query.bindValue(0,TQ_LLONG(aRev.date()));	283	query.bindValue(0,TQ_LLONG(aRev.date()));
284	query.exec();	284	query.exec();
285	if (query.lastError().type()!=TQSqlError::None) {	285	if (query.lastError().type()!=TQSqlError::None) {
286	qDebug(query.lastError().text().TOUTF8().data());	286	qDebug("%s", (TQString(query.lastError().text().TOUTF8().data())).ascii());
287	}	287	}
288	if (query.next()) {	288	if (query.next()) {
289	return query.value(0).toInt();	289	return query.value(0).toInt();
Lines 320-326 Link Here
320	if (!_q.exec()) {	320	if (!_q.exec()) {
321	m_Database->rollback();	321	m_Database->rollback();
322	qDebug("Could not insert values: %s",_q.lastError().text().TOUTF8().data());	322	qDebug("Could not insert values: %s",_q.lastError().text().TOUTF8().data());
323	qDebug(_q.lastQuery().TOUTF8().data());	323	qDebug("%s", (TQString(_q.lastQuery().TOUTF8().data())).ascii());
324	throw svn::cache::DatabaseException(TQString("Could not insert values: ")+_q.lastError().text(),_q.lastError().number());	324	throw svn::cache::DatabaseException(TQString("Could not insert values: ")+_q.lastError().text(),_q.lastError().number());
325	}	325	}
326	_q.prepare(qPathes);	326	_q.prepare(qPathes);
Lines 334-340 Link Here
334	if (!_q.exec()) {	334	if (!_q.exec()) {
335	m_Database->rollback();	335	m_Database->rollback();
336	qDebug("Could not insert values: %s",_q.lastError().text().TOUTF8().data());	336	qDebug("Could not insert values: %s",_q.lastError().text().TOUTF8().data());
337	qDebug(_q.lastQuery().TOUTF8().data());	337	qDebug("%s", (TQString(_q.lastQuery().TOUTF8().data())).ascii());
338	throw svn::cache::DatabaseException(TQString("Could not insert values: ")+_q.lastError().text(),_q.lastError().number());	338	throw svn::cache::DatabaseException(TQString("Could not insert values: ")+_q.lastError().text(),_q.lastError().number());
339	}	339	}
340	}	340	}
Lines 375-381 Link Here
375	_q.prepare(query_string);	375	_q.prepare(query_string);
376	if (!_q.exec()) {	376	if (!_q.exec()) {
377	qDebug("Could not select values: %s",_q.lastError().text().TOUTF8().data());	377	qDebug("Could not select values: %s",_q.lastError().text().TOUTF8().data());
378	qDebug(_q.lastQuery().TOUTF8().data());	378	qDebug("%s", (TQString(_q.lastQuery().TOUTF8().data())).ascii());
379	throw svn::cache::DatabaseException(TQString("Could not select values: ")+_q.lastError().text(),_q.lastError().number());	379	throw svn::cache::DatabaseException(TQString("Could not select values: ")+_q.lastError().text(),_q.lastError().number());
380	}	380	}
381	while(_q.next()) {	381	while(_q.next()) {