PDOX

Dp field Substitution

Create the database conection pools.

Run a query and return all the rows or an error from the query.

let sql = 'SELECT * FROM lti_key WHERE key_key = :key_key';
pdox.allRows(sql,{ key_key: thekey }, false).then(
     function(rows) {
         console.log("Rows:",rows.length);
     },
     function(reason) {
          console.log("Bummer",reason);
     }
);

Run a query and return all the rows from the query and throw any error.

let sql = 'SELECT * FROM {p}lti_key WHERE key_key = :key_key';
pdox.allRowsDie(sql,{ key_key: thekey }).then(
     function(rows) {
         console.log("Rows:",rows.length);
     },
     function(reason) {
          console.log("Bummer",reason);
     }
);

Get a connection promise from the pool Make sure to do a cop.release()

var thekey = '12345';
pdox.cop.then( function(connection) {
    let sql = 'SELECT * FROM lti_key WHERE key_key = :key';
    connection.query(sql, { key: thekey }, function(err, rows, fields) {
        if (err) {
            console.log('Could not load data query');
        } else {
            console.log("Rows:",rows.length);
        }
        connection.release();
    });
});

Run an INSERT and return the generated key, throw on error

sql = "INSERT INTO {p}lti_unit_test (name,email)
       VALUES ('tsugi', 'tsugi@zap.com')";
pdox.insertKey(sql).then( function(retval) {
     console.log("INSERT retval:",retval);
});

Run a query and return the number of affected rows, throw on error

sql = "DELETE FROM {p}lti_unit_test WHERE name='tsugi'";
pdox.query(sql).then( function(retval) {
     console.log("DELETE retval:",retval);
});

Run a query and return the number of changed rows, throw on error

sql = "UPDATE {p}lti_unit_test SET email=:new WHERE name='tsugi'";
pdox.queryChanged(sql, {new:'tsugi@fred.com'}).then(
    function(retval) {
        console.log("UPDATE retval:",retval);
    }
);

Run a query and return the appropriate result for the query

This has more parameters and is typically used by methods with simpler signatures.

Replace {p} with the configured database table prefix.