Can't query json field when testing with sqlite (:inmemory)

Im having issue querying a json field using eloquent when using sqlite for testing. Here is my code: return Project::where('data->name', $name)->firstOrFail(); Error: PDOException: SQLSTATE[HY000]: General error: 1 no such function: json_extract From what I can tell, I have to enable JSON1 for sqlite, but im not sure... Can someone point me in the right direction?

christiangerdes's avatar
christiangerdes's avatar christiang...Testing
2

SQlite NOT throwing exceptions for unknown columns in where clause

A little background: I am building an App on Laravel 5.6.33 (PHP 7.2 with sqlite 3). So i have this weird case where in a test I am expecting an Exception but it never gets thrown. So I went digging and found that Laravel does not throw exceptions for invalid/non existent columns in where clause if the database driver is sqlite. The following code just returns an empty collecti

shxfee's avatar
shxfee's avatar shxfeeEloquent
4

Add automatically "collate nocase" to Sqlite queries

Is there any way for Eloquent to automatically add the COLLATE NOCASE to queries when the connection used is sqlite? I'm having failures in my tests because I use slite in memory for testing and MySql for production and I noticed that sqlite is case sensitive by default for values comparisson.

jago86's avatar
jago86's avatar D9705996Eloquent
1

WEEKDAY() wont work non sqlite database

i want to see all records based on dayofweek. this is my code: $weeks = Book::whereRaw('WEEKDAY(created_at) = WEEKDAY(TODAY())')->get(); its good with mysql database but when i switch to sqlite, it wont accept the WEEKDAY() function. i need sqlite database.. is there any way to compare dayofweek on created_at and day today?

duckz1209's avatar
duckz1209's avatar burlresear...Laravel
3

Laravel connection: sqlite, database: memory leads to could not find driver

I'm running laravel on win10, so I cant really run sudo apt-get install php7.1-sqlite3 as pointed out here: Laravel - Could not find driver exception with sqlite I am trying to run some tests with phpunit and inside one of tests I've done: class ViewConcertListingTest extends TestCase { use DatabaseMigrations; and inside phpunit.xml I've added these two <env name="DB_CO

nikocraft's avatar
nikocraft's avatar nikocraftLaravel
1

sqlite in-memory doesn't seem to be migrating DB before running tests

Laravel Version 5.2. PHP 7.0. I have a system that was setup to use MySQL with transactions for the test suite, but I hate that setup and I'm moving it to sqlite in memory. I have taken the first step of moving to sqlite with the file, and as long as I migrate first and then run the tests everything works fine. So I know the migrations are good. If I change from the file to :me

TorrchDevs's avatar
TorrchDevs's avatar fuzinTesting
3

Statement on SQLite test database returns null while record is available

I'm trying to test a function that tries to fuzzy match a name to a name in the database. Basically: givenName = 'Peter' familyName = 'Pan' match('Peter Joe Pan') should return the record. The query running on a MySQL db would be Person::whereRaw('"' . $name . '" like concat(givenName , "%", familyName)')->first(); When I run my test where I test 'Pet

hepabolu's avatar
hepabolu's avatar hepaboluTesting
2

Sqlite connection errors.

Hi my laravel site is issuing errors on both connection.php and connector.php (see nathanielmcmahon.com) Original developer gone but new ones are telling me the mysql database needs rebuilding as there are no tables. This doesn't make sense to me as all backups of the website from functioning times have the same "no table" database. This led me to believe that the dat

wildtypitch's avatar
wildtypitch's avatar wildtypitc...Laravel
8

Sync sqlite (offline) with mysql (online) database

Hi all, I have a question, I am building an app for a client there is one requirement that is a MUST. And that is to be able to use the app completely offline. The app give the user the ability to fill in a form add some pictures/videos to it and save it (and store it in a sqlite db on the phone). As soon as the phone has a stable internet connection the data has to be pushed t

andreasbakir's avatar
andreasbakir's avatar andreasbak...Laravel
1

Is it possible to store data offline in sqlite and re-sync to the mysql database once the internet is available

I am trying to create an registration form which works both in offline as well as online mode using sqlite and mysql ,your suggestion would be helpful.Thank you.

akshayd121's avatar
akshayd121's avatar doni49Laravel
1

SQLite testing database not migrating properly

I started a fresh Laravel project. I added a new sqlite_testing database connection and use it in the phpunit.xml. I want to use the DatabaseTransactions and DatabaseMigrations traits provided by Laravel in my tests. If I use DatabaseTransactions my database is not migrated and seeded. If I use the DatabaseMigrations, the sqlite database is not used, but my local MySQL db is us

kvalbot's avatar
kvalbot's avatar florenxeTesting
5

Moving from SQLite to MySQL causes error 500

I am making this project for school using Laravel. I started off using SQLite, but the assignment changed and they now want us to use MySQL. After switching from SQLite to MySQL I get an error 500 status page in the browser and the following errors in the NginX output. I am using Laradock. nginx_1 | 2018/05/26 14:25:18 [error] 7#7: *2 FastCGI sent in stderr: &quo

BramVanhoutte's avatar
BramVanhoutte's avatar ejdelmonic...Laravel
1

How to search concatenated fields with MySQL in production and sqlite when testing

Hello I have a real hacky way of trying to get my tests to pass when I'm searching a concatenated field. For example, I store my users as first_name, last_name so when I come to search I would do something like this. ExampleModel::where(DB::raw("concat(first_name, ' ', surname)"), 'LIKE', "%$term%")->get() However, you get an error when testing (when you

bencarter78@hotmail.com's avatar
bencarter78@hotmail.com's avatar bencarter7...Testing
0

SQLite : bigInteger migration becomes integer

I'm trying to make it work my tests on SQLite, but I always the same error : PDOException: SQLSTATE[HY000]: General error: 20 datatype mismatch I looked at the structure in SQLite, and I noticed that all my bigInteger in my migration files are integer in SQLite. On MySQL, everything work, but it's slower. Here are my migration file : public function up() { Schema::c

DimZ's avatar
DimZ's avatar SnapeyTesting
1

sqlite dosent work returns - Database (storage/database.sqlite) does not exist.

Hello there i am trying to use sqlite db because i am working with the laracast series for eloquent. My env file is this: DB_CONNECTION=sqlite DB_DATABASE=/var/www/html/demos/laracast lessons/elequent-series/storage/database.sqlite i tried also with DB_DATABASE=storage/database.sqlite but i still get the same error my database.php file is: 'default' => env('DB_CONNECTION',

bulgaria_mitko's avatar
bulgaria_mitko's avatar rin4ikLaravel
24

Unable to get testing to use a testing database sqlite L5.5

I thought I had this set up cracked but I haven't. It seems no matter what I do I'm unable to get my tests to use an sqlite database to use for tests and instead keeps going to my default mysql database. I think I've done everything as suggested in all the threads and tutorials but absolutely no luck in Laravel 5.5 In my database config I have: 'default' => env('DB_CONNECTIO

longestdrive's avatar
longestdrive's avatar longestdri...Testing
4

Query sqlite database while test is running.

I can't help wondering if this is possible. If I have an xdebug breakpoint in my test, is there any way that I can run up sqlite and check what is happening in the tables? Mick

phpMick's avatar
phpMick's avatar phpMickTesting
4

Setting up SQLite for testing

Hello, I'm trying to set up SQLite for testing. I saw a lot of solutions but none of them worked. So here I'm. This is what I've done : 1- Create the sqlite file sqlite3 database/database.sqlite 2- Set up the env variables in the phpunit.xml file <env name="APP_ENV" value="testing"/> <env name="CACHE_DRIVER" value="array"/> &

Wizix's avatar
Wizix's avatar NashLumen
2

SQLite memory error: "migrations" table already exists?

I've been having some weird errors with phpunit and Laravel Dusk. My first issue was the enviornment variables set in phpunit.xml were not being honored. I am guessing that was b/c of the local .env file. I solved that by using force=true on variables in my XML file. As a side question, is that the correct solution? My real question is on the weird error in the subject line. Du

number6's avatar
number6's avatar number6Testing
3

phpunit really slow with mysql. Tried sqlite. Throws null errors on migration/saving

Completely new to testing. My production db is on MariaDB and locally I'm using MySQL on Homestead. I've written a few very basic tests following tutorials to get started, connecting to a local mysql db. However have noticed that to run these tests it literally takes 45 seconds. I've read that sqlite is a lot faster but is 45 seconds what you would expect for the below tests wi

ralphmorris's avatar
ralphmorris's avatar CronixTesting
2

Laravel 5.3+, JSON column with SQLite

Hello, I red that since laravel 5.3, you can work with JSON columns. I wonder if it works with SQLite with the JSON1 extension that normally bring JSON stuff to SQLite. My objective is to make some database database where statements on json values like that : ->where('meta->favorite_color', 'red') but on a SQLite database with JSON1 extension enabled. Will it works ?

Alex360hd's avatar
Alex360hd's avatar swalkerLaravel
5

After upgrading to 5.5 PHPUnit fails with SQLite

I'm getting this error on my Laravel 5.5 branch. I use SQLite and it works if I switch to my Laravel 5.4 branch. Permissions seem to be reset on the database.sqlite file if I set it to 777 so I don't think that's it (having looked around). SQLSTATE[HY000]: General error: 8 attempt to write a readonly database PHPUnit gets updated since 5.5 comes with "phpunit/phpunit"

bashy's avatar
bashy's avatar bashyTesting
4

More Elegant Approach to Testing when SQLIte Squirms?

SQLite doesn't have a MONTH function. I'm testing my app using SQLite in memory (for the speed gains), but the following approach is really stupid in that I have bypassed the code I want to test. Please share your ideas on how better to handle this type of scenario. Thanks in advance. if (app()->environment() == 'testing') { // sqlite return $query->

Richierob62's avatar
Richierob62's avatar Richierob6...Testing
0

sqlite error when running phpunit in laravel after reinstalling MAMP on windows

I am working on a project for a while and I was working with in memmory sqlite and everything was working fine but recently I reinstalled MAMP and now I am getting the below error when I run phpunit lluminate\Database\QueryException: could not find driver (SQL: select * from sqlite_master where type = 'table' and name = migrations) I checked that I have the below dll's already

dhaval120386's avatar
dhaval120386's avatar dhaval1203...Laravel
0

Unit testing with sqlite and multiple databases

Hi, My system uses 2 databases and my connection. I'm using sqlite in memory for testing 'sqlite_testing' => [ 'driver' => 'sqlite', 'database' => ':memory:', 'prefix' => '', ], so I have a bunch of tables in db1 and the rest table in db2. When I run phpunit, the encounter an error when fetching from tables in db2. I am currently trying to test my code and I kee

stevenson.cunanan@gmail.com's avatar
stevenson.cunanan@gmail.com's avatar lionslairTesting
2

How do you test query to Json columns using sqlite?

Hey folks, I came across an issue testing my queries using SQLite. I need to perform query similar to Product::whereRaw('features->"$.color"', 'red')->first(); This trows sintax error, but works with MySQL Also, I tried the laravel docs way, like so: Product::where('features->color', 'red')->first() but I get null as the result but works with MySQL Th

gocanto's avatar
gocanto's avatar bobbybouwm...Laravel
2

sqlite: "could not find driver"

Cannot get sqlite work on live server, it works fine on local server. Here's my .env variables: DB_CONNECTION=sqlite DB_DATABASE=/var/www/html/example.com/public_html/database/database.sqlite

dmag's avatar
dmag's avatar aj-phpLaravel
3

Laravel unit testing with sqlite database

Hello, I've followed this video: https://laracasts.com/series/lets-build-a-forum-with-laravel/episodes/2 To setup a sqlite database connection for my unit tests. But it keeps failing when I'm running the tests. Error: "No such column email" I've removed the email column from a database table with doctrine, think that's the issue. (it works when I set the db_connection

mevlutozdemir's avatar
mevlutozdemir's avatar Organizm23...Testing
1

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'stories' already exist for sqlite in memory test phpunit

I am using sqlite for my phpunit testing (in memory), it was all working well untill recently i started receiving this error "SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'stories' already exist"

mazinoukah's avatar
mazinoukah's avatar aurawindsu...Testing
1

Comparing two withCount results - different outcomes for Sqlite and MySQL

Hey there, I've been developing a project using Sqlite for the beginning phase, and then switched to mysql, and now one of my main queries doesn't work and throws Column not found: 1054 Unknown column 'matching_count' in 'where clause'... Here's my query scope: public function scopeMatching($query, $options) { return $query->whereHas('combinations', function ($c)

maslauskast's avatar
maslauskast's avatar maslauskas...Eloquent
1

SQLite Encryption / SQLCipher

Hey all! I'm developing a Laravel project requiring to secure stored data. Upon analyzing the solutions, and failing to find decent enough way of MySQL keys management, I've decided to go with SQLite, or to be exact, with sqlcipher. There are library to facilitate it: https://github.com/abbat/pdo_sqlcipher https://github.com/sqlcipher/sqlcipher The problem is I'm not quite sure

sousstudio's avatar
sousstudio's avatar sousstudioLaravel
2

Unit Testing my app's local REST API calls, but using the testing sqlite DB ...

Hi all, I'm building unit tests for my API service, using a sqlite in-memory database - this has worked well for in-application method and DB testing. However, I do need to test my API over HTTP. When I call a $this->getJson in my Unit Test class, the request is being handled outside of the test environment, e.g. no longer on the test database (since I assume Laravel can't p

stuart@yonder.co.za's avatar
stuart@yonder.co.za's avatar tim_jesper...Laravel
1

sqlite in-memory db gets "could not find driver" error

New Laravel 5.4 install; tried configuring phpunit to use in-memory sqlite db as such <env name="APP_ENV" value="testing"/> <env name="DB_CONNECTION" value="sqlite"/> <env name="DB_DATABASE" value=":memory:"/> running vendor/bin/phpunit fails with: 1) Tests\Feature\ThreadsTest

dipasquo's avatar
dipasquo's avatar dipasquoTesting
3

Laravel 5.4, Windows 10, Sqlite database locked

Hi, I'm facing a pb with my sqlite database : SQLSTATE[HY000]: General error: 5 database is locked (SQL: update "users" set "remember_token" = aeb4E7qmFKhOXl33TNLbCPFDwX2a2oha1NJEP7WIgMGAYKvrsqNNY36jrfT5, "updated_at" = 2017-04-12 22:19:08 where "id" = 1) Some information: Laravel 5.4 Windows 10 Vagrant 1.9.1 (box laravel/homestead v. 2.1

christophe.kiffel's avatar
christophe.kiffel's avatar JonjieLaravel
4

Non-existent columns in sqlite

I was re-factoring some code and all my tests against sqlite were passing - 'oh good!'... I thought. Then ran the code against mysql and it blew up. Turns out in sqlite if you do : select non-existing-column from table; It gives an error, but if you do : select "non-existing-column" from table; It doesn't. Which is... interesting ;-). In my case it was an 'orderby

ohffs's avatar
ohffs's avatar ohffsTesting
0

QueryException in Connection.php while using sqlite

Hey guys, This is my first time using Laravel and I'm trying to do a fairly simple tutorial to familiarize myself with it. https://auth0.com/blog/creating-your-first-laravel-app-and-adding-authentication/ I've made a number of changes to get things to work with the latest version of laravel and with my local environment. I'm using sqlite instead of mysql and seem to be having s

sdk99's avatar
sdk99's avatar sdk99Laravel
2

JSON Column types with Sqlite

Has anyone successfully loaded the Sqlite extension JSON1 when using Sqlite as their configured database? I'm interested now that Laravel 5.4 supports querying JSON column types. It makes sense for MySQL 5.7 and Postgres, but I was curious to other possibilities. https://www.sqlite.org/json1.html

mcylinder's avatar
mcylinder's avatar Alex360hdLaravel
4

Set up Laravel 5.4 with Dusk using phpunit.xml, .env.dusk.local, and an sqlite in-memory database

The title says it all. I would like to know how to properly set up a new Laravel 5.4 project with Dusk, using an in-memory SQLite database. I can run the tests, but I get an error: "No such table: users" I have created a new Laravel 5.4 project Installed Dusk I can run the tests, and the first one works (navigating to the /login route) but the second where it tried t

mstnorris's avatar
mstnorris's avatar smartgateTesting
22

Cant use sqlite databases - Identifier name is too long

Hi there, for testing purposes I would like to use sqlite. But when migrating I get: SQLSTATE[HY000] [1059] Identifier name '/Users/myusername/Code/laravel-app/database/testing/account.sqlite' is too long (SQL: create table `migrations` (`id` int unsigned not null auto_increment primary key, `migration` varchar(255) not null, `batch` int not null) default chara cter set ut

Jantlap's avatar
Jantlap's avatar ecomailGuides
1

Not able to run test through SQLite.

I'm not able to run tests through SQLite, Running: phpunit -c phpunit.xml I did manage to change: <phpunit backupGlobals="false" backupStaticAttributes="false" bootstrap="bootstrap/autoload.php" colors="true" convertErrorsToExceptions="true" convertNoticesToExceptions="true&qu

Rafał's avatar
Rafał's avatar ejdelmonic...Testing
6

When is SQLITE too small?

Using SQLITE with Laravel is such a great, self contained solution for a micro-site. I wanted to get a general opinion, though, regarding switching to MYSQL. If I'm doing a project where all rows of all tables totaled no more than 200, it seems fine. Using that as a metric, when would it be better to use MYSQL? 500+? 1500+? PHP memory limit is a factor?

mcylinder's avatar
mcylinder's avatar clayLaravel
1

Laravel 5.3 Integration test error when using sqlite, works fine using mysql

Hi, i'm trying to learn testing using diferent database, when i'm running phpunit and DB_CONNECTION set to mysql everyting works fine, but when i'm change the DB_CONNECTION to sqlite several test got an error authorization like this, Caused by Illuminate\Auth\Access\AuthorizationException: This action is unauthorized. in /home/vagrant/Sites/laravel/l53_todo_tdd/vendor/laravel/f

imansyaefulloh's avatar
imansyaefulloh's avatar imansyaefu...Testing
2

how to change laravel auth database to sqlite

hi i have to two database in project so some times i want you mysql for my user auth ,sometimes use sqlite but i cant change in controllers please help me

alirezavalipour93's avatar
alirezavalipour93's avatar spekkionuEloquent
1

Sqlite load extension

How can we load external extension in Sqlite 3.x? @jeff_way

newroseji's avatar
newroseji's avatar Tschallack...Laravel
4

Sqlite database Not Exists

InvalidArgumentException in SQLiteConnector.php line 34: Database (database\database.sqlite) does not exist. wheather i create a sqlite database in database directory how i configure it resolve my problem.??

ankitsoni's avatar
ankitsoni's avatar ankitsoniLaravel
4

Testing CONCAT queries with SQLite

Hi I am testing my application and have set it up to use a sqlite in-memory database. How would you go about testing the following knowing that the CONCAT doesn't work in sqlite (it's || instead)? Is there a way round this? <?php namespace App\Repositories; use App\Models\Contact; class Contacts extends EloquentRepository { protected $model; function __construct(

bencarter78@hotmail.com's avatar
bencarter78@hotmail.com's avatar codegreenTesting
4

Error when deploying to Heroku w. SQLite

Hi, I am trying to deploy to heroku with sqlite. The error I get is: InvalidArgumentException in SQLiteConnector.php line 34: Database (database.sqlite) does not exist. I did remove *.sqlite from the .gitignore and pushed it. But I do not know what to try next, and I was unable to find any further info on Herok or Stackoverflow. I was also able to go into Heroku settings and

Krad's avatar
Krad's avatar Alexander...Code Review
4

Sqlite for testing

Hey Folks. I have a lumen app setup with eloquent with the the norm mysql database settings. But of course for testing I don't want to use mysql but sqlite. Within phpunit.xml I added the DB_DRIVER as sqlite and a whole load of other options but I cannot get a test to run with 'DatabaseMigrations' Example phpuntit <php> <env name="APP_ENV" value=

oes's avatar
oes's avatar tykus_ikusLumen
1

Migrate SQLite to MySQL

Hello, i'm trying to migrate an existing SQLite to MySQL but it throws the following error: [Doctrine\DBAL\DBALException] Unknown database type requested, Doctrine\DBAL\Platforms\SqlitePlatform may not support it. Also the SQLite contains some Views v_xxx and Indexes "idx_xxx" which can not be migrated. Do you have any idea how to deal with this? I'm using the followi

Rocky's avatar
Rocky's avatar RockyLaravel
1

SQLite On Windows/Homestead

I have installed laravel using homestead. So far, everything has worked fine until I've come to the point where I've tried to use sqlite. In particular, I am working on this lesson and get the following error message when I run php artisan migrate: [PDOException] could not find driver ...iles (x86)\Cmder/vendor/clink-completions/npm_prompt.lua:11: attempt to concatenate

moshemo's avatar
moshemo's avatar moshemoLaravel
5