如何在模型中更改Zend_Db_Table名称以插入多个表中 [英] How to change Zend_Db_Table name within a Model to insert in multiple tables

问题描述

使用Zend Framework，我创建了一个模型以将记录插入数据库.我的问题是，在$this->insert($data)之后如何切换活动表，以便可以将记录插入到另一个表中?

Using Zend Framework, I've created a Model to insert a record into a database. My question is, after $this->insert($data) how can I switch the active table so that I can insert a record into another table?

到目前为止，这是我的代码:

Here's my code so far:

class Model_DbTable_Foo extends Zend_Db_Table_Abstract
{
  protected $_name = 'foo';

  public function addFoo($params)
  {
    $data = array(
      'foo' => $params['foo'],
    );
    $this->insert($data);
    $foo_id = $this->getAdapter()->lastInsertId();

    $data2 = array(
      'bar' => $params['bar']
    );
    // I need to change the Db Table name here.
    $this->insert($data2);
    $bar_id = $this->getAdapter()->lastInsertId();
  }
}

推荐答案

Zend_Db_Table是表数据网关.它

充当数据库表的网关.一个实例处理表中的所有行.

acts as a Gateway to a database table. One instance handles all the rows in the table.

这意味着，每个表有一个类.您的Model_DbTable_Foo代表数据库中的Foo表，并且仅代表此表.它不应在其他表上插入.那就是您要使用另一个表类的原因.最干净的选择是在TDG的顶部添加另一层，该层知道如何处理对多个表的插入，例如

This means, you have one class per table. Your Model_DbTable_Foo represents the Foo table in your database and only this table. It should not do inserts on other tables. That's what you would use another table class for. The cleanest option would be to add another layer on top of your TDGs that knows how to handle inserts to multiple tables, e.g.

class Model_Gateway_FooBar
{
    protected $_tables;

    public function __construct(Zend_Db_Table_Abstract $foo, 
                                Zend_Db_Table_Abstract $bar)
    {
        $this->_tables['foo'] = $foo;
        $this->_tables['bar'] = $bar;
    }

    public function addFoo($data)
    {
        $this->_tables['foo']->insert($data['foo']);
        // yaddayaddayadda
        $this->_tables['bar']->insert($data['bar']);
    }
}

但是，这是您的应用，您可以决定不打扰，只需在Foo类中创建另一个类的新实例，然后从那里进行插入，例如

However, it's your app and you can decide not to bother and simply create a new instance of the other class in the Foo class and do the insert from there, e.g.

$otherTable = new Model_DbTable_Bar;
$otherTable->insert($data);

另一种选择是将逻辑放入控制器中，但我不推荐这样做，因为这不是控制器的责任，通常

Another option would be to put the logic into the controller, but I cannot recommend it, because this is not the responsibility of a controller and generally controllers should be kept thin and models should be fat.

在旁注中，当您进行多次插入时，您可能希望使用事务来使两个插入均按预期工作，例如

On a sidenote, when you're doing multiple inserts, you might want to use transactions to make both inserts work as expected, e.g.

$this->_tables['foo']->getAdapter()->beginTransaction();

，然后是commit()或rollback()，具体取决于查询结果.

and then commit() or rollback() depending on the query outcome.

还要注意，从ZF1.9开始，您还可以创建Zend_Db_Table的实例，而不必先定义具体的子类，例如

Also note that as of ZF1.9, you can also create instances of Zend_Db_Table without having to define a concrete subclass first, e.g.

$fooTable = new Zend_Db_Table('foo');

请参阅《 ZF参考指南》中有关 Zend_Db_Table的章节

See the chapter on Zend_Db_Table in the ZF Reference Guide.

这篇关于如何在模型中更改Zend_Db_Table名称以插入多个表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！