Chapter 3. Using PSQL
Prev   Next

Chapter 3. Using PSQL

Table of Contents

Import XMI file
Import XMI file of the phase
Import XMI file of the package
Symbols in the table tree
Setting the table column order
Creating and modifying indexes
Saving of imported XMI file
Create script generation
Alter script generation

PSQL controls all processes for SQL script generation. To generate SQL script follow steps:

  1. Import XMI file
  2. Save PSQL XML file
  3. Generate Create SQL script
Similary you can generate alter database script:
  1. Import XMI file
  2. Save PSQL XML file
  3. Compare with old version of the PSQL XML file
  4. Generate Alter SQL script

Import XMI file

XMI file is a text file with data in XML format generated from UML CASE tools. XMI is internationally accepted standard supported by good CASE tools.

Import XMI file of the phase

XMI file is possible to import by two ways:

  1. Run generation from UML Suite (Menu->Utilities->PXMI->Export phase)
  2. Option in menu of PSQL File->Load XMI->Generated from phase

Once a file is imported it is required to save it. Select option File->Save.

Import XMI file of the package

XMI file is possible to import by two ways:

  1. Run generation from UML Suite (Menu->Utilities->PXMI->Export package)
  2. Option in menu of PSQL File->Load XMI->Generated from package

Just after starting import you will be prompted to enter the path to the PSQL file contaning the whole project - ie. all packages. The PSQL will read the full project and removes imported one. After that it add the system from import and performs checking of the final model.

PSQL generates only classes from exported package. Remaining classes are taken from the original PSQL file. System also provides conflicts warnings. PSQL assumes that designer makes only changes not affecting other modules. If changes in the module affects other packages then it is required to regenerate the whole project.

WARNING

If original PSQL file does not contain definition of packages then package import will not finish successfuly - the generated model will contain doubled definitions.

If a phase is exported to PSQL then physical database definition kept by PSQL contains also package definition.

Once XMI is imported you should save it. Select option from menu File->Save.

Prev Up Next
From command-line Home Symbols in the table tree