#include <flsql_mysql.h>

Diagrama de herencias de QMYSQLDriver

Tipos públicos
enum	MySQLVersion { Version4 = 4, Version5 = 5 }
Métodos públicos
	QMYSQLDriver (QObject parent=0, const char name=0)
	QMYSQLDriver (MYSQL con, QObject parent=0, const char *name=0)
	~QMYSQLDriver ()
bool	hasFeature (DriverFeature f) const
bool	open (const QString &db, const QString &user=QString::null, const QString &password=QString::null, const QString &host=QString::null, int port=-1)
void	close ()
QSqlQuery	createQuery () const
QStringList	tables (const QString &user) const
QSqlIndex	primaryIndex (const QString &tablename) const
QSqlRecord	record (const QString &tablename) const
QSqlRecord	record (const QSqlQuery &query) const
QSqlRecordInfo	recordInfo (const QString &tablename) const
QSqlRecordInfo	recordInfo (const QSqlQuery &query) const
QString	formatValue (const QSqlField *field, bool trimStrings) const
MYSQL *	mysql ()
bool	open (const QString &db, const QString &user, const QString &password, const QString &host, int port, const QString &connOpts)
bool	tryConnect (const QString &db, const QString &user=QString::null, const QString &password=QString::null, const QString &host=QString::null, int port=-1)
QString	sqlCreateTable (FLTableMetaData *tmd)
QString	formatValueLike (int t, const QVariant &v, const bool upper=false)
QString	formatValue (int t, const QVariant &v, const bool upper=false)
QVariant	nextSerialVal (const QString &table, const QString &field)
int	atFrom (FLSqlCursor *cur)
bool	alterTable (const QString &mtd1, const QString &mtd2, const QString &key=QString::null)
bool	canSavePoint ()
bool	savePoint (const QString &n)
bool	releaseSavePoint (const QString &n)
bool	rollbackSavePoint (const QString &n)
MySQLVersion	version () const
	QMYSQLDriver (QObject parent=0, const char name=0)
	QMYSQLDriver (MYSQL con, QObject parent=0, const char *name=0)
	~QMYSQLDriver ()
bool	hasFeature (DriverFeature f) const
bool	open (const QString &db, const QString &user=QString::null, const QString &password=QString::null, const QString &host=QString::null, int port=-1)
void	close ()
QSqlQuery	createQuery () const
QStringList	tables (const QString &user) const
QSqlIndex	primaryIndex (const QString &tablename) const
QSqlRecord	record (const QString &tablename) const
QSqlRecord	record (const QSqlQuery &query) const
QSqlRecordInfo	recordInfo (const QString &tablename) const
QSqlRecordInfo	recordInfo (const QSqlQuery &query) const
QString	formatValue (const QSqlField *field, bool trimStrings) const
MYSQL *	mysql ()
bool	open (const QString &db, const QString &user, const QString &password, const QString &host, int port, const QString &connOpts)
Métodos protegidos
bool	beginTransaction ()
bool	commitTransaction ()
bool	rollbackTransaction ()
bool	beginTransaction ()
bool	commitTransaction ()
bool	rollbackTransaction ()
Amigas
class	QMYSQLResult

Documentación de las enumeraciones miembro de la clase

enum QMYSQLDriver::MySQLVersion

Valores de enumeraciones:

Version4
Version5

Documentación del constructor y destructor

QMYSQLDriver::QMYSQLDriver	(	QObject *	parent = `0`,
		const char *	name = `0`
	)

QMYSQLDriver::QMYSQLDriver	(	MYSQL *	con,
		QObject *	parent = `0`,
		const char *	name = `0`
	)

Create a driver instance with an already open connection handle.

QMYSQLDriver::~QMYSQLDriver ( )

QMYSQLDriver::QMYSQLDriver	(	QObject *	parent = `0`,
		const char *	name = `0`
	)

QMYSQLDriver::QMYSQLDriver	(	MYSQL *	con,
		QObject *	parent = `0`,
		const char *	name = `0`
	)

QMYSQLDriver::~QMYSQLDriver ( )

Documentación de las funciones miembro

bool QMYSQLDriver::alterTable	(	const QString &	mtd1,
		const QString &	mtd2,
		const QString &	key = `QString::null`
	)		`[virtual]`

Ver FLSqlDatabase::alterTable()

Reimplementado de FLSqlDriver.

int QMYSQLDriver::atFrom ( FLSqlCursor * cur ) [virtual]

Ver FLSqlDatabase::atFrom()

Reimplementado de FLSqlDriver.

bool QMYSQLDriver::beginTransaction ( ) [protected, virtual]

Protected function which derived classes can reimplement to begin a transaction. If successful, return TRUE, otherwise return FALSE. The default implementation returns FALSE.

Ver también:: commitTransaction(), rollbackTransaction()

Reimplementado de QSqlDriver.

bool QMYSQLDriver::beginTransaction ( ) [protected, virtual]

Protected function which derived classes can reimplement to begin a transaction. If successful, return TRUE, otherwise return FALSE. The default implementation returns FALSE.

Ver también:: commitTransaction(), rollbackTransaction()

Reimplementado de QSqlDriver.

bool QMYSQLDriver::canSavePoint ( ) [virtual]

Ver FLSqlDatabase::canSavePoint()

Reimplementado de FLSqlDriver.

void QMYSQLDriver::close ( void ) [virtual]

Derived classes must reimplement this abstract virtual function in order to close the database connection. Return TRUE on success, FALSE on failure.

Ver también:: setOpen()

Implementa QSqlDriver.

void QMYSQLDriver::close ( void ) [virtual]

Derived classes must reimplement this abstract virtual function in order to close the database connection. Return TRUE on success, FALSE on failure.

Ver también:: setOpen()

Implementa QSqlDriver.

bool QMYSQLDriver::commitTransaction ( ) [protected, virtual]

Protected function which derived classes can reimplement to commit a transaction. If successful, return TRUE, otherwise return FALSE. The default implementation returns FALSE.

Ver también:: beginTransaction(), rollbackTransaction()

Reimplementado de QSqlDriver.

bool QMYSQLDriver::commitTransaction ( ) [protected, virtual]

Protected function which derived classes can reimplement to commit a transaction. If successful, return TRUE, otherwise return FALSE. The default implementation returns FALSE.

Ver también:: beginTransaction(), rollbackTransaction()

Reimplementado de QSqlDriver.

QSqlQuery QMYSQLDriver::createQuery ( ) const [virtual]

Creates an empty SQL result on the database. Derived classes must reimplement this function and return a QSqlQuery object appropriate for their database to the caller.

Implementa QSqlDriver.

QSqlQuery QMYSQLDriver::createQuery ( ) const [virtual]

Creates an empty SQL result on the database. Derived classes must reimplement this function and return a QSqlQuery object appropriate for their database to the caller.

Implementa QSqlDriver.

QString QMYSQLDriver::formatValue	(	int	t,
		const QVariant &	v,
		const bool	upper = `false`
	)		`[virtual]`

Ver FLSqlDatabase::formatValue()

Reimplementado de FLSqlDriver.

QString QMYSQLDriver::formatValue	(	const QSqlField *	field,
		bool	trimStrings
	)		const `[virtual]`

Returns a string representation of the field value for the database. This is used, for example, when constructing INSERT and UPDATE statements.

The default implementation returns the value formatted as a string according to the following rules:

If field is NULL, nullText() is returned.

If field is character data, the value is returned enclosed in single quotation marks, which is appropriate for many SQL databases. Any embedded single-quote characters are escaped (replaced with two single-quote characters). If trimStrings is TRUE (the default is FALSE), all trailing whitespace is trimmed from the field.

If field is date/time data, the value is formatted in ISO format and enclosed in single quotation marks. If the date/time data is invalid, nullText() is returned.

If field is bytearray data, and the driver can edit binary fields, the value is formatted as a hexadecimal string.

For any other field type toString() will be called on its value and the result returned.

Ver también:: QVariant::toString().

Reimplementado de QSqlDriver.

QString QMYSQLDriver::formatValue	(	const QSqlField *	field,
		bool	trimStrings
	)		const `[virtual]`

Returns a string representation of the field value for the database. This is used, for example, when constructing INSERT and UPDATE statements.

The default implementation returns the value formatted as a string according to the following rules:

If field is NULL, nullText() is returned.

If field is character data, the value is returned enclosed in single quotation marks, which is appropriate for many SQL databases. Any embedded single-quote characters are escaped (replaced with two single-quote characters). If trimStrings is TRUE (the default is FALSE), all trailing whitespace is trimmed from the field.

If field is date/time data, the value is formatted in ISO format and enclosed in single quotation marks. If the date/time data is invalid, nullText() is returned.

If field is bytearray data, and the driver can edit binary fields, the value is formatted as a hexadecimal string.

For any other field type toString() will be called on its value and the result returned.

Ver también:: QVariant::toString().

Reimplementado de QSqlDriver.

QString QMYSQLDriver::formatValueLike	(	int	t,
		const QVariant &	v,
		const bool	upper = `false`
	)		`[virtual]`

Ver FLSqlDatabase::formatValueLike()

Reimplementado de FLSqlDriver.

bool QMYSQLDriver::hasFeature ( DriverFeature f ) const [virtual]

Returns TRUE if the driver supports feature f; otherwise returns FALSE.

Note that some databases need to be open() before this can be determined.

Ver también:: DriverFeature

Implementa QSqlDriver.

bool QMYSQLDriver::hasFeature ( DriverFeature f ) const [virtual]

Returns TRUE if the driver supports feature f; otherwise returns FALSE.

Note that some databases need to be open() before this can be determined.

Ver también:: DriverFeature

Implementa QSqlDriver.

MYSQL* QMYSQLDriver::mysql ( )

MYSQL * QMYSQLDriver::mysql ( )

QVariant QMYSQLDriver::nextSerialVal	(	const QString &	table,
		const QString &	field
	)		`[virtual]`

Ver FLSqlDatabase::nextSerialVal()

Reimplementado de FLSqlDriver.

bool QMYSQLDriver::open	(	const QString &	db,
		const QString &	user = `QString::null`,
		const QString &	password = `QString::null`,
		const QString &	host = `QString::null`,
		int	port = `-1`
	)		`[virtual]`

Derived classes must reimplement this abstract virtual function in order to open a database connection on database db, using user name user, password password, host host and port port.

The function must return TRUE on success and FALSE on failure.

Ver también:: setOpen()

Implementa QSqlDriver.

bool QMYSQLDriver::open	(	const QString &	db,
		const QString &	user,
		const QString &	password,
		const QString &	host,
		int	port,
		const QString &	connOpts
	)

Esta es una función miembro sobrecargada que se suministra por conveniencia. Difiere de la anterior función solamente en los argumentos que acepta. Open a database connection on database db, using user name user, password password, host host, port port and connection options connOpts.

Returns TRUE on success and FALSE on failure.

Ver también:: setOpen()

Reimplementado de QSqlDriver.

bool QMYSQLDriver::open	(	const QString &	db,
		const QString &	user,
		const QString &	password,
		const QString &	host,
		int	port,
		const QString &	connOpts
	)

Esta es una función miembro sobrecargada que se suministra por conveniencia. Difiere de la anterior función solamente en los argumentos que acepta. Open a database connection on database db, using user name user, password password, host host, port port and connection options connOpts.

Returns TRUE on success and FALSE on failure.

Ver también:: setOpen()

Reimplementado de QSqlDriver.

bool QMYSQLDriver::open	(	const QString &	db,
		const QString &	user = `QString::null`,
		const QString &	password = `QString::null`,
		const QString &	host = `QString::null`,
		int	port = `-1`
	)		`[virtual]`

Derived classes must reimplement this abstract virtual function in order to open a database connection on database db, using user name user, password password, host host and port port.

The function must return TRUE on success and FALSE on failure.

Ver también:: setOpen()

Implementa QSqlDriver.

QSqlIndex QMYSQLDriver::primaryIndex ( const QString & tableName ) const [virtual]

Returns the primary index for table tableName. Returns an empty QSqlIndex if the table doesn't have a primary index. The default implementation returns an empty index.

Reimplementado de QSqlDriver.

QSqlIndex QMYSQLDriver::primaryIndex ( const QString & tableName ) const [virtual]

Returns the primary index for table tableName. Returns an empty QSqlIndex if the table doesn't have a primary index. The default implementation returns an empty index.

Reimplementado de QSqlDriver.

QSqlRecord QMYSQLDriver::record ( const QSqlQuery & query ) const [virtual]

Esta es una función miembro sobrecargada que se suministra por conveniencia. Difiere de la anterior función solamente en los argumentos que acepta. Returns a QSqlRecord populated with the names of the fields in the SQL query. The default implementation returns an empty record.

Reimplementado de QSqlDriver.

QSqlRecord QMYSQLDriver::record ( const QString & tableName ) const [virtual]

Returns a QSqlRecord populated with the names of the fields in table tableName. If no such table exists, an empty record is returned. The default implementation returns an empty record.

Reimplementado de QSqlDriver.

QSqlRecord QMYSQLDriver::record ( const QSqlQuery & query ) const [virtual]

Esta es una función miembro sobrecargada que se suministra por conveniencia. Difiere de la anterior función solamente en los argumentos que acepta. Returns a QSqlRecord populated with the names of the fields in the SQL query. The default implementation returns an empty record.

Reimplementado de QSqlDriver.

QSqlRecord QMYSQLDriver::record ( const QString & tableName ) const [virtual]

Returns a QSqlRecord populated with the names of the fields in table tableName. If no such table exists, an empty record is returned. The default implementation returns an empty record.

Reimplementado de QSqlDriver.

QSqlRecordInfo QMYSQLDriver::recordInfo ( const QSqlQuery & query ) const [virtual]

Esta es una función miembro sobrecargada que se suministra por conveniencia. Difiere de la anterior función solamente en los argumentos que acepta. Returns a QSqlRecordInfo object with meta data for the QSqlQuery query. Note that this overloaded function may return less information than the recordInfo() function which takes the name of a table as parameter.

Reimplementado de QSqlDriver.

QSqlRecordInfo QMYSQLDriver::recordInfo ( const QString & tablename ) const [virtual]

Returns a QSqlRecordInfo object with meta data about the table tablename.

Reimplementado de QSqlDriver.

QSqlRecordInfo QMYSQLDriver::recordInfo ( const QSqlQuery & query ) const [virtual]

Esta es una función miembro sobrecargada que se suministra por conveniencia. Difiere de la anterior función solamente en los argumentos que acepta. Returns a QSqlRecordInfo object with meta data for the QSqlQuery query. Note that this overloaded function may return less information than the recordInfo() function which takes the name of a table as parameter.

Reimplementado de QSqlDriver.

QSqlRecordInfo QMYSQLDriver::recordInfo ( const QString & tablename ) const [virtual]

Returns a QSqlRecordInfo object with meta data about the table tablename.

Reimplementado de QSqlDriver.

bool QMYSQLDriver::releaseSavePoint ( const QString & n ) [virtual]

Ver FLSqlDatabase::releaseSavePoint()

Reimplementado de FLSqlDriver.

bool QMYSQLDriver::rollbackSavePoint ( const QString & n ) [virtual]

Ver FLSqlDatabase::rollbackSavePoint()

Reimplementado de FLSqlDriver.

bool QMYSQLDriver::rollbackTransaction ( ) [protected, virtual]

Protected function which derived classes can reimplement to rollback a transaction. If successful, return TRUE, otherwise return FALSE. The default implementation returns FALSE.

Ver también:: beginTransaction(), commitTransaction()

Reimplementado de QSqlDriver.

bool QMYSQLDriver::rollbackTransaction ( ) [protected, virtual]

Protected function which derived classes can reimplement to rollback a transaction. If successful, return TRUE, otherwise return FALSE. The default implementation returns FALSE.

Ver también:: beginTransaction(), commitTransaction()

Reimplementado de QSqlDriver.

bool QMYSQLDriver::savePoint ( const QString & n ) [virtual]

Ver FLSqlDatabase::savePoint()

Reimplementado de FLSqlDriver.

QString QMYSQLDriver::sqlCreateTable ( FLTableMetaData * tmd ) [virtual]

Sentencia SQL espec�fica de la base de datos que soporta el controlador, necesaria para crear la tabla solicitada.

Parámetros:

tmd	Metadatos con la descripci�n de la tabla que se desea crear

Devuelve:: Sentencia SQL debidamente formateada para el tipo de base de datos soportada por el controlador

Reimplementado de FLSqlDriver.

QStringList QMYSQLDriver::tables ( const QString & tableType ) const [virtual]

Returns a list of tables in the database. The default implementation returns an empty list.

The tableType argument describes what types of tables should be returned. Due to binary compatibility, the string contains the value of the enum QSql::TableTypes as text. An empty string should be treated as QSql::Tables for downward compatibility.

Ver también:: QSql::TableType

Reimplementado de QSqlDriver.

QStringList QMYSQLDriver::tables ( const QString & tableType ) const [virtual]

Returns a list of tables in the database. The default implementation returns an empty list.

The tableType argument describes what types of tables should be returned. Due to binary compatibility, the string contains the value of the enum QSql::TableTypes as text. An empty string should be treated as QSql::Tables for downward compatibility.

Ver también:: QSql::TableType

Reimplementado de QSqlDriver.

bool QMYSQLDriver::tryConnect	(	const QString &	db,
		const QString &	user = `QString::null`,
		const QString &	password = `QString::null`,
		const QString &	host = `QString::null`,
		int	port = `-1`
	)		`[virtual]`

Intentar realizar una conexi�n a una base de datos.

Si la base de datos no existe intenta crearla.

Parámetros:

database	Nombre de la base de datos a la que conectar
user	Usuario
password	Contrase�a
host	Servidor de la base de datos
port	Puerto TCP de conexi�n

Devuelve:: True si la conexi�n tuvo �xito, false en caso contrario

Reimplementado de FLSqlDriver.

QMYSQLDriver::MySQLVersion QMYSQLDriver::version ( ) const

Documentación de las funciones relacionadas y clases amigas

QMYSQLResult [friend]

La documentación para esta clase fue generada a partir de los siguientes ficheros:

src/plugins/sqldrivers/mysql/flsql_mysql.h
src/qt/src/sql/drivers/mysql/qsql_mysql.h
src/plugins/sqldrivers/mysql/flsql_mysql.cpp
src/qt/src/sql/drivers/mysql/qsql_mysql.cpp

Tipos públicos

Métodos públicos

Métodos protegidos

Amigas

Documentación de las enumeraciones miembro de la clase

Documentación del constructor y destructor

Documentación de las funciones miembro

Documentación de las funciones relacionadas y clases amigas