Log of /trunk/sql/mysql/inc/TMySQLServer.h
Parent Directory
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/inc/TMySQLServer.h
File length: 2108 byte(s)
Diff to
previous 15538
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
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/inc/TMySQLServer.h
File length: 2058 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/inc/TMySQLServer.h
File length: 2075 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/inc/TMySQLServer.h
File length: 1929 byte(s)
Diff to
previous 14675
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.
