by date
Plan for Ryan VanIderstine
Plan for Ryan VanIderstine
| Name: | Ryan VanIderstine | |
|---|---|---|
| Date Posted: | Jun 14, 2002 | |
| Rating: |  Not Rated | |
| Public: | NO | |
| Comments: | YES | |
| RSS Feed: |  or Subscribe with  . | |
| Profile Page: | View profile page for Ryan VanIderstine |
Blog post
I am working on the TubettiWorld project with Ken as a C++ and script developer. My background is principly business applications but it pretty much runs the gambit of easy to hard.
One of the primary additions I have added to the TubettiWorld game, or generically the Torque engine, is a new database independent layer sub-system. A small shim of code is compiled into the game which contains no specific references to any particular vender. During the game startup in script you specify the database type and connection information and from that point can execute sql as required. In order to provide the flexibility we were looking for the actual database connection and query code is isolated into a loadable module (.dll, .so) that is loaded on demand. We currently only have a mysql database provider but I intend to construct an oracle provider and may do an ado provider as well. When a query is executed it gets interesting. The query object returned to the script can reference the fields of the query as if they were properties so you can have code like the following:
When I get some time I will clean it up, perhaps add some additional functionality and post it for anyone that would like.
One of the primary additions I have added to the TubettiWorld game, or generically the Torque engine, is a new database independent layer sub-system. A small shim of code is compiled into the game which contains no specific references to any particular vender. During the game startup in script you specify the database type and connection information and from that point can execute sql as required. In order to provide the flexibility we were looking for the actual database connection and query code is isolated into a loadable module (.dll, .so) that is loaded on demand. We currently only have a mysql database provider but I intend to construct an oracle provider and may do an ado provider as well. When a query is executed it gets interesting. The query object returned to the script can reference the fields of the query as if they were properties so you can have code like the following:
%query = $db.execQuery("select * from table");
while !%query.isEof() {
echo( %query.field_name );
%query.moveNext();
}When I get some time I will clean it up, perhaps add some additional functionality and post it for anyone that would like.
Submit your own resources!| Yacine Salmi (Jun 14, 2002 at 21:03 GMT) |
That's pretty cool. I do hope you share it with the rest of us. Goodluck with Tubettiworld.
| Davis Ray Sickmon, Jr (Jun 14, 2002 at 21:07 GMT) |
| Ken Finney (Jun 14, 2002 at 23:00 GMT) |
You must be a member and be logged in to either append comments or rate this resource.
