2017 © Pedro Peláez
 

silverstripe-vendormodule jsontext

JSON storage, querying and modification.

image

phptek/jsontext

JSON storage, querying and modification.

  • Monday, April 30, 2018
  • by phptek
  • Repository
  • 3 Watchers
  • 8 Stars
  • 232 Installations
  • PHP
  • 2 Dependents
  • 0 Suggesters
  • 2 Forks
  • 5 Open issues
  • 20 Versions
  • 404 % Grown

The README.md

SilverStripe JSONText

Build Status Scrutinizer Code Quality License, (*1)

Exposes a complete API that allows developers to write-to, and query-from JSON in a dedicated DBField subclass., (*2)

In addition, if your project uses the silverstripe/cms package, then all SiteTree objects are automatically extended to allow multiple, arbitrary UI fields as declared in getCMSFields(), to write to a JSON object in a single database field., (*3)

Using JSONPath (Think XPath but for JSON) and the module's extensive API, developers can selectively target specific JSON keys for modification., (*4)

Requirements

SilverStripe 4

  • Use ^2.0
  • PHP >=5.6, <=7.1

SilverStripe 3

  • Use ^1.0
  • PHP >=5.4, <7.0

Features

  • Store JSON "object-strings" in a JSON-specific DBField subclass.
  • Query stored JSON via simple accessors: first(), last() & nth() or Postgres-like operators: ->, ->> & #> or even JSONPath expressions.
  • Selectively return query-results as JSON, Array or cast to SilverStripe's DBVarchar, DBInt, DBFloat or DBBoolean objects.
  • Selectively update portions of stored JSON using JSONPath expressions.
  • Selectively transform one or more CMS input fields, to write to a single JSON store.

Introduction

The module exposes a fully featured JSON query and update API allowing developers to use XPath-like queries via JSONPath or Postgres' JSON operators (with some differences, see below) to query and update JSON data., (*5)

Why?

Project scenarios where storing 10s of terse configuration parameters as Booleans and Ints in separate database columns just seems crazy., (*6)

When all you wanted was a simple key / value store but didn't want to muck about with the overhead of an RDBMS and a NOSQL DB., (*7)

That Postgres, MySQL, Oracle and MSSQL 2016 all have, or at time of writing, are planning to have, Database level JSON field-types. This module plugs the gap for users of RDBMS' without native JSON support, while offering the a convenient scaffold on top of which native JSON support could be built., (*8)

Postgres

In Postgres both the -> and ->> operators act as string and integer key matchers on a JSON array or JSON object respectively. The module however treats both source types the same - they are after all both JSON so -> is used as an Integer Matcher and ->> as a String Matcher regardless of the "type" of source JSON stored. The #> Path Matcher operator can act as an object or a text matcher, but the module wishes to simplify things and as such the #> operator is just a simple path matcher., (*9)

Return types

Regardless of the type of query you can set what type you'd like the data returned in via the setReturnType() method on a query by query basis., (*10)

Legitimate types are:, (*11)

  • JSON
  • Array
  • SilverStripe

If using SilverStripe as the return type, the module will automatically cast the result(s) to one of SilverStripe's DBObject subtypes:, (*12)

  • DBBoolean
  • DBInt
  • DBFloat
  • DBVarchar

If there are multiple results from a query, the output will be an indexed array containing a single-value array for each result found., (*13)

The module also allows developers to selectively update all, or just parts of the source JSON, via JSONPath expressions passed to an overloaded setValue() method., (*14)

See the usage docs for examples of JSONPath and Postgres querying and updating., (*15)

Note: This module's query API is based on a relatively simple JSON to array conversion principle. It does not use Postgres' or MySQL's native JSON operators at or below the level of the ORM. The aim however is to allow dev's to use their preferred DB's syntax, and to this end you can set the module into mysql or postgres mode using SS config, see Configuration Docs., (*16)

Installation

#> composer require phptek/jsontext

Configuration

See: Configuration Docs., (*17)

Usage

See: Usage Docs., (*18)

Contributing

If you've been using Postgres or MySQL with its JSON functions for some time, I'm keen to hear from you. Some simple failing tests would be most welcome., (*19)

See: CONTRIBUTING.md., (*20)

Reporting an issue

Please include all details, no matter how small. If it were your module, what would you need to know from a bug/feature request? :-), (*21)

Credits

Author

Russell Michell 2016-2018 russ@theruss.com, (*22)

TODO

  • Add missing prepValueForDB() to JSONText class.
  • See official list of issues on GitHub.

Support Me

If you like what you see, support me! I accept Bitcoin:, (*23)

Bitcoin
3KxmqFeVWoigjvXZoLGnoNzvEwnDq3dZ8Q

 , (*24)

 , (*25)

The Versions

30/04 2018

3.x-dev

3.9999999.9999999.9999999-dev

JSON storage, querying and modification.

  Sources   Download

BSD-3-Clause

The Requires

 

by Russell Michell

json postgres query text silverstripe multi dbfield jsonpath multivalue multivaluefield

30/04 2018

dev-master

9999999-dev

JSON storage, querying and modification.

  Sources   Download

BSD BSD-3-Clause

The Requires

 

The Development Requires

by Russell Michell

json postgres query text silverstripe field multi dbfield jsonpath json field multivalue multivaluefield

30/04 2018

4.x-dev

4.9999999.9999999.9999999-dev

JSON storage, querying and modification.

  Sources   Download

BSD-3-Clause

The Requires

 

The Development Requires

by Russell Michell

json postgres query text silverstripe multi dbfield jsonpath multivalue multivaluefield

30/04 2018

2.0

2.0.0.0

JSON storage, querying and modification.

  Sources   Download

BSD-3-Clause

The Requires

 

The Development Requires

by Russell Michell

json postgres query text silverstripe multi dbfield jsonpath multivalue multivaluefield

29/04 2018

2.0.0-alpha2

2.0.0.0-alpha2

JSON storage, querying and modification.

  Sources   Download

BSD-3-Clause

The Requires

 

The Development Requires

by Russell Michell

json postgres query text silverstripe multi dbfield jsonpath multivalue multivaluefield

03/05 2017

2.0.0-alpha1

2.0.0.0-alpha1

JSON storage, querying and modification.

  Sources   Download

BSD

The Requires

 

by Russell Michell

json postgres query text silverstripe multi dbfield jsonpath multivalue multivaluefield

03/05 2017

dev-issue/6

dev-issue/6

JSON storage, querying and modification.

  Sources   Download

BSD

The Requires

 

by Russell Michell

json postgres query text silverstripe multi dbfield jsonpath multivalue multivaluefield

13/04 2017

1.0.1

1.0.1.0

JSON storage, querying and modification.

  Sources   Download

BSD

The Requires

 

by Russell Michell

json postgres query text silverstripe multi dbfield jsonpath multivalue multivaluefield

09/04 2017

1.0

1.0.0.0

JSON storage, querying and modification.

  Sources   Download

BSD

The Requires

 

by Russell Michell

json postgres query text silverstripe multi dbfield jsonpath multivaluefield

09/04 2017

dev-issue/7

dev-issue/7

JSON storage, querying and modification.

  Sources   Download

BSD

The Requires

 

by Russell Michell

json postgres query text silverstripe field jsonpath json field

01/07 2016

0.7

0.7.0.0

JSON storage, querying and modification.

  Sources   Download

BSD

The Requires

 

by Russell Michell

json postgres query text silverstripe field jsonpath json field

30/06 2016

0.6

0.6.0.0

JSON storage, querying and modification.

  Sources   Download

BSD

The Requires

 

by Russell Michell

json postgres query text silverstripe field jsonpath json field

28/06 2016

0.5

0.5.0.0

JSON storage, querying and modification.

  Sources   Download

BSD

The Requires

 

by Russell Michell

json postgres query text silverstripe field jsonpath json field

28/06 2016

dev-issue/5

dev-issue/5

JSON storage, querying and modification.

  Sources   Download

BSD

The Requires

 

by Russell Michell

json postgres query text silverstripe field jsonpath json field

23/06 2016

0.4

0.4.0.0

JSON storage and querying

  Sources   Download

BSD

The Requires

 

by Russell Michell

json query silverstripe field

23/06 2016

0.3

0.3.0.0

JSON storage and querying

  Sources   Download

BSD

The Requires

 

by Russell Michell

json query silverstripe field

23/06 2016

dev-issue/3

dev-issue/3

JSON storage and querying

  Sources   Download

BSD

The Requires

 

by Russell Michell

json query silverstripe field

21/06 2016

0.2

0.2.0.0

JSON storage and querying

  Sources   Download

BSD

The Requires

 

by Russell Michell

json query silverstripe field

21/06 2016

dev-master-experimental

dev-master-experimental

JSON storage and querying

  Sources   Download

BSD

The Requires

 

by Russell Michell

json query silverstripe field

15/06 2016

0.1

0.1.0.0

JSON storage and querying

  Sources   Download

BSD

The Requires

 

by Russell Michell

json query silverstripe field