Can you create db table with Bitrix ORM?

Pavel Olnyov — Wed, 15 Apr 2020 07:28:03 +0000

If you use bitrix CMS and cannot create a database table in migration using the built-in ORM (bitrix core d7), then here is my working php-code:

$connection = Application::getConnection();

        try{
            $connection->createTable(
                'table_name',
                [
                    'id' => new Entity\IntegerField(
                        'id',
                        [
                            'column_name' => 'id'
                        ]
                    ),
                    'user_id' => new Entity\IntegerField(
                        'user_id',
                        [
                            'column_name' => 'user_id'
                        ]
                    ),
                    'type' => new Entity\StringField(
                        'type',
                        [
                            'column_name' => 'type'
                        ]
                    ),
                    'create_date' => new Entity\DatetimeField(
                        'create_date',
                        [
                            'column_name' => 'create_date'
                        ]
                    ),
                    'lots_count' => new Entity\IntegerField(
                        'lots_count',
                        [
                            'column_name' => 'lots_count'
                        ]
                    )
                ],
                ['id'],
                ['id']
            );
        }
        catch(\Exception $exception){
            echo $exception->getMessage();
        }

This is very bad. Why specify duplicate field names so many times?
Becouse, the method createTable() is far from perfect:

public function createTable($tableName, $fields, $primary = array(), $autoincrement = array())
    {
        $sql = 'CREATE TABLE '.$this->getSqlHelper()->quote($tableName).' (';
        $sqlFields = array();

        foreach ($fields as $columnName => $field)
        {
            if (!($field instanceof ScalarField))
            {
                throw new ArgumentException(sprintf(
                    'Field `%s` should be an Entity\ScalarField instance', $columnName
                ));
            }

            $realColumnName = $field->getColumnName();

            $sqlFields[] = $this->getSqlHelper()->quote($realColumnName)
                . ' ' . $this->getSqlHelper()->getColumnTypeByField($field)
                . ' NOT NULL' // null for oracle if is not primary
                . (in_array($columnName, $autoincrement, true) ? ' AUTO_INCREMENT' : '')
            ;
        }

        $sql .= join(', ', $sqlFields);

        if (!empty($primary))
        {
            foreach ($primary as &$primaryColumn)
            {
                $realColumnName = $fields[$primaryColumn]->getColumnName();
                $primaryColumn = $this->getSqlHelper()->quote($realColumnName);
            }

            $sql .= ', PRIMARY KEY('.join(', ', $primary).')';
        }

        $sql .= ')';

        if ($this->engine)
        {
            $sql .= ' Engine='.$this->engine;
        }

        $this->query($sql);
    }

Laravel Passport don`t work. Error: column "api_token" does not exist

Pavel Olnyov — Fri, 07 Feb 2020 13:17:17 +0000

I want to create API with OAuth 2.0 authentication.

Use Laravel Passport tutorial https://laravel.com/docs/6.x/passport.

Set up the configuration on config/auth.php:

'guards' => [
    'web' => [
        'driver' => 'session',
        'provider' => 'users',
    ],

    'api' => [
        'driver' => 'passport',
        'provider' => 'users',
    ],
],

When testing, I use a fresh token, but in response I get an error:

SQLSTATE[42703]: Undefined column: 7 ERROR:  column "api_token" does not exist↵LINE 1: select * from "users" where "api_token" = $1 limit 1

Solution: clear the cache with command:

php artisan config:clear

DEV Community: Pavel Olnyov

Can you create db table with Bitrix ORM?

Laravel Passport don`t work. Error: column "api_token" does not exist