Re: Creating a EOModel in code
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