{ const TABLE = "testusers2"; const VERSION = 'modified_on'; const MODULE_NAME = "test"; const KEY_NAME = "id"; const F_ID = "id"; const CLASS_NAME = 'yangzie\\UserModel'; const F_TITLE = "title"; const F_CREATED_ON = "created_on"; const F_MODIFIED_ON = "modified_on"; public static $columns = array('id' => array('type' => 'integer', 'null' => false, 'length' => '11', 'default' => ''), 'name' => array('type' => 'string', 'null' => false, 'length' => '201', 'default' => ''), 'register_time' => array('type' => 'date', 'null' => false, 'length' => '', 'default' => ''), 'email' => array('type' => 'string', 'null' => false, 'unique' => true, 'length' => '45', 'default' => ''), 'created_on' => array('type' => 'date', 'null' => true, 'length' => '', 'default' => ''), 'modified_on' => array('type' => 'TIMESTAMP', 'null' => false, 'length' => '', 'default' => 'CURRENT_TIMESTAMP')); } /** * 初始化数据 */ YZE_DBAImpl::getDBA()->migration(UserModel::CLASS_NAME); UserModel::truncate(); /** * 这里的测试需要配置数据库连接 */ $db = \yangzie\YZE_DBAImpl::getDBA(); $user = new UserModel(); $user->set("name", "aa"); $user->set("email", "333333"); $user->set("register_time", "2015-12-17 17:50:30"); $user->save(); //测试插入新数据 $insert_key = $user->get_key(); echo $insert_key >= 1 ? "insert true" : "insert false"; try { $user->set("id", null);
/** * 清空表中所有数据,主键重新从1开始 */ public static function truncate() { $sql = "TRUNCATE `" . YZE_MYSQL_DB . "`.`" . static::TABLE . "`;"; YZE_DBAImpl::getDBA()->exec($sql); }