npm

linq-fns
TypeScript icon, indicating that this package has built-in type declarations

0.0.5-beta • Public • Published

linq-fns

.NET LINQ functions for JavaScript written in TypeScript.

  • ⚡ Provides Queryable<T>,which is reusable, variable and uses a predicate collection for deferred execution.
  • 🔨 Contains most of the original .NET methods and some additional methods.
  • 🔨 Supports Promise as an input source.
  • 🙅 All APIs are JavaScript native methods so can be easily incorporated into existing JavaScript projects.
  • 📊 Includes some simple drivers (such as Firebase Realtime database).
npm install linq-fns --save

This version is an alpha release so if you have any problems, please don't hesitate to let me know. 👋

Browser client files can be found in the release folder.

Basic example

Node or browser

// ES6
import { Queryable } from 'linq-fns';

// ES5
const Queryable = require('linq-fns').Queryable;

let query = Queryable
            .from(nations)
            .join(continents, (x, y) => x.areaId === y.id)
            .groupBy(o => o.y.areaName)
            .select(x => {
                return {
                    area: x.key,
                    total: Queryable.fromSync(x.items).count() // This will return a number, not Promise<number>
                }
            })
const asyncData = query.toList(); // Will return Promise<{area:string, total:number}>
asyncData.then(data => {
    console.log(data);
    // [
    //     {area: 'Euro': total: 2},
    //     {area:'South America', total: 1}
    // ]

// Or use async/await
const data = await query.toList();
console.log(data);
});

Firebase

const FireBaseQueryable = require('linq-fns').FireBaseQueryable;
const admin = require('firebase-admin');
const serviceAccount = require('./serviceAccountKey');

admin.initializeApp({
    credential: admin.credential.cert(serviceAccount),
    databaseURL: 'https://xxx.firebaseio.com'
});

const db = admin.database();
const postsQuery = new FireBaseQueryable(db,'<yourdb>.posts');

// READ AND QUERY DATA
// ES5 Promise
postsQuery.getQuery().where('...').select('...').toList().then(x=>'...');

// Async/await
const data = await postsQuery.getQuery().where('...').select('...').toList();

// WRITE DATA
// Prepare calls, but do not send requests to server
postsQuery.add(item);
postsQuery.remove(item);
postsQuery.update(item);

// Call this to execute 3 above methods
postsQuery.commitChanges();

localStorage

// Node
const LocalStorageQueryable = require('linq-fns').LocalStorageQueryable;

const postsQuery = new LocalStorageQueryable("posts");

postsQuery.add(item);
postsQuery.remove(item);
postsQuery.update(item);

// Call this to execute 3 above methods
postsQuery.commitChanges();

gist file

//Node
const GistQueryable = require('linq-fns').GistQueryable;

const postsQuery = new GistQueryable(
    "6d183b7f997819cd5a8354f35c1e471f123", // gist file
    "259f97b96762c9d3a155630d12321fd1cfaf253ff", // access token
    "posts") // table name

postsQuery.add(item);
postsQuery.remove(item);
postsQuery.update(item);
postsQuery.commitChanges();

Process

1.Methods

  • [x] from
  • [x] where
  • [x] select
  • [x] selectMany
  • [x] join
  • [x] leftJoin
  • [x] groupJoin
  • [x] orderBy
  • [x] orderByDescending
  • [x] take
  • [x] takeWhile
  • [x] skip
  • [x] skipWhile
  • [x] groupBy
  • [x] distinct
  • [x] concat
  • [x] zip
  • [x] union
  • [x] intersect
  • [x] except
  • [x] first : Promise<T>
  • [x] firstOrDefault : Promise<T | null>
  • [x] last : Promise<T>
  • [x] lastOrDefault : Promise<T | null>
  • [x] single
  • [x] singleOrDefault
  • [x] contains
  • [x] sequenceEqual
  • [x] any : Promise<boolean>
  • [x] all : Promise<boolean>
  • [x] count : Promise<number>
  • [x] min : Promise<number>
  • [x] max : Promise<number>
  • [x] sum : Promise<number>
  • [x] average
  • [x] aggregate
  • [x] toList : Promise<T[]>

2. Drivers

  • [x] Firebase : Node
  • [x] Localstorage : Node & Browser
  • [x] Gists Github : Node & Browser
  • [ ] ...

License

MIT License

Package Sidebar

Install

npm i linq-fns

Weekly Downloads

0

Version

0.0.5-beta

License

ISC

Unpacked Size

162 kB

Total Files

168

Last publish

Collaborators

  • jinhduong