Re: Altering EOModel
Re: Altering EOModel
- Subject: Re: Altering EOModel
- From: Pascal Robert <email@hidden>
- Date: Mon, 19 Jan 2009 14:45:18 -0500
Well, EOF coupled with a "standard" SQL RDBMS is not the same thing as
Access, FileMaker or 4D. FileMaker and Access was build for non-
technical people so that they can build small databases themselves.
But why don't you store extra information in plist or XML stored in a
single field in a table? And you should look at GVC SiteMaker for an
example of an app who let people add fields.
Hi Susanne,
I fully understand!
But it is hard to accept that I can do it very easily with ACCESS or
4D and not with WebObjects.
Imagine,
my customer is a major department in a public hospital. Each time
they decide to perform an experiment and take in account different
measurements. No one can predict this. So they need to have the
ability to create and/or alter existing tables.
There should be a way out.
Stavros
On 19 Ιαν 2009, at 8:07 ΜΜ, Susanne Schneider wrote:
Hi Stravros,
having done this I would rather recommend not to go this road
unless you are really shure there is no other way. You will find a
lot of pitfalls you did not even imagine now ;-)
At least, yes: it is possible. The API of EOF allows you to
dynamically create or alter any EOModel or model property you want.
The changing of database structure is not so well supported. As far
as I remember there is no good solution for altering existing
tables. We have our own solution for this as we only support Oracle
this hasn't be too much generic for our needs.
One of the greatest problem is that no WO-application likes its
eomodel to be altered. This is basically assumed to be static after
startup. You can do a lot during startup, but when you have
different applications or even many instances of the same
application you will get synchronization problems.
It would take too much time to describe the whole process (besides
I fear I'm not allowed to share too much business knowledge here).
So good luck!
Hi all,
I am developing an application where I want to give to the end
user the ability to alter EOModel and database, that is to add
fields in a table, or to add a new table and to be able to
insert and/or edit data on this table.
I am sure that there is a way to do it but as with the whole
WebObjects documentation is a miracle to find out how (at least
for a new comer like me).
Can anyone suggest to me some APIs or readings about this?
I think you should also consider alternative technologies. I
*believe* you might find stuff that is a lot more suited to this
kind of work then WO is.
A question to the rest of the list: has anyone ever even tried
doing this with WO? And I don't mean just fiddling with the in-
memory model, but also saving the model, changing the DB schema
on the fly etc...
see above :-)
Regards,
Susanne
--
Susanne Schneider
Coordinator secuTrial Development
iAS interActive Systems GmbH
Dieffenbachstraße 33 c, D-10967 Berlin
fon +49(0)30 22 50 50 - 498
fax +49(0)30 22 50 50 - 451
mail email@hidden
web http://www.interActive-Systems.de
----------------------------------------------------
Geschäftsführer: Dr. Marko Reschke, Thomas Fritzsche
Sitz der Gesellschaft: Berlin
Amtsgericht Berlin Charlottenburg, HRB 106103B
----------------------------------------------------
_______________________________________________
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
-------------------------------------------------------
Pascal Robert
http://www.macti.ca
http://www.aircourriel.com
http://www.linkedin.com/in/macti
Skype: MacTICanada
AIM/iChat : MacTICanada
_______________________________________________
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