Re: Using database objects in different schemas
Re: Using database objects in different schemas
- Subject: Re: Using database objects in different schemas
- From: André Rothe <email@hidden>
- Date: Fri, 15 Dec 2017 12:21:06 +0100
Hi Paul,
Hm, then I will come back to my first idea, building EOModels
dynamically with
databaseContext.availableChannel().adaptorChannel().describeModelWithTableNames(namelist)
I hope, I can set full-qualified tablenames there. It is a very common
method in my business domain to have a master account, which gets
permissions from a lot of slave accounts to access some detail data
there. So it would be helpful to solve that with EOF.
Best regards
André
Am 2017-12-15 11:22, schrieb Paul Hoadley:
Hi André,
On 15 Dec 2017, at 6:33 pm, André Rothe <email@hidden>
wrote:
But how does EOF differ the objects? They come from different tables
(but with the same name, only the owners differ). The owner I would
intercept and change in the SQL code. Can EOF track this without a
model? Also the primary keys could overlap, because the "slaves" use
its own sequence objects, which all start at 1.
Unless Chuck chimes in with some serious esoterica, I cannot imagine
how you’d get this to work. No, EOF won’t be able to track that
without a model. And even if you could somehow trick it into using a
union of several tables, then, and I think you know this, they’re
not really going to function as primary keys if they can possibly
collide.
At the moment I havent't found a delegate for the SQL injection, so
I cannot test it :-(
I don’t think it’s going to help. I just can’t see how EOF can
be the solution to this problem.
--
Paul Hoadley
https://logicsquad.net/
https://www.linkedin.com/company/logic-squad/
_______________________________________________
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