QVariant KexiRecentProjectsModel::data(const QModelIndex& index, int role) const
{
if (!index.isValid()) {
return QVariant();
}
KexiProjectData *pdata = static_cast<KexiProjectData*>(index.internalPointer());
bool fileBased = !pdata->constConnectionData()->dbFileName().isEmpty();
QString opened(openedString(pdata->lastOpened()));
if (!opened.isEmpty())
opened.prepend('\n');
switch (role) {
case Qt::DisplayRole: {
//! @todo add support for imported entries, e.g. MS Access
if (fileBased) {
QString n = pdata->caption().trimmed();
if (n.isEmpty())
n = pdata->constConnectionData()->dbFileName();
return n
+ opened;
}
else {
QString n = pdata->captionOrName();
if (!n.isEmpty()) {
n += '\n';
}
QString serverInfo = pdata->connectionData()->serverInfoString(false /* without user */);
// friendly message:
if (serverInfo == "localhost") {
serverInfo = i18n("on local server");
}
else {
serverInfo = i18n("on \"%1\" server", serverInfo);
}
return n + serverInfo + opened;
}
}
case Qt::ToolTipRole:
//! @todo add support for imported entries, e.g. MS Access
if (fileBased) {
return i18nc("File database <file>", "File database %1",
pdata->constConnectionData()->fileName());
}
else {
KexiDB::DriverManager manager;
return i18nc("<type> database", "%1 database",
manager.driverInfo(pdata->constConnectionData()->driverName).caption);
return pdata->objectName();
}
case Qt::DecorationRole: {
//! @todo show icon specific to given database or mimetype
if (fileBased) {
return KIcon(KexiDB::defaultFileBasedDriverIconName());
}
else {
return KIcon(KEXI_DATABASE_SERVER_ICON_NAME);
}
}
/*case KCategorizedSortFilterProxyModel::CategorySortRole: {
int index = m_categoryNameIndex.value(info->category);
if (index >= 0 && index < m_templateCategories.count()) {
QVariantList list;
list << index << info->caption;
return list;
}
return QVariantList();
}
case KCategorizedSortFilterProxyModel::CategoryDisplayRole: {
int index = m_categoryNameIndex.value(info->category);
if (index >= 0 && index < m_templateCategories.count()) {
KexiTemplateCategoryInfo category = m_templateCategories.value(index);
return category.caption;
}
return QVariant();
}*/
case NameRole:
return pdata->databaseName();
/*case CategoryRole:
return info->category;*/
default:
break;
}
return QVariant();
}
int main(int argc, char** argv)
{
int minargs = 2;
bool gui = false;
/* if (argc < minargs) {
usage();
RETURN(0);
}*/
QFileInfo info = QFileInfo(argv[0]);
prgname = info.baseName().toLatin1();
KAboutData aboutData(prgname, 0, ki18n("KexiDBTest"),
KEXI_VERSION_STRING, KLocalizedString(), KAboutData::License_GPL,
ki18n("(c) 2003-2010, Kexi Team\n"
"(c) 2003-2006, OpenOffice Software.\n"),
KLocalizedString(),
"http://www.calligra.org/kexi",
"*****@*****.**");
KCmdLineArgs::init(argc, argv, &aboutData);
KCmdLineOptions options;
options.add("test <test_name>", ki18n("Available tests:\n"
"- cursors: test for cursors behaviour\n"
"- schema: test for db schema retrieving\n"
"- dbcreation: test for new db creation\n"
"- tables: test for tables creation and data\n"
" inserting\n"
#ifndef NO_GUI
"- tableview: test for KexiDataTableView data-aware\n"
" widget\n"
#endif
"- parser: test for parsing sql statements,\n"
" returns debug string for a given\n"
" sql statement or error message\n"
"- dr_prop: shows properties of selected driver"));
options.add("buffered-cursors", ki18n("Optional switch: turns cursors used in any tests\n"
" to be buffered"));
options.add("query-params <params>", ki18n("Query parameters separated\n"
"by '|' character that will be passed to query\n"
"statement to replace [...] placeholders."));
options.add("", ki18n(" Notes:\n"
"1. 'dr_prop' requires <db_name> argument.\n"
"2. 'parser' test requires <db_name>,\n"
" <driver_name> and <sql_statement> arguments\n"
"3. All other tests require <db_name>\n"
" and <driver_name> arguments.\n"
"4. 'tables' test automatically runs 'dbcreation'\n"
" test. (<new_db_name> is removed if already exists).\n"
"5. <db_name> must be a valid kexi database\n"
" e.g. created with 'tables' test."));
options.add("+driver_name", ki18n("Driver name"));
options.add("+[db_name]", ki18n("Database name"));
options.add("+[sql_statement]", ki18n("Optional SQL statement (for parser test)"));
KCmdLineArgs::addCmdLineOptions(options);
KCmdLineArgs *args = KCmdLineArgs::parsedArgs();
QStringList tests;
tests << "cursors" << "schema" << "dbcreation" << "tables"
<< "tableview" << "parser" << "dr_prop";
if (!args->isSet("test")) {
kDebug() << "No test specified. Use --help.";
RETURN(1);
}
test_name = args->getOption("test");
if (!tests.contains(test_name)) {
kDebug() << QString("No such test \"%1\". Use --help.").arg(test_name);
RETURN(1);
}
if (test_name == "tableview") {
gui = true;
} else if (test_name == "parser") {
minargs = 3;
} else if (test_name == "dr_prop") {
minargs = 1;
db_name_required = false;
}
if ((int)args->count() < minargs) {
kDebug() << QString("Not enough args (%1 required). Use --help.").arg(minargs);
RETURN(1);
}
if (gui) {
app = new QApplication(true);
app->setWindowIcon(koIcon("table"));
instance = new KComponentData(KGlobal::mainComponent());
KIconLoader::global()->addAppDir("kexi");
} else {
instance = new KComponentData(prgname);
}
drv_name = args->arg(0);
KexiDB::DriverManager manager;
QStringList names = manager.driverNames();
kDebug() << "DRIVERS: ";
for (QStringList::ConstIterator it = names.constBegin(); it != names.constEnd() ; ++it)
kDebug() << *it;
if (manager.error() || names.isEmpty()) {
manager.debugError();
RETURN(1);
}
//get driver
const KexiDB::Driver::Info drv_info = manager.driverInfo(drv_name);
driver = manager.driver(drv_name);
if (drv_info.name.isEmpty() || manager.error()) {
manager.debugError();
RETURN(1);
}
kDebug() << "MIME type for '" << drv_info.name << "': " << drv_info.fileDBMimeType;
//open connection
if (args->count() >= 2)
db_name = args->arg(1);
if (db_name_required && db_name.isEmpty()) {
kDebug() << prgname << ": database name?";
RETURN(1);
}
if (!db_name.isEmpty()) {
//additional switches:
if (args->isSet("buffered-cursors")) {
cursor_options |= KexiDB::Cursor::Buffered;
}
KexiProjectData project_data;
project_data.setDatabaseName(db_name);
if (drv_info.fileBased) {
project_data.connectionData()->setFileName(db_name);
}
project_data.connectionData()->driverName = drv_name;
project = new KexiProject(project_data);
bool incompatibleWithKexi = false;
tristate res;
if (test_name == "dbcreation" || test_name == "tables")
res = project->create(true /*force overwrite*/);
else
res = project->open(incompatibleWithKexi);
if (res != true) {
if (incompatibleWithKexi)
kDebug() << "incompatibleWithKexi";
project->debugError();
RETURN(1);
}
conn = project->dbConnection();
/* conn = driver->createConnection(conn_data);
if (!conn || driver->error()) {
driver->debugError();
RETURN(1);
}
if (!conn->connect()) {
conn->debugError();
RETURN(1);
}*/
}
//start test:
int r = 0;
if (test_name == "cursors")
r = cursorsTest();
else if (test_name == "schema")
r = schemaTest();
else if (test_name == "dbcreation")
r = dbCreationTest();
else if (test_name == "tables")
r = tablesTest();
#ifndef NO_GUI
else if (test_name == "tableview")
r = tableViewTest();
#endif
else if (test_name == "parser") {
QStringList params;
if (args->isSet("query-params"))
params = args->getOption("query-params").split('|');
r = parserTest(QString(args->arg(2)), params);
} else if (test_name == "dr_prop")
r = drPropTest();
else {
kWarning() << "No such test: " << test_name;
// usage();
RETURN(1);
}
if (app && r == 0)
app->exec();
if (r)
kDebug() << "RECENT SQL STATEMENT: " << conn->recentSQLString();
if (project) {
if (!project->closeConnection())
r = 1;
delete project;
}
// if (conn && !conn->disconnect())
// r = 1;
// kDebug() << "!!! KexiDB::Transaction::globalcount == " << KexiDB::Transaction::globalCount();
// kDebug() << "!!! KexiDB::TransactionData::globalcount == " << KexiDB::TransactionData::globalCount();
delete app;
RETURN(r);
}
