teranex weblog

Persistency Framework

In an application that uses a database it is very common that you have lots of SQL-queries, that only differ in very small parts, and boring to write. By using a persistency framework you can avoid having to write most of these queries and save a lot of time. Once you discover the power of a persistency framework such as Hibernate, you'll probably never want to work again without such a library.

PHP 5

After having used Hibernate and NHibernate in some projects, i wanted to have a similar framework for PHP. While there are several solutions, i didn't really found what i was looking for. Either they were just too simple, they required you to adapt some design, like inheriting from a specific class, or they were very heavy, such as Propel.

I wanted an easy to use and small framework, which doesn't require you to adapt special design patterns. These are the key feature i keep in mind for SiPPF.

An example

After configuration, which is rather straigthforward and comparable to Hibernate configuration, storing and loading an entity from your database is as simple as:

1
2
3
4
56
7
8
9
1011
12

//get the sippf instance and connect
$sippf = SiPPF_SiPPF::getInstance();
$sippf->connect("dbbms://user:pwd@host/dbname");
 
//create a new person, which will be stored in the database$person = new Person("name", 22);
 
//store the entity
$sippf->persistObject($person);
 //load the person with ID 1
$anotherPerson = $sippf->loadObject(1, 'Person'); 

eMusic SitePlugin

Easily import albums from eMusic with this siteplugin.

Install

1. Upload all files to your opendb dierctory
2. Go to System Admin Tools -> Site plugins.
3. Install eMusic plugin

Using

You have two ways to add music

1. use the album title: this will search eMusic for albums with the given title
2. use the album url: either paste the complete url, or the part after /album/ in the url, of the page on eMusic. By example to import Live At Tonic by Chritian McBride, simply paste http://www.emusic.com/album/Christian-McBride-Live-At-Tonic-MP3-Download/10915705.html in the 'eMusic Link'-field.