Breaking News: Grepper is joining You.com. Read the official announcement!

BadMethodCallException: SQLite doesn't support dropping foreign keys (you would need to re-create the table).

Uptight Unicorn answered on February 22, 2024 Popularity 1/10 Helpfulness 1/10

answer BadMethodCallException: SQLite doesn't support dropping foreign keys (you would need to re-create the table).

BadMethodCallException: SQLite doesn't support dropping foreign keys (you would need to re-create the table).

Comment

namespace Tests;

use Closure;
use Illuminate\Database\Connection;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Schema\SQLiteBuilder;
use Illuminate\Database\SQLiteConnection;
use Illuminate\Foundation\Testing\TestCase as BaseTestCase;
use Illuminate\Support\Fluent;

abstract class TestCase extends BaseTestCase
{
    use CreatesApplication;
    public function __construct(?string $name = null, array $data = [], string $dataName = '')
    {
        $this->resolveSqlite();
        parent::__construct($name, $data, $dataName);
    }
    public function resolveSqlite()
    {
        Connection::resolverFor('sqlite',
            function ($connection, $database, $prefix, $config) {
                return new class($connection, $database, $prefix, $config)
                    extends SQLiteConnection {
                    public function getSchemaBuilder()
                    {
                        if ($this->schemaGrammar === null) {
                            $this->useDefaultSchemaGrammar();
                        }

                        return new class($this) extends SQLiteBuilder {
                            protected function createBlueprint($table, Closure $callback = null)
                            {
                                return new class($table, $callback) extends Blueprint {
                                    public function dropForeign($index)
                                    {
                                        return new Fluent();
                                    }
                                };
                            }
                        };
                    }
                };
            });
    }
}

Popularity 1/10 Helpfulness 1/10 Language sql

Source: codingwisely.com

Tags: foreign-keys sql sqlite

Link to this answer
Share Copy Link

Contributed on Feb 22 2024

Uptight Unicorn

0 Answers Avg Quality 2/10

BadMethodCallException: SQLite doesn't support dropping foreign keys (you would need to re-create the table).

Contents

More Related Answers

BadMethodCallException: SQLite doesn't support dropping foreign keys (you would need to re-create the table).

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.