noinfopath-data

@version 0.2.30

Overview

NoInfoPath data provides several services to access data from local storage or remote XHR or WebSocket data services.

Dependencies

• AngularJS
• jQuery
• ngLodash
• Dexie
• Dexie Observable
• Dexie Syncable

Development Dependencies

See package.json for exact version requirements.

• indexedDB.polyfill
• angular-mocks
• es5-shim
• grunt
• grunt-bumpup
  • grunt-version
• grunt-contrib-concat
• grunt-contrib-copy
• grunt-contrib-watch
• grunt-karma
• jasmine-ajax
• jasmine-core
• jshint-stylish
• karma
• karma-chrome-launcher
• karma-coverage
• karma-firefox-launcher
• karma-html-reporter
• karma-ie-launcher
• karma-jasmine
• karma-phantomjs-launcher
• karma-safari-launcher
• karma-verbose-reporter
• noinfopath-helpers
• phantomjs

Developers' Remarks

|Who|When|What| |---|----|----| |Jeff|2015-06-20T22:25:00Z|Whaaat?|

@interface noInfoPath

Overview

This interface exposes some useful funtions on the global scope by attaching it to the window object as window.noInfoPath

Methods

getItem

setItem

bindFilters deprecated

noFilter deprecated

noFilterExpression deprecated

noDataReadRequest deprecated

noDataSource deprecated

digest deprecated

digestError deprecated

digestTimeout deprecated

@class NoFilterExpression : Object

Represents an single filter expression that can be applied to an IDBObjectStore.

Constructor

NoFilterExpression(column, operator, value [, logic])

|Name|Type|Description| |----|----|-----------| |column|String|The name of the column filter on.| |operator|String|One of the following values: eq, ne, gt, ge, lt, le, contains, startswith| |value|Any Primative or Array of Primatives or Objects | The vales to filter against.| |logic|String|(Optional) One of the following values: and, or.|

Properties

|Name|Type|Description| |----|----|------------| |column|String|The name of the column filter on.| |operator|String|One of the following values: eq, ne, gt, ge, lt, le, contains, startswith| |value|Any Primative or Array of Primatives or Objects | The vales to filter against.| |logic|String|(Optional) One of the following values: and, or.|

Class NoFilters : Array

NoFilters is an array of NoFilterExpression objects.

Properties

|Name|Type|Description| |----|----|------------| |length|Number|Number of elements in the array.|

Methods

add(column, operator, value[, logic])

Creates and adds a new NoFilterExpression into the underlying array that NoFilters represents.

Parameters

|Name|Type|Description| |----|----|------------| |column|String|The name of the column filter on.| |operator|String|One of the following values: eq, ne, gt, ge, lt, le, contains, startswith| |value|Any Primative or Array of Primatives or Objects | The vales to filter against.| |logic|String|(Optional) One of the following values: and, or.|

Class NoSortExpression : Object

Represents a single sort expression that can be applied to an IDBObjectStore.

Constructor

NoFilterExpression(column[, dir])

Properties

|Name|Type|Description| |----|----|------------| |column|String|The name of the column filter on.| |dir|String|(Optional) One of the following values: asc, desc.|

Class NoSort : Array

NoSort is an array of NoSortExpression objects.

Properties

|Name|Type|Description| |----|----|------------| |length|Number|Number of elements in the array.|

Methods

add(column[, dir])

Creates and adds a new NoSortExpression into the underlying array that NoSort represents.

Parameters

|Name|Type|Description| |----|----|------------| |column|String|The name of the column filter on.| |dir|String|(Optional) One of the following values: asc, desc.|

Class NoPage : Object

NoPage represent that information required to support paging of a data set.

Constructor

NoPage(skip, take)

Properties

|Name|Type|Description| |-|-|-| |skip|Number|Number of objects to skip before returning the desired amount specified in take.| |take|Number|Number of objects records to return when paging data.|

Class NoResults : Object

NoResults is a wrapper around a standard JavaScript Array instance. It inherits all properties and method offered by Array, but adds support for paged queries.

@constructor NoResults(arrayOfThings)

Parameters

|Name|Type|Description| |----|----|-----------| |arrayOfThings|Array|(optional) An array of object that is used to populate the object on creation.|

Properties

Inherited properties are omitted.

|Name|Type|Description| |----|----|-----------| |total|Number|The total number of items in the array|

Methods

page(options)

Parameters

|Name|Type|Description| |----|----|-----------| |options|NoPage|A NoPage object that contains the paging instructions|

Parameters

|Name|Type|Description| |----|----|-----------| |arrayOfThings|Array|(optional) An array of object that is used to populate the object on creation.|

Returns

void

@class NoFilterExpression : Object

Represents an single filter expression that can be applied to an IDBObjectStore.

Constructor

NoFilterExpression(column, operator, value [, logic])

|Name|Type|Description| |----|----|-----------| |column|String|The name of the column filter on.| |operator|String|One of the following values: eq, ne, gt, ge, lt, le, contains, startswith| |value|Any Primative or Array of Primatives or Objects | The vales to filter against.| |logic|String|(Optional) One of the following values: and, or.|

Properties

|Name|Type|Description| |----|----|------------| |column|String|The name of the column filter on.| |operator|String|One of the following values: eq, ne, gt, ge, lt, le, contains, startswith| |value|Any Primative or Array of Primatives or Objects | The vales to filter against.| |logic|String|(Optional) One of the following values: and, or.|

Class NoFilters : Array

NoFilters is an array of NoFilter objects.

Constructors

NoFilters()

Usage

var x = new noInfoPath.data.NoFilters()

Properties

|Name|Type|Description| |----|----|------------| |length|Number|Number of elements in the array.|

Methods

add(column, logic, beginning, end, filters)

Creates and adds a new NoFilter into the underlying array that NoFilters represents.

Parameters

|Name|Type|Description| |----|----|------------| |column|String|The name of the column to filter on.| |logic|String|One of the following values: 'and', 'or'| |beginning|Boolean|If the NoFilter is the beginning of the filter expression| |end|Boolean|If the NoFilter is the end of the filter expression| |filters|Array|Array of NoFilterExpressions|

toSQL()

Converts the NoFilters array to a partial SQL statement. It calls the toSQL() method on every NoFilter object within the NoFilters array.

Parameters

None

Class NoFilter : Object

NoFilter is an object with some properties that has an array of NoFilterExpressions hanging off of it.

Properties

|Name|Type|Description| |----|----|------------| |column|String|The column that will be filtered on| |logic|String|One of the following values: 'and', 'or'| |beginning|Boolean|If the NoFilter is the beginning of the filter expression| |end|Boolean|If the NoFilter is the end of the filter expression| |filters|Array|Array of NoFilterExpressions|

Methods

toSQL()

Converts the current NoFilter object to a partial SQL statement. It calls the NoFilterExpression toSQL() method for every NoFilterExpression within the filters array.

Parameters

|Name|Type|Description| |----|----|------------| |column|String|The name of the column filter on.| |operator|String|One of the following values: eq, ne, gt, ge, lt, le, contains, startswith| |value|Any Primative or Array of Primatives or Objects | The vales to filter against.| |logic|String|(Optional) One of the following values: and, or.|

Class NoSort : Array

NoSort is an array of NoSortExpression objects.

Properties

|Name|Type|Description| |----|----|------------| |length|Number|Number of elements in the array.| |total|Number|Total number of rows available given the current filters.| |paged|Array|An array of object sliced on the skip and take parameters passed into the constructor.|

Methods

add(column[, dir])

Creates and adds a new NoSortExpression into the underlying array that NoSort represents.

Parameters

|Name|Type|Description| |----|----|------------| |column|String|The name of the column filter on.| |dir|String|(Optional) One of the following values: asc, desc.|

@interface INoQueryParser

INoQueryParser is a conceptual entity, it does not really exist the reality. This is because JavaScript does not implement interfaces like other languages do. This documentation should be considered a guide for creating query parsers compatible with NoInfoPath.

Overview

INoQueryParser provides a service interface definition for converting a set of NoInfoPath class related to querying data into a given query protocol. An example of this is the ODATA 2.0 specification.

Methods

makeQuery(filters, sort, page)

Parameters

|Name|Type|Descriptions| |----|----|------------| |filters|NoFilters|(Optional) Instance of a NoFilters class| |sort|NoSort|(Optional) Instance of NoSort class| |page|NoPage|(Optional) Instance of NoPage class|

Returns

Object

noQueryParser

Overview

The noQueryParser takes the data property of the options parameter passed to the Kendo DataSources transport.read method. The data object is inspected and its filter, sort, and paging values are converted to NoInfoPath compatible versions.

Methods

parse(options)

Parses provided filter, sort and paging options into NoInfoPath compatible objects. Stores the results internally for future use.

Returns

Any/all filters, sorts or paging data as an array compatible with a call to function.prototype.array.

Properties

None.

noQueryParser : INoQueryParser

Overview

Implements a INoQueryBuilder compatible service that converts NoFilters, NoSort, NoPage into ODATA compatible query object.

@class MockStorage

@class NoStorage

@service noConfig

Overview

The noConfig service downloads the application's config.json and exposes its contents via the noConfig.current property. If the application's server is offline noConfig will try to load config.json from LocalStorage.

Properties

|Name|Type|Description| |----|----|-----------| |current|object|exposes the entire download config.json|

Methods

fromCache()

Loads the configuration from LocalStorage.

Parameters

none

Returns

String

load(uri)

Loads the conifiguration data from and HTTP endpoint.

Parameters

|Name|Type|Description| |----|----|-----------| |uri|string|(optional) A relative or fully qualified location of the configuration file. If not provided the default value is /config.json|

Returns

AngularJS::promise

whenReady(uri)

Returns a promise to notify when the configuration has been loaded. If the server is online, whenReady will call load, if not it will try to load it from LocalStorage. If there is no cached version available then an error is returned.

Once the config.json is resolved is it stored on $rootScope as $rootScope.noConfig

Parameters

|Name|Type|Description| |----|----|-----------| |uri|string|(optional)A relative or fully qualified location of the configuration file. If not provided the default value is /config.json|

Returns

AngularJS::promise

@service noHTTP

Overview

Provides a RESTful compatible HTTP service.

Methods

create(uri, data)

Parameters

|Name|Type|Description| |----|----|-----------| |uri|string|unique identifier of the table to operate against| |data|object|the data to use to create the new obejct in the db|

read(resourceURI, query)

update(resourceURI, formdata)

TODO: Implementation required.

destroy(resourceURI, formdata)

TODO: Implementation required.

@class NoDb

Overview

Creates and manages a set of NoTable objects.

@constructor NoDb(tables, queryBuilder)

Parameters

|Name|Type|Description| |----|----|-----------| |tables|object|A hash object that contains a collection of table configuration as provided by noDbScema| |queryBuilder|function|a reference to a function that compiles supplied NoFilters, NoSort, and NoPage objects into a query object compatible with the upstream provider.|

@class NoTable

Overview

Provides an interface that loosely matches that of the NoTable class provided by noDexie. This to ease the integration with NoInfoPath component that consume data such as noKendo.

@constructor NoTable(tableName, queryBuilder)

Parameters

|Name|Type|Description| |----|----|-----------| |tableName|string|name of the table that this instance will interact with.| |queryBuilder|function|a reference to a function that compiles supplied NoFilters, NoSort, and NoPage objects into a query object compatible with the upstream provider.|

noDbSchema

The noDbSchema service provides access to the database configuration that defines how to configure the local IndexedDB data store.

Properties

|Name|Type|Description| |----|----|-----------| |store|Object|A hash table compatible with Dexie::store method that is used to configure the database.| |tables|Object|A hash table of NoInfoPath database schema definitions| |isReady|Boolean|Returns true if the size of the tables object is greater than zero|

Methods

_processDbJson

Converts the schema received from the noinfopath-rest service and converts it to a Dexie compatible object.

Parameters

|Name|Type|Descriptions| |----|----|------------| |resp|Object|The raw HTTP response received from the noinfopath-rest service|

load()

Loads and processes the database schema from the noinfopath-rest service.

Returns

AngularJS::Promise

whenReady

whenReady is used to check if this service has completed its load phase. If it has not is calls the internal load method.

Returns

AngularJS::Promise

noDbSchema

The noDbSchema service provides access to the database configuration that defines how to configure the local IndexedDB data store.

Properties

|Name|Type|Description| |----|----|-----------| |store|Object|A hash table compatible with Dexie::store method that is used to configure the database.| |tables|Object|A hash table of NoInfoPath database schema definitions| |isReady|Boolean|Returns true if the size of the tables object is greater than zero|

NoDbSchema : Class

This provides

Constructors

Constructor()

Usage

var x = new NoDbSchema();

Parameters

None

Methods

createSqlTableStmt(tableName, tableConfig)

Returns a SQL query string that creates a table given the provided tableName and tableConfig

Usage

var x = createSqlTableStmt(tableName, tableConfig);

Parameters

|Name|Type|Description| |----|----|-----------| |tableName|String|The name of the table to be created| |tableConfig|Object|The schema of the table to be created|

Returns

Returns a SQL query string

Properties

|Name|Type|Description| |----|----|-----------| |queryString|String|Returns a SQL query string that creates a table given the provided tableName and tableConfig|

{
	"dbName": "NoInfoPath_dtc_v1",
	"provider": "noIndexedDB",
	"remoteProvider:": "noHTTP",
	"version": 1,
	"schemaSource": {
		"provider": "inline",
		"schema": {
			"store": {
				"NoInfoPath_Changes": "$$ChangeID"
			},
			"tables": {
				"NoInfoPath_Changes": {
					"primaryKey": "ChangeID"
				}
			}
		}
	}
}

NoDbSchemaFactory

Creates unique instances of NoDbSchema based on noDBSchema configuration data.

NOTE: noDbSchema property of noConfig is an array of NoInfoPath data provider configuration objects.

@interface INoQueryBuilder

INoQueryBuilder is a conceptual entity, it does not really exist the reality. This is because JavaScript does not implement interfaces like other languages do. This documentation should be considered as a guide for creating query providers compatible with NoInfoPath.

Overview

INoQueryBuilder provides a service interface definition for converting a set of NoInfoPath class related to querying data into a given query protocol. An example of this is the ODATA 2.0 specification.

Methods

makeQuery(filters, sort, page)

Parameters

|Name|Type|Descriptions| |----|----|------------| |filters|NoFilters|(Optional) Instance of a NoFilters class| |sort|NoSort|(Optional) Instance of NoSort class| |page|NoPage|(Optional) Instance of NoPage class|

Returns

Object

@service noSQLQueryBuilder : INoQueryBuilder

Overview

Implements a INoQueryBuilder compatible service that converts NoFilters, NoSort, NoPage into a WebSQL compatible query string.

createTable(tableName, table)

Parameters

|Name|Type|Description| |----|----|-----------| |type|String|One of T|V| |tableName|String|The table's name| |table|Object|The table schema|

NoTable

CRUD interface for WebSql

_getOne(rowid)

Parameters

|Name|Type|Description| |----|----|-----------| |rowid|Number or Object| When a number assume that you are filtering on "rowId". When an Object the object will have a key, and value property.|

_exec(sqlExpressionData)

Parameters

|Name|Type|Description| |----|----|-----------| |sqlExpressionData|Object|An object with two properties, queryString and valueArray. queryString is the SQL statement that will be executed, and the valueArray is the array of values for the replacement variables within the queryString.|

webSqlOperation(operation, noTransaction, data)

Parameters

|Name|Type|Description| |----|----|-----------| |operation|String|Either one of (C|U|D|BD|BC)| |noTransaction|Object|The noTransaction object that will commit changes to the NoInfoPath changes table for data synchronization. This parameter is required, but can be null.| |data|Object|Name Value Pairs|

noCreate(data, noTransaction)

Inserts a record into the websql database with the data provided.

Parameters

|Name|Type|Description| |----|----|-----------| |data|Object|Name Value Pairs| |noTransaction|Object|The noTransaction object that will commit changes to the NoInfoPath changes table for data synchronization|

noRead([NoFilters, NoSort, NoPage])

Reads records from the websql database.

Parameters

|Name|Type|Description| |----|----|-----------| |NoFilters|Object|(Optional) A noInfoPath NoFilters Array| |NoSort|Object|(Optional) A noInfoPath NoSort Object| |NoPage|Object|(Optional) A noInfoPath NoPage Object|

noUpdate(data, noTransaction)

Updates a record from the websql database based on the Primary Key of the data provided.

Parameters

|Name|Type|Description| |----|----|-----------| |data|Object|Name Value Pairs| |noTransaction|Object|The noTransaction object that will commit changes to the NoInfoPath changes table for data synchronization|

noDestroy(data, noTransaction)

Deletes a record from the websql database based on the Primary Key of the data provided.

Parameters

|Name|Type|Description| |----|----|-----------| |data|Object|Name Value Pairs| |noTransaction|Object|The noTransaction object that will commit changes to the NoInfoPath changes table for data synchronization|

noOne(data)

Reads a record from the websql database based on the Primary Key of the data provided.

Parameters

|Name|Type|Description| |----|----|-----------| |data|Object|Name Value Pairs|

noClear()

Delete all rows from the current table.

Returns

AngularJS Promise.

NoView

An in memory representation of complex SQL operation that involes multiple tables and joins, as well as grouping and aggregation functions.

NoView JSON Prototype

{
	"sql": String,
	"primaryKey": String,
	"params": []
}

References

• https://www.sqlite.org/lang_createview.html

noOne(data)

Reads a record from the websql database based on the Primary Key of the data provided.

Parameters

|Name|Type|Description| |----|----|-----------| |data|Object|Name Value Pairs|

noIndexedDB

The noIndexedDB factory creates and configures a new instance of Dexie. Dexie is a wrapper around IndexedDB. noIndexedDB is a Dexie AddOn that extends the query capabilites of Dexie, and exposes a CRUD interface on the WriteableTable class.

Class noDatum

This is a contructor function used by Dexie when creating and returning data objects.

Class noDexie

This is the classed used to construct the Dexie AddOn.

noCreate

Adds a new record to the database. If the primary key is provided in that will be used when adding otherwise a new UUID will be created by Dexie.

Parameters

|Name|Type|Description| |data|Object|An object contains the properties that match the schema for the underlying WriteableTable.

Returns

AngularJS:Promise

noRead

The read operation takes a complex set of parameters that allow for filtering, sorting and paging of data.

Parameters

|Name|Type|Descriptions| |----|----|------------| |filters|NoFilters|(Optional) Any NofilterExpression objects that need to be applied to the the current table.| |sort|NoSort|(Optional) Any NoSortExpression objects that need to be applied to the result set. The will be applied in the order supplied.| |page|NoPage|(Optional) Paging information, if paging is reqired by the read operation.|

Returns

AngularJS::Promise

Internal Values

|Name|Type|Description| |------|-----|-------------| |deferred|$q::deferred|An AngularJS deferment object that is used to return a Promise.| |_resolve|Function|Call to resolve Dexie::Promise upon successful completion of _applyFilters(). This function is returned while resolving the underlying IDBObjectStore from the table parameter.| |_reject|Function|Call to resolve the Dexie::Promise when an unexpected for un recoverable error occurs during processing.| |_store|IDBObjectStore|This underlying IDBObjectStore that the table parameter represents.| |_trans|IDBTransaction|This is the underlying IDBTransaction that the current object store is bound to.|

nonIndexedOperators

This hash table allows for quick access to the operations that can be applied to a property on a target object and the value(s) being filtered on.

NOTE: The "a" parameter will always be the value tested, and "b" will always be the value being filter for.

_applyFilters

This function develops an array of objects that has had all of the filters provided in the original request applied to them. The schema matches the schema of the table parameter.

Parameters

|Name|Type|Description| |----|----|------| |iNofilters|[iNoFilterExpression]|An array of filter expressions. Contains both indexed and non-indexed filters| |table|Dexie::Table|A reference to the Dexie::Table being filtered.

Internal variables

|Name|Type|Description| |------|-----|-------------| |deferred|$q::deferred|An AngularJS deferment object that is used to return a Promise.| |iNoFilterHash|Collection|Used to organize the filters received in the iNoFilters in to a set of indexed and non-indexed filter object The collection is created by a call to _sortOutFilters().| |resultsKeys|Array<guid>|This will be use to collect the final set of results. It will be an array of keys that will be used to query the final result set.|

Returns

AngularJS::Promise (Maybe)

_filterByIndex

This method of filtering goes against a predefined index. Basically we are doing a MapReduce techique angaist each indexed filter we come across. Using the filter parameter provided the index is reduced by matching against the value property of the INoFilterExpression. See the INoFilterExpression for more details.

Parameters

|Name|Type|Description| |------|-----|-------------| |filter|INoFilterExpression|A single indexed filter the contains the column, operator, and value to apply to the index.|

Returns

AngularJS::Promise

_filterByPrimaryKey -- Being Deprecated

This method of of filterig goes against the IDBObjectStore's primary key.

_filterHasIndex uses the iNoFilter parameter to determine if there is an index available for the give filter. it returns true if there is, false if not.

To determine if and index exists, we look at the table.schema.primKey, and table.schema.indexes properties.

_recurseIndexedFilters

This method of filtering compares the supplied set of filters against each object return in the Dexie colletion. This is a much slower than filtering against an index.

While Dexie supports a put operation which is similar to upsert, we're going with upsert which decides whether an insert or an update is required and calls the appropreiate function.

configure

This function splits up the filters by indexed verses not. The return value is a INoFilterHash.

interface INoFilterHash { indexedFilters: [INoFilterExpression] nonIndexedFilters: [INoFilterExpression] }

This function applies the provided sort items to the supplied Dexie:Collection. It should always sort on indexed columns and return a DexieCollection.

NOTE: Need to research how to apply multi-column sorting.

Applies the specified skip and take values to the final Dexie::Collection, if supplied.

Note that this is the function returns the final Array of items based on all of the properties applied prior to this call.

The promise should resolve to a Dexie::Collection that will result in a set of data that matches the supplied filters, reject errors.

The update function expects the key to be within the update object.

Maps to the Dexie.Table.get method.

_extendDexieTables

Class noDatum

This is a contructor function used by Dexie when creating and returning data objects.

noDataSource Service

Provides a generic service that exposes the NoInfoPath data providers' underlying CRUD interface.

"noDataSource": {
       "dataProvider": "noWebSQL",
       "databaseName": "FCFNv2",
       "entityName": "LU_PercentColor",
       "primaryKey": "PercentColorID",
       "queryParser": "noQueryParser",
       "sort":  [{"field": "Percentage", "dir": "asc"}]
   }

resolveFilterValues(filters)

This is more information

Note of some kind

|Name|Type|Description| |----|----|-----------| |Foo|Number|Does something fun.|

TODO: Implement support for delayed (waitFor) filter values.

NOTE: If a filter.value is an object and it has a source property set to scope then use the directives scope variable. Otherwise assume source is an injectable.

create(dsConfigKey)

create a new instance of a NoDataSource object configured based on the datasource configuration found in noConfig at the given dsConfigKey location.

Parameters

|Name|Type|Description| |----|----|-----------| |dsConfigKey|String|The location in noConfig where the data source's configuration can be found. Can be a complex name like the following. noForms.myForm1.noComponents.foo.noDataSource|

Returns

An instance of a NoDataSource object.