storage.js

.import QtQuick.LocalStorage 2.0 as Sql

function getDatabase() {
    console.log('Trying to open:');
    try {
        var db = Sql.LocalStorage.openDatabaseSync("Neliapila", "0.1", "SettingsDatabase", 100);
        return db;
    } catch(e) {
        if(e.code === SQLException.DATABASE_ERR) {
            console.warn('Database error:', e.message);
        } else if(e.code === SQLException.VERSION_ERR) {
            console.warn('Database version error:', e.message);
        } else {
            console.warn('Database unknown error:', e.message);
        }

        return false;
    }
}

function getBoardTable() {
    var db = getDatabase();

    db.transaction(
                function(tx) {
                    try {
                        tx.executeSql('CREATE TABLE IF NOT EXISTS boards(board TEXT UNIQUE, title TEXT,favorite INT,start_board INT)');
                    } catch(e) {
                        if(e.code === SQLException.DATABASE_ERR) {
                            console.warn('Board Database error:', e.message);
                        } else if(e.code === SQLException.SYNTAX_ERR) {
                            console.warn('Board Database syntax error:', e.message);
                        } else {
                            console.warn('Board Database unknown error:', e.message);
                        }

                        return false;
                    }
                }
                );
    return db;
}

function setBoardTable(board,
                       title,
                       favorite,
                       start_board) {

    var db = getBoardTable();
    var result;

    db.transaction(
                function(tx) {
                    try {
                        var result = tx.executeSql('INSERT OR REPLACE INTO boards VALUES (?,?,?,?);',
                                                   [board,
                                                    title,
                                                    favorite,
                                                    start_board]);
                    } catch(e) {
                        if(e.code === SQLException.DATABASE_ERR) {
                            console.warn('Database error:', e.message);
                        } else if(e.code === SQLException.SYNTAX_ERR) {
                            console.warn('Database syntax error:', e.message);
                        } else {
                            console.warn('Database unknown error:', e.message);
                        }

                        return false;
                    }
                    //console.log('Affected rows:', result.rowsAffected)
                    if (result.rowsAffected > 0) {
                        console.debug('Saved board with: ' + board)
                        return true;
                    } else {
                        //@TODO handle error on saving
                        console.error('ERROR: Storage: Failed to save board: ' + board);
                        return false;
                    }
                }
                );
}