Class Connection
A class representing a database connection.
If you are using Vibe.d, consider using MySQLPool instead of
creating a new Connection directly. That will provide certain benefits,
such as reusing old connections and automatic cleanup (no need to close
the connection when done).
// Suggested usage:
{
auto con = new Connection("host=localhost;port=3306;user=joe;pwd=pass123;db=myappsdb");
scope(exit) con.close();
// Use the connection
...
}
Constructors
| Name | Description |
this
|
Construct opened connection.
|
Properties
| Name | Type | Description |
charSet[get]
|
ubyte | Current character set
|
closed[get]
|
bool | Check whether this Connection is still connected to the server, or if
the connection has been closed.
|
currentDB[get]
|
string | Current database
|
hasPending[get]
|
bool | Gets whether anything (rows, headers or binary) is pending.
New commands cannot be sent on a conncection while anything is pending.
|
lastCommandID[get]
|
ulong | This gets incremented every time a command is issued or results are purged,
so a ResultRange can tell whether it's been invalidated.
|
lastInsertID[get]
|
ulong | After a command that inserted a row into a table with an auto-increment
ID column, this method allows you to retrieve the last insert ID.
|
protocol[get]
|
ubyte | Return the in-force protocol number
|
resultFieldDescriptions[get]
|
FieldDescription[] | Gets the result header's field descriptions.
|
rowsPending[get]
|
bool | Gets whether rows are pending
|
serverCapabilities[get]
|
uint | Server capability flags
|
serverStatus[get]
|
ushort | Server status
|
serverVersion[get]
|
string | Server version
|
socketType[get]
|
MySQLSocketType | Socket type being used
|
Methods
| Name | Description |
acquire
|
Used by Vibe.d's ConnectionPool, ignore this.
|
amOwner
|
Used by Vibe.d's ConnectionPool, ignore this.
|
close
|
Explicitly close the connection.
|
enableMultiStatements
|
Enable multiple statement commands
|
getNextRow
|
Get the next Row of a pending result set.
|
isOwner
|
Used by Vibe.d's ConnectionPool, ignore this.
|
parseConnectionString
|
Parses a connection string of the form
"host=localhost;port=3306;user=joe;pwd=pass123;db=myappsdb"
|
pingServer
|
Check the server status
|
purgeResult
|
Flush any outstanding result set elements.
|
reconnect
|
Reconnects to the server using the same connection settings originally
used to create the Connection.
|
refreshServer
|
Refresh some feature(s) of the server.
|
release
|
Used by Vibe.d's ConnectionPool, ignore this.
|
selectDB
|
Select a current database.
|
serverStats
|
Get a textual report on the server status.
|