Create entity extends from User entity using cuba-cli

Support
#1

Hello everyone,
How can I create an entity (eg. ExtUser) that inherit from User entity using cuba-cli?
I’ve tried create an entity using create-entity command and edit the extends class to User, but it failed when run gradlew updateDb command.
Please help me, thank you!

#3

Hi,
When the entity is created using CLI you should manually edit the generated SQL update-script. gradlew updateDb only executes the script.

For instance, in my project, it is modules\core\db\update\hsql\20\200212-1-createExtUser.sql
And I should add the following code there (for ‘single table’ inheritance strategy).

-- begin SEC_USER
alter table SEC_USER add column USER_ADD_INFO varchar(255) ^
alter table SEC_USER add column DTYPE varchar(100) ^
update SEC_USER set DTYPE = 'sec$User' where DTYPE is null ^
-- end SEC_USER

It works.

CUBA Studio has a tool to generate DB-scripts. It is available in Free version too.
So you can open the project in Studio, edit the entity and then execute CUBA → Generate Database Scripts.
image

Correct update-script should appear. Save it and run gradlew updateDb or CUBA → Update Database in Studio.
image

Regards.