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";