noinfopath-data v0.2.30

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

@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)

Properties

Class NoFilters : Array

NoFilters is an array of NoFilterExpression objects.

Properties

Methods

add(column, operator, value, logic)

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

Parameters

Class NoSortExpression : Object

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

Constructor

NoFilterExpression(column, dir)

Properties

Class NoSort : Array

NoSort is an array of NoSortExpression objects.

Properties

Methods

add(column, dir)

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

Parameters

Class NoPage : Object

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

Constructor

NoPage(skip, take)

Properties

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

Properties

Inherited properties are omitted.

Methods

page(options)

Parameters

Parameters

Returns

void

@class NoFilterExpression : Object

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

Constructor

NoFilterExpression(column, operator, value , logic)

Properties

Class NoFilters : Array

NoFilters is an array of NoFilter objects.

Constructors

NoFilters()

Usage

var x = new noInfoPath.data.NoFilters()

Properties

Methods

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

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

Parameters

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

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

Class NoSort : Array

NoSort is an array of NoSortExpression objects.

Properties

Methods

add(column, dir)

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

Parameters

@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

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

Methods

fromCache()

Loads the configuration from LocalStorage.

Parameters

none

Returns

String

load(uri)

Loads the conifiguration data from and HTTP endpoint.

Parameters

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

Returns

AngularJS::promise

@service noHTTP

Overview

Provides a RESTful compatible HTTP service.

Methods

create(uri, data)

Parameters

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

@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

noDbSchema

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

Properties

Methods

_processDbJson

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

Parameters

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

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

Returns

Returns a SQL query string

Properties

{
	"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

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

NoTable

CRUD interface for WebSql

_getOne(rowid)

Parameters

_exec(sqlExpressionData)

Parameters

webSqlOperation(operation, noTransaction, data)

Parameters

noCreate(data, noTransaction)

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

Parameters

noRead(NoFilters, NoSort, NoPage)

Reads records from the websql database.

Parameters

noUpdate(data, noTransaction)

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

Parameters

noDestroy(data, noTransaction)

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

Parameters

noOne(data)

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

Parameters

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

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

Returns

AngularJS::Promise

Internal Values

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

Internal variables

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

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

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

Returns

An instance of a NoDataSource object.