[root] / trunk / net / net / inc / TSQLStatement.h Repository:
ViewVC logotype

Log of /trunk/net/net/inc/TSQLStatement.h

Parent Directory Parent Directory

Links to HEAD: (view) (download) (as text) (annotate)
Sticky Revision:
Revision 28011 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Tue Mar 31 15:54:10 2009 UTC (5 years, 9 months ago) by pcanal
File length: 5836 byte(s)
Diff to previous 27990 
Temporarily (?) hide the member function of TSQLStatement that have std::vector as argument.  Generating the dictionary for those functions currently means that we need to load the whole vector.dll at startup time since the "net" package is part of libCore.  Loading vector.dll requires a significant amount of memory and thus we had decided _not_ to load it by default.  A priori this requirement can not be lifted without change to cint (which have to wait until later)
Revision 27990 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Mon Mar 30 14:33:07 2009 UTC (5 years, 9 months ago) by brun
File length: 5780 byte(s)
Diff to previous 23091 
From Sebastien Ponce and Sergei Linev:
Two little extensions to the ROOT classes dealing with SQL and more
precisely ORACLE Statement and Server :
  - added possibility to connect to ORACLE in object mode, by adding to
    the connection URL an argument like "?ObjectMode=yes"
  - added vector interfaces for numeric data in the sqlStatement class
    and its implementation in ORACLE
Revision 23091 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Wed Apr 9 15:04:27 2008 UTC (6 years, 9 months ago) by rdm
File length: 4593 byte(s)
Copied from: trunk/net/inc/TSQLStatement.h revision 23090
Diff to previous 20882 
moving the follwing directories to "net":

alien, auth, glite, globusauth, krb5auth, ldap, monalisa, net, netx,
rootd, rpdutils, srputils, xrootd
Revision 20882 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Mon Nov 19 11:31:26 2007 UTC (7 years, 2 months ago) by rdm
Original Path: trunk/net/inc/TSQLStatement.h
File length: 4593 byte(s)
Diff to previous 19826 
Set property svn:eol-style LF on all source and Makefiles. This should avoid
problems with Win32 line endings ending up in the repository. All MS tools
support LF eols fine.
Revision 19826 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Wed Sep 19 19:56:11 2007 UTC (7 years, 4 months ago) by rdm
Original Path: trunk/net/inc/TSQLStatement.h
File length: 4593 byte(s)
Diff to previous 19825 
imported svn:keywords Id property
Revision 19825 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Wed Sep 19 19:49:10 2007 UTC (7 years, 4 months ago) by rdm
Original Path: trunk/net/inc/TSQLStatement.h
File length: 4646 byte(s)
Diff to previous 19293 
remove :$ from tag line
Revision 19293 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Mon Jul 9 18:53:27 2007 UTC (7 years, 6 months ago) by brun
Original Path: trunk/net/inc/TSQLStatement.h
File length: 4656 byte(s)
Diff to previous 16204 
From Sergey Linev:
1. New virtual method TSQLStatement::SetMaxFieldSize(). It implemented for now only for Oracle and
   specifies maximum size in bytes, which should be used for field in read/write operation.

2. Improved implementation of TOracleStatement::GetBinary method. Now not only BLOB, but also
   CLOB, LONG, BFILE, CFILE Oracle datatypes are supported for reading. Fow now BFILE and CFILE
   not supported for writing.
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/net/inc/TSQLStatement.h
File length: 4583 byte(s)
Diff to previous 15538 
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/net/inc/TSQLStatement.h
File length: 3000 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/net/inc/TSQLStatement.h
File length: 2797 byte(s)
Diff to previous 15168 
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 15168 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Wed May 24 15:10:47 2006 UTC (8 years, 8 months ago) by brun
Original Path: trunk/net/inc/TSQLStatement.h
File length: 2685 byte(s)
Diff to previous 15124 
Fix coding conventions violations
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/net/inc/TSQLStatement.h
File length: 2669 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
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/net/inc/TSQLStatement.h
File length: 2201 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.

  Diffs between and
  Type of Diff should be a
Sort log by:
Subversion Admin
 ViewVC Help
Powered by ViewVC 1.0.9