dojox/sql/_base.js

• Provides:

  • dojox.sql._base

• Requires:

  • dojox.sql._crypto in common

• dojox.sql.dbName

  • type

    Object

• dojox.sql.debug

• dojox.sql.open

  • parameters:
    • dbName
  • type

    Function

• dojox.sql.open.dbName

  • type

    Object

• dojox.sql.open._dbOpen

  • type

    Object

• dojox.sql.close

  • parameters:
    • dbName
  • type

    Function

• dojox.sql.close.dbName

• dojox.sql.close._dbOpen

  • type

    bool

• dojox.sql._exec

  • parameters:
    • params
  • returns

    encrypted results will arrive asynchronously|decrypted results will arrive asynchronously

  • type

    Function

• dojox.sql._exec._autoClose

  • type

    Object

• dojox.sql._initDb

  • type

    Function

• dojox.sql._initDb.db

  • type

    Object

• dojox.sql._printDebugSQL

  • parameters:
    • sql
    • args
  • type

    Function

• dojox.sql._normalizeResults

  • parameters:
    • rs
  • type

    Function

• dojox.sql._needsEncrypt

  • parameters:
    • sql
  • type

    Function

• dojox.sql._needsDecrypt

  • parameters:
    • sql
  • type

    Function

• dojox.sql

  • summary

    If true, then we print out any SQL that is executed
    to the debug window

  • description

    There are four ways to call this:
    1) Straight SQL: dojox.sql("SELECT * FROM FOOBAR");
    2) SQL with parameters: dojox.sql("INSERT INTO FOOBAR VALUES (?)", someParam)
    3) Encrypting particular values:
    dojox.sql("INSERT INTO FOOBAR VALUES (ENCRYPT(?))", someParam, "somePassword", callback)
    4) Decrypting particular values:
    dojox.sql("SELECT DECRYPT(SOMECOL1), DECRYPT(SOMECOL2) FROM
    FOOBAR WHERE SOMECOL3 = ?", someParam,
    "somePassword", callback)
    
    For encryption and decryption the last two values should be the the password for
    encryption/decryption, and the callback function that gets the result set.
    
    Note: We only support ENCRYPT(?) statements, and
    and DECRYPT(*) statements for now -- you can not have a literal string
    inside of these, such as ENCRYPT('foobar')
    
    Note: If you have multiple columns to encrypt and decrypt, you can use the following
    convenience form to not have to type ENCRYPT(?)/DECRYPT(*) many times:
    
    dojox.sql("INSERT INTO FOOBAR VALUES (ENCRYPT(?, ?, ?))",
    someParam1, someParam2, someParam3,
    "somePassword", callback)
    
    dojox.sql("SELECT DECRYPT(SOMECOL1, SOMECOL2) FROM
    FOOBAR WHERE SOMECOL3 = ?", someParam,
    "somePassword", callback)

  • mixins:
    • dojox.sql: (normal)
  • alias - dojox.sql
  • type

    Object

• dojox.sql._SQLCrypto

  • type

    Function

  • parameters:
    • action
    • sql
    • password
    • args
    • callback
  • summary

    A private class encapsulating any cryptography that must be done
    on a SQL statement. We instantiate this class and have it hold
    it's state so that we can potentially have several encryption
    operations happening at the same time by different SQL statements.

• dojox.sql._SQLCrypto.constructor

  • constructor - constructor
  • type

    Function

  • parameters:
    • action
    • sql
    • password
    • args
    • callback

• dojox.sql._SQLCrypto._execEncryptSQL

  • parameters:
    • sql
    • password
    • args
    • callback
  • type

    Function

• dojox.sql._SQLCrypto._execDecryptSQL

  • parameters:
    • sql
    • password
    • args
    • callback
  • type

    Function

• dojox.sql._SQLCrypto._encrypt

  • parameters:
    • sql
    • password
    • args
    • encryptColumns
    • callback
  • type

    Function

• dojox.sql._SQLCrypto._totalCrypto

  • type

    Number

• dojox.sql._SQLCrypto._finishedCrypto

  • type

    Number

• dojox.sql._SQLCrypto._finishedSpawningCrypto

  • type

    Object

• dojox.sql._SQLCrypto._finalArgs

• dojox.sql._SQLCrypto._decrypt

  • parameters:
    • resultSet
    • needsDecrypt
    • password
    • callback
  • type

    Function

• dojox.sql._SQLCrypto._finalResultSet

• dojox.sql._SQLCrypto._stripCryptoSQL

  • parameters:
    • sql
  • type

    Function

• dojox.sql._SQLCrypto._flagEncryptedArgs

  • parameters:
    • sql
    • args
  • type

    Function

• dojox.sql._SQLCrypto._determineDecryptedColumns

  • parameters:
    • sql
  • type

    Function

• dojox.sql._SQLCrypto._decryptSingleColumn

  • parameters:
    • columnName
    • columnValue
    • password
    • currentRowIndex
    • callback
  • type

    Function

• dojox.sql._base

  • type

    Object

• dojox

  • type

    Object