Forum Stats

  • 3,780,928 Users
  • 2,254,456 Discussions
  • 7,879,497 Comments

Discussions

SQL Developer Datamodeler - Design Rules through scripts.

Saubhik
Saubhik Member Posts: 5,803 Gold Crown

I have recently started using SQL Developer Data modeler in my new project apart from the other commercial data modeling tools. I am having problems with the automation parts/ scripting parts. Generally Oracle products has very good documentation but this scripting part is not up to the mark.

I want to put all my design rule validations into a Library, I have only the Logical data model, relational is not generated till now, So, all the validations will happen in logical model only.

Now, I have created a Library. ti looks like:

pastedImage_0.png

The custom rule is defined as:

pastedImage_1.png

When I am applying this, to my surprise it is saying everything is fine! Shouldn't it return an false error with "xxx" for every entity in the logical data model?

What I am missing here?

EDIT: I already read about SQLDeveloperDataModelerScripting.docx, index,.html and the only book available on SQL Developer Datamodeler by Heli etc.

Best Answer

  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,367 Employee
    edited Jun 29, 2020 7:54AM Accepted Answer

    Hi @Saubhik ,

    thanks for reporting the problem - I logged a bug.

    You still can execute your design rules with correct result:

    1) just select several entities on diagram and in their context menu you'll find option for "Design Rules" and selected design rules will be applied to selected entities

    2) in context menu for diagram

    Design_rules_in_diagram_context_menu.png

    2.1) if it's a diagram for subview then rules will applied only for objects in theat subview

    2.2) if it's the main diagram then rules will be applied for all objects in the model

    Philip

Answers

  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,367 Employee
    edited Jun 29, 2020 7:54AM Accepted Answer

    Hi @Saubhik ,

    thanks for reporting the problem - I logged a bug.

    You still can execute your design rules with correct result:

    1) just select several entities on diagram and in their context menu you'll find option for "Design Rules" and selected design rules will be applied to selected entities

    2) in context menu for diagram

    Design_rules_in_diagram_context_menu.png

    2.1) if it's a diagram for subview then rules will applied only for objects in theat subview

    2.2) if it's the main diagram then rules will be applied for all objects in the model

    Philip