PHP download

Download the PHP package footwork_solutions/json_table without Composer

On this page you can find all versions of the php package footwork_solutions/json_table. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Table of contents
Download footwork_solutions/json_table
More information about footwork_solutions/json_table
Files in footwork_solutions/json_table

Vendor footwork_solutions
Package json_table
Short Description A validator and storage library using the JSON table schema written in PHP.
License MIT
Homepage https://github.com/FootworkSolutions/json_table

Keywords validation json table schema data protocols open knowledge foundation

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:

If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.

Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
To use Composer is sometimes complicated. Especially for beginners.
Composer needs much resources. Sometimes they are not available on a simple webspace.
If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.

Please rate this library. Is it a good library?

Informations about the package json_table

JSON Table

A validator and storage library using the JSON table schema written in PHP.

This is a great utility library for validating that CSV files, streams or any other data source validates against a predefined JSON table schema definition.

Limitations

Although this library has many great features, it does not (yet) adhere to the entire JSON table schema specification.

Currently the parts of the specification that are NOT supported are:

Formats:
- array
- binary (this is just validated as a string)
- geopoint
- geojson
Constraints currently there is no support for constraints.
Foreign Keys
- To meet our specific needs this has been built to reference a database table and not a data package as outlined in the specification.
The same schema structure is accepted but with the following considerations:
- "datapackage" MUST be "postgresql".
- "resource" MUST be the name of the table to use with optional schema qualifier. I.E. "import.t_table_name".
- "fields" follow the JSON table schema specification but refer to the fields in the database table.

Motivation

This library was written to fulfill a need for Halo a commercial client management system maintained by Footwork Solutions Ltd.

It is used to validate and store data as part of a import tool for users of Halo.

We use a lot of open source projects at Footwork Solutions and this project, along with our other open source work is our way of giving back to the community we appreciate so much.

Usage

See the examples directory for a detailed run through of how to validate and store a CSV file.

Quick Start

Validate a CSV file:

Store the valid CSV file:

Installation

Implementation Notes

datetime; date; time - fmt:[PATTERN] - This supports PHP date formats @see http://php.net/manual/en/datetime.formats.date.php
datetime; date; time - ISO8610 - The following formats are validated without specifing a format:
- Combined date and time in UTC: 2015-03-09T13:07:04Z
- Date: 2015-03-09
- Time: hh:mm:ss
Given the range of options that match the ISO8610 format, we recommend that you always specify a format.
Pattens: A delimiter must be included in the regex.
Column name checking is case insensitive.
Foreign keys with a single field can be omitted from the CSV and the foreign key check will be ignored. However, foreign keys with multiple fields must have all those fields in the CSV file.

Contributors

Bugs & Feature Requests

Please use the issue tracker to report any bugs or request new features.

Developing

Pull Requests are always welcome.

Please ensure that your code meets the PSR-1, PSR-2 and PSR-4 standards.

Fork the repository.
Create your feature branch (git checkout -b my-new-feature).
Commit your changes.
Push to the branch (git push origin my-new-feature).
Create a new Pull Request.

Licence

This is free software distributed under the terms of the MIT license. See LICENCE for the full details.

All versions of json_table with dependencies

PHP Build Version

Package Version

Version 1.0.0 Release 20. Apr 2016
create-project require 0 people chose require and
0 people chose create-project.

Download

Download latest version of json_table from vendor footwork_solutions

Requires php Version >=5.6.0

Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package footwork_solutions/json_table contains the following files

Loading the files please wait ....