• 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: Creating a EOModel in code
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Creating a EOModel in code


  • Subject: Re: Creating a EOModel in code
  • From: OCsite via Webobjects-dev <email@hidden>
  • Date: Mon, 29 Jun 2020 13:14:58 +0200

Don,

we do something remotely similar all the time (not creating a complete model,
but adding attributes dynamically at launch to entities). Works without a
glitch, I cannot recall any problem at all with this.

Should work for you as well, I would be rather surprised if you encounter any
problems model-side.

Potential problems might possibly occur at the database side: how do you read
the schema in? We tried lots of things, eventually decided to stick with
low-level DB-specific approach like e.g.,

def sch_list=EOUtilities.rawRowsForSQL(ec,model.name,'select "SCHEMA_PK",
"SCHEMA_NAME" from INFORMATION_SCHEMA.SCHEMATA',null)
def table_list=EOUtilities.rawRowsForSQL(ec,model.name,/select "TABLE_PK",
"TABLE_NAME" from INFORMATION_SCHEMA.TABLES where "SCHEMA_PK"=$schemaPK/,null)

and so forth, which seem to work reliably for our FrontBase. None of the
higher-level APIs we have tried worked reliably for us (note though we not only
read the schema in, but also need to add columns to tables dynamically;
presumably, you won't need that).

All the best,
OC

> On 28 Jun 2020, at 17:51, Don Lindsay via Webobjects-dev
> <email@hidden> wrote:
>
> Sorry if I was not clear in my first email.
>
> I don’t want to create a EOModel file.  I want to take database connection
> properties from the user of an application and use those to build an EOModel
> that is used in the application while it is running on the server.  The
> database connection parameters would be stored in a settings database and
> retrieved when the user wants to load data from that connection.  This is a
> tool to allow users to specify their own data sources and compare data
> between different datasources in whatever manner the user wishes to compare
> or display it.
>
> Thanks for all the answers so far I was not aware Apache Cayenne could be
> used as a full replacement for EOF
>
> Don
>
>
>> On Jun 25, 2020, at 20:53, Don Lindsay via Webobjects-dev
>> <email@hidden> wrote:
>>
>> Hello;
>>
>> The Documentation for EOModel states that you can build one in code, but
>> there are no examples or further information that I can find.  Does anyone
>> have any documentation or samples that they can direct me to so I can create
>> EOModels while the application is running:
>>
>> What I want to do is connect to a database that my app does not know about,
>> someone provides connection parameters and I create an EOModel and connect
>> to that database or rest and access it using the EOModel created using new
>> EOModel().
>>
>> Thanks
>>
>> Don
>> _______________________________________________
>> 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

 _______________________________________________
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: Creating a EOModel in code
      • From: Don Lindsay via Webobjects-dev <email@hidden>
References: 
 >Creating a EOModel in code (From: Don Lindsay via Webobjects-dev <email@hidden>)
 >Re: Creating a EOModel in code (From: Don Lindsay via Webobjects-dev <email@hidden>)

  • Prev by Date: Re: Creating a EOModel in code
  • Next by Date: Looks like an OSC must be disposed manually?!? (was: background tasks locked, workers run all right)
  • Previous by thread: Re: Creating a EOModel in code
  • Next by thread: Re: Creating a EOModel in code
  • Index(es):
    • Date
    • Thread