Method record

sources/db/SQLite.cpp:258–299

}

SqlRecord SqlQuery::record()
{
	SqlRecord rec;
	int numberOfColumns = sqlite3_data_count(_prepared);

	for (int i = 0; i < numberOfColumns; i++)
	{
		int type = sqlite3_column_type(_prepared, i);
		QVariant value;

		if (type == SQLITE_BLOB)
		{
			auto size = sqlite3_column_bytes(_prepared, i);
			QByteArray arr(size, 0);
			auto data = sqlite3_column_blob(_prepared, i);
			memcpy(arr.data(), data, size);
			value = QVariant(arr);
		}
		else if (type == SQLITE_FLOAT)
		{
			value = QVariant(sqlite3_column_double(_prepared, i));
		}
		else if (type == SQLITE_INTEGER)
		{
			value = QVariant(sqlite3_column_int(_prepared, i));
		}
		else if (type == SQLITE3_TEXT)
		{
			auto size = sqlite3_column_bytes(_prepared, i);
			QByteArray arr(size, 0);
			auto data = sqlite3_column_blob(_prepared, i);
			memcpy(arr.data(), data, size);
			value = QVariant(QString::fromUtf8(arr));
		}

		auto columnName = sqlite3_column_name(_prepared, i);
		std::pair<QString, QVariant> column(QString::fromUtf8(columnName), value);
		rec._result.push_back(column);
	}

	return rec;
}

bool SqlQuery::next()
{