Log of /trunk/sql/mysql/inc/TMySQLStatement.h
Parent Directory
Revision
43515 -
(
view)
(
download)
(
as text)
(
annotate)
-
[select for diffs]
Modified
Tue Mar 27 21:15:53 2012 UTC (2 years, 9 months ago) by
pcanal
File length: 5460 byte(s)
Diff to
previous 43276
Fix coding convention R.RN7 (Avoid the raw C types 'long', 'unsigned long', 'long double', 'bool', 'long long' and 'unsigned long long'.)
Revision
43276 -
(
view)
(
download)
(
as text)
(
annotate)
-
[select for diffs]
Modified
Wed Mar 7 17:13:42 2012 UTC (2 years, 10 months ago) by
pcanal
File length: 5482 byte(s)
Diff to
previous 29976
Coverity number 35355,35805,35666,35708,35511,35782,35782,35642,35787,35796,35653,35806,35667,
35670,35809,35810,35671,35673,35812,35688,35283,35824,35689,35825,35690,35691,35826,35827,35692,
35635,35636,35275
about missing operator= and/or copy constructors.
Revision
16204 -
(
view)
(
download)
(
as text)
(
annotate)
-
[select for diffs]
Modified
Tue Sep 5 13:37:08 2006 UTC (8 years, 4 months ago) by
brun
Original Path:
trunk/mysql/inc/TMySQLStatement.h
File length: 5143 byte(s)
Diff to
previous 15625
From Sergey Linev:
1. Support of date/time/date&time/timestamp data introduced in TSQLStatement
All such data now can be accessed without text conversion.
The following methods can be used:
SetTime()/GetTime() - only time (hour:min:sec),
SetDate()/GetDate() - only date (year-month-day),
SetDatime()/GetDatime() - date and time
SetTimestamp()/GetTimestamp() - timestamp with seconds fraction
For some of these methods TDatime type can be used as parameter / return value.
Be aware, that TDatime supports only dates after 1995-01-01.
There are also methods to get separately year, month, day, hour, minutes and seconds.
2. Support of binary data in TSQLStatement
Most of modern data bases support just binary data, which is
typically has SQL type name 'BLOB'. To access data in such
columns, GetBinary()/SetBinary() methods should be used.
Current implementation supposes, that complete content of the
column must be retrieved at once. Therefore very big data of
gigabytes size may cause a problem.
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/TMySQLStatement.h
File length: 4088 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/TMySQLStatement.h
File length: 3942 byte(s)
Diff to
previous 14679
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
14675 -
(
view)
(
download)
(
as text)
(
annotate)
-
[select for diffs]
Added
Wed Apr 12 20:53:45 2006 UTC (8 years, 9 months ago) by
rdm
Original Path:
trunk/mysql/inc/TMySQLStatement.h
File length: 3818 byte(s)
From Sergei Linev:
Added TSQLStatment abstract class and TMySQLStatment and TOracleStatement
classes to support bulk DB operations. For more details see the description
in the TSQLStatement.cxx file.
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.
