Eloquent - Retrieve model records where count of records matches attribute/column of parent model?

Eloquent - How to get model records where the count of that model for a parent model matches a column of that parent model instead of a PHP value? Pseudo: select * from answers where the count of answers on the answer's question is equal to the question's max_answers attribute? Hello everyone, I've been scratching my head at this one for a while and can't seem to come up with a

stevenfox's avatar
stevenfox's avatar CorvSEloquent
3

Call to a member function connection() on null at Laravel unit testing

I used the DatabaseMigrations trait at feature tests and It was fine but at unit test, it gives me an error that the connection to sqlite can not be resloved <?php namespace Tests\Unit; use App\Models\Thread; use App\Models\User; use Illuminate\Foundation\Testing\DatabaseMigrations; use PHPUnit\Framework\TestCase; class ThreadTest extends TestCase { use DatabaseMigrat

sajadsholi's avatar
sajadsholi's avatar JonjieLaravel
4

How to setup environment for testing for laravel using .env.testing

I am trying to run some basic testing on my laravel app. What I have done so far: cp .env .env.testing my .env.testing looks like : APP_NAME=Laravel APP_ENV=local APP_KEY=base64:WSkPBl1NrEIjoOjV32QQocm/Bxaq+wU9cm959+cabcmM= APP_DEBUG=true APP_URL=http://laracms.test LOG_CHANNEL=stack LOG_LEVEL=debug DB_CONNECTION=sqlite DB_DATABASE="var/www/laracms/database/laracms.sqli

ssquare's avatar
ssquare's avatar tykusTesting
1

Offline App service

I'll be building a very simple data collection system, the collection part will be running on some kind of small tablet, not determined yet probably an Android. My concern is that in some sites, where this collection is going to take place, it may not be internet connection, because is inside a warehouse with metal walls. Is anyone dealt with such scenario before? I was thinkin

dan3460's avatar
dan3460's avatar martinbeanGeneral
3

Problems setting up automatic tests for Laravel

Hey! I've been trying to set up automatic tests for Laravel for a while now but nothing seems to work. I wasn't able to find anything useful in the documentation, and for some reason any testing presets don't work for me. Basically - Unit tests run fine, except for the ones using a database, and no feature tests run for me - always getting a 500. In case of Feature tests I was

ame180's avatar
ame180's avatar jacynoadamTesting
1

Address in mailbox given [] does not comply with RFC 2822, 3.6.2.

This is regarding Laravel backup plugin of spatie https://spatie.be/docs/laravel-backup/v6/installation-and-setup if backup fail, system should send email to user. Please note: I test this in localhost environment. also i m using WAMP server for this . When i run php artisan backup:run command , it gives the following error Starting backup... Backup failed because: Cannot cre

DDSameera's avatar
DDSameera's avatar DDSameeraLaravel
1

Uncaught Error: The SQLite3 object has not been correctly initialised or is already closed

I'm using SQLite to create an API with PHP 8 but I have this error Uncaught Error: The SQLite3 object has not been correctly initialised or is already closed here is the db.php <?php class SQLiteDB extends SQLite3 { function __construct() { // $this->open('../db/development_db.sqlite3'); } } $db = new SQLiteDB('sqlite:../db/development_db.sqlite3'); if(!$db){

jet's avatar
jet's avatar jetGeneral
0

Github Action failed: Test directory not found

My Github action is failing due to the file path. Any ideas? I'm using the almost default action there for Laravel: name: Laravel on: push: branches: [ dev, master ] pull_request: branches: [ dev, master ] jobs: laravel-tests: runs-on: ubuntu-latest steps: - uses: actions/checkout@v2 - name: Setup PHP uses: shivammathur/setup-php@v2

EmilMoe's avatar
EmilMoe's avatar BinotaLIUTesting
9

[L8] Help with "NOT NULL constraint failed: failed_jobs.uuid"

I get this error when jobs fail, I have not modified the table or the migration. It's a fresh queue:failed-table table. I don't understand what the problem is and I cannot find any results on this issue. The closest was someone modifing the ID column, which I have not. If you need to see some code, let me know what I should post as I'm not sure, it's just the failed jobs that..

jove's avatar
jove's avatar joveCode Review
2

created_at hours displaying wrong

I have a model with sessions belonging to a user. In the Session model i've added: protected $casts = [ 'items' => 'array', 'created_at' => 'datetime:Y-m-d H:i:s', ]; when I print out the session.created_at it returns the wrong hour. My initial idea was that this must be a timezone issue, so I set 'timezone' => 'Asia/Singapore', in app.php and cleared the caches

m4rinos's avatar
m4rinos's avatar Rida Makhc...Laravel
15

query using recursive CTE

I have the following tables Category - id - parent_id - title Threads - id - category_id - title A category have sub-categories and only the "leaf" category can have threads To explain further with an example Computer -> Mac -> macbook In this case the category macbook can have threads while the parent categories can't have threads. What i want to achieve is

orest's avatar
orest's avatar orestCode Review
2

[Sail] MySQL test database

Hi. I'm using Laravel Sail, I've read docs section and I'm curious how to create MySQL database container to feature testing. Default phpunit.xml with SQLite works fine, but I want to use the same database as in dev and production. <?xml version="1.0" encoding="UTF-8"?> <phpunit xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

pmieleszkiewicz's avatar
pmieleszkiewicz's avatar tisuchiLaravel
1

Github actions error.

name: build on: push: branches: main jobs: test-php: name: Build runs-on: ubuntu-latest steps: - name: Checkout code uses: actions/checkout@v2 - name: Copy .env run: php -r "file_exists('.env') || copy('.env.ci', '.env');" - name: Install Dependencies run: composer install -q --no-ansi --no-interaction --

somenet77's avatar
somenet77's avatar ms1987Testing
9

set env variable in phpunit at runtime

by default the database variables in the phpunit.xml are the following: <server name="DB_CONNECTION" value="sqlite"/> <server name="DB_DATABASE" value=":memory:"/> In one of my tests, i want to set the DB_CONNECTION to mysql because i test a functionality which uses whereJsonContains which is not supported by sqlite. Is th

orest's avatar
orest's avatar slev1nCode Review
2

Laravel migration MySQL fail error 150

Hey, so I am moving my project into production on a normal server but I ran into some issues with migration. I don't have this problem when I am using sqlite for localhost and testing, but for some reason MySQL won't let me migrate my database structure: In Connection.php line 669: SQLSTATE[HY000]: General error: 1005 Can't create table `laravel`.`roles_permissions` (errno:

iKyzu's avatar
iKyzu's avatar iKyzuLaravel
4

Eloquent subquery ordering different database connections?

I have two models with different database connections. --- class Foo extends Model { $connection = 'sqlite'; $table = 'foos'; public function bar() { $this->belongsTo(Bar::class); } } class Bar extends Model { $connection = 'mysql'; $table = 'bars'; public function foos() { $this->hasMany(Foo::class); } } The basic relationship works just fine, for ex

rifki's avatar
rifki's avatar rifkiEloquent
2

DB Session Error Message

I deployed my application on production server. now i can see this error Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from `sessions` where `id` = QlK0M3El8UsvfKZGKqfCn2Eh7QGVpqbLViDiAl1s limit 1) https://xxxxx.com/login all of db credentials are correct . don't know the reason. env file ... APP_NAME=Laravel APP_ENV=local APP_KEY=

DDSameera's avatar
DDSameera's avatar DDSameeraLaravel
2

Laravel 8 - Testing a Package: record not found in db after queue has altered it

In my test, I post a fake image that is saved on a fake disk. This works the tested controller save a record and dispatch a job Queue::assertPushed(UnpackUploadedFile::class, 1); This test passes, I've a job dispatched The job's handle() method alters the row just created, using update $this->batch_upload->update([ 'mime_type' => $mime,

realtebo's avatar
realtebo's avatar realteboLaravel
3

Use already existing database in eloquent

Hi, I have a SQLite database on which I need to build reports, ... I try to use DB('mySQLiteDB')->select('SELECT * FROM table1')->paginate(5); I do that to create readable Web pages. Problem, it seems, it requires the database to be defined in Eloquent. I just passed 4 hours on Google to try to discover something easy to understand (Eloquent for dummies) but .. nothing is

DominiqueGEORGES's avatar
DominiqueGEORGES's avatar DominiqueG...Eloquent
13

Can anyone explain Atomic Locks ?

I want to learn more about Atomic Locks: https://laravel.com/docs/8.x/cache#atomic-locks, the laravel doc is not clear for me, i will explain why, Let say 100 requests hits my controller within one hour, but i want to only dispatch 1 job for all them So i did this: public function update($product) { $product->update(...); $lock = Cache::lock('productsIndex', 3600);

untymage's avatar
untymage's avatar Ayman Alha...Laravel
12

Changing Test Database and Deleting My Local THREE times

Given that I have accidentally deleted and had to restore my local database three times in the last 2 hours, I am reaching out for help. I have been using sqlite in :memory: for testing but I am starting to use some features not available in sqlite so I want to test on a mysql ddb. [1] I created a new database called atc_phpunit (atc is the prod database) [2] I modified my phpu

jgravois's avatar
jgravois's avatar jgravoisTesting
10

Testing Two Factor Authenticaition

When I using the voyager with laravel 8, it produces the message BadMethodCallException: SQLite doesn't support dropping foreign keys (you would need to re-create the table).

shaungbhone's avatar
shaungbhone's avatar Hoff29Testing
2

Laravel backend with offline first app

Hey wanted to ask I am using MySQL as my DB and I plan to have a teammate to develop the mobile app. The mobile app is offline first. I just wanted to know from my end other than having the api controllers and writing all the requests in postman, should I use a different DB. I read that couchdb and pouchdb are good just haven’t seen updated repositories or use cases. Should I c

devionti's avatar
devionti's avatar martinbeanLaravel
1

Unable to test BelongsToMany relationships

I'm working with a ProfileFactory that randomly attaches BelongsToMany relationships which works great when seeding the database. It also works fine when running the factory in tinker $profile = factory(\App\Profile::class)->create(); $profile->spokenLanguages; This will neatly print out all the randomly attached spokenLanguages. However, whenever I run the factory in my

Zhen's avatar
Zhen's avatar ZhenTesting
1

Debug PHPUnit tests that only fail occasionally based on factory data

Hi there, I'm working with a financial application that basically accepts inputs from a user, does some calculations, and spits back "scenarios", think financial planning. There's a few options the user can set that change how the calculations work, but at the end of the day, there's an inherent amount of flexibility in the amount of data that is processed. As I've st

bt3's avatar
bt3's avatar bt3Testing
2

Laravel 8: phpunit giving error on test

Since today, when running phpunit tests, I get: Illuminate\Contracts\Container\BindingResolutionException: Target class [DatabaseSeeder] does not exist. That class is there under the database/seeds directory. I don't know if this is related, but I recently upgraded to Laravel 8 and also used the new schema dump features and pruned all migrations. PHPunit is using an in-memory s

EckyEckyPtang's avatar
EckyEckyPtang's avatar 4unkurTesting
10

Laravel and Flutter App Authentication

Im building a Flutter app that will allow users to register and login. I want to authorise that registration in the Laravel back end and once the registration is authorised allow sign in on the device when there is a connection or no connection. The device will be used in areas with no wifi or mobile data signal. I still want to allow sign in and the data they collect will be

finchy70's avatar
finchy70's avatar finchy70Code Review
3

PDOException: could not find driver

Hi! I am using Laravel with Laragon on windows 10, php 7.4, everything is working fine except when I run phpunit --filter it_fetches_a_feed_for_any_user Then I get Illuminate\Database\QueryException: could not find driver (SQL: PRAGMA writable_schema = 1;) If I look down on the error message printed I also see Caused by PDOException: could not find driver Any Assistance wil

DavMaxwel's avatar
DavMaxwel's avatar SinnbeckLaravel
7

Are you using TNTSearch and what is your experience with it, alternative for Laravel Scout

I am trying TNTSearch and I was able to make it works, but I am a bit concerned regarding it cause some issues reported but seem never fixed, or also regarding the limit of sqlite database that is being locked down during write. I would like to know your experience with it, and if there are better alternative for Laravel Scout without paid service like Algolia or Elasticsearch.

thewebartisan7's avatar
thewebartisan7's avatar thewebarti...General
0

A lot of composer suggetsions after `laravel new ..` for 8

voku/portable-ascii suggests installing ext-intl (Use Intl for transliterator_transliterate() support) symfony/var-dumper suggests installing ext-intl (To show region name in time zone dump) symfony/routing suggests installing symfony/config (For using the all-in-one router or any loader) symfony/routing suggests installing symfony/yaml (For using the YAML loader) symfony/routi

untymage's avatar
untymage's avatar bobbybouwm...Laravel
1

Approach for testing a multi-tenant app.

Hello artisans, hope you are all doing well. I am building a multi-tenant app and I am using the spatie/laravel-multitenancy package with single-domain / multiple db. Everything is working great but I'd like to create some tests along the way and I hit a wall. For instance, I want to test my signup process which goes like this : User submit the signup form I create the Tenant

rachids's avatar
rachids's avatar kei_mxTesting
3

Dusk: Very weird behavior between running locally and in homestead

Okay, so I came across this very weird behavior. I run my computer on an ubuntu 18.04 client and I hope I can to a certain extent set permissions correctly. Also, I run Laravel in Homestead. Here is my .env.dusk.local file: APP_NAME=Laravel APP_ENV=local APP_KEY=mykey APP_DEBUG=true APP_URL=https://laravel.test APP_LANG=en DB_CONNECTION=testing_browser and the respective DB_CO

rezafm's avatar
rezafm's avatar rezafmTesting
2

DB issues when testing

Hello, I'm working on a project and for strange reasons testing give me troubles. On my current branch all works fine, but when I switch on another one tests are not working anymore, it resets completely my database which make me think that tests are not run in memory. This is my phpunit config : <server name="BCRYPT_ROUNDS" value="4"/>

jeFFF's avatar
jeFFF's avatar SinnbeckTesting
5

Telescope receiving empty responses even though there are records in the database that it should show

Telescope doesn't display any records from the telescope_entries table, but instead it only shows this: If we take a look into the browser console, we will see that Telescope frequently sends POST requests to its API, but receives an empty array of entries: I am sure that there are records in the database, because I can see them using my database viewer: Also when I run DB::

RCRalph's avatar
RCRalph's avatar RCRalphCode Review
1

How to drop database name in Eloquent Model Query?

Hey all, I am cant get my eloquent queries to work with in memory sqlite unit tests, how can I drop the db name from all model queries? For Example Item::whereId(1)->toSql() returns "select * from ":memory:"."items" where "id" = ?" I want to drop the ":memory:". part because it breaks the query. DB::table('items')->whereId

xgrave's avatar
xgrave's avatar xgraveEloquent
2

Issue with SQL while running test (Build a Laravel App with TDD course)

Hi, Yesterday i started this course and ran into problem immediately after 2nd lesson. I tried to copy everything from that lesson but it won't work. I have "SQLState Unknown column" issue and i was not able to find proper solution online. This is the error when i try to run the test. SQLSTATE[42S22]: Column not found: 1054 Unknown column '0' in 'field list' (SQL: ins

Sajjad Ali's avatar
Sajjad Ali's avatar KeyTesting
2

Can I specify a database connection for an individual unit test?

My test suite currently has 67 tests and 167 assertions. If I run the tests in a SQLite memory database, the tests run in less than 20 seconds. If I run them in MySQL, they take a lot longer, so I'd prefer to run all the tests that I can using the SQLite memory database. However, I have a table that contains spatial data, and SQLite doesn't support spatial data. I want to run t

Benjamest's avatar
Benjamest's avatar erikwestlu...Testing
6

Drop foreign

Hi! I'm working on the tests on a project with sqlite as default, but someone in the team added a dropforeign and it broke everything. There's an answer that suggests to use something like (DB::getDriverName() !== 'sqlite') ?: $table->dropForeign(['xxx']); But getdrivername is non existant in the facade, and the closest i found is getdefaultconnection (DB::getDefaultConnecti

Chizpon's avatar
Chizpon's avatar ChizponTesting
5

Unit testing and the database

I'm looking for advice regarding unit testing and the database. I know testing best practice is a very opinionated topic which different developer communities disagree on, but I wanted to know if the Laravel community has a preferred approach to unit testing. My Laravel app is dependent on Eloquent and there are references to Eloquent persistence methods and model relations eve

pauladams8's avatar
pauladams8's avatar bobbybouwm...Testing
1

Random Dusk failures, caching issue?

Hello, I am using Laravel 6.18.14 and I'm currently facing big issues with Dusk. Sometimes the tests are not running at all, sometimes it helps to do php artisan config:clear php artisan cache:clear I cannot really find a pattern in it, sometimes it works, sometimes not. I am using a Sqlite database in the database directory, the .env.dusk.local points to it and is copied befo

xBnLEg6Fo's avatar
xBnLEg6Fo's avatar mtbossaTesting
10

[SERVER/PHP] Is it safe to change config variables at runtime?

For example, i have many database files on my server, they are the same the only thing that changes is the language, so i want to put a option to user choose the language and so i change de config of my config/database.php in 'connections' => [ 'sqlite' => 'database' .... to the path of the database that correspond to the language the user choose, but, i do it on my c

JoaoHamerski's avatar
JoaoHamerski's avatar JoaoHamers...General
3

Laravel 5.4 DatabaseMigrations issue

While running tests using in-memory sqlite, i'm getting a "no such column" error while using this code: class myCoolTest extends TestCase { use DatabaseMigrations; protected $user; public function setUp() { parent::setUp(); #$this->artisan('migrate'); <-- if I uncomment this and comment DatabasseMigrations trait, everything works $this->user = f

LiorBroshi's avatar
LiorBroshi's avatar LiorBroshiLaravel
0

CSRF token mismatch. ($this->withoutExceptionHandling() not doing its job)

Hey there, The test suite passes sometimes but not others. I'm at a loss as to why this occurs randomly. Using sqlite, :memory: local env. /** @test * * @throws Illuminate\Session\TokenMismatchException */ public function registering_with_a_valid_invitation_code() { $this->withoutExceptionHandling(); // dd(env('APP_ENV')); $shell

trevorpan's avatar
trevorpan's avatar trevorpanTesting
3

Configuring PHPUnit to connect with a test DB

Here's what I'd like to do.. have a test DB in MySQL (backend_apis_laravel_testing) that gets used for all PhpUnit tests. I do not want to use Sqlite (because I don't know how to view the database and tables in sqlite) clear any cache (if needed) before PHPUnit runs migrate the DB (and seeds) before PHPUnit runs, and cleanup after ignore all settings in phpunit.xml, and only u

connecteev's avatar
connecteev's avatar connecteevTesting
6

Database connection [testing.sqlite] not configured.

https://laracasts.com/discuss/channels/testing/database-does-not-exist-when-trying-to-use-mysql-for-phpunit-tests https://medium.com/@james_fairhurst/issues-i-ran-into-when-testing-in-laravel-5-with-sqlite-7ef79de29a94 I've spent the last few hours trying to setup a sqlite database. What is the order of php artisan dusk reading the env.dusk.local phpunit.dusk.xml database.php

trevorpan's avatar
trevorpan's avatar trevorpanTesting
1

php artisan migrate error

I have Laravel installed on a VPS. I connecting to it with my computer via SSH. The "php artisan migrate" command returns this error: Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: create table `migrations` (`id` int unsigned not null auto_increment primary key, `migration` varchar(255) not null, `batch` int not null) default ch

exactspace's avatar
exactspace's avatar Tray2General
10

Boolean type casts

I have a unit test that is failing due to the boolean column on a table apparently not being cast properly. The schema I defined is as so: Schema::create('entries', function (Blueprint $table) { ... $table->boolean('is_archived')->default(false); ... }); And an eloquent model that contains the following cast: protected $casts = [ 'is_archived' => 'bool

viglucci's avatar
viglucci's avatar viglucciEloquent
1

Handling blobs from the database as streams

I'm wondering if Laravel query builder or eloquent supports this or not. I am copying some very large blobs from an SQLite database to a MySQL database. The BLOBs need some conversion in PHP, and the thrown into MySQL as a geometry object. At the moment I select the source BLOB - that's a chunk of memory. Then I convert teh BLOB (by taking off a wrapper layer it has) to another

jjudge's avatar
jjudge's avatar consilEloquent
8

How to set up the database sql server on laravel?

i tried to connect database from my apps to sql server and it seems my configurations was right database config return [ /* |-------------------------------------------------------------------------- | PDO Fetch Style |-------------------------------------------------------------------------- | | By default, database results will be returned as instanc

rickyreza12's avatar
rickyreza12's avatar Hissein_To...Laravel
8

SMTP port25

Hi guys, I am using mailgun services to test mails. Right now I am using port 587 and it is working fine, instead of in need port 25. I am using SQLite for my database and I am pulling the port details from a database instead of .env. Can anyone help me with this? thank you.

Sandeepvemuri's avatar
Sandeepvemuri's avatar flightsimm...General
1