mindyphp / orm Goto Github PK

View Code? Open in Web Editor NEW

4.0 3.0 3.0 5.47 MB

[READ-ONLY] Subtree split of the django like ORM component

License: MIT License

PHP 99.96% Makefile 0.04%

django-orm php queryset mindy-bundle

orm's People

Contributors

Stargazers

Watchers

Forkers

qantus alexandrgordeev tsukasa-mixer

orm's Issues

Не корректная работа isNewRecord

Не корректная работа isNewRecord. Не устанавливается корректное значение после выборок.

Add support $qs = Product::objects()->filter(['category_id' => [1, 2, 3, 4, 5]]); where category FK

Add proxy 'pk' field to primary key name

При изменении размеров теряется оригинальное изображение, зато присутствуют 2 превью

Удалить бестолковые модели из тестов

Собрать полноценный пример на основе Customer, Order, User, Product, Category.

Исправление ошибки FK. См тест TreeModel.

Нужна ли такая абстракция как extraFields, когда одно поле может содержать другие поля? Пример: поле content типа MarkdownField хранит в себе content_html типа TextField в котором содержится скомпилированное содержимое от markdown поля.

Прокинуть updateCounters

Many2Many through lookups.

Рекурсия на NestedModel::tree()->get(['pk' => 2])->descendants()->countSql()

Метод всегда возвращает все поля, если не указаны явно. Возвращать только измененные.

    /**
     * TODO method work incorrect
     * @param array $fields return incoming fields only
     * @return array
     */
    protected function getChangedValues(array $fields = [])

Не работают выборки где в качестве аргумента приходит модель

Пример:

NestedModel::objects()->filter(['parent' => $rootModel]);

Ошибка:

Mindy\Query\Exception : SQLSTATE[42S22]: Column not found: 1054 Unknown column 'nested_model_1.parent' in 'where clause'
The SQL being executed was: SELECT `nested_model_1`.* FROM `nested_model` `nested_model_1` WHERE (`nested_model_1`.`name`='test2') AND (`nested_model_1`.`parent`=Tests\Models\NestedModel)

Вопрос datetime на уровне sql

Вопрос, что мы будем использовать в __week_date фильтре? какой формат?

Method                              Range
------                              -----
PYTHON
    datetime_object.weekday()       0-6    Sunday=6
    datetime_object.isoweekday()    1-7    Sunday=7
    dt_object.isoweekday() % 7      0-6    Sunday=0 # Can easily add 1 for a 1-7 week where Sunday=1

MYSQL
    DAYOFWEEK(timestamp)            1-7    Sunday=1
    WEEKDAY(timestamp)              0-6    Monday=0

POSTGRES
    EXTRACT('dow' FROM timestamp)   0-6    Sunday=0
    TO_CHAR(timestamp, 'D')         1-7    Sunday=1

ORACLE
    TO_CHAR(timestamp, 'D')         1-7    Sunday=1 (US), Sunday=6 (UK)

Баг в выборке связанных записей через m2m

LookupTest.php #92 строка

$this->assertEquals(5, Order::objects()->get(['pk' => 1])->products->count());

PHPUnit_Framework_ExpectationFailedException : Failed asserting that '25' matches expected 5.
Expected :5
Actual   :25

unit тесты для ImageField

QuerySet values list

Model::objects()->count() возвращает str а не int

Table quotes

Не корректное формирование таблиц при (new Sync($models))->create(); в случае если у 1 модели указан tableName вида {{my_table}}, у второй не указан.

Получившийся sql:

CREATE TABLE user_group_`users_permission` ( `users_permission`_id int, `user_group_id` int )

Lookup builders for "date" lookups (day, month, year, etc) + tests

Add find_or_create method

Добавить valuesList($q, $flat = false) для не ассоциативного массива

Рефакторинг обращения к метадате

сейчас там есть несколько мелких багов и оно в целом выглядит нелаконично.
поэтому опишу с нуля:

суть такова - метадата это синглтон в пределах одной модели, и для самой этой модели обращение к ней должно быть максимально простым:

public static function metadata()
{
     return Metadata::getInstance(get_called_class());
}

в метадату надо выносить все что касается "свойств" модели, а не её данных (например - tableName())
Вот есть метод "public static function getTableSchema()" - но по сути метадата это смысловое продолжение TableSchema

Итак, метадата и тот самый метод:

class Metadata
{
    public static function getInstance($modelClass)
    {
        if (!isset(self::$instances[$modelClass])) {
            self::$instances[$modelClass] = new static($modelClass);
            // workaround to avoid endless cycle when this field init remote field, and remote field use this model metadata before __construct ends
            self::$instances[$modelClass]->initFields();
        }
        return self::$instances[$modelClass];
    }

всю инициализацию полей и тд можно делать в конструкторе, при том если унаследовать этот класс - то все будет работать без изменений.
в метадате больше не нужны (другие) статические методы и сво-ва, так как для модели это всегда нормальный инстанс.

ps:
public function getFields() можно сделать static так как для инициализации метадаты не нужно делать new Model
pss:
вот пример метадаты в которую выкинуто все что можно из модели
https://github.com/buldezir/dja_orm/blob/master/src/Dja/Db/Model/Metadata.php
потому что метадата всегда одна, а инстансов моделей может быть тысяча

// TODO return $this->countInternal($q);
return count($this->asArray()->all());

Рефакторинг FileField && ImageField для работы с Storage

sqlite3 test fail

[max:local:~/projects/Mindy_Orm]$ phpunit -c phpunit.xml                                                                                                                                                                           (master) 
PHPUnit 3.7.28 by Sebastian Bergmann.

Configuration read from /home/max/projects/Mindy_Orm/phpunit.xml

.............................E.......EEEEEEE.EE.................. 65 / 87 ( 74%)
.......E..............

Time: 2.82 seconds, Memory: 13.75Mb

There were 11 errors:

1) Tests\Orm\LookupTest::testIn
Mindy\Query\Exception: SQLSTATE[HY000]: General error: 1 no such column: product_1.category
Failed to prepare SQL: SELECT COUNT(*) FROM `product` `product_1` WHERE (`product_1`.`category` IN (:qp0, :qp1, :qp2, :qp3, :qp4))

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:155
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:127

Caused by
PDOException: SQLSTATE[HY000]: General error: 1 no such column: product_1.category

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:127

2) Tests\Orm\LookupTest::testYear
Mindy\Query\Exception: SQLSTATE[HY000]: General error: 1 near "FROM": syntax error
Failed to prepare SQL: SELECT COUNT(*) FROM `product_list` `product_list_1` WHERE ((EXTRACT(YEAR FROM `product_list_1`.`date_action`) = :product_list_1_date_action1))

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:155
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:183

Caused by
PDOException: SQLSTATE[HY000]: General error: 1 near "FROM": syntax error

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:183

3) Tests\Orm\LookupTest::testMonth
Mindy\Query\Exception: SQLSTATE[HY000]: General error: 1 near "FROM": syntax error
Failed to prepare SQL: SELECT COUNT(*) FROM `product_list` `product_list_1` WHERE ((EXTRACT(MONTH FROM `product_list_1`.`date_action`) = :product_list_1_date_action1))

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:155
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:196

Caused by
PDOException: SQLSTATE[HY000]: General error: 1 near "FROM": syntax error

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:196

4) Tests\Orm\LookupTest::testDay
Mindy\Query\Exception: SQLSTATE[HY000]: General error: 1 near "FROM": syntax error
Failed to prepare SQL: SELECT COUNT(*) FROM `product_list` `product_list_1` WHERE ((EXTRACT(DAY FROM `product_list_1`.`date_action`) = :product_list_1_date_action1))

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:155
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:209

Caused by
PDOException: SQLSTATE[HY000]: General error: 1 near "FROM": syntax error

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:209

5) Tests\Orm\LookupTest::testWeekDay
Mindy\Query\Exception: SQLSTATE[HY000]: General error: 1 no such function: DAYOFWEEK
Failed to prepare SQL: SELECT COUNT(*) FROM `product_list` `product_list_1` WHERE ((DAYOFWEEK(`product_list_1`.`date_action`) = :product_list_1_date_action1))

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:155
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:222

Caused by
PDOException: SQLSTATE[HY000]: General error: 1 no such function: DAYOFWEEK

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:222

6) Tests\Orm\LookupTest::testHour
Mindy\Query\Exception: SQLSTATE[HY000]: General error: 1 near "FROM": syntax error
Failed to prepare SQL: SELECT COUNT(*) FROM `product_list` `product_list_1` WHERE ((EXTRACT(HOUR FROM `product_list_1`.`date_action`) = :product_list_1_date_action1))

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:155
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:235

Caused by
PDOException: SQLSTATE[HY000]: General error: 1 near "FROM": syntax error

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:235

7) Tests\Orm\LookupTest::testMinute
Mindy\Query\Exception: SQLSTATE[HY000]: General error: 1 near "FROM": syntax error
Failed to prepare SQL: SELECT COUNT(*) FROM `product_list` `product_list_1` WHERE ((EXTRACT(MINUTE FROM `product_list_1`.`date_action`) = :product_list_1_date_action1))

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:155
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:248

Caused by
PDOException: SQLSTATE[HY000]: General error: 1 near "FROM": syntax error

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:248

8) Tests\Orm\LookupTest::testSecond
Mindy\Query\Exception: SQLSTATE[HY000]: General error: 1 near "FROM": syntax error
Failed to prepare SQL: SELECT COUNT(*) FROM `product_list` `product_list_1` WHERE ((EXTRACT(SECOND FROM `product_list_1`.`date_action`) = :product_list_1_date_action1))

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:155
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:261

Caused by
PDOException: SQLSTATE[HY000]: General error: 1 near "FROM": syntax error

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:261

9) Tests\Orm\LookupTest::testRegex
Mindy\Query\Exception: SQLSTATE[HY000]: General error: 1 near ":product_list_1_name1": syntax error
Failed to prepare SQL: SELECT COUNT(*) FROM `product_list` `product_list_1` WHERE ((`product_list_1`.`name` REGEXP BINARY :product_list_1_name1))

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:155
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:285

Caused by
PDOException: SQLSTATE[HY000]: General error: 1 near ":product_list_1_name1": syntax error

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:285

10) Tests\Orm\LookupTest::testIregex
Mindy\Query\Exception: SQLSTATE[HY000]: General error: 1 no such function: REGEXP
Failed to prepare SQL: SELECT COUNT(*) FROM `product_list` `product_list_1` WHERE ((`product_list_1`.`name` REGEXP :product_list_1_name1))

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:155
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:298

Caused by
PDOException: SQLSTATE[HY000]: General error: 1 no such function: REGEXP

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:235
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:393
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:271
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:747
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:714
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:240
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/LookupTest.php:298

11) Tests\Orm\SaveUpdateTest::testUpdate
Mindy\Query\Exception: SQLSTATE[HY000]: General error: 1 near "`user_1`": syntax error
Failed to prepare SQL: PRAGMA table_info(user `user_1`)

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:155
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:395
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:312
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Sqlite/Schema.php:122
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Sqlite/Schema.php:106
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Schema.php:106
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:455
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/QueryBuilder.php:195
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:500
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:753
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:134
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/SaveUpdateTest.php:120

Caused by
PDOException: SQLSTATE[HY000]: General error: 1 near "`user_1`": syntax error

/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:151
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:395
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:312
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Sqlite/Schema.php:122
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Sqlite/Schema.php:106
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Schema.php:106
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Connection.php:455
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/QueryBuilder.php:195
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Command.php:500
/home/max/projects/Mindy_Orm/vendor/mindy/query/src/Mindy/Query/Query.php:753
/home/max/projects/Mindy_Orm/src/Mindy/Orm/QuerySet.php:134
/home/max/projects/Mindy_Orm/Tests/Cases/Orm/SaveUpdateTest.php:120

FAILURES!
Tests: 87, Assertions: 294, Errors: 11.

Remove extra "(" and ")" in sql

See tests for extra information

Добавить поддержку order by rand()

Model::objects()->filter(['parent_id' => 1])->order('?')->all();

User::objects()->filter([...])->update(['is_active' => false]);

Mindy\Query\Exception : SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '5' for key 'PRIMARY'
The SQL being executed was: INSERT INTO `nested_model` (`id`, `parent_id`, `lft`, `rgt`, `level`, `root`, `name`) VALUES (5, NULL, 1, 2, 1, 3, 'test4')

Преобразования DateTimeField && DateField в зависимости от субд.

Order by lookups

реальзовать лукапы в order_by

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.