A struct representing a database connection.
An exception type to distinguish exceptions thrown by this module.
Received invalid data from the server which violates the MySQL network protocol.
The server sent back a MySQL error code and message. If the server is 4.1+, there should also be an ANSI/ODBC-standard SQLSTATE error code.
Type of Command Packet (COM_XXX)
Field Flags
Server refresh flags
Magic marker sent in the first byte of mysql results in response to auth or command packets
Column type codes
Server capability flags.
Returns N number of bytes from the packet and advances the array
Parse Length Coded String
Decodes a Length Coded Binary from a packet
Decodes a Length Coded Binary from a packet
Extract number of bytes used for this LCB
Function to pack a TimeOfDay into a binary encoding for transmission to the server.
Function to pack a Date into a binary encoding for transmission to the server.
Function to pack a DateTime into a binary encoding for transmission to the server.
Converts a value into a sequence of bytes and fills the supplied array
Parse Length Coded Binary
Set packet length and number. It's important that the length of packet has already been set to the final state as its length is used
Skips over n items, advances the array, and return the newly advanced array to allow method chaining
Function to extract a Date from a binary encoded row.
Function to extract a Date from a text encoded column value.
Function to extract a DateTime from a binary encoded row.
Function to extract a DateTime from a text encoded column value.
Function to extract a DateTime from a ulong.
Function to extract a time difference from a binary encoded row.
Function to extract a time difference from a text encoded column value.
Function to extract a TimeOfDay from a binary encoded row.
Function to extract a TimeOfDay from a text encoded column value.
A struct to hold column metadata
A struct to represent specializations of prepared statement parameters.
Encapsulation of an SQL command or query.
Composite representation of a column value
A struct representing an EOF packet from the server
A struct representing a field (column) description packet
Length Coded Binary Value
Length Coded String
Facilities to recover meta-data from a connection
A struct to hold stored function metadata
A struct representing an OK or Error packet
A struct representing a prepared statement parameter description packet
A struct to represent specializations of prepared statement parameters.
A struct representing the collation of a prepared statement parameter description sequence
An input range of Rows.
A Random access range of Rows.
A struct representing the collation of a sequence of FieldDescription packets.
A struct to represent a single row of a result set.
A simple struct to represent time difference.
A D struct to stand for a TIMESTAMP
A native D driver for the MySQL database system. Source file mysql.d.
This module attempts to provide composite objects and methods that will allow a wide range of common database operations, but be relatively easy to use. The design is a first attempt to illustrate the structure of a set of modules to cover popular database systems and ODBC.
It has no dependecies on GPL header files or libraries, instead communicating directly with the server via the published client/server protocol.
http://dev.mysql.com/doc/internals/en/client-server-protocol.html
This version is not by any means comprehensive, and there is still a good deal of work to do. As a general design position it avoids providing wrappers for operations that can be accomplished by simple SQL sommands, unless the command produces a result set. There are some instances of the latter category to provide simple meta-data for the database,
Its primary objects are:
$(LIAn input range of similar rows.)
There are numerous examples of usage in the unittest sections.
The file mysqld.sql, included with the module source code, can be used to generate the tables required by the unit tests.
This module supports both Phobos sockets and http://vibed.org/, Vibe.d sockets. Vibe.d support is disabled by default, to avoid unnecessary depencency on Vibe.d. To enable Vibe.d support, use: -version=Have_vibe_d
If you compile using https://github.com/rejectedsoftware/dub, DUB, and your project uses Vibe.d, then the -version flag above will be included automatically.
This requires DMD v2.061 or later, and a MySQL server v4.1.1 or later. Older versions of MySQL server are obsolete, use known-insecure authentication, and are not supported by this module.
There is an outstanding issue with Connections. Normally MySQL clients sonnect to a server on the same machine via a Unix socket on *nix systems, and through a named pipe on Windows. Neither of these conventions is currently supported. TCP must be used for all connections.