GMan's Mods & Stuff — Pub.ISQLDB (WIP)

new updates

null@example.com (gavinb) — Sat, 03 Mar 2007 18:58:05 +0000

hey ya Gman,

Do you still update this module? was looking to use with max 1.24, havent actually treid coz dont wonna muck n e thing up>

fyi . your mod was the reason i returned to max :-)

rebuilt mods for BMAX v1.20

null@example.com (gman) — Wed, 03 May 2006 13:15:20 +0000

i rebuilt and repackaged the mods for BMAX v1.20

repackaged MySQL

null@example.com (gman) — Fri, 03 Mar 2006 02:50:12 +0000

i repackaged the MySQL mod to include the .a file for MySQL 5.0.18

Blobs :S

null@example.com (gavinb) — Wed, 01 Mar 2006 10:08:48 +0000

Hey GMan, just wonder i know its cheeky but i'm kinda desperate, in the mysql u have ways of getting int val's double, long etc, but no way of getting blob data? is this something u could impletement?

a blob is a binary object (i.e used for storing images) and shouldnnt be too hard for u to do

well thanks

linux ;)

null@example.com (gavinb) — Sun, 19 Feb 2006 10:56:00 +0000

hey ya GMan,

n e plans to launch a linux version of the mod?
i have got it to compile on linux by removing the #include because as far as i can see its not used. however if i compile a program using the module i get:

Building main
Compiling:main.bmx
flat assembler  version 1.64
3 passes, 9315 bytes.
Linking:main
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0x57): In function `bmx_mysql_field_name':
mysql.cpp: undefined reference to `mysql_fetch_field_direct'
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0x93): In function `bmx_mysql_insert_id':
mysql.cpp: undefined reference to `mysql_insert_id'
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0xab): In function `bmx_mysql_eof':
mysql.cpp: undefined reference to `mysql_eof'
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0x105): In function `bmx_mysql_field_length':
mysql.cpp: undefined reference to `mysql_fetch_lengths'
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0x136): In function `bmx_mysql_num_rows':
mysql.cpp: undefined reference to `mysql_num_rows'
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0x14a): In function `bmx_mysql_affected_rows':
mysql.cpp: undefined reference to `mysql_affected_rows'
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0x164): In function `bmx_mysql_real_query':
mysql.cpp: undefined reference to `mysql_real_query'
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0x187): In function `bmx_mysql_select_db':
mysql.cpp: undefined reference to `mysql_select_db'
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0x1bc): In function `bmx_mysql_real_connect':
mysql.cpp: undefined reference to `mysql_real_connect'
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0x216): In function `bmx_mysql_init':
mysql.cpp: undefined reference to `mysql_init'
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0x3c): In function `bmx_mysql_real_escape_string':
mysql.cpp: undefined reference to `mysql_real_escape_string'
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0x6c): In function `bmx_mysql_data_seek':
mysql.cpp: undefined reference to `mysql_data_seek'
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0x7e): In function `bmx_mysql_free_result':
mysql.cpp: undefined reference to `mysql_free_result'
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0xc6): In function `bmx_mysql_fetch_row':
mysql.cpp: undefined reference to `mysql_fetch_row'
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0xda): In function `bmx_mysql_use_result':
mysql.cpp: undefined reference to `mysql_use_result'
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0xee): In function `bmx_mysql_store_result':
mysql.cpp: undefined reference to `mysql_store_result'
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0x11e): In function `bmx_mysql_num_fields':
mysql.cpp: undefined reference to `mysql_num_fields'
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0x1dc): In function `bmx_mysql_error':
mysql.cpp: undefined reference to `mysql_error'
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0x1f4): In function `bmx_mysql_errno':
mysql.cpp: undefined reference to `mysql_errno'
/home/gavin/bin/BlitzMax/mod/pub.mod/mysql.mod/mysql.release.linux.a(mysql.cpp.release.linux.o)(.text+0x20a): In function `bmx_mysql_close':
mysql.cpp: undefined reference to `mysql_close'
collect2: ld returned 1 exit status
Build Error: Failed to link /home/gavin/Desktop/game/main
Process complete

i have moved the lib file to the right location as well

proposed new interface additions

null@example.com (gman) — Fri, 20 Jan 2006 15:42:08 +0000

the following are additions i am proposing to the current interface. questions/comments would be much appreciated.

' additions to the existing ISQLDB type
Type ISQLDB

    ' driver supports transactions
    Const FETR_TRANSACTIONS:Int 
    ' driver supports transaction save points
    Const FETR_TRANSACTION_SAVEPOINTS:Int 
    ' driver supports keeping results on the server
    Const FETR_FETCH_ON_DEMAND:Int 
    ' can prepare statements
    Const FETR_PREPARED_STMTS:Int    
    
    ' returns True if the implementation supports the passed feature
    Method hasFeature:Int(feature:Int) Abstract 
    
    ' same as the MySQL implementation, but with the addition of hasFeature can now be moved here
    Method setPrefetch:Int(bPrefetch:Int=True) Abstract 

    ' passed string contains only text
    Const ESCT_STRING:Int 
    ' passed string has binary values
    Const ESCT_BINARY_STRING:Int 
    ' escape a string to make it compatible with the native engine
    Method escapeString:String(stmt:String,esc_type:Int=ESCT_STRING) Abstract 

    ' creates a transaction object to be used with commands
    Method BeginTransaction:ISQLTransaction(Options:String) Abstract 
    ' creates a command object for use by the driver
    Method CreateDBCommand:ISQLCommand(Transaction:ISQLTransaction = Null) Abstract 
    
    ' returns the version info for the native server
    Method getNativeServerVer:String() Abstract
    ' returns the version info for the native client
    Method getNativeClientVer:String() Abstract
    ' returns the version info for the driver implementation
    Method getISQLDriverVer:String() Abstract
    ' returns "about" type information regarding the driver implementation
    Method getISQLDriverInfo:String() Abstract
EndType

' type enabling transaction support and performing transaction functionality
Type ISQLTransaction
    ' commits a transaction
    Method Commit() Abstract
    ' rollsback a transaction
    Method RollBack(SavePoint:String) Abstract  ' Save Points are better for nesting... and method used by SQL Standards
    ' begins a transaction
    Method BeginTransaction(SavePoint:String) Abstract   
EndType

' collection of parameters
Type ISQLParmeterCollection Extends TMap
    ' creates a new parameter object, sets its value, adds to collection, and returns it
    Method addParam:ISQLParameter(pname:String,value:String,ptype:Int=TYPE_STRING) Abstract
    ' removes a parameter from the collection.  returns true if successful.
    Method removeParam:Int(pname:String)
    ' gets the parameter from the collection.
    Method getParam:ISQLParameter(pname:String) Abstract
EndType

' parameter for ISQLCommand
Type ISQLParameter
    
    ' based on this type, the underlying implementation will convert the value
    ' to a format supported by the SQL database engine
    Const TYPE_STRING:Int=0
    Const TYPE_BINARY:Int=1
    Const TYPE_BYTE:Int=2
    Const TYPE_BOOLEAN:Int=3
    Const TYPE_CURRENCY:Int=4
    Const TYPE_DATE:Int=5
    Const TYPE_TIME:Int=6
    Const TYPE_DATETIME:Int=7
    Const TYPE_SHORT:Int=8
    Const TYPE_INT:Int=9
    Const TYPE_LONG:Int=10
    Const TYPE_FLOAT:Int=11
    Const TYPE_DOUBLE:Int=12
    
    ' returns the data type of this parameter
    Method getISQLType:Int() Abstract
    ' sets the data type of this parameter.  default is TYPE_STRING.
    Method setISQLType(isqltype:Int=TYPE_STRING)

    ' gets the parameter value
    Method getVal:String() Abstract
    ' sets the parameter value
    Method setVal(value:String) Abstract
        
    ' gets the parameter name
    Method getName:String() Abstract
    ' sets the parameter name
    Method setName:String() Abstract
    
    ' returns True if the parameter accepts null values
    Method getIsNullable:Int() Abstract
    ' sets whether the value can be Null or not
    Method setIsNullable(bIsNullable:Int) Abstract
            
EndType

' This is what you will need to do  prepared Statements
Type ISQLCommand

    ' this command will run an SQL statement
    Const SQLQUERYCOMMAND=1
    ' this command will run a stored procedure
    Const SQLSTOREDPROCEDURE=2

    ' returns the connection object associated with this command
    Method GetConnection:ISQLDB() Abstract
    
    ' sets the transaction object for this command
    Method SetTransaction(Transaction : ISQLTransaction) Abstract
    ' returns the transaction object for this command
    Method GetTransaction:ISQLTransaction() Abstract
    
    ' sets the command that will run
    Method SetCommandText(SQLStatement:String) Abstract
    ' returns the command set to run
    Method GetCommandText:String() Abstract
    
    ' sets the command type
    Method SetCommandType(SQLCommandType:Int=SQLQUERYCOMMAND) Abstract
    ' returns the command type
    Method GetCommandType:Int() Abstract
    
    ' executes the statement and returns the result set
    Method Execute:ISQLResultSet() Abstract
    ' executes this statement as a scaler and returns either the first row/col 
    ' value or the value of the field passed from the first row
    Method ExecuteScaler:String(field_nm:String=Null) Abstract

    ' gets the parameters collection
    Method getParameters:ISQLParmeterCollection() Abstract

    ' prepares a statement for better performance
    Method Prepare() Abstract
    
EndType

Current Releases (last updated 2006_05_03)

null@example.com (gman) — Wed, 18 Jan 2006 13:57:59 +0000

Dev Status

null@example.com (gman) — Sat, 14 Jan 2006 19:05:14 +0000

nothing really to see yet. i have defined and declared the functions i wish to include in the mod and begun initial testing. i have successfully connected to a server, selected the DB, performed select statements and am currently working on processing the returned results. the goal is then to wrap usage of these functions up into types in a similar fashion as the Irrlicht mods. if all goes well i would like to have this mod wrapped up in the week or so.

stay tuned...