atk4\data\tests\PersistentSQLTest::testLoadArray PHP Method

    public function testLoadArray()
    {
        $a = ['user' => [1 => ['name' => 'John', 'surname' => 'Smith'], 2 => ['name' => 'Sarah', 'surname' => 'Jones']]];
        $p = new Persistence_SQL('sqlite::memory:');
        $p->connection->expr('drop table if exists user')->execute();
        $p->connection->expr('create table user(id int, name varchar(255), surname varchar(255))')->execute();
        foreach ($a['user'] as $id => $row) {
            $row['id'] = $id;
            $p->connection->expr('insert into user values([id], [name], [surname])', $row)->execute();
        }
        $m = new Model($p, 'user');
        $m->addField('name');
        $m->addField('surname');
        $m->load(1);
        $this->assertEquals('John', $m['name']);
        $m->load(2);
        $this->assertEquals('Jones', $m['surname']);
        $m['surname'] = 'Smith';
        $m->save();
        $m->load(1);
        $this->assertEquals('John', $m['name']);
        $m->load(2);
        $this->assertEquals('Smith', $m['surname']);
    }