summaryrefslogtreecommitdiffstats
path: root/kjsembed/bindings/sql_imp.h
blob: f2fa6e6d8319fcc6678ec8c28f2ceeca52e8f21a (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
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 <geiseri@kde.org>
 *
 *  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 QSQLQuery.
 *
 * @author Ian Reinhart Geiser, geiseri@kde.org
 * @version $Id$
 */
class SqlQuery : public BindingObject
{
	Q_OBJECT
	Q_PROPERTY( int  size READ size)
	Q_PROPERTY( int  at READ at)
	Q_PROPERTY( int  numRowsAffected READ numRowsAffected )
	Q_PROPERTY( bool  select READ isSelect)
	Q_PROPERTY( bool  valid READ isValid)
	Q_PROPERTY( bool  active READ isActive)
	Q_PROPERTY( TQString lastError READ lastError)
	Q_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 &copy);
	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 QSQLDatabase.
 *
 * @author Ian Reinhart Geiser, geiseri@kde.org
 * @version $Id$
 */
class SqlDatabase : public BindingObject
{
    Q_OBJECT
    Q_PROPERTY( TQString  databaseName READ databaseName WRITE setDatabaseName)
    Q_PROPERTY( TQString  userName READ userName WRITE setUserName)
    Q_PROPERTY( TQString  password READ password WRITE setPassword)
    Q_PROPERTY( TQString  hostName READ hostName WRITE setHostName)
    Q_PROPERTY( int port READ port WRITE setPort)
    Q_PROPERTY( TQString  driverName READ driverName)
    Q_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