forensictool-plugin-android-vk/dbmanager.cpp at master · forensictool/forensictool-plugin-android-vk · GitHub

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
#include <dbmanager.h>
#include <QSqlQuery>
#include <QSqlRecord>
#include <iostream>
#include <QVariant>
#include <QDebug>
#include <QFile>
#include <QTextStream>
#include <QXmlStreamWriter>
#include <QSqlField>
#include <QDir>


DbManager::DbManager(const QString &path)
{
    db = QSqlDatabase::addDatabase("QSQLITE");
    db.setDatabaseName(path);

    if (!db.open()) {
        qDebug() << "Error; connection failed";
    }
    else {
        qDebug() << "Database: connection ok";
    }
}


DbManager::~DbManager()
{
    if (db.isOpen()) {
        db.close();
    }
}


void DbManager::printTables()
{
    QStringList tables = db.tables(QSql::Tables);
    int i;
    for (i=0; i<tables.length(); i++) {
        qDebug() << tables[i];
    }
}


bool DbManager::isOpen() const
{
    return db.isOpen();
}


void DbManager::toXML()
{
    int i,j,k;
    QStringList tables = db.tables(QSql::Tables);
    QSqlRecord record;
    QSqlQuery query;
    int numOfFields;
    QXmlStreamWriter xmlWriter;
    //QDir::setCurrent("/home/alexey/QtProjects/databaseproject0/XMLoutput/");
    QFile file ("output.xml");
    if (!file.open(QIODevice::WriteOnly)) {
        qDebug() << "Error opening file";
    }
    else {
        xmlWriter.setDevice(&file);
        xmlWriter.writeStartDocument();
        xmlWriter.writeStartElement("tables");
        for (i=0; i<tables.length(); i++) {
            xmlWriter.writeStartElement(tables[i]);
            query.exec("SELECT * FROM " + tables[i]);
            while (query.next()) {
            //for (j=0; j<numOfRows; j++) {
                xmlWriter.writeStartElement("record");
                record = db.record(tables[i]);
                numOfFields = record.count();
                for (k=0; k<numOfFields; k++) {
                    //BLOB into base64
                    if (QString(query.value(k).typeName()) == "QByteArray") {
                        xmlWriter.writeAttribute(record.fieldName(k), (query.value(k).toByteArray()).toBase64());
                    }
                    else {
                        xmlWriter.writeAttribute(record.fieldName(k), query.value(k).toString());
                    }
                }
                xmlWriter.writeEndElement();
            }
            xmlWriter.writeEndElement();
        }
        xmlWriter.writeEndElement();
        xmlWriter.writeEndDocument();
    }
}