beetle-query-extensions

Adds query extension methods to JavaScript arrays.


Keywords
ORM, OData, Unit, of, Work, Client, Side, Change, Tracker, JavaScript, TypeScript, angularjs, data-management, entity, entity-framework, knockout, linq, mvc, mvvm, webapi
License
MIT
Install
npm install beetle-query-extensions@3.0.0-alpha.17

Documentation

Beetle.js

Build status NuGet Badge npm version Known Vulnerabilities Join the chat at https://gitter.im/umutozel/Beetle.js

Beetle is a data manager for Javascript. The goal is to be able to work with data as easy as Entity Framework and LINQ.

Features

  • Tracks objects and persists changes to server
  • Can work with Knockout and ES5 properties (others can be implemented easily)
  • Can work with Q, Angular, ES6 and jQuery promises
  • Supports data model inheritance
  • Supports aggregate functions
  • Can work without metadata
  • Can work with Mvc and WebApi Controllers
  • Supports property, entity validations
  • Can use existing data annotation validations (carries multi-language resource messages to client)
  • Can query server with Http POST
  • Can be extended to support almost every library (client and server side), flexible architecture
  • Auto fix navigation properties (after foreign key set, entity attach etc..)
  • Can check-auto convert values for its proper data types
  • Can be internationalized (for internal messages, validation messages etc..)

Current prerequisities

All dependencies have base types so custom implementations can be made easily.

  • Entity Framework
  • WebApi or Asp.Net Mvc project for service
  • Knockout.js or EcmaScript5 Properties for providing observable properties

Usage

  • Create a Controller and inherit from BeetleApiController, generic argument tells we are using Entity Framework context handler with TestEntities context (DbContext)
public class BeetleTestController : BeetleApiController<EFContextHandler<TestEntities>> {
		
	[HttpGet]
	public IQueryable<Entity> Entities() {
		return ContextHandler.Context.Entities;
	}
}
  • Configure routing
public static class BeetleWebApiConfig {

	public static void RegisterBeetlePreStart() {
		GlobalConfiguration.Configuration.Routes.MapHttpRoute("BeetleApi", "api/{controller}/{action}");
	}
}
  • Create an entity manager
var manager = new EntityManager('api/BeetleTest');
  • Create a query
var query = manager.createQuery('Entities').where('e => e.Name != null');
  • Execute the query and edit the data
manager.executeQuery(query)
	.then(function (data) {
		self.entities = data;
        data[0].UserNameCreate = 'Test Name';
    })
  • Execute local query
var hasCanceled = self.entities.asQueryable().any('e => e.IsCanceled == true').execute();
// q is shortcut for asQueryable, x is shortcut for execute
var hasDeleted = self.entities.q().any('e => e.IsDeleted').x();
// alias is optional
var hasDeleted = self.entities.q().any('IsDeleted').x();

// with beetle.queryExtensions.js we can write queries like these;
// this query will be executed immediately and returns true or false
var hasExpired = self.entities.any('IsExpired == true');
// below query will be executed after it's length property is accessed (like LINQ GetEnumerator)
var news = self.entities.where('IsNew');
  • Add a new entity
var net = manager.createEntity('EntityType', {Id: beetle.helper.createGuid()});
net.Name = 'Test EntityType';
  • Delete an entity
manager.deleteEntity(net);
  • Save all changes
manager.saveChanges()
    .then(function () {
        alert('Save succesfull');
    })

Supported Data Types

string, guid, date, dateTimeOffset, time, boolean, int, number (for float, decimal, etc..), byte, enum, binary, geometry, geography (spatial types are supported partially, can be fully supported once we decide how to represent them at client side)

Validators

required, stringLength, maximumLength, minimumLength, range, emailAddress, creditCard, url, phone, postalCode, time, regularExpression, compare

Supported Query Expressions

ofType, where, orderBy, expand (include), select, skip, top (take), groupBy, distinct, reverse, selectMany, skipWhile, takeWhile, all, any, avg, max, min, sum, count, first, firstOrDefault, single, singleOrDefault, last, lastOrDefault

Supported Query Functions

toupper, tolower, substring, substringof, length, trim, concat, replace, startswith, endswith, indexof, round, ceiling, floor, second, minute, hour, day, month, year, max, min, sum, count, avg, any, all, contains (can be used in expression strings, some are not supported by OData but can be used with beetle query string format)

License

See License

drawing Thanks to JetBrains for providing me with free licenses to their great tools.