public function getTable($tableName)
{
// Compatibility with zenMysql2 ORM
$storage = kanon::getModelStorage();
foreach ($storage->getRegistry()->modelSettings as $modelName => $settings) {
if ($settings['table'] == $tableName) {
return kanon::getCollection($modelName);
}
}
return false;
}
protected $_fields = array('topicId' => 'help_topic_id', 'keywordId' => 'help_keyword_id');
protected $_foreignKeys = array('topicId' => array('helpTopic', 'id'), 'keywordId' => array('helpKeyword', 'id'));
}
class helpKeyword extends model
{
protected $_fields = array('id' => 'help_keyword_id', 'name' => 'name');
}
class groupImage extends model
{
protected $_fields = array('id' => 'id', 'groupId' => 'group_id', 'filename' => 'filename', 'createdAt' => 'created_at');
protected $_foreignKeys = array('groupId' => array('group', 'id'));
}
/*$storage = kanon::getModelStorage()
->connect('mysql:host=localhost;port=3307;dbname=db', 'root', 'password')
;*/
$storage = kanon::getModelStorage()->connect('sqlite:' . dirname(__FILE__) . '/test.sqlite', 'root', '');
$storage->registerCollection('helpCategory', 'help_category');
$storage->registerCollection('helpTopic', 'help_topic');
$storage->registerCollection('helpRelation', 'help_relation');
$storage->registerCollection('helpKeyword', 'help_keyword');
//$storage->getConnection();
/*echo '<pre>';
storageRegistry::dump();
echo '</pre>';*/
$categories = helpCategory::getCollection();
//echo 'start foreach'."\r\n";
//echo $categories->select()->getSql();
foreach ($categories->select() as $category) {
}
//var_dump($categories->getStorage()->getConnection()->errorInfo());
//echo 'finish foreach'."\r\n";
