Handling relations

Most of the time, you have modeled your database with relations inside it.

The haXe SPOD is able to handle one-to-one and many-to-one relations.

This is done by implementing the static function RELATIONS that takes no parameter. It has to return an array of anonymous objects made of the fields prop, key, and manager.

The prop field will be a string that is the name of a property by which you will get and set the object. This property has to be a dynamic property.

The key field is also a string that is the name of the field (in the database) that stores the foreign key.

So, let's take our User example and a sponsorship program to it. A user can sponsor another one.

class User extends neko.db.Object
{
   public var id : Int;
   public var username : String;
   public var password : String;
   public var sponsorId : Int; //Foreign Key
   //The property
   public var sponsor(dynamic, dynamic) : User;
   //Our function
   static function RELATIONS()
   {
      return [{prop: "sponsor...