Count the number of associated objects.

Get the table name for the association target

Construct an associator to map between two models representing database tables. The source is the subject and the target is the object of the relationship. e.g. If a customers has-many orders, then Customer is the source and Order is the target.

Count the number of associated targets matching specified criteria.

See also

Query associated objects A generic sql-based find method to query and load field information for all records based on SQL conditions, ordering and limits including join and grouping operations.

See also

Find all association targets with matching association attributes. Associations of type has_and_belongs_to_many can have attributes as part of the mapping between the source and target models. Use this method to find all associated targets matching the specified association attributes.

See also

Get the value for a given attribute for a specific target

See also

List all target objects. Equivalent to findAll({})

See also

Create an association between the source and the specified target object. Saves the source and the target if either of them are new records.

  var post:Post = Modeler.findery(Post, {id: 1});
  // Push (and saves) new comment
  post.comments.push(new Comment({title: '1st', text: 'i wuz here'}));
  

Remove an association which the given object might have with this source.

Set attributes on the association. Associations of type has_and_belongs_to_many can have attributes as part of the mapping between the source and target models. Use setAttr to set the values for these attributes, either for a single target or for all of the many targets associated with the source.

See also

 
  [Association type="has_and_belongs_to_many" name="tags" class="example.Tag"]
  dynamic public class Post extends Modeler {
    private static var migrations:Migrator = new Migrator(
     Post, {id: true}, 
     [
      function(my:Migrator):void {
       my.createTable(function():void {
        my.column('name', DB.Field.VarChar, {limit: 255});
        my.columnTimestamps();
       });
      }, 
      function(my:Migrator):void {
       var tagVotesCol:Array = ['votes', DB.Field.Integer, {
        'default': 1}
       ];     
       my.joinTable(Photo, [tagVotesCol]);
      },
     ]
    )
  }
  // Push as usual to create a new association and corresponding join row
  var post:Post = new Post();
  var flex:Tag = new Tag().find({name: 'flex'});
  post.tags.push(flex);
  
  // Update the votes for a given for some post
  numVotes = post.tags.getAttrVal('votes', flex.id);  
  post.tags.setAttr({votes: numVotes + 1}, flex.id);
  
  // Reset the votes for all tags for a given post
  post.tags.setAttr({votes: 1});