Ticket #676 (task)

Opened 1 year ago

Last modified 11 months ago

ActiveRecord Oracle Drives

Status: closed (fixed)

Reported by: marcosanobre Assigned to: mnobre
Priority: urgent Milestone: 3.1.1
Component: Prado Framework v3 Version: 3.1
Severity: minor Keywords: Oracle ActiveRecord driver
Cc:

This pack of files provides to a prado ActiveRecord? functionalities a gateway to work with Oracle Database.

Basicaly, the the heavy work was concentrated onto this files: TOracleCommandBuilder, TOracleTableInfo, TOracleMetaData, TOracleTableColumn. I put them under Oracle direcotry under my C:\programs files\xampp\htdocs\prado3\framework\Data\Common.

The main work here was to translate / convert the PgSQL files into Oracle compliant ones. I have Tested and debugged this files and by now (for this moment) I have Oracle ActiveRecord? classes running to me (for my Application).

I am needing some help in doing prado-cli well running in Windows NT/2000/XP command-shell window. I have seriuos problems in do it. But creating my AR class by hand and using it into my App, it runs very well.

MN.

Attachments

Oracle.zip (12.6 kB) - added by marcosanobre on 07/24/2007 02:49:35 PM.
Oracle.2.zip (7.7 kB) - added by marcosanobre on 07/26/2007 09:29:00 AM.
Oracle3.zip (7.4 kB) - added by marcosanobre on 08/22/2007 09:33:31 AM.
latest Oracle AR class files.

Change History

07/24/2007 02:49:35 PM: Modified by marcosanobre

  • attachment Oracle.zip added.

07/24/2007 02:56:32 PM: Modified by marcosanobre

Pay attention to modified TDbMetaData.php file that goes with a modified php switch/case instruction to consider a connection string that using a PDO_OCI Oracle driver.

The peace modified code looks like: ...

case 'oci':

Prado
using('System.Data.Common.Oracle.TOracleMetaData');

return new TOracleMetaData($conn); ...

Good lucky.

MN.

07/26/2007 08:13:57 AM: Modified by tof06

  • status changed from new to closed.
  • resolution set to fixed.

Added. Thanks

07/26/2007 09:28:32 AM: Modified by marcosanobre

  • status changed from closed to reopened.
  • resolution deleted.

Hi all.

I have carefuly tested this pakage drives and have solved heavy seriuos problems with: a) upper and lower cased columns names; b) using of LIMITs sql clause on Oracle Database;

So I will post (upload) the package again.

BTW, my environment of dev/test this class-files was Oracle 10g over WinXP plataform. If someone has any other environment, please test over it and report here some sort of problems.

TIA: MN.

07/26/2007 09:29:00 AM: Modified by marcosanobre

  • attachment Oracle.2.zip added.

08/22/2007 09:32:10 AM: Modified by marcosanobre

Hi all Oracle AR users.

I need to re-write all Oracle-AR drives files and I suggest this updating.

For now, Oracle-AR drivers are prepared to do: 1) all find AR style methods; 2) find with critheria ( corrected using of LIMITs ); 3) save() and delete() AR methods ar OK;

BTW, define your Database TABLE AR classes in LOWERCASE.

(for this, get Oracle3.zip file)

TIA:

MN.

08/22/2007 09:33:31 AM: Modified by marcosanobre

  • attachment Oracle3.zip added.

latest Oracle AR class files.

09/04/2007 09:58:39 AM: Modified by xue

  • version changed from 3.0 to 3.1.
  • milestone set to 3.1.1.

09/04/2007 01:14:23 PM: Modified by xue

  • status changed from reopened to closed.
  • resolution set to fixed.

Thanks!