class Connection

Manages the connection state to a SQL engine. More...

Full nameKDB::Connection
Definition#include <connection.h>
InheritsKDB::Object [public ]
List of all Methods
Annotated List
Files
Globals
Hierarchy
Index

Public Methods

Public Slots

Signals


Detailed Description

Manages the connection state to a SQL engine.

Basically stores all authentication tokens and opens/closes connection as needed.

It is also a collection of database objects, allowing

 ~Connection ()

[virtual]

bool  open ()

Connect to the host. If username and password are missing, pops up a dialog to ask them. If the connection is open, nothing is actually done. Returns true if the connection has been succesfully opened, false otherwise.

void  close (bool destructive = true)

Disconnects from the host. all databases are closed. unless destructive == false, the connection is deleted right after the call

bool  isConnected ()

Returns true if a successful connection has been established.

bool  saveStatus ()

Returns true if a the connection will be saved in config files

void  setSaveStatus (bool status)

sets the save status for this connection. If the save status is true, the connection will be saved in kdbrc

void  setUser (const QString &name)

Sets the user for this connection. The change will not take place until a disconnect/connect is made.

QString  user ()

Returns the user for this connection.

QString  plugin ()

Returns the plugin name of this connection.

void  setPassword (const QString &pwd, bool save = false)

Sets the password for this connection. The change will not take place until a disconnect/connect is made. Passing QString::null will force the connection to ask for the password next time open is called.

QString  password ()

Returns the password for this connection.

QString  host ()

Returns the host name for this connection.

int  port ()

Returns the port number for this connection.

QString  prettyPrint ()

Returns a complete description of the connection.

Database *  openDatabase (const QString &name)

Open a database by name.

Database *  findDatabase (const QString &name)

Return a database by name. If no database with this name exists it returns 0L.

Database *  createDatabase (const QString &name)

Creates a new database in the current connection.

bool  dropDatabase (const QString &name)

Drops a database

DatabaseList  databases ()

Return a list of all available databases.

DatabaseIterator  begin ()

Return an iterator that points to the first database.

void  saveToConfig ( KConfigBase *config, int number = 0)

saves this connection to the given config file, with an optional connection number. The config file must exists and must refer to the correct section.

void  beginTransaction ()

start a transaction for the current connection an error is raised if the underlying DBMS does not support transactions

void  commit ()

end the current transaction and save all the changes to the database. an error is raised if the underlying DBMS does not support transactions or if there isn't any transaction started

void  rollback ()

end the current transaction and drop all changes made up to now. an error is raised if the underlying DBMS does not support transactions or if there isn't any transaction started

void  slotDeleteYourself ()

[slot]

void  closing (KDB::Connection *)

[signal]

void  opened ()

[signal]

void  databaseAdded ( QString )

[signal]

void  databaseRemoved ( QString )

[signal]