Re: Creating a EOModel in code
Re: Creating a EOModel in code
- Subject: Re: Creating a EOModel in code
- From: Don Lindsay via Webobjects-dev <email@hidden>
- Date: Mon, 29 Jun 2020 11:16:09 -0400
Thanks for the information. This may be the path I will need to go down for
this specific project.
Thanks
Don
> On Jun 29, 2020, at 07:14, OCsite <email@hidden> wrote:
>
> 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 <mailto: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 <mailto: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
>>> <mailto: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
>> <mailto: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