SQLITE not throwing exception

Hi, is there a way for sqlite to throw exception like Illuminate\Database\QueryException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ?? because on our mysql database it throwing this exception but when using sqlite on testing. it didn't throw anything.

marbobo's avatar
marbobo's avatar CharizardTesting
1

SQLite no such tables.

I am setting up a Test case for the existing project. But I am getting SQLite no such tables error. Following is my setup phpunit.xml <server name="DB_CONNECTION" value="sqlite"/> <server name="DB_DATABASE" value=":memory:"/> AuthControllerTest.php class AuthControllerTest extends TestCase { use RefreshDatabase; /**

channaveer's avatar
channaveer's avatar channaveerTesting
3

(SQLite) migration "down" on tests can't find columns

Given the following migration, when I run my tests I get the error: Doctrine\DBAL\Schema\SchemaException: There is no column with name 'accreditation_start' on table 'validation_reviews'. I also notice the // dd($table->getColumns()); in my up() method. It printed the two columns I created, but only those columns. This migration works as expected on the standard DB, but fai

number6's avatar
number6's avatar number6Testing
3

[Sail] Run database tests with sqlite

Hi guys, I'm trying to run database tests in my local environment that is running with Sail. Looks that everything is working fine, but what I try to run a simple database test it looks my environment can't connect to the sqlite instance that is running in the Laravel container. For example, with the default users table migration I can migrate the table without any problems in

thinway's avatar
thinway's avatar thinwayTesting
0

sqlite: could not find driver On Windows

I want to work with sqlite database while i'm on phpunit but laravel says driver not found: Windows php.ini: extension=pdo_sqlite phpunit.xml: <?xml version="1.0" encoding="UTF-8"?> <phpunit xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="./vendor/phpunit/phpunit/phpunit.xsd"

untymage's avatar
untymage's avatar KarunurLaravel
3

SQLITE requires group by when using 'having'

The following query works fine with Mysql: Community::withCount('stories')->having('stories_count', '>', 20)->whereNotExists(function($query) { $query->select(DB::raw(1)) ->from('communities_followers') ->whereRaw('communities_followers.community_id = communities.id and communities_followers.user_id = '. auth()->i

EckyEckyPtang's avatar
EckyEckyPtang's avatar sr57Laravel
4

whereJsonContains() equivalent for SQLite database

You may use whereJsonContains to query JSON arrays. This feature is not supported by the SQLite database. JSON Where Clauses I have a relationship using whereJsonContains. Upon runing unit test with in-memory sqlite, I receive this error This database engine does not support JSON contains operations. What are my options here? To keep the relationship and have a working test.

chaudigv's avatar
chaudigv's avatar destherLaravel
6

Sqlite test database do not update when added columns

Hi! I have added a column, and changed one columnname in a new migration. I'm running Postgres. For my test I use Sqlite. Schema::table('log_services', function (Blueprint $table) { $table->date('end')->nullable(); $table->renameColumn('date', 'start'); }); The new migration look like above I get the following errormessage SQLSTATE[HY0

TobiasS's avatar
TobiasS's avatar ahinkleTesting
5

Models with foreign key fails in sqlite (with foreign keys enabled)

This is driving me a little crazy. I can easily work round it but it seems a shame to change the code to suit tests with SQlite. I migrate my 'crop_requests' table. Schema::create('crop_requests', function (Blueprint $table) { $table->increments('id'); $table->integer('user_id'); $table->integer('business_id'); $table-&g

Ltloafer's avatar
Ltloafer's avatar LtloaferGeneral
6

Package Test: could not find driver for SQLite - (Laravel 8 - Windows 10)

I am developing a package using latest laravel 8.x. In on a windows 10 machine. I am trying to create tests. I start tests in this way C:\php-7.3.18-Win32-VC15-x64\php.exe C:/progetto/packages/product_image/vendor/phpunit/phpunit/phpunit --configuration C:\progetto\packages\product_image\phpunit.xml In the .xml I configured <php> <server name="APP_KE

realtebo's avatar
realtebo's avatar realteboLaravel
1

phpunit not using in memory sqlite

Hi, I've just started the 'Let's Build A Forum with Laravel and TDD' series, and am unable to get the tests running using the sqlite in memory database. Using Laragon if that makes any difference. include in the php tag in phpunit.xml <server name="DB_CONNECTION" value="sqlite"/> <server name="DB_DATABASE" value=":memory:"/>

strawberry's avatar
strawberry's avatar strawberryTesting
6

schema:dump test sqlite

Love the idea of this feature in L8! However, I am using sqlite in memory for phpunit - anyone know how to implement the schema:dump just for sqlite in memory for tests??

futurefuture's avatar
futurefuture's avatar futurefutu...Testing
3

Testing with sqlite CONSTRAINT name issue

I'm updating from laravel 5.8 to 6 the issue is that all of my tests, that are depending on the database, are failing. The error I'm getting is: Illuminate\Database\QueryException: SQLSTATE[HY000]: General error: 1 near "0": syntax error (SQL: CREATE TABLE posts (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, type_id INTEGER NOT NULL, author_id INTEGER NOT NULL, statu

nadj's avatar
nadj's avatar nadjTesting
4

Problem With PHPUnit + SQLite dropColumn()

Hello Everyone, Suddenly all my tests started to fail with the same error. Im using Laravel Framework 7.27.0 Ubuntu 20.04 PHPUnit in :memory: database and sqlite I did not change any migration and always worked before without problems. If run phpunit on my production server, works, looks like some bad configuration issue If I create blank project and add a dropCOlum

manojo123's avatar
manojo123's avatar manojowTesting
5

how to test mysql specific function in sqlite

Hi guys, I use mysql db in production and dev, but for testing I use sqlite in memory, because is it much faster. IMHO this is common. I did not have any problem until now. Now I need to test complicated custom sql query with some mysql specific functions like (year, month, sec_to_time, time_to_sec, timediff,...) What is the best approach to test sql query with mysql specific f

marek7's avatar
marek7's avatar marek7Testing
4

sqlite sushi 'database' throwing error

I have a sushi model that is throwing a: SQLSTATE[HY000]: General error: 1 no such table: <tablename> error. Sqlite is installed properly and have validated that and sushi in another project on the same machine. I have ubuntu 19.10 / php7.4 and valet installed. Everything has been turn off and on again and restarted. Anyone have any ideas?

njames180's avatar
njames180's avatar njames180Eloquent
2

i used sqlite for a social media project

The size just keeps increasing at an exponential level. it's about 18gig now. I am using a shared hosting platform. is there a way i could convert from sqlite to mysql without losing any info?

tomasosho's avatar
tomasosho's avatar tomasoshoGeneral
9

Setting up SQLite

I'm having problems accessing my local MySQL so I'm going to try and use SQLite instead. Following the official docs I have so far just run this in my project: touch database/database.sqlite Now it says I have to add: DB_CONNECTION=sqlite DB_DATABASE=/absolute/path/to/database.sqlite So, the database is in the database folder, what would the absolute path be? Thanks.

SarahS's avatar
SarahS's avatar SarahS74Laravel
2

How list all tables of database using sqlite in Laravel?

I know that using MySQL or Postgres i can do DB::select('SHOW TABLES') but using a sqlite database it isn't working. I got this error: SQLSTATE[HY000]: General error: 1 near "SHOW": syntax error (SQL: SHOW TABLES) I tried using sqlite syntax with DB::select('.tables') but got a syntax error too.

JoaoHamerski's avatar
JoaoHamerski's avatar MichalOrav...Laravel
1

How with Cypress testing vue/cli to switch to sqlite db?

Looking at “Episode 39 - Learn Cypress with Laravel Integration” at https://laracasts.com/series/whatcha-working-on/episodes/39 there is an example of Laravel app testing with diferent .env file and switching to sqlite db. As I have @vue/cli 4 app with Laravel 6 Backend REST API and backend. I wonder if there is a way to test frontend part with cypress and switching Laravel 6 B

mstdmstd's avatar
mstdmstd's avatar mstdmstdTesting
0

How with Cypress testing vue/cli to switch to sqlite db?

Looking at “Episode 39 - Learn Cypress with Laravel Integration” at https://laracasts.com/series/whatcha-working-on/episodes/39 there is an example of Laravel app testing with diferent .env file and switching to sqlite db. As I have @vue/cli 4 app with Laravel 6 Backend REST API and backend. I wonder if there is a way to test frontend part with cypress and switching Laravel 6 B

mstdmstd's avatar
mstdmstd's avatar mstdmstdTesting
0

SQLite foreign key dont set null on delete in phpunit test

Hello, I have migration where I add foreign key to threads table (https://github.com/keizah7/forum/commit/e1aa1b31555c9469091be178e23f5746c377c080#diff-873a697d9df8d6d454c40acbb165080e) Problem is that in phpunit test sqlite don't set foreign key null on delete. 1) Tests\Feature\BestReplyTest::if_a_best_reply_is_deleted_then_the_thread_is_properly_updated_to_reflect_that Failed

keizah7's avatar
keizah7's avatar amirrezam7...Testing
11

Downsides of testing with SQLite?

I'm working on a large scale project with multiple devs and we were discussing the pros and cons of using SQLite :memory: tests. We already know that SQLite does not return integers, which we're wondering if that could cause unexpected issues. The main question that has been raised is, is testing using SQLite "a bad idea" because it is not actually testing what prod

fylzero's avatar
fylzero's avatar mabdullahs...Testing
7

What is your opinion on using != vs !== in PHP? SQLite testing

So, apparently (and correct me if I'm wrong)... All data in SQLite is a string? I'd like to consider using SQLite :memory: for a project, but said project is using strict type checking in almost every comparison. Not sure if it absolutely needs to be written this way. What is the best move here? Don't use SQLite in memory for testing? Remove the strict comparison operators? T

fylzero's avatar
fylzero's avatar fylzeroLaravel
5

Testing with Sqlite JSON column?

As you may know, Sqlite has different approach to creating JSON fields, so I'm wondering how do you run phpunit with sqlite if you have some JSON columns? Mysql as test DB is working fine, but it is slooow :( So what's your approach?

sasafister's avatar
sasafister's avatar joveTesting
3

How to get rid of Sqlite default in migration

As you know, when you use Sqlite you have to specify default value in your migrations, otherwise, error is thrown. Anyone knows how to avoid that? I'm using now MySql as test DB, but it's little bit to slow.

sasafister's avatar
sasafister's avatar rodrigo.pe...Testing
3

Any downsides to using SQLite locally?

I'm considering just using SQLite for local development... First thing I ran into today... strict type checking against an integer "broke" MySQL - Works some_number !== integer_from_mysql SQLite - Doesn't Work some_number !== integer_from_sqlite Not sure if this is actually SQLite NOT being able to spit out integers or not, even though they are specified as an inte

fylzero's avatar
fylzero's avatar fylzeroLaravel
1

SQLite and foreign cascade issues with unit tests

My Unit test fails with this Failed asserting that a row in the table [pages] does not match the attributes { "page": 1 }. Correct, it is in there. Now if I delete the Book which has this hasMany from my dev environment it works fine. migration: Schema::create('books', function (Blueprint $table) { $table->bigIncrements('id'); $

jove's avatar
jove's avatar joveLaravel
5

PHPUnit sqlite and JSON fields

Hi all, I wish to write tests on a model which utilises the JSON field type. The test runs fine when utilising mysql or running the code in production however it is extremely slow to run the full suite of tests. Whenever I try to run the test in sqlite I get: "RuntimeException : This database engine does not support JSON contains operations." From what I have read th

Benjamest's avatar
Benjamest's avatar bugsyshaTesting
1

SQLite 'year', 'month' error

Hi, I have the next method, and it works fine with MySQL, but not with SQLite (when I run my tests). Looks like the root of the problem in 'year' and 'month' in SQLite. return static::selectRaw('year(created_at) year, monthname(created_at) month, count(*) published') ->groupBy('year', 'month') ->orderByRaw('min(created_at) desc') ->get()

Stillfinder's avatar
Stillfinder's avatar Stillfinde...Code Review
2

Sqlite General error near "auto_increment"

I am using Sqlite for test database. When i run a factory it is showing SQLSTATE[HY000]: General error: 1 near "auto_increment": syntax error in SQLite they have autoincrement not auto_increment. how do I can define a primary key or auto increment for sqlite?

marufalom's avatar
marufalom's avatar jonwinstan...Testing
19

phpunit.xml does not use my sqlite settings

I start to learn testing. After a lot of tests I realized, that even if i setup my phpunit.xml to use sqlite, it uses my main database, which is mysql. I have this in my phpunit.xml: <server name="APP_ENV" value="testing"/> <server name="BCRYPT_ROUNDS" value="4"/> <server name="CACHE_DRIVER" value=&quo

Pixelairport's avatar
Pixelairport's avatar tykusTesting
10

dusk/phpunit test using homestead db instead of sqlite

Running the test below, with phpunit ./tests/Browser/NotesTest.php --filter a_user_can_delete_notes I see my homestead db being changed, instead of sqlite db ! Why is that ? public function a_user_can_delete_notes() { $user = factory(User::class)->create(); $notes = factory(Note::class, 2)->create([ 'user_id' => $user->id

trogne's avatar
trogne's avatar trogneLaravel
7

How can I test a multi-tenant Postgres app with in memory sqlite?

With our app, we're using Postgres as our DB. We have a public schema that houses all shared data, then each customer has their own schema (company_[ID]) with their own set of identical tables. When a new customer comes on board, we create a new schema for them and migrate all tables to get them up to speed instantly. When it comes to testing though, I'm struggling to find if t

duellsy's avatar
duellsy's avatar duellsyTesting
0

Migration issues - MySQL vs SQLite

I've recently inherited a codebase and whilst there are some tests, I want to improve the setup. At the moment, tests run using the local dev DB - rather than a separate DB for testing. This just feels wrong, and is causing a couple of tests to fail depending on the state of local data. The current database is MySQL. I'm want to use a SQLite database for running tests, however

gbuckingham89's avatar
gbuckingham89's avatar tykusTesting
2

MySQL functions are not supported in SQLite!

I am using MySQL as my primary database and SQLite for testing. Some of the MySQL functions like YEAR, MONTH etc is not supported by SQLite. How you guys are dealing with this sort of issue while testing?

minhajul's avatar
minhajul's avatar siangboonTesting
4

SQLite Driver Installed but not Seen!

Hi, my sqlite driver has just been installed and I can see it with sqlite command. When I run php artisan migrate I get this error. at <font color="#4E9A06">/opt/lampp/htdocs/laravel_tutorials/freecodecamp/vendor/laravel/framework/src/Illuminate/Database/Connection.php</font>:<font color="#4E9A06">664</font> <font color=&quo

Randy_Johnson's avatar
Randy_Johnson's avatar Randy_John...General
3

php artisan migrate ERROR for sqlite connection

i am working on laravel on my local system for the first time and followed the step by step instructions but I am getting errors at this point. This is my .env file: DB_CONNECTION=sqlite DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=database/database.sqlite DB_USERNAME=homestead DB_PASSWORD=secret This is my database.php: 'default' => env('DB_CONNECTION', 'sqlite')), 'sqlit

Joycey's avatar
Joycey's avatar tykusLaravel
3

Handle differences between SQLite and MySQL in test environment

I like to use in-memory SQLite for testing but I always get stuck on the differences between the two for example, regex and full-text search indices are diffrent so how you cope with that?

ahmadsalah's avatar
ahmadsalah's avatar Tray2Testing
1

Inner Join Increments Works in MySQL but not SQLite

I have the following codes that does cross tables increments when executed. When being tested against MySQL, they work perfectly. But they don't work with SQLite and that creates problems with my test cases. Any advice if there are simple workarounds to have the same query / outcome that work on MySQL and SQLite? DB::table('entries') ->join('transactions', function ($joi

blacklotus's avatar
blacklotus's avatar blacklotusLaravel
1

SQLite :memory: testing results inconsistent with MySql?

Hey Everyone, I've got an app with API resources where I've been using MySql for php unit tests. I attempted to move across to use sqlite :memory: as the testing having read about the potential speed/performance benefits. After making the change I found a few examples of strange test results, where the API resource has started returning certain attributes values as blank, rathe

it-is-all-about-laravel's avatar
it-is-all-about-laravel's avatar paul-a-byf...Testing
2

testing json and enum column types with sqlite

Hey Everyone, I attempted to switch to sqlite (in memory) to speed up running phpunit testing with the RefreshDatabase trait. Currently I'm using mysql and found that RefreshDatabase adds about 2 seconds to the run time to process the migrations. I discovered sqlite doesn't seem to support column types enum or json. Can you recommend a way around this with sqlite, or any altern

it-is-all-about-laravel's avatar
it-is-all-about-laravel's avatar paul-a-byf...Testing
3

Laravel 5.8 does not use sqlite for testing

I've tried many of the solutions I've come across, all of them were for older versions of laravel. but none of them worked, laravel always uses mysql database even when setting the default database to sqlite (as a solution!). So please, how to set up sqlite for testing in laravel 5.8?

joe-inz's avatar
joe-inz's avatar amadeannLaravel
14

SQLite - unique constraint failed

I have a test in my aqpplication. I have the following model factory: use App\Hand; /* |-------------------------------------------------------------------------- | Model Factories |---------------?php use App\Hand; /* |-------------------------------------------------------------------------- | Model Factories |-------------------------------------------------------------

canadianlover's avatar
canadianlover's avatar canadianlo...Testing
5

SQLite in Memory for PHPUnit Testing

Hi All, I am working on optimising our unit tests, we are currently using a MySQL database to run our tests, and it takes quite a great deal of time and we only have currently about 20% code coverage. Our plan was to use an SQLite database held in memory to speed up the performance. However, with every test, I need to migrate and seed the data. The seeding is slowing the proces

drewdan's avatar
drewdan's avatar drewdanTesting
2

Renaming a column in SQLite on a table referenced by a foreign key fails

I'm trying to add a username column to my users table (which currently just has the standard columns provided in a new Laravel project on it). To avoid confusion with the name column, I wanted to first rename the name column to display_name. I attempted to do so using the following migration: /** * Run the migrations. * * @return void */ public funct

tylernathanreed's avatar
tylernathanreed's avatar volley_bal...Laravel
7

Testing DB join queries over connections with SQLite :memory: databases

In my application I have this query which uses joins over a different mysql connection. DB::connection('tenant1')->table('stats AS t') ->select(['user_id', 'u.created_at']) ->join(config('database.connections.tenant2.database').'.users AS u', 't.user_id', '=', 'u.uid') ->whereBetween('event_date', $datesInterval) ... It

phikhi's avatar
phikhi's avatar phikhiTesting
0

PDOException: could not find driver (for SQLite)

Howdy, I've just started a fresh Laravel project, looking to approach it from a TDD point of view. With that in mind, I have setup a simple test, and as per the Birdboard series have set phpunit to use an sqlite database for testing in phpunit.xml <env name="DB_CONNECTION" value="sqlite"/> <env name="DB_DATABASE" value=":memory:"

TimeSocks's avatar
TimeSocks's avatar JussiManni...Laravel
11

SQLite Foreign Keys with Set Null on Delete not working for PHPUnit test

I have added a foreign keys constraint in migration file for posts table to the user_id column. So, on delete user, I want to set the user_id column to null. So, I added this. $table->foreign('user_id') ->references('id') ->on('users') ->onDelete('set null'); It is working on the MySQL database. But not working on SQL

gewode's avatar
gewode's avatar staudenmei...Testing
6

Laravel Dusk loginAs not working / using sqlite DB

I am using Laravel Spark 7.0 and trying to use Laravel Dusk to test my application. This is my simple test. I am trying to create a user and a team, make the user the owner of that team and then start navigating the app. It fails when trying to visit DashboardPage. The URL does not validate "/home" b/c it's actually still "/login". The screenshot taken is of

number6's avatar
number6's avatar number6Testing
2