Application Initialization Scripts

For each application, you can specify an SQL script that should be executed as a part of application initialization. This will be sometimes needed for your application to work properly after it is clonned.

Here is a simple example, that shows you how to setup your application with an initialization script.

Lets create a TaskManager^? Application:

1. Application -> Create Application

Name taskmgr

Path taskmgr

2. Database -> Initialization Scripts

Click 'Add Initialization Script'

Name TaskManagerScript

SqlScript

create table TaskMgr_User(id autotupleid, name varchar(255));

create table TaskMgr_Task(id autotupleid, task text);

Save and execute the script.

3. Database -> Add Named Query

Name TaskMgr.insertUser

Query insert into TaskMgr_User(name) values(?);

Name TaskMgr.insertTask

Query insert into TaskMgr_Task(task) values(?);

4. Function -> Create

Name insertUser

Source

   var uname = getWidgetByName("taskmgr_uname").value;   
   if(uname == "") return;
   var ajaxdb = new Applibase.db.AjaxDb();
   ajaxdb.query("TaskMgr.insertUser", [uname], true, handler);
   function handler(rs, err) {
    if(err != null) { alert(err.message); return; }
    ajaxdb.renderResultTable(rs, document.body);
   }

Name insertTask

Source

   var task = getWidgetByName("taskmgr_task").value;   
   if(task == "") return;
   var ajaxdb = new Applibase.db.AjaxDb();
   ajaxdb.query("TaskMgr.insertTask", [task], true, handler);
   function handler(rs, err) {
    if(err != null) { alert(err.message); return; }
    ajaxdb.renderResultTable(rs, document.body);
   }

5. Import library requrired for doing Named Query. Function -> Function Library -> Database Functions.

Click on icon before the label: Named Query

6. Required UI.

+===========================================+
+                                           +
+  TextArea                                 +
+  Name: taskmgr_task                       +
+                                           +
+                                           +
+===========================================+
+  TextInput, Name: taskmgr_uname           +
+=====================+=====================+
+  AddTask (Button)   +  Button             +
+onclick=insertTask() +onclick=insertUser() +
+=====================+=====================+

When this application is cloned then the schema script information will be used to initialize the cloned application.