PHPUnit MySQL in memory test with point and polygon column

I have a migration for a table as following: use Illuminate\Support\Facades\Schema; use Grimzy\LaravelMysqlSpatial\Schema\Blueprint; //use this as blueprint use Illuminate\Database\Migrations\Migration; Schema::create('properties', function (Blueprint $table) { $table->increments('id'); $table->string('name'); $table->point('position'); $t

PoncetheLion's avatar
PoncetheLion's avatar gourabCode Review
9

Unit Test "deep" relational data

Dear community, In Laravel it is very normal to get data from related objects like $customer->wallet->balance. What is the best approach in testing the value of the customers' current balance? Sometimes this even goes a layer deeper. Thanks!

meijdenmedia's avatar
meijdenmedia's avatar meijdenmed...Testing
3

Test Database with multiple Databases

I have created an .env.testing with the following data: DB_CONNECTION=sqlite DB_DATABASE=database/test.sqlite So everytime I ran phpunit it put the data in the test.sqlite file. However, I now need to use two development databases, so I added these lines to my Models. class ExampleModelOne { protected $connection = 'mysql'; ... } class ExampleModelTwo { protected

Ben94's avatar
Ben94's avatar shez1983Testing
1

seeding works in command line but not in phpunit test file

I run database seeding using php artisan db:seed everything works fine; but if I put $this->seed('DatabaseSeeder'); in the TestCase.php set up class after refresh database, I ran into issues: foreign key constraint.... this is my TestCase.php file: <?php namespace Tests; use Illuminate\Foundation\Testing\TestCase as BaseTestCase; use Illuminate\Foundation\Testing\Refres

lishaliu's avatar
lishaliu's avatar Kel_Testing
3

Swap class when running test?

In my Laravel 5.7 I want to 'fake' an API endpoint of a service we use. I've created a 'Fake class' which acts as the API. In my models I whip up a new connection to the external API like this: $connection = (new TicketAPI)->bookings($attributes); This works, like a charm. Now, I want to replace, or 'swap' the TicketAPI::class when I'm running tests. So, I thought I could u

JorickL's avatar
JorickL's avatar TalinonTesting
7

How to have JSON_NUMERIC_CHECK applied on test response?

If I take an object and assert a JSON response has it using $response->assertJsonFragment($new_labor->toArray()); then it fails with float/decimal numbers because 16.5 is not "16.50". I can get around this manually simply by decoding the response and looping through the keys, but is there a built-in way to handle this that I've missed? Maybe something I can set

PatrickSJ's avatar
PatrickSJ's avatar PatrickSJTesting
1

Custom service provider gives Purify errors in PHPUnit test

Hi guys, This is a weird one. I'm trying to add some extra allowable HTML elements to Steve Baumans' Purify. It takes a custom ServiceProvider, seeing as the element (anchor target) isn't 'officially' allowed. Now, don't get me wrong, it works. Perfectly. When showing database-content, the anchor target attribute is shown. But when I run my tests, half of them fail with the fol

Thyrosis's avatar
Thyrosis's avatar ThyrosisTesting
11

Adding Factory to test POST

How can I refactor the below $attributes = [ 'sector' => 'CARGO', 'name' => strToUpper($this->faker->word) . ' AIRWAYS', 'icao' => 'ABC', 'iata' => 'AB', ]; $response = $this->actingAs($admin)->post('/admin/airline', $attributes) To the following $response = $this->actingAs($admin)->post('/a

NoTimeForCaution's avatar
NoTimeForCaution's avatar DawgOnKingTesting
7

How test forked laravel package?

For example for this package laravel-paginateroute. When I clone to local machine a run phpunit from console. I got some errors. Problem is becouse this return NULL.

MichalOravec's avatar
MichalOravec's avatar MichalOrav...Testing
2

Laraval Passport Authentication Test

Hello I am using Laravel Passport for my API authentication. Now, there are some endpoints those are required to be authenticated to access. However, once I use- Passport::actingAs( factory(User::class)->create() ); It show's me Expected status code 200 but received 403. that means redirect to other page. It's clearly shows that, it doesn't authenticate

hasandev's avatar
hasandev's avatar hasandevTesting
0

ReflectionException: Class request does not exist running unit test

I'm getting a Class request does not exist ReflectionException running phpunit. I've run composer dump and php artisan clear:compiled. Laravel 5.7. <?php declare(strict_types=1); namespace Tests\Unit; use DemoSite\Data\Authors\Author; use DemoSite\Data\Authors\AuthorRepository; use Tests\TestCase; use Illuminate\Foundation\Testing\DatabaseMigrations; use Illuminate\Foundat

Kirk.Franklin's avatar
Kirk.Franklin's avatar Kirk.Frank...Testing
3

Basic Split Test Without DB Access

Hi; I want to send half of the traffic to Yahoo and have to Google. 1 - Is this way of redirecting correct? 2 - Anyways to make the distribution 100% accurate? Thanks $rand=rand(1,2); $url = "https://yahoo.com"; if($rand==1) { $url = "https://google.com"; } header('Location: '.$url);

behnampmdg3's avatar
behnampmdg3's avatar douglasaku...General
4

Using cretueusebiu/valet-windows can't connect to .test domains

Not really Laravel specific, but thought I'd ask anyway. Anyone have any experience using cretueusebiu/valet-windows? I've installed as per the guide, configured my DNS to point to 127.0.0.1 and ::1. Pinging any of my projects i.e. app.test returns a reply from 127.0.0.1 successfully. However, visiting app.test in the browser returns 'The requested URL could not be retrieved -

nickdavies07's avatar
nickdavies07's avatar D9705996Laravel
3

query execution test

I want to know that does laravel have any builtin way that, "if i have multiple query between a single function/method ,then if any of those query return an exception , the all query result (data saving in the table) that is being executed successfully before the unsuccessful query, will be removed from database table." ????

nionta's avatar
nionta's avatar niontaMix
1

How do you test Laravel Filesystem with AWS?

Is there any resource on testing Laravel with AWS? Any guideline/rule of thumb on this?

joshuajazleung's avatar
joshuajazleung's avatar luciandexTesting
2

How do I test speed in laravel?

I mean debug the function execution time?

GTHell's avatar
GTHell's avatar wilk_randa...Laravel
1

need help with factory test and phpunit

$roles = factory(App\Role::class, 5)->create(); $tags = factory(App\Tag::class, 20)->create(); when i run phpunit, i always got Error: Class 'Tests\Feature\App\Role' not found, I've tried to add use App\Role too but it does not work either. what am i missing?

Chaeril's avatar
Chaeril's avatar ChaerilTesting
3

Do you unit test model factories? (and their states)

Let's say your using factory(Post::class)->make() to create a Post model in your unit tests, and a post can have various states e.g. published, unpublished. By default, a post will return unpublished. Do you write unit tests to ensure that the factory is returning the default state correctly for use in your tests? I would assume it's a good idea because if a developer on you

garygreen's avatar
garygreen's avatar garygreenTesting
3

Vuejs test utils + mocha webpack userAgent error

Hi all, Has anyone come across with this error when run tests? TypeError: Cannot read property 'userAgent' of undefined I'm using this stack https://vue-test-utils.vuejs.org/guides/#testing-single-file-components-with-mocha-webpack Thank you!

tiagomatosweb's avatar
tiagomatosweb's avatar tiagomatos...Vue
0

Test transactions in Laravel

I have been trying to implement transaction in laravel. But I guess it isn't working. When I change the database field/column name (throwing a force error) the earlier tables gets inserted instead of rolling back. What is happening here?? try { DB::beginTransaction(); $drugInventory = DrugInventory::create([

uchihaabhi's avatar
uchihaabhi's avatar uchihaabhiLaravel
3

Can anybody test my app (problems with Cookies)?

I have back-end Laravel app: GitHub. I have front-end Vue app: GitHub. I'm trying to receive Cookies in my Vue app, but I don't get them. I don't understand what's wrong. Both apps have same subdomain parts locally. Cookie Header exists but there is no Cookies in Developers Console->Application->Cookies. TL;DR //Laravel api routes Route::get('testget', function () { s

Tarasovych's avatar
Tarasovych's avatar TarasovychCode Review
7

login test failed

public function testLoginPost(){ Session::start(); $response = $this->call('POST', 'login', [ 'email' => '[email protected]', 'password' => '123456', '_token' => csrf_token() ]); $this->assertEquals(200, $response->getStatusCode()); $this->assertEquals('auth.login', $response->original->name()); } output

Webiondev123's avatar
Webiondev123's avatar jcphpdevTesting
1

How to test browser functionality of popups (such as for Payment Request API)

How can I write browser tests for modals like this? In case it matters, I'm using Laravel 5.6 Dusk for browser testing, and my payment request modal is generated via a Stripe Payment Request Button. Stripe's Payment Request Button uses the cross-browser Payment Request API from W3C. Chrome doesn't let me "inspect" the HTML of the elements of the modal, so I'm not sur

GoTesla's avatar
GoTesla's avatar jlrdwLaravel
3

Better way to submit json data in post test

I currently have this testable piece of code to submit a json filled data via post. I let my controller do its thing and respond back. $responseKey = 'abcdabcd6b1649f681a408f1beebabcd'; $sendJson = $this->createSaleResponse($responseKey); $sendHeaders = [ 'CONTENT_TYPE' => 'application/json' ]; $response = $this->call( 'POST',

beerbuddha's avatar
beerbuddha's avatar wilburpowe...Testing
1

csrf_token in PHPUnit test for Laravel 5.2 project

Hi, I'm trying to upgrade Laravel from 5.1 to 5.2 in my project. I have done all instructions from the official manual and project works normally, but some PHPUnit tests are failed. In all failed tests POST call like following is used: \Session::start(); $this->call("POST", "/myroute", [ '_token' => csrf_token(), 'param' => $param ]); Previously in

lubart's avatar
lubart's avatar bobbybouwm...Laravel
6

How to change app domain into to the test?

I have used app domain on my laravel projects till today, but today mozilla starts open app domains with `https.. So I edited my laravel.app.conf file and changed Servername as laravel.test then restart my apache2 sudo service apache2 restart But this time local website doesn't open, it says server not found.. Did I something wrong ? Or am I need to do something else ? Edit: Al

hsntngr's avatar
hsntngr's avatar hsntngrLaravel
1

Laravel Free Test Server

Good day everyone, anyone knows a free hosting site or free sandbox where I can upload my Laravel Project together with its Database? Thank you.

harriesbmariano's avatar
harriesbmariano's avatar impbobLaravel
6

OAuth is not working - ERR_TOO_MANY_REDIRECTS - Is not possible to test oauth login in localhost?

Im using Valet, when accessing "http://proj.test/auth/facebook" we are redirected to "http://proj.test/auth/facebook?code=B...". But it appears an error: Page is not working, proj.test redirect too many times. ERR_TOO_MANY_REDIRECTS. Do you know how to fix the error? Routes: Auth::routes(); Route::get('/home', 'HomeController@index')->name('home'); Rout

johnnw's avatar
johnnw's avatar bashyGeneral
1

Test against value in array/JSON

I've got a database table called scrapeobjects which I use as temporary storage for a number of scraper and parser jobs. The structure is basically an id, a category text field, a type text field and a data JSON field (plus the created/updated_at fields, of course). Reading and writing to this from Eloquent has never been a problem and I've been able to use the flexibility of t

Breki's avatar
Breki's avatar mortezaEloquent
1

"Use of undefined constant LARAVEL_START" when running a Test

I'm starting to learn Tests now, this simple method bellow is returning error 500 on my homepage, even though I can see it just fine in the browser: public function testExample() { $response = $this->get('/'); $response->assertStatus(200); } The error is that the constant LARAVEL_START which I use to show processing time of page isn't defined in the moment of tes

founders's avatar
founders's avatar a-dev-code...Laravel
6

How to test soft deletes?

Hi, How are we doing this? Like this?: https://stackoverflow.com/questions/33117746/laravel-unit-testing-how-to-seeindatabase-soft-deleted-row

phpMick's avatar
phpMick's avatar phpMickTesting
4

Advice for Shared Test Setup

Current Server Setup MacOS Server 10.10.5 Apache 2.4.16 mySQL PHP 5.4 (yes I know...) git 2.4.9 Apache is set up with dynamic routing similar to Valet but uses an externally accessible domain so we can share with clients during development. We then mount a folder (effectively the equivalent of a www folder) from the server using AFP and can then create/edit/maintain sites built

CarlWilson's avatar
CarlWilson's avatar CarlWilsonServers
1

How to test Job Chaining in Laravel 5.5?

I have applied Job Chaining to an event in Laravel 5.5. I can check if the first job in the chain is being dispatched via: Queue::assertPushedOn(FirstJob::class) Is there a way to check that the rest of the jobs in the chain will be dispatched too?

boptom's avatar
boptom's avatar m165437Testing
8

How to add headers to test?

I'm using Lumen, but there is no information in the Lumen documentation on how to do this. So I followed the Laravel docs: public function testUpdateMethodSuccess() { $response = $this->withHeaders([ 'HTTP_Authorization', $this->token ])->json('POST', 'users/3', ['name' => 'Sally']); $response->assertResponseStatus(422); } Whet

chillcaw's avatar
chillcaw's avatar BorisuTesting
3

Phpunit error 'No test executed!'

Am using laravel 5.5 and anytime I run phpunit I get this error No tests executed. Can anyone help me. c:\xampp\htdocs\L5.5 (master) λ phpunit PHPUnit 3.7.21 by Sebastian Bergmann. Configuration read from C:\xampp\htdocs\L5.5\phpunit.xml Time: 42 ms, Memory: 4.00MB No tests executed!

nanadjei2's avatar
nanadjei2's avatar nanadjei2Laravel
2

How to test my package?

I maintain several packages that are available for download via composer. To my shame, most of these do not have tests, despite me using them extensively in my day to day activities. Reason is simple: I don't know how to make them work properly. For example: my most used package is ixudra/curl, a package for easily sending cURL requests through a fluent query builder. Ideally,

ixudra's avatar
ixudra's avatar ixudraTesting
4

Kind of a gross functional test. How to improve it, maybe?

GIVEN that we have a Character with a Type that has a Might pool value and a Descriptor that has a Might bonus value WHEN we run that character through the calculation rules for rendering THEN the Character's Might will be calculated accurately public function it_calculates_might_accurately() { $this->signIn(); $stat = Stat::findOrFail(Stat::MIGHT);

thc1967's avatar
thc1967's avatar thc1967Code Review
0

Make the DatabaseMigrations trait migrate the test database

So the problem I'm facing is that after the tests are run, my local development database is rolled back instead of the testing one that is referenced in the .env.dusk.local file. Is this indeed an issue or I'm missing something? Any way I can fix this? Maybe overwrite the trait migration so that it does migrate --env=dusk.local, any ideas?

ionelfona's avatar
ionelfona's avatar ionelfonaTesting
0

Test that db table has some rows?

Is there a good way to do this? At the moment I am doing: $this->seeInDatabase('things',['id' => 1]); Mick

phpMick's avatar
phpMick's avatar phpMickTesting
2

Test Mail without server?

Hello, can I test/mock Mail locally? with no mail server Thank you

Marins's avatar
Marins's avatar ModestasVLaravel
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

Should I test redirections ?

Hi there, I'm a long time lurker on this forum and I thought I would ask my first question since I usually read good and specific answers here. I'm still trying to get the hang of some Laravel's features, and I'm definetly not an expert :-) To situate : I have a controller (let's call it ServerController). This controller has the auth middleware applied to it, therefore any gue

Magelfik's avatar
Magelfik's avatar MikeHopleyTesting
2

Gulpfile Auto Test, TDD and phpspec

Hello, i am following Jeff step 6 course, Step 1 prime factors, i followed his steps, from php descirbe primefactors to run, but everytime i run i get 1 argument broken instead of passed even after i create the class. Also after i install gulp, with his gulpfile, i run gulp in cmd and nothing changes, i can't get the auto-test messages jeff gets. I also don't understand how he

dannys's avatar
dannys's avatar dannysGeneral
3

DatabaseMigrations is too slow for each test, how to fix ?

When I run phpunit testing it takes long time to complete process because of migrations and seed, so how to fix this problem ?

mg-freelancer's avatar
mg-freelancer's avatar robrogers3Testing
4

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

Provision Server and test on subdomain on different IP

Hey All, I've searched Google but I can't really find a succinct answer to my question so I'm hoping you guys can help. Basically, I've haven't gone live with a Laravel project yet and that requirements from the client add even more complication that I need some advise on. We have a domain 'example.com' that has a Wordpress installation on it and I would like to host a Laravel

lukecurtis's avatar
lukecurtis's avatar neilherber...Servers
1

Test datatables file download?

Anybody know how to do acceptance tests for datatables CSV file downloads? We're using phpunit/Codeception and can't find a way to get the file to download. Any help?

zachleigh's avatar
zachleigh's avatar zachleighTesting
0

Should I test for unauthenticated behavior?

Hi, I am new to testing. So far, I have been testing each of my API endpoints for both authenticated and unauthenticated users: public function testAuthenticatedUser() { Passport::actingAs($this->user); $response = $this ->get('/api/posts') ->assertStatus(200); //... (other assertions) } public function testUnauthenticatedUser() {

ill-logical's avatar
ill-logical's avatar ill-logica...Testing
3

avoriaz - a Vue test util library

I've made a library to make testing Vue components easier. Check it out. Hopefully you find it as useful as I have

eddyerburgh's avatar
eddyerburgh's avatar eddyerburg...Testing
0

Test Markdown Test

Do we have delete functionality for thread here?

ajmerainfo's avatar
ajmerainfo's avatar ajmerainfoLaravel
0