Log of /trunk/sql/mysql/src/TMySQLServer.cxx
Parent Directory
Revision
30501 -
(
view)
(
download)
(
as text)
(
annotate)
-
[select for diffs]
Modified
Mon Sep 28 10:56:29 2009 UTC (5 years, 3 months ago) by
brun
File length: 26241 byte(s)
Diff to
previous 26487
From Sergey Linev:
small add on for TMySQLServer constructor to solve a problem with automatic reconnect.
One is also able to specify custom config file, where many other mysql options can be redefined.
Revision
25637 -
(
view)
(
download)
(
as text)
(
annotate)
-
[select for diffs]
Modified
Wed Oct 1 09:49:57 2008 UTC (6 years, 3 months ago) by
brun
File length: 23475 byte(s)
Diff to
previous 23469
From Sergei Linev:
1. Support of MEDIUMBLOB and LONGBLOB binary types in TMySQLStatement
2. Support of read_timeout and write_timeout parameters in TMySQLServer connect string.
Read/write timeout only works on Windows or with newest version of MySQL.
Revision
16517 -
(
view)
(
download)
(
as text)
(
annotate)
-
[select for diffs]
Modified
Fri Oct 13 07:33:16 2006 UTC (8 years, 3 months ago) by
brun
Original Path:
trunk/mysql/src/TMySQLServer.cxx
File length: 21054 byte(s)
Diff to
previous 16384
From Sergey Linev:
1. Workaround for Oracle ODBC driver for Linux. Number of fetched rows is
not set,
therefore one should calculate this number ourself.
2. TODBCServer::GetDrivers() and TODBCServer::GetDataSources() static
methods are implemented.
They provide information about available configured ODBC drivers and data
sources respectively.
Also PrintDrivers() and PrintDataSources() methods are implemented.
3. TODBCServer::ServerInfo() method is implemented. It nows returns server
name and version like:
"Oracle 10.01.0030" or "MySQL 4.1.11"
TMySQLServer::ServerInfo() modified to return info in form: "MySQL
4.1.11"
4. TODBCServer::GetTablesList() modified in respect of Oracle ODBC driver
functionality -
wildcarding is now works correctly.
Revision
16162 -
(
view)
(
download)
(
as text)
(
annotate)
-
[select for diffs]
Modified
Wed Aug 30 12:55:09 2006 UTC (8 years, 4 months ago) by
brun
Original Path:
trunk/mysql/src/TMySQLServer.cxx
File length: 20904 byte(s)
Diff to
previous 15815
From Sergey Linev:
1. Lightweight support of DATE, TIME, DATETIME and TIMESTAMP SQL types for mysql plugin.
Now stmt->GetString() and stmt->GetInt() calls return meaningfull infotmation for that types.
In the future I will add methods like stmt->GetDate() for all SQL plugins.
2. Fix error with reading of unsigned data types from MySQL.
I was ignoring this flag, therefore methods like GetUInt(), GetULong() were not working
properly.
3. Support of TEXT/BLOB types in TMySQLStatement.
There are several small changes, which allows to read BLOB/TEXT data with TSQLStatement methods.
I also modify TMySQLServer::GetTableInfo() method to provide correct metainformation about
BLOB/TEXT columns.
Revision
15538 -
(
view)
(
download)
(
as text)
(
annotate)
-
[select for diffs]
Modified
Sun Jun 25 18:43:24 2006 UTC (8 years, 7 months ago) by
brun
Original Path:
trunk/mysql/src/TMySQLServer.cxx
File length: 18718 byte(s)
Diff to
previous 15305
From Sergey Linev:
1. Support for MySQL version 3.2.x and 4.0 enabled again. For that old MySQL versions TSQLStatement is not supported.
2. Small fix in TSQLFile. With old MySQL versions it does not try to use TSQLStatement class.
3. Enabling/disabling error output for TSQLStatement class.
4. Fix in error handling in TMySQLServer::Statement() method. Previousely error code was not correctly stored.
Revision
15305 -
(
view)
(
download)
(
as text)
(
annotate)
-
[select for diffs]
Modified
Fri Jun 2 14:02:03 2006 UTC (8 years, 7 months ago) by
brun
Original Path:
trunk/mysql/src/TMySQLServer.cxx
File length: 18002 byte(s)
Diff to
previous 15124
From Sergey Linev:
1. New methods of TSQLServer class (also for Oracle, MySQL, ODBC):
Exec() - execute query which does not produce any result
GetTablesList() - return list of tables names in data-base independent form
IsTableExists() - check if table of given name exists
GetTableInfo() - returns instance of TSQLTableInfo with list of columns.
2. New methods of TSQLStatement class (also for Oracle, MySQL, ODBC):
IsNull() - checks, if field value is NULL
SetNull() - sets parameter value to NULL
New TSQLTableInfo contains information about table and table columns.
For MySQL additional information like engine type, creation and last update time is provided
New TSQLColumnInfo class contains information about single column from SQL table
Has following methods:
GetTypeName() - field type name in string form as it is reported by correspondent
database method. Some databases providing full type name like "numeric(20)",
other showing only "NUMERIC". As a result, one cannot use this string directly
to create new field of similar types in other table
IsNullable() - says if field value can be NULL or not
GetSQLType() - returns kind of sql type. Possible values:
TSQLServer::kSQL_NONE data type unknown
TSQLServer::kSQL_CHAR CHAR(n) - string with fixed length n
TSQLServer::kSQL_VARCHAR VARCHAR(n) - string with variable length upto n
TSQLServer::kSQL_INTEGER INTEGER, INT, TINYINT - any integer types
TSQLServer::kSQL_FLOAT FLOAT - float value
TSQLServer::kSQL_DOUBLE DOUBLE - double precision value
TSQLServer::kSQL_NUMERIC NUMERIC(n,s), NUMBER(n,s) - numeric values with length and precion
TSQLServer::kSQL_BINARY BLOB, VARBINARY - binary data (vriable or fixed size)
TSQLServer::kSQL_TIMESTAMP TIMESTAMP - time and date stamp
GetSize() - size of field in database. -1 if not known.
GetLength() - length argument in type declaration like CHAR(len) or NUMERIC(len), -1 if not defined
GetScale() - second argument in declarations like NUMERIC(len, s), -1 if not defined
GetSigned() - is type signed(==1) or unsigned(==0), -1 if not defined
Revision
15124 -
(
view)
(
download)
(
as text)
(
annotate)
-
[select for diffs]
Modified
Mon May 22 08:55:30 2006 UTC (8 years, 8 months ago) by
brun
Original Path:
trunk/mysql/src/TMySQLServer.cxx
File length: 9960 byte(s)
Diff to
previous 15063
From Sergei Linev:
1. Error handling is introduced. Now TSQLServer/TSQLStatement returns error code - GetErrorCode()
and message - GetErrorMsg() of last operation.
If desired, error output can be suppressed for TSQLServer. Correspondent changes done in implementation
for Oracle, MySQL, ODBC
2. New methods of TSQLServer class for transactions control: StartTransaction() / Commit() / Rollback().
As desfault implmenetaion in TSQLServer class they corresopnd to SQL "START TRANSACTION", "COMMIT", "ROLLBACK" queries.
For Oracle, MySQL and ODBC specific implmentaion were done while there special methods should be called.
3. Some other new methods of TSQLServer class:
IsSupportStatement() - return kTRUE if plugin has TSQLStatement implementation
GetMaxIdentifierLength() - return maximum allowed length of identifiers
4. Bugfix in TODBCRow class
This form allows you to request diffs between any two revisions of this file.
For each of the two "sides" of the diff,
enter a numeric revision.
