Lianja concept

Posted: 2017-01-18 in Lianja concept

The Lianja App Center is the focal point for running apps that you have built and deployed using the Lianja App Builder.

You firstly need to use the Lianja App Builder to build your apps.
You then deploy them with their database
and run them under the Lianja App Center.
There are many example apps which you can open and run inside the App Builder as desktop, web or mobile apps.

Users authenticate in the App Center using credentials that you setup in the App Builder “Users” workspace.

The default user is admin/admin.


In the beginning there is data. Without data we have nothing to build LOB (Line Of Business) Apps against.

The primary goal of the Lianja is to provide an Enterprise RAD platform for Desktop, Web and Mobile Apps.

When building large enterprise class applications with 100’s of tables that are used in multiple Apps and their associated Lianja UI elements, it can be tedious and error prone to apply the same section, field and grid column attributes consistently throughout the UI using the attributes panel in the App Builder.

To alleviate this problem and to speed up app development we are extending the Lianja App Builder and the Lianja engine to handle metadata with a new MetaDataBuilder API. This mechanism provides a way of dynamically setting up UI element attributes when a new section is created or when an app is loaded and its pages and their corresponding sections are loaded.

Also, and probably more importantly, any changes to the metadata for the tables and/or their columns contained in the database schema that are used in many different Lianja apps and their UI elements (Sections, Fields, Grid Columns) are propagated throughout apps dynamically as they are loaded at design time.

The metadata can be created externally by a CASE/builder tool (such as XCase) and imported into the Lianja App Builder using “Import from XCase…” which will be added to the context menu in the “Data” workspace. This will populate (or update) a database with table schemas (native tables or virtual tables) and the associated metadata for the database, tables and columns.

Let’s now take a look at how this all works.

Lianja Databases contain tables and their associated indexes. You can associate metadata with a database.

Code:
create database mydb metadata <cExp>open database mydb
omd = databaseMetaData()

Each table in a Lianja database can have an associated active data dictionary which contains business rules and triggers for the table itself and its columns.
You manipulate these using standard SQL DDL

Column constraints:

Code:
alter table customers modify constraint name set default “Barry”
alter table customers modify constraint name drop default

alter table customers modify constraint name set check not empty(name)
alter table customers modify constraint name drop check

alter table customers modify constraint name set error “Name cannot be blank”
alter table customers modify constraint name drop error

alter table customers modify constraint name set picture “@!”
alter table customers modify constraint name drop picture   

alter table customers modify constraint name set choices “Apples,Oranges,Bananas”
alter table customers modify constraint name drop choices

alter table customers modify constraint name set not null
alter table customers modify constraint name set null  

alter table customers modify constraint pkid set autoinc
alter table customers modify constraint pkid drop autoinc   

alter table customers modify constraint name set help “Customer name”
alter table customers modify constraint name drop help

Triggers (written in Lianja/VFP):

Code:
alter table customers modify onopen “customers_onopen”    
alter table customers modify onclose “customers_onclose”    
alter table customers modify oninsert “customers_oninsert”    
alter table customers modify onbeforeinsert “customers_onbeforeinsert”    
alter table customers modify onafterinsert “customers_onafterinsert”    
alter table customers modify onupdate “customers_onupdate”    
alter table customers modify onbeforeupdate “customers_onbeforeupdate”    
alter table customers modify onafterupdate “customers_onafterupdate”    
alter table customers modify ondelete “customers_ondelete”    
alter table customers modify onbeforedelete “customers_onbeforedelete”    
alter table customers modify onafterdelete “customers_onafterdelete”

We call this an “Active Data Dictionary” as these business rules are associated with the table whenever it is used in a desktop App, Lianja SQL Server or Lianja Cloud Server. Altering any of the attributes has immediate effect on all applications that use the corresponding table without needing to make any code changes.

The Active Data Dictionary can also be associated and used with Virtual Tables (third party databases e.g MSSQL, MySQL, PostgreSQL etc) when the tables are opened.

To provide a flexible solution so that any type of user defined metadata can be associated with a table you use the METADATA clause on the CREATE/ALTER table SQL DDL commands.

The metadata you specify should be a JSON encoded character string. After a table is opened you can obtain a metadata object using the new TABLEMETADATA() function.

Example:

Code:
Use customers 
omd = tableMetaData()

The TABLEMETADATA() function returns an object which is created by decoding the JSON encoded METADATA string from the Active Data Dictionary associated with the table. This can be a complex object containing properties that are arrays of objects or nested objects.

You can change the elements of the metadata object then update the Active Data Dictionary with the new metadata.

Example:

Code:
use customers
omd = tableMetaData()
omd.searchpanelvisible = .t.
use
alter table customers metadata json_encode(omd)

It is important to realize that the members of the metadata object are completely up by the data architect who creates the database schema. This provides them with the ability to create a complex relationship of database tables and their associated UI attributes in a database design tool such as XCase or other similar type of ER CASE tool.

Metadata can also be associated with columns of a table. You use the columnMetaData( nExp | cExp) function to obtain a JSON decoded object containing the column metadata.

Example:

Code:
omd = object()
omd.caption = “Customer Name”
omd.searchfield = .t.
alter table customers modify constraint name metadata json_encode(omd)
use customers
omd = columnMetaData(“name”)
omd.caption = “Customer”
omd.picture = “@!”
omd.searchfield = .t.
alter table customers modify constraint name metadata json_encode(omd)

How does this all work with the Lianja App Builder?

When you create a new section by dragging a table onto a page (or opening an existing App) Lianja will layout the section, then if the script setupUI.prg exists in the App or setupUI_tablename exists in the database it will be called with the section id as the first parameter and the cursor for the table bound to that section will be current.

Example:

Code:
// File: database:setupUI_tablename.prg then app:setupUI.prg
parameter id
local osection = Lianja.getElementByID( id )

// check to see if UI section attributes are same version as last time applied
// and if so do nothing (improves performance)
if osection.metaDataVersion = tableMetaDataVersion()
    return
endif
osection.metaDataVersion = tableMetaDataVersion()
local omd = tableMetaData()

// Interrogate the metadata and apply the attributes to the section
// …

// foreach formitem in the form section (can also traverse grid columns)
local i
local oitem
local count = osection.count
for i=1 to count
  oitem = osection.item( i )
  omd = columnMetaData( oitem.controlsource )
  if not isObject(omd)
    next
  endif
  // Interrogate the column metadata and apply the attributes to the field or grid column
  // ...
endfor

If your App is a Web or Mobile App you will now need to “Preview” it and then “Deploy” it (or rebuild a Mobile App) to reflect the changes made in the metadata.



Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s