Example #1
0
 public function setup()
 {
     $this->setTableSettings(array(Settings::table('user', array(Settings::field('id', 'ID', Variable::INT), Settings::field('rank', 'RankID', Variable::INT), Settings::field('token', 'AccessToken', Variable::STRING), Settings::field('name', 'Name', Variable::STRING), Settings::field('modified', 'DateModified', Variable::STRING)))));
     $this->modifyReadSettings(array(Settings::readResource('rank', 'Ranks', 'id', NULL, TRUE), Settings::readField('modified', Filter::SQL_DATE_TO_TIMESTAMP), Settings::readResources('inbox', 'Messages', array('fields' => 'id,text,sender(id,name,rank(name))', 'receiver' => $this->injectValue('id'))), Settings::readResources('outbox', 'Messages', array('fields' => 'id,text,receiver(id,name)', 'sender' => $this->injectValue('id')))));
     $this->setCreateSettings(array(Settings::create('rank', FALSE), Settings::create('token', FALSE), Settings::create('name')));
     $this->setUpdateSettings(array(Settings::update('rank'), Settings::update('token'), Settings::update('name')));
     $this->setOrderSettings(array(Settings::order('id'), Settings::order('rank'), Settings::order('name'), Settings::order('modified')));
 }
Example #2
0
 public function setup()
 {
     $this->setDefaultLimit(10);
     $this->setMaxLimit(200);
     $this->setTableSettings(array(Settings::table('city', array(Settings::field('id', 'ID', Variable::INT), Settings::field('name', 'Name', Variable::STRING), Settings::field('country', 'CountryCode', Variable::STRING), Settings::field('district', 'District', Variable::STRING), Settings::field('population', 'Population', Variable::INT)))));
     $this->setReadSettings(array(Settings::readField('id'), Settings::readField('name'), Settings::readResource('country', 'Countries', 'code'), Settings::readField('district'), Settings::readField('population')));
     $this->setCreateSettings(array(Settings::create('name'), Settings::create('country')));
     $this->setUpdateSettings(array(Settings::update('name'), Settings::update('country'), Settings::update('district'), Settings::update('population')));
     $this->setOrderSettings(array(Settings::order('id'), Settings::order('name'), Settings::order('country'), Settings::order('district'), Settings::order('population')));
     $this->setConditionSettings(array(Settings::condition('id'), Settings::condition('name'), Settings::condition('country'), Settings::condition('district'), Settings::condition('population')));
 }
Example #3
0
 public function setup()
 {
     $this->setDefaultLimit(10);
     $this->setMaxLimit(200);
     $this->setTableSettings(array(Settings::table('country', array(Settings::field('code', 'Code', Variable::STRING), Settings::field('name', 'Name', Variable::STRING), Settings::field('continent', 'Continent', Variable::STRING), Settings::field('region', 'Region', Variable::STRING), Settings::field('surfaceArea', 'SurfaceArea', Variable::FLOAT), Settings::field('independence', 'IndepYear', Variable::INT), Settings::field('population', 'Population', Variable::INT), Settings::field('lifeExpectancy', 'LifeExpectancy', Variable::FLOAT), Settings::field('gnp', 'GNP', Variable::FLOAT), Settings::field('gnpOld', 'GNPOld', Variable::FLOAT), Settings::field('localName', 'LocalName', Variable::STRING), Settings::field('govForm', 'GovernmentForm', Variable::STRING), Settings::field('headOfState', 'HeadOfState', Variable::STRING), Settings::field('capital', 'Capital', Variable::INT), Settings::field('code2', 'Code2', Variable::STRING)))));
     $this->setReadSettings(array(Settings::readField('code'), Settings::readField('name'), Settings::readField('continent'), Settings::readField('region', NULL, FALSE), Settings::readField('surfaceArea', NULL, FALSE), Settings::readField('independence', NULL, FALSE), Settings::readField('population', NULL, FALSE), Settings::readField('lifeExpectancy', NULL, FALSE), Settings::readField('gnp', NULL, FALSE), Settings::readField('gnpOld', NULL, FALSE), Settings::readField('localName', NULL, FALSE), Settings::readField('govForm', NULL, FALSE), Settings::readField('headOfState', NULL, FALSE), Settings::readField('capital', NULL, FALSE), Settings::readField('code2', NULL, FALSE), Settings::readResources('langs', 'Languages', array('country' => $this->injectValue('code'))), Settings::readResources('mainLangs', 'Languages', array('country' => $this->injectValue('code'), 'percent' => 'gt(10)'))));
     $this->setCreateSettings(array(Settings::create('code'), Settings::create('name'), Settings::create('continent'), Settings::create('region'), Settings::create('surfaceArea'), Settings::create('independence'), Settings::create('population'), Settings::create('lifeExpectancy'), Settings::create('gnp'), Settings::create('gnpOld'), Settings::create('localName'), Settings::create('govForm'), Settings::create('headOfState'), Settings::create('capital'), Settings::create('code2')));
     $this->setUpdateSettings(array(Settings::update('code'), Settings::update('name'), Settings::update('continent'), Settings::update('region'), Settings::update('surfaceArea'), Settings::update('independence'), Settings::update('population'), Settings::update('lifeExpectancy'), Settings::update('gnp'), Settings::update('gnpOld'), Settings::update('localName'), Settings::update('govForm'), Settings::update('headOfState'), Settings::update('capital'), Settings::update('code2')));
     $this->setOrderSettings(array(Settings::order('code'), Settings::order('name'), Settings::order('continent'), Settings::order('region'), Settings::order('surfaceArea'), Settings::order('independence'), Settings::order('population'), Settings::order('lifeExpectancy'), Settings::order('gnp'), Settings::order('gnpOld'), Settings::order('localName'), Settings::order('govForm'), Settings::order('headOfState'), Settings::order('capital'), Settings::order('code2')));
     $this->setConditionSettings(array(Settings::condition('code'), Settings::condition('name'), Settings::condition('continent'), Settings::condition('region'), Settings::condition('surfaceArea'), Settings::condition('independence'), Settings::condition('population'), Settings::condition('lifeExpectancy'), Settings::condition('gnp'), Settings::condition('gnpOld'), Settings::condition('localName'), Settings::condition('govForm'), Settings::condition('headOfState'), Settings::condition('capital'), Settings::condition('code2')));
 }
Example #4
0
 public function setup()
 {
     $this->setDefaultLimit(10);
     $this->setMaxLimit(200);
     $this->setTableSettings(array(Settings::table('countrylanguage', array(Settings::field('country', 'CountryCode', Variable::STRING), Settings::field('name', 'Language', Variable::STRING), Settings::field('official', 'IsOfficial', Variable::BOOL), Settings::field('percent', 'Percentage', Variable::FLOAT)))));
     $this->setReadSettings(array(Settings::readField('name'), Settings::readField('official'), Settings::readField('percent')));
     $this->setCreateSettings(array(Settings::create('country'), Settings::create('name'), Settings::create('official', FALSE), Settings::create('percent', FALSE)));
     $this->setUpdateSettings(array(Settings::update('name'), Settings::update('official'), Settings::update('percent')));
     $this->setOrderSettings(array(Settings::order('country'), Settings::order('name'), Settings::order('official'), Settings::order('percent')));
     $this->setConditionSettings(array(Settings::condition('country'), Settings::condition('name'), Settings::condition('official'), Settings::condition('percent')));
 }
Example #5
0
 public function setup()
 {
     $this->setTableSettings(array(Settings::table('message', array(Settings::field('id', 'ID', Variable::INT), Settings::field('sender', 'SenderUserID', Variable::INT), Settings::field('receiver', 'ReceiverUserID', Variable::INT), Settings::field('text', 'Text', Variable::STRING), Settings::field('created', 'DateCreated', Variable::STRING)))));
     $this->setReadSettings(array(Settings::readField('id'), Settings::readResource('sender', 'Users', 'id'), Settings::readResource('receiver', 'Users', 'id'), Settings::readField('text'), Settings::readField('created', Filter::SQL_DATE_TO_TIMESTAMP)));
     $this->setCreateSettings(array(Settings::create('sender'), Settings::create('receiver'), Settings::create('text')));
 }
Example #6
0
 public function setup()
 {
     $this->setTableSettings(array(Settings::table('rank', array(Settings::field('id', 'ID', Variable::INT), Settings::field('name', 'Name', Variable::STRING), Settings::field('ordinal', 'Ordinal', Variable::INT)))));
 }