PHP dmDb::create方法代码示例

 /**
  * Store a copy of the file in backup folder
  */
 public function backup()
 {
     if (!($backupFolder = $this->getBackupFolder())) {
         throw new dmException(sprintf('Can not create backup folder for %s', $this));
     }
     $this->copyTo(dmDb::create('DmMedia')->set('Folder', $backupFolder))->save();
 }

 public function executeImportSentences(dmWebRequest $request)
 {
     $catalogue = $this->getObjectOrForward404($request);
     $form = new DmCatalogueImportForm();
     sfContext::getInstance()->getConfiguration()->loadHelpers(array('Url'));
     if ($request->isMethod('post') && $form->bindAndValid($request)) {
         $file = $form->getValue('file');
         $override = $form->getValue('override');
         $dataFile = $file->getTempName();
         $table = dmDb::table('DmTransUnit');
         $existQuery = $table->createQuery('t')->select('t.id, t.source, t.target, t.created_at, t.updated_at')->where('t.dm_catalogue_id = ? AND t.source = ?');
         $catalogueId = $catalogue->get('id');
         $nbAdded = 0;
         $nbUpdated = 0;
         try {
             if (!is_array($data = sfYaml::load(file_get_contents($dataFile)))) {
                 $this->getUser()->logError($this->getI18n()->__('Could not load file: %file%', array('%file%' => $file->getOriginalName())));
                 return $this->renderPartial('dmInterface/flash');
             }
         } catch (Exception $e) {
             $this->getUser()->logError($this->getI18n()->__('Unable to parse file: %file%', array('%file%' => $file->getOriginalName())));
             return $this->renderPartial('dmInterface/flash');
         }
         $addedTranslations = new Doctrine_Collection($table);
         $line = 0;
         foreach ($data as $source => $target) {
             ++$line;
             if (!is_string($source) || !is_string($target)) {
                 $this->getUser()->logError($this->getI18n()->__('Error line %line%: %file%', array('%line%' => $line, '%file%' => $file->getOriginalName())));
                 return $this->renderPartial('dmInterface/flash');
             } else {
                 $existing = $existQuery->fetchOneArray(array($catalogueId, $source));
                 if (!empty($existing) && $existing['source'] === $source) {
                     if ($existing['target'] !== $target) {
                         if ($override || $existing['created_at'] === $existing['updated_at']) {
                             $table->createQuery()->update('DmTransUnit')->set('target', '?', array($target))->where('id = ?', $existing['id'])->execute();
                             ++$nbUpdated;
                         }
                     }
                 } elseif (empty($existing)) {
                     $addedTranslations->add(dmDb::create('DmTransUnit', array('dm_catalogue_id' => $catalogue->get('id'), 'source' => $source, 'target' => $target)));
                     ++$nbAdded;
                 }
             }
         }
         $addedTranslations->save();
         if ($nbAdded) {
             $this->getUser()->logInfo($this->getI18n()->__('%catalogue%: added %count% translation(s)', array('%catalogue%' => $catalogue->get('name'), '%count%' => $nbAdded)));
         }
         if ($nbUpdated) {
             $this->getUser()->logInfo($this->getI18n()->__('%catalogue%: updated %count% translation(s)', array('%catalogue%' => $catalogue->get('name'), '%count%' => $nbUpdated)));
         }
         if (!$nbAdded && !$nbUpdated) {
             $this->getUser()->logInfo($this->getI18n()->__('%catalogue%: nothing to add and update', array('%catalogue%' => $catalogue->get('name'))));
         }
         return $this->renderText(url_for1($this->getRouteArrayForAction('index')));
     }
     $action = url_for1($this->getRouteArrayForAction('importSentences', $catalogue));
     return $this->renderText($form->render('.dm_form.list.little action="' . $action . '"'));
 }

 protected function checkMissingAreas()
 {
     foreach (self::getAreaTypes() as $type) {
         if (!$this->getArea($type)) {
             $this->get('Areas')->add(dmDb::create('DmArea', array('dm_layout_id' => $this->get('id'), 'type' => $type))->saveGet());
         }
     }
 }

 public function findFirstOrCreate()
 {
     if (null === $this->firstLayout || !$this->firstLayout->exists()) {
         if (!($this->firstLayout = $this->createQuery()->fetchRecord())) {
             $this->firstLayout = dmDb::create('DmLayout', array('name' => 'Global'))->saveGet();
         }
     }
     return $this->firstLayout;
 }

 public function save(Doctrine_Connection $conn = null)
 {
     $wasNew = $this->isNew();
     $return = parent::save($conn);
     if ($wasNew && !$this->get('Zones')->count()) {
         dmDb::create('DmZone', array('dm_area_id' => $this->get('id')))->save();
         $this->refresh(true);
     }
 }

 /**
  * Set a template to the mail
  *
  * @param mixed $templateName the template name, or a DmMailTemplateInstance
  * @return dmMail $this
  */
 public function setTemplate($templateName)
 {
     if ($templateName instanceof DmMailTemplate) {
         $this->template = $templateName;
     } elseif (!($this->template = dmDb::query('DmMailTemplate t')->where('t.name = ?', $templateName)->fetchRecord())) {
         $this->template = dmDb::create('DmMailTemplate', array('name' => $templateName));
     }
     return $this;
 }

 protected function createMediaFromUploadedFile(array &$values)
 {
     $file = $values['file'];
     $folder = dmDb::table('DmMediaFolder')->findOneByRelPathOrCreate('widget');
     $media = dmDb::table('DmMedia')->findOneByFileAndDmMediaFolderId(dmOs::sanitizeFileName($file->getOriginalName()), $folder->id);
     if (!$media) {
         $media = dmDb::create('DmMedia', array('dm_media_folder_id' => $folder->id))->create($file)->saveGet();
     }
     $values['mediaId'] = $media->id;
 }

 /**
  *
  * @return boolean true if ok, false else
  */
 public function addRate(array $rateData)
 {
     if ($rate = $this->getRatesQuery()->addWhere('dm_user_id = ?', $rateData['dm_user_id'])->fetchOne()) {
         $rate->rate = $rateData['rate'];
     } else {
         $rate = dmDb::create($this->getDmRatable()->getOption('className'), $rateData);
         $rate->id = $this->getInvoker()->id;
     }
     $rate->save();
 }

 public function getArea($type)
 {
     foreach ($this->get('Areas') as $area) {
         if ($area->get('type') == $type) {
             return $area;
         }
     }
     $area = dmDb::create('DmArea', array('dm_page_view_id' => $this->get('id'), 'type' => $type))->saveGet();
     $this->get('Areas')->add($area);
     return $area;
 }

 /**
  * Creates an empty instance of the DmBehavior
  * 
  * @param string $key The behavior key
  * @param string $attachedTo On which container is attached, page, area, zone or widget?
  * @param int $attachedToId The id of the container
  * @param string $attachedToSelector If it is attached to the content
  * @return type 
  */
 public function createEmptyInstance($key, $attachedTo, $attachedToId, $attachedToSelector = null)
 {
     $formClass = $this->getBehaviorFormClass($key);
     $behavior = new DmBehavior();
     $behavior->setDmBehaviorKey($key);
     $form = new $formClass($behavior);
     $form->removeCsrfProtection();
     $position = dmDb::query('DmBehavior b')->orderBy('b.position desc')->limit(1)->select('MAX(b.position) as position')->fetchOneArray();
     $saveData = array('position' => $position['position'] + 1, 'dm_behavior_key' => $key, 'dm_behavior_attached_to' => $attachedTo, 'dm_' . $attachedTo . '_id' => (int) $attachedToId, 'dm_behavior_value' => json_encode($form->getDefaults()));
     if (!is_null($attachedToSelector)) {
         $saveData['dm_behavior_attached_to_selector'] = $attachedToSelector;
     }
     return dmDb::create('DmBehavior', $saveData)->saveGet();
 }

 protected function storeInDb(dmErrorDescription $error)
 {
     dmDb::create('DmError', array('description' => $error->name . "\n" . $error->exception->getTraceAsString(), 'php_class' => $error->class, 'name' => dmString::truncate($error->name, 255, ''), 'module' => $error->module, 'action' => $error->action, 'uri' => $error->uri, 'env' => $error->env))->save();
 }

$helper->boot();
$t = new lime_test(24);
$t->diag('default culture tests');
$user = $helper->get('user');
$userCulture = $user->getCulture();
$t->is(myDoctrineRecord::getDefaultCulture(), $user->getCulture(), 'default culture is ' . $user->getCulture());
$user->setCulture('en');
$t->is(myDoctrineRecord::getDefaultCulture(), $user->getCulture(), 'default culture is ' . $user->getCulture());
$user->setCulture('es');
$t->is(myDoctrineRecord::getDefaultCulture(), $user->getCulture(), 'default culture is ' . $user->getCulture());
$user->setCulture($userCulture);
$t->is(myDoctrineRecord::getDefaultCulture(), $user->getCulture(), 'default culture is ' . $user->getCulture());
$t->diag('Basic record tests');
$layout = dmDb::create('DmLayout', array('name' => dmString::random(), 'css_class' => 'the_class'))->saveGet();
$t->ok($layout instanceof DmLayout, 'call saveGet() returns the record');
$t->is(dmDb::create('DmLayout')->orNull(), null, 'call orNull() on new record returns null');
$t->is($layout->orNull(), $layout, 'call orNull() on existing record returns the record');
$t->diag('Property access tests');
$t->is($layout->get('css_class'), 'the_class', '->get("css_class")');
$t->is($layout->getCssClass(), 'the_class', '->getCssClass()');
$t->is($layout->css_class, 'the_class', '->css_class');
$t->is($layout->cssClass, 'the_class', '->cssClass');
$t->is($layout['cssClass'], 'the_class', '["css_class"]');
$t->ok($layout->set('css_class', 'other_class'), '->set("css_class")');
$t->ok($layout->setCssClass('other_class'), '->setCssClass()');
$t->ok($layout->css_class = 'other_class', '->css_class');
$t->ok($layout->cssClass = 'other_class', '->cssClass');
$layout->delete();
dmDb::table('DmPage')->checkBasicPages();
$page = dmDb::table('DmPage')->findOne();
$page->set('auto_mod', 'test');

 protected function createWidget($moduleAction, array $data, DmZone $zone)
 {
     list($module, $action) = explode('/', $moduleAction);
     $widgetType = $this->context->get('widget_type_manager')->getWidgetType($module, $action);
     $formClass = $widgetType->getOption('form_class');
     $form = new $formClass(dmDb::create('DmWidget', array('module' => $module, 'action' => $action, 'value' => '[]', 'dm_zone_id' => $zone->id)));
     $form->removeCsrfProtection();
     $form->bind(array_merge($form->getDefaults(), $data), array());
     if (!$form->isValid()) {
         throw $form->getErrorSchema();
     }
     return $form->updateWidget();
 }

$wtm = $helper->get('widget_type_manager');
$t->ok($wtm instanceof dmWidgetTypeManager, 'got an instanceof dmWidgetTypeManager');
$widgetTypes = $wtm->getWidgetTypes();
$t->ok(is_array($widgetTypes), 'got an array of widget types');
foreach ($widgetTypes as $moduleKey => $actions) {
    foreach ($actions as $actionKey => $widgetType) {
        $t->diag('Testing ' . $moduleKey . '.' . $actionKey . ' widget options, component, form and view');
        $fullKey = $moduleKey . ucfirst($actionKey);
        $t->is($widgetType->getFullKey(), $fullKey, 'full key is ' . $fullKey);
        try {
            $useComponent = $helper->get('controller')->componentExists($moduleKey, $actionKey);
        } catch (sfConfigurationException $e) {
            $useComponent = false;
        }
        $t->is($widgetType->useComponent(), $useComponent, $useComponent ? $fullKey . ' uses a component' : $fullKey . ' uses no component');
        $widget = dmDb::create('DmWidget', array('module' => $widgetType->getModule(), 'action' => $widgetType->getAction(), 'value' => '[]'));
        $formClass = $widgetType->getOption('form_class');
        try {
            $form = new $formClass($widget);
            $html = $form->render();
            $t->like($html, '_</form>$_', 'Successfully obtained and rendered a ' . $formClass . ' instance');
        } catch (Exception $e) {
            $t->fail('Successfully obtained and rendered a ' . $formClass . ' instance : ' . $e->getMessage());
        }
        $viewClass = $widgetType->getOption('view_class');
        try {
            $view = new $viewClass($helper->get('context'), $widgetType, $widget->toArrayWithMappedValue());
            sfConfig::set('sf_debug', false);
            $html = $view->render();
            sfConfig::set('sf_debug', true);
            $t->pass('Successfully obtained and rendered a ' . $viewClass . ' instance');

 protected function createPage($module, $action, $name = null, $slug = null)
 {
     $name = $name ? $name : $module . '.' . $action;
     $slug = $slug ? $slug : dmString::slugify($name);
     return dmDb::create('DmPage', array('module' => $module, 'action' => $action, 'name' => $name, 'slug' => $slug));
 }