Myna. DataManager

Myna.DataManager = function ( dataSource )

Contructs a Myna.DataManager Object for the supplied dataSource

Parameters

Myna.DataManager.prototype.getManager=function( tableName )

Constructs a ManagerObject for the supplied table.

Parameters

Detail

Creates a ManagerObject for the supplied table.

See

• Myna.DataManager.managerTemplate

loadTableData:function( tableName )

internal function to load table data into the manager

remove:function( id )

Removes a row from the managed table matching the supplied primary key

Parameters

create:function( requiredFields )

Creates a record in the database, optionally generating a primary key

Parameters

Detail

requiredFields must contain entries for all non-null columns without default values, except the primary key.  If the primary key is not specified, and the column does not have a default value, genKey is called to generate a key.  Any extra columns supplied will be inserted as well.

Returns

instance of the Bean that represents the new row.  See getById

Example

    +- - - - - - - - - - - - - - - - - -+
    |   table employees                 |
    +- - - - - - - - - - - - - - - - - -+
    |  emp_id       int4    primary key |
    |  fname        varchar             |
    |  mname        varchar             |
    |  lname        varchar             |
    |  manager_id   int4                |
    |  hire_date    date                |
    +- - - - - - - - - - - - - - - - - -+

var dm = new Myna.DataManager("hr_datasource");

var empManager = dm.getManager("employees");

var newEmpBean = empManager.create({
    fname:"Bob",
    lname:"Dobb",
    hire_date:Date.parse("02/21/1992","m/d/Y")
})

find:function( pattern, caseSensitive )

returns an array of primaryKey values that match a search

Parameters

Examples

var employees = new Myna.DataManager("some_ds").getManager("employees");

// a primary key search
var bob_exists = employees.find("55652315").length

//one column search for exact match
var bobs_emps = employees.find({
    manager_id:"55652315"
})

//Who are Bob's employees?
bobs_emps.forEach(function(employee_id){
    Myna.print(employees.getById(employee_id).get_name() +"<br>");
})

//more complicated search with wildcards
var bobs_helpers = employees.find({
    manager_id:"55652315",
    job_title:"%assitant%"
})

See

findBeans

findBeans:function( pattern, caseSensitive )

returns a Myna.DataSet of bean objects that match a search

Parameters

Examples

var employees = new Myna.DataManager("some_ds").getManager("employees");

// a primary key search
var bob_exists = employees.find("55652315").length

//one column search for exact match
var bobs_emps = employees.findBeans({
    manager_id:"55652315"
})

//Who are Bob's employees?
bobs_emps.forEach(function(employee){
    Myna.print(employee.get_name() +"<br>");
})
//What are their email addresses?
Myna.printDump(bobs_emps.valueArray("email"),"Bob's Emloyees' Email")


//more complicated search with wildcards
var bobs_helpers = employees.findBeans({
    manager_id:"55652315",
    job_title:"%assitant%"
})

//Using aggregate math: Bob's employees average salary
//See Myna.DataSet
var bobs_emps_avg_sal = employees.findBeans({
    manager_id:"55652315"
}).average("salary")

See

find

genKey:function()

generates a primary key value

Detail

By default this returns the maximum value of the primary key column + 1.  This is not the ideal algorithm and should be replaced with a database specific means of generating a primary key.

This function can be replaced in Myna.DataManager.managerTemplate or by replacing the function in ManagerObject

var dm = new Myna.DataManager("some datasource");

//via manager template
dm.managerTemplate.genKey=function(){
    <your code here returning a key here>
}
//via the ManagerObject
var man = dm.getManager("employees")
man.genKey = function(){
    <your code here returning a key here>
}

getById:function( id )

Returns a BeanObject representing the row identified by the supplied primary key

Parameters

Detail

This function loads the data from the indicated row into into a <Myna.DataManager.prototype.BeanBase> object.  Each bean is generated with get_<column name> and set_<column name> functions.  The set functions will immediately set the value in the underlying row.

See

• BeanObject
• Myna.DataManager.beanTemplate
• ManagerObject.beanTemplate

gets a value for <columnName>

Detail

This function is generated for every column in the associated table.

sets a value for <columnName>

Parameters

Returns

Myna.ValidationResult object representing the result of the set.

Detail

This function is generated for every column in the associated table, except for the primary key.

setFields:function( fields )

Sets multiple fields at once

Parameters

Returns

Myna.ValidationResult representing the result of this action.

Detail

This function will examine each non-function property of fields and call the corosponding “set” function, if available.  Properties that do not match a “set” function are ignored

saveField:function( fieldName, newval )

Persists a value to its underlying row

Parameters

Returns

Myna.ValidationResult representing the result of this action.

Detail

This function is normally called from the “set” function, but may be useful when overriding the generated “set” function.

getData:function()

return a structure of this bean’s data

Detail

This is a copy of the data, so it will not change when the object is modified

getParent:function( column )

return a bean representing this bean’s parent record

Parameters

Example

var orderBean = new Myna.DataManager("myapp")
                    .getManager("orders")
                    .getById(curOrderId);
var customerBean = orderBean.getParent("customer_id");
Myna.print(customerBean.last_name);

getChildren:function( table, column )

return a Myna.DataSet of beans representing this bean’s child records

Parameters

Example

var customerBean = new Myna.DataManager("myapp")
                    .getManager("customers")
                    .getById(curCustomerId);
var orders = customerBean.getChildren("orders");
Myna.print("Orders Total: " +orders.sumByCol("order_total"));