This project implements a Midgard2 -backed provider of the PHP Content Repository (PHPCR) interfaces. phpcr-midgard2 is a fully Jackalope compatible PHPCR provider that can be used in PHP Content Management Systems without requiring Java.
Using Midgard2 instead of Apache Jackrabbit also has the benefit of making interoperability with regular relational databases used by many CMSs easy. Midgard2 supports multiple databases, including MySQL and SQLite.
You need to have a midgard2 PHP extension installed. On many distributions setting this up is as simple as:
$ sudo apt-get install php5-midgard2
If your distribution doesn't come with Midgard2, then you can either compile it manually or use our precompiled packages.
Then set your project to depend on midgard/phpcr by having your composer.json to include:
"require": {
"midgard/phpcr": ">=1.0"
}
Then just install the provider via Composer:
$ wget http://getcomposer.org/composer.phar
$ php composer.phar install
You also need to copy the Midgard2 PHPCR schemas from vendor/midgard/phpcr/data/share to your schema directory (by default /usr/share/midgard2):
$ sudo cp vendor/midgard/phpcr/data/share/schema/* /usr/share/midgard2/schema/
$ sudo cp vendor/midgard/phpcr/data/share/views/* /usr/share/midgard2/views/
You can use the Composer-generated autoloader to load all needed classes:
require 'vendor/autoload.php';
After you've included the autoloader you should be able to open a Midgard2 repository session:
// Set up Midgard2 connection
$parameters = array(
// Use local SQLite file for storage
'midgard2.configuration.db.type' => 'SQLite',
'midgard2.configuration.db.name' => 'midgard2cr',
'midgard2.configuration.db.dir' => __DIR__,
// Where you want to store file attachments
'midgard2.configuration.blobdir' => '/var/lib/midgard2/blobs',
// Let Midgard2 initialize the DB as needed
'midgard2.configuration.db.init' => true,
);
// Get a Midgard repository
$repository = Midgard\PHPCR\RepositoryFactory::getRepository($parameters);
// Log in to get a session
$credentials = new \PHPCR\SimpleCredentials('admin', 'password');
$session = $repository->login($credentials, 'default');
After this the whole PHPCR API will be available. See some example code in the examples` directory.
With MySQL, the connection parameters could for example be:
$parameters = array(
// MySQL connection settings. The database has to exist
'midgard2.configuration.db.type' => 'MySQL',
'midgard2.configuration.db.name' => 'midgard2',
'midgard2.configuration.db.username' => 'midgard',
'midgard2.configuration.db.password' => 'midgard',
'midgard2.configuration.db.host' => '127.0.0.1',
'midgard2.configuration.db.port' => '3306'
// Let Midgard2 initialize the DB as needed
'midgard2.configuration.db.init' => true,
);
This is the only different part from the example using SQLite above.
The PHP Content Repository API is a PHP version of the Java Content Repository specification. From Wikipedia:
Content Repository API for Java (JCR) is a specification for a Java platform application programming interface (API) to access content repositories in a uniform manner. The content repositories are used in content management systems to keep the content data and also the metadata used in content management systems (CMS) such as versioning metadata.
This way a content management system, for example, would not be tied to a particular database or other storage scheme. Instead, the content repository providers could be chosen based on deployment requirements.
There is currently discussion about including PHPCR APIs into the Java Content Repository specification.
Midgard2 is an open source content repository library available for multiple programming languages.
Midgard2 is able to access and manage content stored in various common relational databases, including SQLite, MySQL and Postgres. For this, you get a reasonably simple object-oriented interface. An example:
$article = new net_example_article();
$article->title = "Hello, world";
$article->create();
echo "Article {$article->title} was stored with GUID {$article->guid}";
There have been some studies into the conceptual differences and similarities between the Midgard2 Content Repository model and the Java Content Repository model used in PHPCR. Because of these differences, some conceptual mappings are needed.
- Repository = Midgard config
- Session = Midgard connection
- Node = Midgard object
- Node Type = MgdSchema
- Property = Property or Parameter of Midgard object
- Workspace = Midgard workspace
The Midgard PHPCR tree is built out of midgard_node objects. These objects are only used for building the tree, and are connected to the real content objects in the tree by their objectguid property.
Properties that are not managed by MgdSchemas (so, properties not registered to Node Types) are handled by midgard_node_property objects.
Midgard2 uses standard relational databases for content storage. The PHPCR model is mapped to database tables in the following way:
- Tree structure is defined in
midgard_nodetable, which containsname,parentreference, and a reference to a content object - Properties of a node type are stored in the table defined for that node type in its MgdSchema (see examples)
- Multivalued properties, and properties not defined in the node type (for example with
nt:unstructured) are stored in themidgard_node_propertytable, which containsname, reference tomidgard_nodeentry,typeandvalue - Binary property contents are stored as files into the
blobdirdefined in repository configuration
New Node Types can be registered by writing MgdSchemas for them and copying them to Midgard's schema directory (by default /usr/share/midgard2/schema).
When Midgard2's own Workspaces implementation lands in 10.05.5, we will support using JCR Workspaces as well. The workspace strings will be in format:
workspaceworkspace/subworkspace
The PHPCR API uses namespaces for node types and property names. The regular Midgard2 MgdSchema RDF mappings should be used for this.
- Symfony CMF
- Doctrine ODM
- Flow3/TYPO3
Content Repositories are important piece of software infrastructure that must be usable by any projects or companies regardless of their business model. Because of this, the Midgard2 PHPCR implementation will be available under permissive terms of the GNU Lesser General Public License.
Contributions to the Midgard2 PHPCR provider are very much appreciated. The development is coordinated on a GitHub repository:
Feel free to watch the repository, make a fork and submit pull requests. Code reviews, testing and bug reports are also very welcome.
The Midgard2 PHPCR provider is using Travis for Continuous Integration.
If you have a fork of this repository and want it tested, enable it on the Travis website. Each push will be automatically tested.