コード例 #1
0
 public function testExecQueryAndInsertStatement()
 {
     $testValue = 'test_exec_insert_statement';
     $recordsXml = "\n            <defaultRecords>\n               <record>\n                    <table>\n                        <name>{$this->_table->name}</name>\n                    </table>\n                    <field>\n                        <name>id</name>\n                        <value>1</value>\n                    </field>\n                    <field>\n                        <name>name</name>\n                        <value>{$testValue}</value>\n                    </field>\n                </record>\n            </defaultRecords>";
     $records = simplexml_load_string($recordsXml);
     $this->_backend->execInsertStatement($records->record[0]);
     $db = Tinebase_Core::getDb();
     $statement = 'SELECT * FROM ' . $db->quoteIdentifier(SQL_TABLE_PREFIX . $this->_table->name);
     $result = $this->_backend->execQuery($statement);
     $this->assertEquals(1, count($result));
     $this->assertEquals($testValue, $result[0]['name']);
 }