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 > <webobjects-dev@lists.apple.com> 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 >> <webobjects-dev@lists.apple.com> 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 (Webobjects-dev@lists.apple.com) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/pccdonl%40me.com >> >> This email sent to pccd...@me.com > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/ocs%40ocs.cz > > This email sent to o...@ocs.cz
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
