The li3_fixtures from unionofrad

li3_fixtures's People

Contributors

Stargazers

Watchers

li3_fixtures's Issues

Table name with a period in it is, apparently, now allowed

I'm on MySQL 5.1.66:

mysql> STATUS;
--------------
mysql  Ver 14.14 Distrib 5.1.66, for debian-linux-gnu (i486) using readline 6.1

According to
MySQL 5.1 Reference Manual :: 9 Language Structure :: 9.2 Schema Object Names:

Before MySQL 5.1.6, database and table names cannot contain “/”, “\”, “.”, or characters that are not permitted in file names.

So, even though it's discouraged, I should be able to have a database named example.com, for example :)

And I do and I can perform CRUD operations fine, using the regular Lithium app models.

However, I have a class that extends \lithium\console\Command with the following:

    $class = '\app\models\Users';
    $records = [
        ['id' => 1, 'name' => 'Nate'],
        ['id' => 2, 'name' => 'Gwoo']
    ];
    $fields = $class::schema()->fields();
    $connection = $this->connection ? $this->connection : $class::meta()['connection'];

    $fixture = new Fixture([
        'connection' => $connection,
        'source' => $class,
        'fields' => $fields,
        'records' => $records
    ]);
    $fixture->create();

Running this via CLI yields the following error:

SHOW TABLES FROM `example`.`com`;: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.`com`' at line 1

Seems like the period is being parsed and it's looking at example and com as two separate words.

Is there any way to override this?