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
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
|
/*
* Copyright (C) 2003, Ian Reinhart Geiser <[email protected]>
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Library General Public
* License as published by the Free Software Foundation; either
* version 2 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Library General Public License for more details.
*
* You should have received a copy of the GNU Library General Public License
* along with this library; see the file COPYING.LIB. If not, write to
* the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
* Boston, MA 02110-1301, USA.
*/
#ifndef KJSEMBED_SQL_IMP_H
#define KJSEMBED_SQL_IMP_H
#include "bindingobject.h"
#include <tqsqlquery.h>
#include <tqsqldatabase.h>
namespace KJSEmbed {
namespace Bindings {
/**
* TQObject Binding for TQSQLQuery.
*
* @author Ian Reinhart Geiser, [email protected]
* @version $Id$
*/
class SqlQuery : public BindingObject
{
TQ_OBJECT
TQ_PROPERTY( int size READ size)
TQ_PROPERTY( int at READ at)
TQ_PROPERTY( int numRowsAffected READ numRowsAffected )
TQ_PROPERTY( bool select READ isSelect)
TQ_PROPERTY( bool valid READ isValid)
TQ_PROPERTY( bool active READ isActive)
TQ_PROPERTY( TQString lastError READ lastError)
TQ_PROPERTY( TQString lastQuery READ lastQuery)
public:
SqlQuery( TQObject *parent=0, const char *name=0 );
SqlQuery( TQObject *parent, const char *name, const TQSqlQuery &q );
//SqlQuery( const SqlQuery ©);
virtual ~SqlQuery();
TQSqlQuery query(){ return m_query; }
void setQuery(const TQSqlQuery &q) {m_query = TQSqlQuery(q); }
int size () const;
bool isSelect () const;
bool isValid () const;
bool isActive () const;
int at () const;
int numRowsAffected () const;
TQString lastError () const;
TQString lastQuery () const;
public slots:
bool isNull ( int field );
bool exec ( const TQString & m_query );
TQVariant value ( int i );
bool seek ( int i, bool relative = FALSE );
bool next ();
bool prev ();
bool first ();
bool last ();
private:
TQSqlQuery m_query;
};
/**
* TQObject Binding for TQSQLDatabase.
*
* @author Ian Reinhart Geiser, [email protected]
* @version $Id$
*/
class SqlDatabase : public BindingObject
{
TQ_OBJECT
TQ_PROPERTY( TQString databaseName READ databaseName WRITE setDatabaseName)
TQ_PROPERTY( TQString userName READ userName WRITE setUserName)
TQ_PROPERTY( TQString password READ password WRITE setPassword)
TQ_PROPERTY( TQString hostName READ hostName WRITE setHostName)
TQ_PROPERTY( int port READ port WRITE setPort)
TQ_PROPERTY( TQString driverName READ driverName)
TQ_PROPERTY( TQString lastError READ lastError)
public:
SqlDatabase( TQObject *parent=0, const char *name=0 );
virtual ~SqlDatabase();
public slots:
void setDatabaseName (const TQString &name );
void setUserName (const TQString &name );
void setPassword (const TQString &password );
void setHostName (const TQString &host );
void setPort ( int p );
TQString databaseName () const;
TQString userName () const;
TQString password () const;
TQString hostName () const;
int port () const;
TQString driverName () const;
bool addDatabase ( const TQString & type, const TQString & connectionName = TQSqlDatabase::defaultConnection );
TQStringList drivers ();
bool open ();
bool open ( const TQString &user, const TQString &password );
void close ();
bool isOpen ();
bool isOpenError ();
TQStringList tables ();
SqlQuery *exec( const TQString &query );
TQString lastError () const;
bool transaction ();
bool commit ();
bool rollback ();
private:
TQString connectionName;
//TQSqlDatabase *db;
};
} // namespace KJSEmbed::Bindings
} // namespace KJSEmbed
#endif // KJSEMBED_SQL_IMP_H
|