Ticket #1588 (closed defect: fixed)

Opened 9 months ago

Last modified 9 months ago

Oracle building schema does not detect foreign keys

Reported by: tchakkapark Owned by: jwage
Priority: major Milestone: 1.1.0-ALPHA1
Component: Import/Export Version: 1.1-DEV
Severity: Keywords: oracle foreign keys
Cc: Has Test: no
Status: Pending Core Response Has Patch: no

Description (last modified by tchakkapark) (diff)

I am using Symfony 1.1 with the sfDoctrinePlugin along with PHP version 5.2.6. I've confirmed that this happens with the 1.0.x version of Doctrine, as well as the latest 1.1 version of doctrine in SVN (changeset 5110).

When reverse-engineering using 

symfony doctrine:build-schema

In Oracle, the schema.yml gets generated, but lacks any foreign key definitions. I can understand that it wouldn't be able to guess if a foreign key is 1:1, 1:n, n:n, but it would be nice to have the foreign keys be detected with some placeholder to fill in the relation mapping.

Change History

Changed 9 months ago by tchakkapark

  • keywords oracle foreign keys added
  • description modified (diff)

Changed 9 months ago by jwage

Since none of the devs have access to oracle can you provide a patch or access to a server with oracle for us to test against so we can write a patch for the Doctrine_Import_Oracle class?

Changed 9 months ago by tchakkapark

I'd love to.

Do you guys use Hamachi? I can give access to one of my dev servers that run Oracle and give you connection details.

Changed 9 months ago by jwage

I don't know what Hamachi is, so I suppose we don't :)

Changed 9 months ago by tchakkapark

It's a free-to-use VPN software. My server is closed from outside access, so to give access, we use Hamachi.

 https://secure.logmein.com/products/hamachi/vpn.asp?lang=en

If you'd like to coordinate this:

AIM: Personalife Yahoo: hiroki_kanada MSN: ranmaguy@…

Changed 9 months ago by adrive

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

(In [5111]) [1.0, 1.1] Fixes #1588: Oracle building schema does not detect foreign keys

Changed 9 months ago by adrive

(In [5112]) Merged changes from 5110 branch 1.0: Fixes #1588

Changed 9 months ago by tchakkapark

Thanks! Have tested and confirmed as working.

Note: See TracTickets for help on using tickets.