| Info |
|---|
|
We currently support MS SQL Server, mySQL and H2 (for Express editions) databases. We would be happy to assist anyone in the community with the construction of additional dbgateway components; especially keen to see Oracle and Postgres support. |
| Tip |
|---|
Implemented in FarCry 6.1.0 |
| Excerpt |
|---|
FarCry 6.1 presents a completely refactored database layer. The goal is to make the layer more distinct so that implementing a gateway CFC is enough to add support for a database to FarCry. |
The following outlines the features required and a testing methodology.
...
createData will add an objectid if it is missing and it is the primary key for the schema. However all other uses of these functions require the primary key values to be provided, either in the stProperties struct or as an argument.
| Code Block |
|---|
|
<cfset db.createData(typename,stProperties,dsn) /> |
| Code Block |
|---|
|
<cfset db.setData(typename,stProperties,dsn) /> |
| Code Block |
|---|
|
<cfset db.getData(typename,*objectid,*bDepth,*fields,dsn) /> |
| Info |
|---|
|
- ObjectID ... or whatever the primary key is for the schema. Get can be used for simple array properties by specifying parentid and seq
- bDepth (defaults to 1)
0: Everything (with full structs for all array field elements)
1: Everything (only extended array field as structs)
2: No array fields
3: No array or longchar fields - fields - Overrides the default fields returned. NOTE: the bDepth field may restrict the list further.
|
| Code Block |
|---|
|
<cfset db.deleteData(typename,*objectid,dsn) /> |
...