Source: /app/hbasic/hbasic/src/hbdatabase.h

/* **************************************************************************
 File: hbdatabase.h
 ----------------------------------------------------------------------------
	copyright : (C) 2001 HBasic project (Marcus Engels)
 ***************************************************************************/
/* **************************************************************************
 * *
 * This program is free software; you can redistribute it and/or modify *
 * it under the terms of the GNU General Public License as published by *
 * the Free Software Foundation; either version 2 of the License, or *
 * (at your option) any later version. *
 * *
 ***************************************************************************/
/* ----------------------------------------------------------------------- */
/* Classlist: List of classes that will be defined in this source file. */
/* ----------------------------------------------------------------------- */
/**
 Class HBDatabase: This class will be used as an interface to all
 database access functions. Every connection to a database needs
 at least one HBDatabase.
*/
/* ----------------------------------------------------------------------- */
/* Changelog: Description of important changes within this file. */
/* Please report with date, maintainer and change description. */
/* ----------------------------------------------------------------------- */
#ifndef HBDATABASE_H
#define HBDATABASE_H
#include 
#include 
#include 
#include 
#include 
#include 
#include 
#include "../hbdata/hbobject.h"
#include "../hbdata/hbsublist.h"
#include "../src/structs.h"
#define STR_LENGTH 100
class QString;
class QPushButton;
class QDataBrowser;
class QSqlForm;
/* Global defined methods in hbdatabase.cpp */
void readDatabaseList(void);
void saveDbListToFile( void );
int getCurrentDriverType( void );
#define DTYPE_UNDEF 0
#define DTYPE_MYSQL3 1
#define DTYPE_PSQL7 2
class HBDatabase : public QObject, public HBObject
{
Q_OBJECT
Q_PROPERTY( QString dbname READ getDbName WRITE setDbName )
Q_PROPERTY( QString host READ getHost WRITE setHost )
Q_PROPERTY( QString driver READ getDriver WRITE setDriver )
Q_PROPERTY( QString user READ getUser WRITE setUser )
Q_PROPERTY( QString password READ getPassword WRITE setPassword )
Q_PROPERTY( QString desc READ getDesc WRITE setDesc )
public:
	HBDatabase( char *name );
	short prepareConnect( void );
	HBSubList *getColumnList( HBDbTable *table_ptr );
	short loadTableList( short force_rebuild );
	HBDbTable *findTableDesc( char *table_name );
	HBDbTable *bindQueryColumns( QSqlCursor *query_cursor );
	long compMemLength( HBDbColumn *query_column_ptr );
	HBDbColumn *prepareQueryDesc( void );
	void getDbControl( QString *dsn_name );
	void execDirect( QString *statement );
	/**
	 * Create a connection to a QT database description.
	 */
	short connectDatabase( void );
	/**
	 * Close current database connection.
	 */
	void closeConnection( void );
	/* db_desc */
public:
	/* Name of database driver description in name-field of Qobject */
	/* dbname is the name of the database on the server */
	QString *dbname;
	QString *str_host;
	QString *driver;
	QString *desc;
	QString *user;
	QString *password;
	short save_pw; /* TRUE if password should be saved to file for this DSN */
	QSqlDatabase *qt_db_desc; /* pointer to qt database description widget. */
	void loadColumnList( HBDbTable *table_ptr );
	void setDbName( QString new_name );
	QString getDbName( void ) const;
	void setHost( QString new_name );
	QString getHost( void ) const;
	void setDriver( QString new_name );
	QString getDriver( void ) const;
	void setUser( QString new_name );
	QString getUser( void ) const;
	void setPassword( QString new_name );
	QString getPassword( void ) const;
	void setDesc( QString new_name );
	QString getDesc( void ) const;
private:
	void prepareQuery(void);
};
class DBCursorForm : public QWidget
{
	Q_OBJECT
	Q_PROPERTY( QString DB_TABLE READ getDbTable WRITE setDbTable )
private:
	QDataBrowser *db_browse;
	QSqlCursor *sql_cursor;
	QString *table_name;
	QWidget *wgt_ptr;
	HBDatabase *db_control;
public:
	DBCursorForm( QWidget *parent );
	void resizeEvent( QResizeEvent *evt );
	void initDataBrowser( QWidget *wgt );
	QSqlForm *form_ptr;
private:
	QPushButton *btn_first;
	QPushButton *btn_previous;
	QPushButton *btn_next;
	QPushButton *btn_last;
	QPushButton *btn_add;
	QPushButton *btn_delete;
	QString prop_db_table;
private slots:
	void slotBtnFirstClicked( void );
	void slotBtnPreviousClicked( void );
	void slotBtnNextClicked( void );
	void slotBtnLastClicked( void );
	void slotBtnAddClicked( void );
	void slotBtnDeleteClicked( void );
public slots:
	/* Property db_table */
	QString getDbTable( void ) const;
	void setDbTable( const QString & );
};
/*-------------------------------------------------------------------------- */
class ColumnEditor : public QLineEdit
{
	Q_OBJECT
	Q_PROPERTY( QString DB_COLUMN READ getDbColumn WRITE setDbColumn )
public:
	ColumnEditor( QWidget *parent );
private:
	QString prop_db_column;
public slots:
	/* Property db_table */
	QString getDbColumn( void ) const;
	void setDbColumn( const QString & );
};
#endif