Watcher and sequencing javascript

DecSoft HTML Compiler include a convenient Command Line Compiler, so you can compile your apps from the console.

DecSoft App Builder include a convenient Command Line Compiler, so you can compile your apps from the console.

Compile, convert your modern HTML apps and games into Microsoft Windows executable programs without dependencies.

Take a look at our YouTube channel and subscribe to be notified about new videos!

Save money by purchasing our NeoPlugins bundles. Five, Ten and even the complete NeoPlugins collection at an incredible price!

Create modern HTML apps and games at another level making things impossible to do even by modern HTML apps and games.

Create multiplatform apps with DecSoft App Builder, including Android and iOS with the same base of code.

Design for small screen devices but deploy also (without changes) in larger devices like tablets.

Save time, resources and money creating apps for Android, iOS and more with the same base of code.

DecSoft NeoPlugins put your VisualNeo projects into another level with +1,000 new actions for your apps.

DecSoft HTML Compiler is easy to use: set your project's options and compile your apps and games in a nutshell.

Create apps and expand their capabilities by using the world's popular programming language: Javascript.

DecSoft NeoPlugins are available in both runtime and designtime flavours to keep your apps as small as possible.

DecSoft App Builder integrates an Open AI assistant in order to assist you while developing your apps.

Take a look at some frequently asked questions about us and our products!

Apache Cordova's official plugins are supported out of the box and there are hundreds of plugins ready to use.

Ryan Sytsma

I am having problems getting a watcher to work, and I am trying to sequence some javascript to run in the right order.

Fire off watcher start....I get the "watcher start" alert first.

WatcherStart "watcherWaitForSqlInit"
Alert "1" "watcher start"

Run this JS code to create a SQlite database, create a table, and add a record.

StartJS
var db = null;
document.addEventListener('deviceready', function() {
var db = window.sqlitePlugin.openDatabase({ name: 'pts.db', location: 'default' });
db.transaction(function(tx) {
         tx.executeSql("CREATE TABLE IF NOT EXISTS tracking (table, action, record_id)");
         tx.executeSql("INSERT INTO tracking (table, action, record_id) VALUES ('test', 'test', '1')");
         alert("sqlinit created and inserted tracking table");
    },
function (tx, error) {
alert('Open database ERROR at Sqlinit ' + error.message);
});
});
EndJS

Now set the watcher variable value to something...

SetVar "[SqlInitDone]" "done" "String"

I do not get any response from my watcher... None of this watcher code fires off

If "[watcherWaitForSqlInit.OldValue]" "!=" "[watcherWaitForSqlInit.NewValue]"
WatcherStop "watcherWaitForSqlInit"
Alert "1" "sqlinit watcher stopped"

StartJS
var db = null;
document.addEventListener('deviceready', function() {
var db = window.sqlitePlugin.openDatabase({ name: 'pts.db', location: 'default' });

db.transaction(function(tx){

tx.executeSql('SELECT count(*) AS mycount FROM tracking', [], function(rs) {
window.App.RootScope.trackingRowsCount = rs.rows.item(0).mycount;
},
function(tx, error){
alert('Tracking table count error: ' + error.message);
});

}); //db transaction

}); //ready event listener

EndJS
Alert "1" "tracking count = [trackingRowsCount]"
EndIf

Not sure what is going on

DecSoft

Hello Ryan,

Maybe you no need the Watcher at all? That is, since "db.transaction" already provide the "success" and the "error" callback, that is what you must to use in order to do what you wanted. For example, if you wanted to perform some action after "db.transaction", you MUST wait for the "success" or the "error" callback, and therefore continue the work.

Similarly when you use an HttpClient control: after execute the HTTP call, we must wait for the events of the HttpClient control, in order to continue, for example, with other HTTP call.

What do you think about? There is a Watcher sample app that works as expected, so, maybe what happen is the Watcher is not the right solution for your specific case.

Purchase one or more licenses of our products if they are useful to you!

Ryan Sytsma

If I add this callback to the db.transaction, I dont get the alert or an error:

function(tx, success){
alert("sql init done");
window.App.RootScope.SqlInitDone = "done";
}

this version does not alert either:

function(tx){
alert("sql init done");
window.App.RootScope.SqlInitDone = "done";
}

Ryan Sytsma

The larger issue is that I have about 10 Http Get calls to make do load data into the Sqlite database for offline use. I need to chain those calls together so they run in order of 1:Many relationships. Each Http control is going to have a matching Sqlite insert function similar to the one in this post. So what I was envisioning was some like:

Start Watcher --> Execute Get --> Set Watcher Var to Stop Watcher--> Call JS function from inside Watcher....move on to next Http Get

DecSoft

Hello Ryan,

Follow the plugin's documentation, something like below must work:

db.transaction(
  function(tx) {
    tx.executeSql("CREATE TABLE IF NOT EXISTS tracking (table, action, record_id)");
    tx.executeSql("INSERT INTO tracking (table, action, record_id) VALUES ('test', 'test', '1')");
    alert("sqlinit created and inserted tracking table");
  },
  function(tx, error) {
    alert('Open database ERROR at Sqlinit ' + error.message);
  });
});

Means... one of the provided callback must be executed, except if what you wanted is to use a third callback... because, again, according this plugin's documentation, a third callback is supported:


  db.transaction(function(tx) {
    tx.executeSql('CREATE TABLE IF NOT EXISTS DemoTable (name, score)');
    tx.executeSql('INSERT INTO DemoTable VALUES (?,?)', ['Alice', 101]);
    tx.executeSql('INSERT INTO DemoTable VALUES (?,?)', ['Betty', 202]);
  }, function(error) {
    console.log('Transaction ERROR: ' + error.message);
  }, function() {
    console.log('Populated database OK');
  });

What I can't see is any syntax error in your code: so, one of the provided callback must be executed... except if "db.transaction" can be called without cause to call any of the provided callbacks: you must look at the plugin's documentation or ask the author about: "is db.transaction" executing always at least one of the provided callbacks, or what?".

I understand what you wanted, however, the Watcher must work... except if the code cause other thing... but anyway, I did not consider a Watcher to do something like you wanted. If you need to made 10 or any other number of HTTP calls in certain order, just execute the calls in the right order. Every HttpClient control provide an "Error" and a "Success" event, which we can use in order to do what we need: abort possible next calls, continue with them, etc.

Maybe you can reduce the complexity and do not made such a number of HTTP calls in certain specific order... but,... if you see that you must perform that number of HTTP calls and in certain order... just do it... start with the first one and end with the last of them... using the HTTP Client control's events. On the other hand,... be sure that no one of the callbacks provided to "db.transaction" are not executed: maybe something is wrong, so, you must debug it.

P.S. Take a look at the Debugger help topic of the new AB: you can use it also for the previous AB. Look mainly at the Debug Apache Cordova apps: basically you must take a look at the console in order to see what happend, since, if any of the "db.transaction" provided callbacks are executed... maybe some error occur... and you must see what error is in order to fix it.

Purchase one or more licenses of our products if they are useful to you!

Ryan Sytsma

I followed the directions here ( https://www.getappbuilderhelp.com/help/en-US/apache-cordova.html#batchfiles-integration ) and the app gets launched to my attached Andoid, but the debug console in the AB does not fire up

DecSoft

Hello Ryan,

The debug console is shown in the console window, not in AB. The "Run" Batch file compile and launch the app in an attached device, and, after that the console window show the debug information. So we are not talking about the console in AB, but the console window itself.

If you can't see anything rare... you must start step by step. For example, forget any HTTP call, just perform a "db.transaction", and see what happen: in other words, see if everything is fine and what callback is executed: asuming one of them must be executed... I think so, however, can't see in the plugin's documentation the "params help" for "db.transaction".

Purchase one or more licenses of our products if they are useful to you!

Ryan Sytsma

using the Run bat is launching the app on my connected tablet but the console window (npm) does not show any console.log out put.

Ryan Sytsma

This time I got an error that 'adb' is not regocnized as an internal or external command, operable program, or batch file

DecSoft

Hello Ryan,

"adb" means Android Debug Bridge. It's a command line tool which come with the Android SDK. What happen is that the tools is not in your PATH environment variable. You must set the path for the "adb" tool (see the previous link for his location) into your PATH environment variable.

Purchase one or more licenses of our products if they are useful to you!

Ryan Sytsma

David, I got the ABD working. It is very helpful.

So, here is something interesting. I got this code to work when the first view event "Show" fires.

var db = null;
document.addEventListener('deviceready', function() {
var db = window.sqlitePlugin.openDatabase({ name: 'pts.db', location: 'default' });
db.transaction(function(tx) {
         tx.executeSql("CREATE TABLE IF NOT EXISTS tracking (tbl, action, id)");
         tx.executeSql("INSERT INTO tracking (tbl, action, id) VALUES ('test', 'test', '1')");
         console.log("sqlinit created and inserted tracking table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS activitycode (id, activity_code, activity_description)");
         console.log("sqlinit created activity code table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS position (id, code, description)");
         console.log("sqlinit created position table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS users (id, user_name, user_level)");
         console.log("sqlinit created users table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS customer (id, customer_name)");
         console.log("sqlinit created customer table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS contract (id, contract_name, is_active)");
         console.log("sqlinit created contract table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS contracttask (id, contract_id, task_number, task_status, date_complete, crew_comments, completed_crew_id, mobile_create, mobile_update)");
         console.log("sqlinit created contract task table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS dailycrew (id, crew_date, crew_start, crew_end, note, crew_hours, server_create, server_update, mobile_create, mobile_update, user_create, user_update)");
         console.log("sqlinit created daily crew table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS dailycrewemployee (id, daily_crew_id, user_id, employee_position, user_start, user_end, mobile_create, mobile_update, user_create, user_update)");
         console.log("sqlinit created daily crew employee table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS dailycrewactivity (id, daily_crew_id, activity_date, contract_task_id, activity_code, activity_start, activity_end, activity_hours, mobile_create, mobile_update, user_create, user_update)");
         console.log("sqlinit created daily crew activity table");
         tx.executeSql("CREATE TABLE IF NOT EXISTS viewtaskvaluedisplay (id, contract_id, task_id, label_text, value_display, value_order)");
         console.log("sqlinit created task value display table");
         console.log("all tables have been created");
    },
function(error) {
window.alert('Open database ERROR at Sqlinit ' + error.message);
},
function(){
console.log("success");
});
});

and here is the output of the console window...

LAUNCH SUCCESS
11-29 22:10:04.070 32253 32253 D CordovaWebViewImpl: onPageFinished(file:///android_asset/www/index.html#/)
11-29 22:10:05.522 32253 32253 D SystemWebChromeClient: file:///android_asset/www/plugins/cordova-sqlite-storage/www/SQLitePlugin.js: Line 175 : OPEN database: pts.db
11-29 22:10:05.536 32253 32253 D SystemWebChromeClient: file:///android_asset/www/plugins/cordova-sqlite-storage/www/SQLitePlugin.js: Line 106 : new transaction is queued, waiting for open operation to finish
11-29 22:10:05.563 32253 32253 D SystemWebChromeClient: file:///android_asset/www/plugins/cordova-sqlite-storage/www/SQLitePlugin.js: Line 179 : OPEN database: pts.db - OK
11-29 22:10:05.566 32253 32253 D SystemWebChromeClient: file:///android_asset/www/plugins/cordova-sqlite-storage/www/SQLitePlugin.js: Line 80 : DB opened: pts.db
11-29 22:10:05.570 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 885 : sqlinit created and inserted tracking table
11-29 22:10:05.580 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 887 : sqlinit created activity code table
11-29 22:10:05.583 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 889 : sqlinit created position table
11-29 22:10:05.586 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 891 : sqlinit created users table
11-29 22:10:05.588 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 893 : sqlinit created customer table
11-29 22:10:05.591 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 895 : sqlinit created contract table
11-29 22:10:05.594 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 897 : sqlinit created contract task table
11-29 22:10:05.599 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 899 : sqlinit created daily crew table
11-29 22:10:05.602 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 901 : sqlinit created daily crew employee table
11-29 22:10:05.607 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 903 : sqlinit created daily crew activity table
11-29 22:10:05.612 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 905 : sqlinit created task value display table
11-29 22:10:05.615 32253 32253 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 906 : all tables have been created

However, after this JS code finishes, no other code will run. Even code I put into the success callback such as this...

tx.executeSql('SELECT count(*) AS mycount FROM tracking', [], function(rs) {
console.log(rs.rows.item(0).mycount);
});

...will not execute. I also quickly built this same code in the new AB 2020 with the same results.

DecSoft

Hello Ryan,

No errors at all? That is... my idea right now is that "tx" may is not defined... Apparently "tx" can be used inside the right "db.transaction" callback, but, outside that callback... where is "tx"? So maybe this is the problem, that "tx" is not defined?

There must be another way to execute queries on existing databases... without the "tx"... or you must use the "tx" inside a "db.transaction" callback... in which "tx" exists. I hope this can at least give you an idea about where to look.

Purchase one or more licenses of our products if they are useful to you!

Ryan Sytsma

All of the samples and documents for this plugin use "tx" or "transaction" inside of the db.transaction callback.

https://github.com/brodybits/cordova-sqlite-test-app

https://github.com/xpbrew/cordova-sqlite-storage#sample

I built this test app using AB 2020 as detailed in this link, and it also did not work. ( https://github.com/brodybits/cordova-sqlite-test-app/blob/master/www/app.js ). The only feedback I get from the console is that the database is waiting to close after I issued a close command. It seems like something is not getting released by the plugin.

Offline data is critical to this app... I have to get this or another offline solution working.

Ryan Sytsma

I deleted the Cache and Compiled folders just in case something is not compiling clean. Now the output in the console is this. I am not sure what this means.

ANDROID_HOME=C:\Users\ryans\AppData\Local\Android\Sdk (DEPRECATED)
No target specified, deploying to device 'DTFGSKR2F1'.
Using apk: C:\Sync\Ryan\GitHub Repos\PTS Mobile\PTS_Compiled\platforms\android\app\build\outputs\apk\debug\app-debug.apkPackage name: com.ptsapp.ptsmobile
LAUNCH SUCCESS
12-01 13:33:33.947 13343 13343 D CordovaWebViewImpl: onPageFinished(file:///android_asset/www/index.html#!/Home)
12-01 13:33:34.029 13343 13343 D SystemWebChromeClient: file:///android_asset/www/cordova.js: Line 1739 : Could not find cordova.js script tag. Plugin loading may fail.
12-01 13:33:34.042 13343 13343 D SystemWebChromeClient: file:///android_asset/www/app/scripts/app.js: Line 389 : Error: [$templateRequest:tpload] http://errors.angularjs.org/1.7.8/$templateRequest/tpload?p0=app%2Fviews%2FHome.html&p1=-1&p2=

DecSoft

Hello Ryan,

About the "tx" identifier, certainly, it appear as an argument of certain callback of the "db.transaction" method. However, you put that code alone, so, I must ask if yo uare sure that "tx" is defined, since, out of the referred callback, probably "tx" is undefined or don't have the expected reference. Are you sure that the plugin did not allow to make SELECT questies without using "tx"? Because I don't know why to use a transaction in a SELECT query...

About your latest problem, if I am not wrong, what happen is that the app try to load a non existing app view. You must save the app, and then compile it, in order to assert that all the app views are properly compiled and therefore available to be load by the app.

Purchase one or more licenses of our products if they are useful to you!

Everybody can read the DecSoft support forum for learning purposes, however only DecSoft customers can post new threads. Purchase one or more licenses of some DecSoft products in order to give this and other benefits.