AnyDataset
AnyDataset is a powerful data source abstraction layer for PHP that provides a simple and consistent interface to access different data sources. With AnyDataset, you can work with various data formats and storage systems using the same programming interface.
It is the core component of the Anydataset project, an agnostic data source abstraction layer for PHP.
Key Features
- Unified Interface: Access different data sources (databases, arrays, XML, JSON, etc.) using the same interface
- Flexible Iteration: Multiple ways to iterate through your data
- Powerful Filtering: Filter your data using a SQL-like syntax
- Data Transformation: Convert between different formats (JSON, XML, arrays)
- Validation: Validate your data against rules
- Extensible: Create your own data source implementations
Quick Start
Installation
composer require "byjg/anydataset"
Basic Usage
<?php
# Create a dataset
$dataset = new \ByJG\AnyDataset\Core\AnyDataset("example");
# Get an iterator
$iterator = $dataset->getIterator();
# Iterate over the results
foreach ($iterator as $row) {
print_r($row->toArray());
}
Documentation
Core Concepts
- AnyDataset Overview - Core component overview and usage
- The Row Object - Working with data rows
- Iterators - Different ways to iterate through data
Advanced Features
- Filtering Results - How to filter your data
- Formatting Output - Transform your data into different formats
- Field Validation - Validate your data against rules
- Data Population - Populate objects with data
Available Implementations
| Data Source Type | Implementation | Read/Write | Repository |
|---|---|---|---|
| Core | AnyDataSet | R/W | Github |
| Databases | DbDriverInterface | R/W | Github |
| Arrays | ArrayDataSet | R | Github |
| Text Files | TextFileDataSet | R | Github |
| Fixed Width Files | FixedTextFileDataSet | R | Github |
| XML | XmlDataSet | R | Github |
| JSON | JSONDataSet | R | Github |
| SparQL | SparQLDataSet | R | Github |
| NoSQL Document | NoSqlDocumentInterface | R/W | Github |
| NoSQL Key/Value | KeyValueInterface | R/W | Github |
Example Code Snippets
Filtering Data
<?php
$filter = new \ByJG\AnyDataset\Core\IteratorFilter();
$filter->addRelation("field1", \ByJG\AnyDataset\Core\Enum\Relation::EQUAL, 10);
$iterator = $dataset->getIterator($filter);
Using Formatters
<?php
$formatter = new XmlFormatter($anydataset->getIterator());
$formatter->raw(); // Return a DOM object
$formatter->toText(); // Return the XML as a text
$formatter->saveToFile("/path/to/file.xml"); // Save the XML Text to a file
Running Unit Tests
vendor/bin/phpunit