blob: a98d97ed94d35cc4eb6827c7903399879a8cf938 (
plain)
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
94
95
96
97
98
|
/*
* Copyright (C) 2012 Digia Plc and/or its subsidiary(-ies).
* Contact: http://www.qt-project.org/legal
* This component and the accompanying materials are made available
* under the terms of "Eclipse Public License v1.0"
* which accompanies this distribution, and is available
* at the URL "http://www.eclipse.org/legal/epl-v10.html".
*
* Initial Contributors:
* Nokia Corporation - initial contribution.
*
* Contributors:
*
* Description:
*
*/
/**
@file
@internalComponent
@released
*/
#ifndef __CDbSqlDumper_H__
#define __CDbSqlDumper_H__
#include <e32std.h>
#include <e32def.h>
#include <f32file.h>
#include <badesca.h>
#include <sqldb.h>
#include <e32cmn.h>
#include <e32base.h>
/**
Utility class used to provide table names and column names existing in the sql database.
It is mapped to a specific sql schema.
*/
class CDbStructure : public CBase
{
public:
CDbStructure();
~CDbStructure();
void Init();
TBool NextTable();
const TDesC& TableName();
const TDesC& TableName(TInt aTablePosition);
TBool NextColumn(TInt aTableIndex);
const TDesC& Column(TInt aTableIndex);
const TDesC& Column(TInt aTableIndex, TInt aColumnIndex);
TBool IsLastColumn(TInt aTableIndex);
TInt ColumnNo(const TInt aTableIndex);
private:
TInt iTablesIndex;
TInt iNumTables;
RArray<TInt> iColumnsIndex;
RArray<TInt> iNumColumns;
};
/**
CDbSqlDumper class dumps the contents and columns of all tables in
a given sql database in HTML format to a given location
*/
class CDbSqlDumper : public CBase
{
public:
static CDbSqlDumper* NewLC(const TDesC& aDbName, const TDesC& aOutputDir);
~CDbSqlDumper();
void OutputDBContentsL();
private:
void ConstructL(const TDesC& aDbName, const TDesC& aOutputDir);
void OutputTableNameToFile(TInt aTableIndex);
void OutputTableColHeadingsToFile(TInt aTableIndex);
void OutputTableColDataToFileL(TInt aTableIndex);
void OutputTableToFileL(TInt aTableIndex);
void FieldHeaderColL(TInt aFieldIndex);
void LongBinaryL(TInt aFieldIndex);
void DumpStreamL(RReadStream& stream);
void PrepareSQLStatementL(TInt aTableIndex);
private:
RFs iFsSession;
RSqlDatabase iDatabase;
RSqlStatement iSqlStatement;
RPointerArray<TDesC> iTableNames;
RFile iFile;
HBufC8* iBuffer;
CDbStructure* iDbStructure;
};
#endif // __CDbSqlDumper_H__
|