Test Scenario

Prerequisites

If you want to skip the prerequisites steps, open Dirigible from here.


  1. Go to Dirigible’s official site
  2. Click the GET STARTED button
  3. Follow the getting started steps
  4. Open the project’s address in a new browser

Initial experience

  1. When dirigible is opened in the browser, the registry page should be displayed

Landing page

  1. Then click the IDE icon
  2. A new tab should be opened with the IDE itself

Landing page

  1. If this is the first time you use dirigible (or this instance) the Workspace Explorer should be empty
  2. Explore the other perspectives by clicking the other… button

Landing page

  1. There should be a list of all available perspectives
  2. From the list, select Database and press OK
  3. The Database perspective should open

Landing page

  1. Depending on the roles your user has, under the SQL Console view you should see the following:
    • Query and Update buttons, if you have assigned role Operator
    • Query button, if you don’t have assigned the Operator role
  2. Switch back to the workspace perspective, by clicking the Workspace button

Simple project

  1. Right click in the Workspace Explorer view
  2. From the menu select New->Project

Landing page

  1. Enter a name for the project, for example test_project and click Next >
  2. A list of all available project templates should be displayed
  3. Choose Blank Application and click Finish

Landing page

  1. A new project should be created in the Workspace Explorer
  2. Expand the initial empty project and list of all project artifacts should be displayed

Landing page

  1. Right click on the project, and from the menu choose New->Scripting Service

Landing page

  1. From the list of all available Scripting Services select Server-Side JavaScript Service and click Next >

Landing page

  1. Give the service some meaningful name like hello_world.js and click the Finish button
  2. Under the Scripting Service folder, a new generated service should appear

Landing page

  1. Switch to the Preview view
  2. The service should be executed and the response in the Preview view should be Hello World!

Landing page

  1. Right click on the project and from the menu choose Publish

Landing page

  1. In the Preview tab click the Sandbox/Public button

Landing page

  1. The URL should be changed from

    https://[host]:[port]/dirigible/js-sandbox/[project-name]/[service-name]

to

1
https://[host]:[port]/dirigible/**js**/[project-name]/[service-name]
  1. Copy the URL and open it in a anonymous browser session
  2. The service should be executed without asking you for credentials
  3. Change the URL path from …/js/… to …/js-sandbox/…
  4. You should be asked to authenticate before the execution of the service

Full-fledged application

  1. Right click in the Workspace Explorer view
  2. From the menu select New->Project

Landing page

  1. Enter a name for the project, for example test_project and click Next >
  2. A list of all available project templates should be displayed
  3. Choose Blank Application and click Finish

Landing page

  1. A new project should be created in the Workspace Explorer
  2. Expand the initial empty project and list of all project artifacts should be displayed

Landing page

  1. Right click on the project and from the menu select New->Data Structure

Landing page

  1. A list of all available Data Structure templates should be displayed
  2. Choose Database Table and click Next >

Landing page

  1. Page for managing table fields should be opened

Landing page

  1. Click on the Add button
  2. Add Column dialog should be displayed
  3. Fill the fields and click OK

Landing page

  1. Add several more fields.
  2. The final result should look like this

Landing page

  1. Click Next >
  2. Give the table some meaningful name like students.table and click Finish
  3. From the Workspace Explorer select the project and from the bar above, click on the Activate button

Landing page

  1. Switch to the Database perspective
  2. In the SQL Console enter the following script and click Query
1
2
3
	select * from students

Landing page

  1. The result, of executing the SQL script, should be empty table
  2. Switch back to the Workspace perspective
  3. Right click on the project and from the menu select New->Scripting Service
  4. From the list of available templates, choose Entity Service on Table and click Next >
  5. All available database table should be listed
  6. Select the STUDENTS table and click Next >

Landing page

  1. Give the service some meaningful name like students_service.js and click Finish
  2. Under the ScriptingServices folder 3 files should be generated

Landing page

  1. From the Workspace Explorer view, select the project and from the bar above, click on the Publish button

Landing page

  1. Select students_service.js and open the Preview view
  2. The result should be empty JSON array
    1
    []
    
  3. Right click on students_service.entity and from the menu select Generate->User Interface for Entity Service

Landing page

  1. A list of all available UI templates should be opened
  2. Select the List and Manage View and click Next >

Landing page

  1. A list of all available fields, for which will be generated the UI, should be displayed
  2. Click Select All and then click Next > button

Landing page

  1. Give some meaningful name for the page, like students.html and click Next >
  2. Enter Students for Page Title and click Finish
  3. In the Preview view, the page should be displayed

Landing page

  1. Select the project and Publish it again
  2. Try adding some entries
  3. Switch to the Database perspective
  4. In the SQL Console view execute again the same query
1
2
3
	select * from students

  1. This time the query should return the entries you had enter
Edit