topic Re: Nuxeo SQL Database Schema Creation in Nuxeo Forum

Nuxeo SQL Database Schema Creation

SMAH_Haider — Wed, 29 Aug 2012 13:54:19 GMT

We have to run Nuxeo with db.user and db.password having no table creation rights and we have successfully configured nuxeo but we have to do the following steps:

Start nuxeo with db.user and db.password having table creation rights. (This step creates all the necessary tables)
Set noDDL as "true" and added custom plugin having directories' table creation policies as "never"
Start nuxeo with db.user and db.password having no table creation rights.

Nuxeo starts perfectly fine.

We want to avoid step # 1 (first starting nuxeo with db.user and db.password having table creation rights) So we want to create tables via sql db scripts. Is this possible?

Re: Nuxeo SQL Database Schema Creation

Benjamin_Jalon1 — Thu, 30 Aug 2012 14:06:36 GMT

I'm not sure to understand your question. Do you ask our permission to do that ? 😄

If you really want, why not 🙂 but you will do exactly the same that what Nuxeo do automatically. Maybe my advices would be

is to allow table creation just for the first start and remove the right after.
or you do the initialization of a pre-production instance identical of your production one and dump the data to inject it into the production instance...

But becareful if you do maintenance action (hot fix deployment) or add more feature through studio project or any else action that need the table rights, you may have some instabilities. My real advice will be to let the right.

Hope this will help you 😄

Re: Nuxeo SQL Database Schema Creation

SMAH_Haider — Thu, 30 Aug 2012 14:37:31 GMT

Bjalon, Thats the constraint from the client that we cannot run nuxeo with user having table creation rights.

Re: Nuxeo SQL Database Schema Creation

Benjamin_Jalon1 — Thu, 30 Aug 2012 14:40:21 GMT

I'm sad for you

Re: Nuxeo SQL Database Schema Creation

Florent_Guillau — Mon, 03 Sep 2012 16:16:39 GMT

The simplest way is to start Nuxeo once on an empty database, then use a database script generation tool to dump its content and turn it into a SQL script.

For instance using PostgreSQL you can use pg_dump --schema-only.