Version 1 of XOSql

Updated 2004-01-30 17:57:51

What: XDobry

Where: http://www.xdobry.de/xosql

Description: XOSql is XOTcl genaral wraper for many tcl sql interfaces. It was primary used to provide db independent sql access in projects XOTclIDE and xdobry.

Updated: 01/2004.

Contact: mailto:[email protected] (Artur Trzewik)

Supported tcl sql interfaces:

1. mysqltcl
2. tclodbc
3. PostgreSQL throw pgtcl
4. sqlite

Features:

1. introspection of connect parameters
2. schema queries (getTables)
3. tk connecting dialog
4. really oo interface. queries are XOTcl objects

Sample interactive XOSql usage

   % package require XOTcl
   1.1
   % namespace import xotcl::*
   % package require xdobry::sql
   0.55
   % Sqlinterface loadInterface mysqltcl
   MySql
   % MySql create mysql
   ::mysql
   % mysql getconnectargs
   {hostname text localhost} {socket text {}} {port integer 3306} {user text {}} {password password {}} {dbank text {}}
   % mysql connect {user root dbank xotcllib}
   1
   % mysql getTables
   Component ComponentObject ComponentRequire Configmap ConfigmapChildren ConfigmapComponent Info Method Mysequence Object ObjectMethod     Userlib
   % mysql query {select * from Component}
   ::mysql::__#0
   % ::mysql::__#0 rows
   436
   % ::mysql::__#0 columnNames
   componentid name defcounter basedon timestamp versioninfo isclosed userid infoid
   % ::mysql::__# fetch
   46 xdobry::FormServer 1 {} 20011017183902 {[import] 1.0} 1 1 {}
   % ::mysql::__#0 destroy
   % mysql disconnect
   0