nmaguiar / nlinq Goto Github PK

View Code? Open in Web Editor NEW

1.0 3.0 0.0 648 KB

Provide JavaScript abstraction over different ways of "querying" arrays of maps/objects

License: Apache License 2.0

JavaScript 99.85% HTML 0.15%

browser javascript linq query

nlinq's Introduction

nLinq

Aims to be a replacement to the old jLinq providing most of the functionality hopefully faster than the original.

The aim is to provide a declarative JavaScript abstraction over different ways of "querying" arrays of maps/objects.

Examples:

// How many contacts there are with email ending in @domain.com
$from( arrayOfContacts )
.ends("email", "@domain.com")
.count();

// Sort all contacts in @domain.com by first name and last name
$from( arrayOfContacts )
.ends("email", "@domain.com")
.sort("firstName", "lastName")
.select()

Althought some code (OpenAFSigil) is borrowed from OpenAF it will be released for both in browser use and in OpenAF use.

Check out the nLinq reference.

Using in a browser

Example of using nLinq in a browser:

<html>
 <body>
  <h1>Test nLinq</h1>
  <script src="dist/nlinq.min.js"></script>
  <hr>

  <script> 
    var family = [
      { id: 1, firstName: "John", lastName: "Smith", bornYear: 1982, state: "NY" },
      { id: 2, firstName: "Anne", lastName: "Smith", bornYear: 1985, state: "NY" },
      { id: 3, firstName: "Steve", lastName: "Andrews", bornYear: 1997, state: "CA" },
      { id: 4, firstName: "Greg", lastName: "Andrews", bornYear: 1995, state: "CA" },
      { id: 5, firstName: "Louise", lastName: "Andrews", bornYear: 2012, state: "NY" },
      { id: 6, firstName: "Paul", "lastName": "Smith", bornYear: 2020, state: "CA" }
    ] 

    var _w = r => document.write(r)
    var showName = r => r.firstName + " " + r.lastName
    var _wArr = r => _w(r.map(showName).join(", ")) 
  </script>

  <p><b>Smiths in CA: </b><script>_wArr( $from( family )
                                        .equals("lastName", "Smith")
                                        .equals("state", "CA")
                                        .select())</script></p>

  <p><b>Youngest: </b><script>_w(showName( $from( family )
                                           .attach("age", r => new Date().getFullYear() - r.bornYear)
                                           .min("age")))</script></p>

 </body>
</html>

Currently not implemented comparing jLinq

This is not an exaustive list by just to provide a heads-up on what is still missing:

Functionality

Parameter arrays to apply functions over values.
Parameter on or, and, not, andNot & orNot.
Context key aware "where" methods.

nlinq's People

Contributors

Stargazers

Watchers

nlinq's Issues

Using double dollar strings for searching

Problem

Fails whenever trying to search a double dollar string. Example:

$from(["$$.g", "$$.s"]).equals("$$.g").count()   // returns 0

Add take, skip and skipTake

Add the JLinq take, skip and skipTake methods.

Limit, head and tail should apply to result set

Currently the limit, head and tail apply to the original source but it's "more intuitive" that they are applied to the end result set.

Cannot set property "_key" of null

Problem

When using $from under a map with a null entry an error equivalent to:

TypeError: Cannot set property "_key" of null to "b"

occurs.

Steps to reproduce:

var o = { a: 1, b: null, c: 2 };
$from(o)

Convert fields to a date type

In several cases is useful to sort an array by date but the field might not be a date type. So you end up doing this:

$from(array_of_data)
.attach(“date2”, r => new Date(r.date))
.sort(“date2”)
.select(r => ({ filename: r.filename, date: r.date2 })

It would be more practical and simple just to do:

$from(array_of_data)
.toDate(“date”)
.sort(“date”)
.select({ filename: “n/a”, date: “” })

_from( anArray )
.equals("names.firstName", "Joe")
.select()

useCase incorrectly changing settings

Problem

By default nLinq will be case insensitive:

> $from(["hello"]).equals("HELLO").any()
> false

but when setting useCase to true:

> $from(["hello"]).useCase(true).equals("HELLO").any()
> true

the result should be false.

List of fields selector

It’s already possible to map which fields to will be returned has a result:

// Providing the defaults
$from(array_of_data).select({ field1: “n/a”, field2: 0 })

// OR

$from(array_of_data).select(r => ({ f1: r.field1, field2: r.field2 }))

But it could be more practical to have an array of keys to do the same as the last function option:

$from(array_of_data).select([ “f1:field1”, “field2” ])

nmaguiar / nlinq Goto Github PK

nlinq's Introduction

nLinq

Using in a browser

Currently not implemented comparing jLinq

Functionality

nlinq's People

Contributors

Stargazers

Watchers

nlinq's Issues

Recommend Projects

Recommend Topics

Recommend Org