Here are some new and upcoming features for our NodeRun site.

Improvements to Widget Sets UI

The widget sets UI in the Profound UI, Profound.js, and NodeRun.com designers has been improved to make it easier and more efficient to create custom widget sets.

Widgets can now be copied directly from one set to another and edited directly within the widget set panel using new right-click menu options:

The Edit Properties option brings up a window that can be used to update the widget properties:

This saves a lot of time compared to prior releases, where widgets had to be dragged from the widget set to the design canvas, edited, and then re-added to the widget set.

Multiple Selections in File Tree

You can now select multiple items in the Designer Files tab. Upon right-clicking, an adaptive context menu is opened depending on the types of items selected. Actions such as copy or cut can be performed on many items at once this way.

We’ve also included support for multi drag-and-drop. Begin a drag from any selected item and the whole group will come along as well. 

To take advantage of this new feature, ctrl + click can be used to add or remove individual items from the selection, shift + click selects a range of items, and items above and below can be selected by holding shift and pressing up or down.

Profound.js and NodeRun Now has a Utility to Dynamically Create Valid SQL statements

Profound.js 4.14.0

The syntax of SQL statements varies between databases.  For example, Oracle’s syntax for a SELECT statement is slightly different from IBM’s!  In Profound.js 4.14.0 we’ve provided a set of SQL helper functions that help you construct an AQL statement, they will adapt to the database driver you choose, so you will be able to write applications that will work against several databases.

See here for more information or for a working example on noderun.com.

Profound.js and NodeRun Now has simple way running multiple SQL at the same time

(FUTURE) Profound.js 4.15.0

You can now use the pjs.parallelQueries API to run several queries all at the same time.

function getData(request, response) {

    let id = request.query.id;

    let name = request.query.name;

    let sql1 = “select count(*) as total from productsp”;

    let sql2 = [“select * from productsp”];

    let sql3 = [“select * from productsp where productid = ? or prname = ?”, id, name];

    let qryResults = pjs.parallelQueries([sql1, sql2, sql3]);

    response.send(qryResults);

}

See here for more information or for a working example on noderun.com.

Additional “New” Options in Profound.js and NodeRun

From the designer, you can now quickly add a typescript or vue file by simply clicking on the New ribbon button on the Home Tab, and choosing the type of file you want to add. Those buttons will open a new file with a sample of the appropriate structure.  These file types, in the Files tab, will also have the proper icon.

Profound.js and NodeRun Now Have a Built-In ORM

  1. Allows for using the Record Level Access API’s on any supported database
  2. Allows for quickly expose Data as REST services
  3. Allows for exposing Business Processes through REST services
  4. Allows for moving Business Logic from screen modules to share modules
  5. Allows for accessing data from all supported database types
  6. Allows for accessing data from multiple schema

These are features are inherited by a new file type called DbDefn.  See here for more information.

This new type of file can do as little or as much as you need it to do.

  1. You can enable using RLA APIs against any supported database with just a few lines of code. 
  • You can enable simple data REST services with just a few lines of code, and that can expose all of the standard CRUD operations (Create, Read, Update, and Delete) for that given database object.
  • You can enable Business Processes as REST services, as well, with just a few lines of code.
  • You can also put more of your Business Logic into this DbDefn file, because this module can be shared across multiple modules.  In doing this allows removing a lot of duplicated code, making that process flow easier to maintain, enhance and better confidence in the product.  You can easily create unit tests over these “shared” modules.
  • Multiple database support is achieved because all of the built-in REST services use the new SQLHelper to dynamically construct SQL statement based on the type of database.
  • All built-in REST services support the ability to use a list of schemas when accessing data from a non IBMi database.
  • These DbDefn modules are also a good place to put:
    • Data and Process validation.  This means no need to “duplicate” validation in multiple modules (screen and batch).
    • All database logic.  Not just the simple CRUD, but all database work.  This means no need to “duplicate” database stuff in multiple modules (screen and batch).

Subscribe to our blog to stay updated for any new NodeRun news!

Visit our community site here: www.noderun.com

Any questions? Visit our discussion forum: discuss.noderun.com/