Is it possible to run db:seed when using SQLite in memory with phpunit?

I am using use DatabaseMigrations; in my test files to migrate:fresh the database on every test run. Is there a way to seed the database on every test?

fylzero's avatar
fylzero's avatar STEREOHTesting
1

SQLITE Database throw error could not find driver (SQL: PRAGMA foreign_keys = ON;)

Hello Everyone, I am new in laravel and ubantu. i am trying to migrate my database using php artisan migrate command but i get error. i have already created a database/database.sqlite file. my .env file DB_CONNECTION=sqlite BROADCAST_DRIVER=log CACHE_DRIVER=file QUEUE_CONNECTION=sync SESSION_DRIVER=file SESSION_LIFETIME=120 Error:- PHP Warning: PHP Startup: Unable to load dyna

AlokDev's avatar
AlokDev's avatar Tray2Laravel
30

How to use sqlite when testing Lumen.

Hi, I am wondering how do to this with Lumen because there is no database.php? <env name="APP_ENV" value="testing"/> <env name="CACHE_DRIVER" value="array"/> <env name="QUEUE_DRIVER" value="sync"/> <env name="DB_CONNECTION" value="database.sqlite" /&g

MickBee's avatar
MickBee's avatar FlaviusTesting
18

Sqlite 3 and HTML checkbox trouble

I have a controller, wich has got the logic for a form-group. This form-group has two checkboxes and i store the valuer in an Sqlie3 database. (There are booleans represented as TinyInt-s, and these can store the value of 0 and 1. I try to represent this problem in my controller like this, but it won't set the proper 0 or 1 digits in the database. What am i doing wrong? The che

Albert90's avatar
Albert90's avatar belalehner...Eloquent
6

phpunit sqlite error after updating laragon (PDOException: could not find driver)

php artisan migrate etc works fine.But when i try to use phpunit i am getting the following errors after updating my laragon which updated php too in the process, its now 7.1 , but i also have xampp installed which has php 7.0 and if i remove the php from laragon folder then the tests works with php 7.0 (xampp,s php is in my environment variables) i also tried removing xampp,s

Muhammad.shahid.shah's avatar
Muhammad.shahid.shah's avatar emdidarGeneral
3

Tests fails with sqlite but works with mysql?

Hi, I've got a method that looks like this: protected function saveDescriptions($descriptionsShort, $descriptionsLong, $productId) { /* * Check if product description short already exists * otherwise create one. */ foreach ($descriptionsShort as $description) { if(! ProductDescriptionModel::where( 'description', $description )

Lars-Janssen's avatar
Lars-Janssen's avatar Lars-Janss...Laravel
5

sqlite table relation on the database migration

I have two tables I am using laravel 5.4 and I want to fill the type_id in user table with data on id in types table, if possible i want to do it on database migration I have two tables Types table id name Users table id type_id username password

wardaddy's avatar
wardaddy's avatar burlresear...General
2

Models Using Invalid Memory Sqlite DB

AuthenticationTest <?php namespace Tests\Unit\Authentication; use App\Club; use Artisan; use Tests\TestCase; /** * Route::post('/do/login', 'Auth\LoginController@login')->name('do.login'); * Route::post('/do/logout', 'Auth\LoginController@logout')->name('do.logout'); */ class AuthenticationTest extends TestCase { public function testLoginPage() { //

lara65535's avatar
lara65535's avatar gofish543Testing
1

Laravel tests with sqlite doesn't create users table

I'm with problem with tests in Laravel. I don't know why the users table isn't be created, because all other tables are ok. My PHP Unit configuration file (phpunit.xml) <php> <env name="APP_ENV" value="testing"/> <env name="DB_CONNECTION" value="sqlite"/> &l

diegosmota's avatar
diegosmota's avatar diegosmotaTesting
2

Delete problem DB record from SQlite in Tinker

Hi, while adding the user in PHP artisan tinker on laravel-5-from-scratch/episodes/10, I accidentally typed $username->username = 'JohnDoe'; instead of $user->username = 'JohnDoe'; So the $username does not exist and is therefore causing an issue when trying to save a user. How do I delete it? Thanks

trendsideas's avatar
trendsideas's avatar trendsidea...General
3

Unit Testing using different sqlite file - connection override in model

I'm hoping someone can either explain what I'm doing wrong, or whether this is just the way it is. My setup is as follows: Default connection string: default ( DB_CONNECTION env) Alt connection string: alt Testing connection string: testing In a model class I use the protected $connection variable to set which connection to use when not using default so in some instances; $c

ritey's avatar
ritey's avatar muhammad_z...Testing
12

Seeder problem with SQLite

This is a double-post. I received a Whoops error from Laracasts each time I tried posting this question. There seems to be no way to delete a post here. Please see my other question at: https://laracasts.com/discuss/channels/general-discussion/sqlite-database-seeder-problem-help

ChristopherSFSD's avatar
ChristopherSFSD's avatar Christophe...General
0

Sqlite Migration Error - Unable to open database file

I have been developing an app on a machine I have at home. I pushed the project to github and am attempting to migrate the database on a new machine. Both machines are using Homestead on windows as the host. Everything on the home machine works. On the problematic machine ssh'ed into homestead: 06:44:32 {master} ~/Code/InnKeep$ php artisan migrate --seed Migration table create

Railalis's avatar
Railalis's avatar mdecoomanEloquent
5

Migration sqlite Won't Work on Laravel 5.2

Hello I'm new to the laravel framework and i'm trying to follow the Laravel 5 Fundamentals tutorial, so when i run php artisan migrate, it shows this error: [PDOException] could not find driver I tried to put the database in storage, and i tried it in database directory, both didn't work. Any help is appreciated.

MohammadAbusaleh's avatar
MohammadAbusaleh's avatar MohammadAb...Laravel
2

Auth Help, switch from Sqlite to MySql

I think I broke it!!! Pushed a commit to BitBucket which my dev environment i'm using Sqlite3 had it pulled down into someone else's dev environment and switch it to MySql, My login info is seeded into the DB, but when I try to login a notification that the email field is required pops up which isn't a required field to login with? the Login should just be Username and Password

jbowman99's avatar
jbowman99's avatar willvincen...General
1

How do I specify a sqlite database within .env or phpunit.xml?

I wanna be able to use a different database, but I don't know how to mimic the storage_path() function within those files. Also, I'd like to avoid editing the database.php file, where it says env('DB_DATABASE', storage_path('database.sqlite')).

JohnRivs's avatar
JohnRivs's avatar JohnRivsTesting
4

Using sqlite with Laravel & Behat

I follow Jeffery's instruction to the letter on the "Laravel 5 and Behat: Driving Authentication" video, but for some reason, I get this error when running my code: ┌─ @BeforeScenario # FeatureContext::migrate() │ ╳ Database [acceptance.sqlite] not configured. (InvalidArgumentException) │ ┌─ @BeforeScenario # FeatureContext::beginTransaction() │ ╳ Datab

danhanly's avatar
danhanly's avatar CommandZTesting
2

Malformed SQLite database

Hi there! I'm trying to use a simple sqlite-database for playing around with homestead and Laravel 5. All I do is create a empty database.sqlite in the storage dir and then run artisan migrate. I do get "Migration table created successfully." first and then immediately it fails with the message "General error: 11 database disk image is malformed" . Have anyone else experien

coldKingdom's avatar
coldKingdom's avatar seandowneyGeneral
4

codeception acceptance with sqlite

I followed this cast: https://laracasts.com/lessons/test-databases-in-memory But it is for unit testing or functional. I would like to use the idea with acceptance tests . somebody tried it?

tzookb's avatar
tzookb's avatar tzookbGeneral
0

Use sqlite in memory db with codeception

Okay, I feel like a total dumb-ass right now, because it seems like I'm totally missing the obvious... I am trying out Codeception, using some of the vids on here. And just as with my other tests, I'd like to use an in memory database. I've set up the stuff in /testing/database.php, it's working in other tools like plain old PHPUnit. But with Codeception I keep getting errors

Crinsane's avatar
Crinsane's avatar Mike Hople...General
9

Isolated git worktrees for Laravel + Herd - a Claude Code skill

Hey everyone, I've been running multiple Claude Code sessions on the same Laravel project and kept hitting the same wall - each git worktree needs its own database, Herd domain, Vite port, and .env. Setting it all up manually every time defeats the purpose of worktrees. So I built a Claude Code plugin skill that generates all the setup/teardown scripts for your project. You ins

gause's avatar
gause's avatar LaryAIAI
1

Cache does not persist within Livewire component

I need to store the state of a user, but instead of using fields in the users table I have decided to use a persistent cache. The reason is that I will have other use cases to store states not all related to the users, so I needed a more generic solution. So, I created the migrations for persistent_cache and persistent_cache_lock as copies for the migrations for the cache provi

troccoli's avatar
troccoli's avatar troccoliLivewire
3

Laravel 12: Pest and multiple databases

Hello everyone, I have come across a problem. I have two databases a main database and another database for another project. I can migrate in both without any problems and also the tests for the main database are working like they should be working. But as soon as I test a model which uses the second database the test fails and tells me that the table of the model is not existe

SaschaWaitz's avatar
SaschaWaitz's avatar LaryAILaravel
1

Error when adding a new record via form

I'm getting an error and don't quite understand why or how to resolve. The error occurs when I try to create a new LibraryItem or edit an existing LibraryItem. Here is the error: SQLSTATE[HY000]: General error: 20 datatype mismatch (Connection: sqlite, SQL: update "authors" set "id" = ?, "updated_at" = 2025-09-07 20:48:50 where "authors".

earmsby's avatar
earmsby's avatar earmsbyFilament
2

Laravell 12 with MySQL instead

Hello, Laravel has now stopped asking if I want to use MySQL instead of SQLite. I'm a bit lost trying to change it myself. On a fresh install, I've changed my .env: DB_CONNECTION=mysql DB_HOST=mysql DB_PORT=3306 DB_DATABASE=laravel DB_USERNAME=sail DB_PASSWORD=password Seems to be working great with Sail. But when I push to github, the workflow tests.yml seems to fail. Do I ne

ignaciodev's avatar
ignaciodev's avatar ignaciodevLaravel
2

Cannot deploy a site with Forge to Akamai

I'm not using a databse with my Laravel site and I'm trying to deploy the site onto Akamai. It gets to a part in the deploy where it errors out and here is the message: In Connection.php line 822: Database file at path [/home/forge/listingnaples.com/database/database.sqli te] does not exist. E

ChrisF79's avatar
ChrisF79's avatar LaryAIForge
1

Error while migrate Pivot Table

I have been following 30 day to learn laravel , I am on ep 12 Pivot Tables and BelongsToMany Relationships in this lesson we are building a Pivot Table between a Job table and a Tag table. build the Pivot table no problem, we populate the table. then deleting the entry in the job table to see the orphan in the pivot table, then add constraint in the tags table migration to cas

mhballa's avatar
mhballa's avatar mhballaLaravel
2

Error when using create or save related to polymorphic relationships

I can't seem to get polymorphic MorphMany relationships working correctly, both in an app that I'm working on and in a clean app I created in Google's Firebase Studio just to test the issue. Here's a video model which is one of multiple models that will have a one-to-many polymorphic relationship with the image model: <?php namespace App\Models; use Illuminate\Database\El

pablomac's avatar
pablomac's avatar LaryAIEloquent
1

How to serve app over https in GitHub Actions?

Hi all, I'm in the process of developing a CI/CD pipeline for an app, and I'm running into an SSL-related issue when executing my browser tests. I'm wanting to test the integration with Square Payments. This is working perfectly on local, since I'm serving the local site over SSL and therefore the Square Payments SDK allows rendering of the card payment form. However, when runn

evan-55's avatar
evan-55's avatar evan-55DevOps
0

Tailwind CSS Not Working with Laravel

Basic Information: Laravel Installer Version 5.14.0 Laravel Framework Version 12.9.0 Node Version 23.11.0 NPM Version 11.2.0 Composer Version 2.8.8 Windows 10 Pro I was originally using Herd for my laravel projects, but tailwind wasn't working unless I used the CDN. I also had difficulty getting my project to use a different database other than sqlite. I uninstalled Herd, and d

judia's avatar
judia's avatar Tray2Vite
1

Errors on server but none on local

On my local build of Laravel 12 running on MacOS with herd, I have everything working perfectly. No errors in the logs, nothing in the browser, my .env file basically matches my .env.server file, except for the fact the server file has a mysql database and the local one uses sqlite. But... On the server, things just seem to fall apart. I run: mv .env.server .env composer updat

Frostist's avatar
Frostist's avatar FrostistLaravel
1

Laravel API in Docker is returning HTML instead of JSON?

I'm dockerzing my Laravel API and going quite crazy. Locally with either php artisan serve or symfony serve everything works well and has been working for years. Now I'm finally dockerzing (not an expert in Docker) Laravel for production and having some problems. The main one is that all the api routes return text/html as content type and not application/json, but locally it re

swagger's avatar
swagger's avatar swaggerDevOps
5

SQL Server 2014

I'm tryining to connect to a SQL Server database, but I'm stuck in the error: SQLSTATE[28000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error de inicio de sesión del usuario 'GAConLINE'. I've tried every possible given solution on the internet. But today I've read this on the Larave documentation: Currently, Laravel provides first-party support for five databases:

Vonsulnasaga's avatar
Vonsulnasaga's avatar jlrdwLaravel
1

Going Crazy: No such table even though the table exists

I have a many to many relationship between users and tenants. This is on a SQLite db. When I try to do a attach on either side of the relationship: $user = User::where("id", 2)->firstOrFail(); $tenant = Tenant::where("id", 2)->firstOrFail(); $tenant->users()->attach($user); // same with inverse. $user = User::where("id", 2)->firstO

mr_reboot's avatar
mr_reboot's avatar mr_rebootEloquent
2

How to properly make a paginated HTTP call?

Good day everybody. I'm trying to understand what's the proper way to make a paginated call to an external endpoint without having PHP crashing everytime because of the lack of memory. I'm using PHP 8.3.0, with Laravel 11.31, and I'm making a "simple" HTTP GET call to an external endpoint. Here below, the code I'm using: public function handle() { $startTime = no

FrancescoDiMuro's avatar
FrancescoDiMuro's avatar FrancescoD...Requests
4

Hosting a Laravel Inertia Vue App on an SBC: Hardware Requirements and Recommendations

I have a project where I'll need to host a Laravel app on an SBC. I'll be using Laravel Inertia Vue, so I'll need to install PHP (with SQLite), Composer, Node.js, and a web server on that SBC. Would a Raspberry Pi 3 Model B with the following specs be sufficient? Quad-Core 1.2GHz Broadcom BCM2837 64-bit CPU 1GB RAM BCM43438 wireless LAN and Bluetooth Low Energy (BLE) on board

maska's avatar
maska's avatar SnapeyLaravel
1

Not able to login under 2 different accounts

Hi, I was building a project doing initially the first steps to build it (model, factory, migration,etc) including to 2 new users ([email protected] with "TextUser" as name and [email protected] with "Mario" as name). The initial installation was with Laravel Breeze with Vue and Inertia and finally using SQlite as database. After to complete the migration t

MDelisle's avatar
MDelisle's avatar MDelisleGeneral
5

Issue with migration command

Hello! I'm trying to set up a new project and I can't get past the migrate stage. I have everything running through Herd and running laravel new project-name works until I try and run the migration and it just stops. I've tried with both sqlite and mysql as options when installing. Also ran composer global update and nothing changed. All other php artisan commands seem to be wo

jeksn's avatar
jeksn's avatar jeksnLaravel
2

ValueFactory in the first instantiation

When running my github action I got this error > Illuminate\Foundation\ComposerScripts::postAutoloadDump > @php artisan package:discover --ansi In ValueRegisterService.php line 63: You must pass ValueFactory in the first instantiation Script @php artis

rafa-acioly's avatar
rafa-acioly's avatar rafa-aciol...Laravel
0

Integrity constraint violation

Hi, I am following the chapter 9 at 30 days to learn laravel series, i have the employer_id colum at job_listings table . I already have two records at the employer table , when i try to run php artisan tinker App\Models\Job::create(['employer_id'=>2, 'title'=>'Acme Director', 'salary'=>'$1,000,000']); the message is : Illuminate\Database\QueryException SQLSTATE[23000

angelorigo's avatar
angelorigo's avatar JussiManni...Eloquent
4

Dusk with Filament using wrong database for Authentication

Hi Laracasts community. I've been trying out Dusk recently for a Filament project I've been working on, but have hit a stumbling block on the first test.... LoginTest! I've installed Dusk, setup my .env.dusk.local file, with it using a sqlite file which differs from my production one. My configuration is as follows: .env DB_CONNECTION=sqlite .env.dusk.local DB_CONNECTION=s

racsuk's avatar
racsuk's avatar LaryAITesting
1

How to test for non-existing database

I have a command that runs the migrate:fresh command on some databases, using their own migrations. I also have a test for when the database is missing it('returns an error if it cannot migrate to the database', function (): void { config()->set('database.connections.sgr.testing', [ 'driver' => 'sqlite', 'database' => database_path('nonexistent.sqli

troccoli's avatar
troccoli's avatar troccoliTesting
2

Is it possible to make Livewire Update a GET and not a POST?

I am attempting to use litefs (https://fly.io/docs/litefs/) to allow for replication of sqlite databases since sqlite has insane read speeds. Here's the problem: LiteFS looks at the request type to determine if it contains a write, and from what I see, all my livewire requests, regardless of if they make a write go as a post, which LiteFS interprets as a write, and makes a requ

waffleophagus's avatar
waffleophagus's avatar LaryAILivewire
1

Queue Stops Without Exception

Hello Everyone, I am implementing orders export with the help of Laravel queue system. When the user clicks export button, I am dispatching a ExportJob, which retrieves the data from the external API and store it in the database. While I run in my local, the export just runs fine(running with php artisan serve and php artisan queue:work). But while I configure the same thing in

bala_dev's avatar
bala_dev's avatar SnapeyLaravel
2

how to secure NativePhP Desktop App

hi, i built a desktop app using NativePhP and local sqlite database, now im trying to secure the app from steeling , like if a client ask for trial i will only give him some period before the app wont open again . second , how im gonna secure the app in the future to prevent the client copying the app files to another computer and make it working again . if one of you guys impl

kaiserkais's avatar
kaiserkais's avatar jlrdwLaravel
2

Foreign key constraint fails via Eloquent yet works in the database

I'm trying to run an insert query on a SQLite database which results in the following QueryException: Illuminate\Database\QueryException SQLSTATE[23000]: Integrity constraint violation: 19 FOREIGN KEY constraint failed (Connection: sqlite, SQL: insert into "stock_price_movement" ("stock_symbol_id", "price", "updated_at", "created_at

settermjd's avatar
settermjd's avatar settermjdEloquent
2

Fresh Breeze Install Error

I'm wondering if anyone has run into the following error when trying to install a fresh install of Laravel 11 with Breeze + Vue: /PhpstormProjects/myapp/node_modules/vue-tsc/index.js:34 throw err; ^ Search string not found: "/supportedTSExtensions = .*(?=;)/" Steps to reproduce the problem: Command: laravel new Name the project: 'myapp' Starter kit: Laravel Breeze Br

aladin's avatar
aladin's avatar mouse0270Laravel
4

Laravel seeder dont fill table with foreing keys

I'm working on a Laravel project, and I have the following migrations: public function up(): void { Schema::create('customers', function (Blueprint $table) { $table->id('customer_id'); $table->string('first_name', 50); $table->string('last_name', 50); $table->string('address', 100)->nullable(); $table->string('phone'

Anthonyx82's avatar
Anthonyx82's avatar jaseofspad...Laravel
3

SQLSTATE[HY000]: General error: 1 no such table

Hello, When running tests, I'm encountering an error because a specific database table cannot be found. The error seems to occur due to a query in the AppProviderService. How can I ensure that the database is fully set up and accessible during tests to prevent this issue? phpunit.xml <?xml version="1.0" encoding="UTF-8"?> <phpunit xmlns:xsi="ht

alkhatib's avatar
alkhatib's avatar alkhatibLaravel
14

Custom Admin Panel or Nova? Big Inertia project.

I am building out a site about books. Its a 25 year old Public Domain site and we have 2+ million full books. We are building out a bunch of cool features such as a book reader, audio books, wiki, user comments, subscriptions, etc. For my DB I am using Turso.tech and hosting on Vapor. I want to have each user on their own separate SQLite DB and each book on a DB which will mean

ista's avatar
ista's avatar jlrdwNova
2