• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: import from an external DB
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: import from an external DB


  • Subject: Re: import from an external DB
  • From: Chuck Hill <email@hidden>
  • Date: Mon, 22 Feb 2016 18:18:00 +0000
  • Thread-topic: import from an external DB

It sounds to me like sharing the model would be less effort.  Rather than use rawRowsForSQL you can just make regular fetch specs and tell them to fetch raw rows.  You might get more data back than you need, but all the join and name translation etc will be handled for you.

Chuck





On 2016-02-21, 6:40 AM, "webobjects-dev-bounces+chill=email@hidden on behalf of ocs.cz" <webobjects-dev-bounces+chill=email@hidden on behalf of email@hidden> wrote:

>Hello there,
>
>my web app should occassionally import from an external DB (a database created and maintained by another WO-based application). Just import, and only low-level dictionaries at that, never full-fledged EO-objects. Probably though, the imported tables would be rather big, it would be needed to join them (i.e., import also attributes accessible through a relationship), etc.
>
>Having so far no experience with accessing another DB, I wonder.
>
>Would I gain anything of importance by sharing the model and using EOF for the import (in which case, due to them joins, I am afraid I would have to go as low as to EOUtilities.rawRowsForSQL anyway), or would you rather, in this special case, skip EOF altogether and go DIY at the JDBC level? (The latter approach would lead to reading in the other app's model anyway, but without using the EOF stack over it, just to manually translate entity and property names to tables/columns, nothing more.)
>
>Thanks,
>OC
>
>
> _______________________________________________
>Do not post admin requests to the list. They will be ignored.
>Webobjects-dev mailing list      (email@hidden)
>Help/Unsubscribe/Update your Subscription:
>
>This email sent to email@hidden

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden


  • Follow-Ups:
    • Re: import from an external DB
      • From: OC <email@hidden>
References: 
 >import from an external DB (From: "ocs.cz" <email@hidden>)

  • Prev by Date: Re: ERDDelayedBooleanAssignment question
  • Next by Date: Re: import from an external DB
  • Previous by thread: import from an external DB
  • Next by thread: Re: import from an external DB
  • Index(es):
    • Date
    • Thread