Tray2

Found that in this blog post by Chris Trombley

https://tighten.co/blog/tidying-up-your-phpunit-tests-with-data-providers

Like @nakov said use Intervention for that.

http://image.intervention.io/

You are most welcome :)

You can use the test method to do the comparsion. I also missed that you need to escape the /

var patt = /events\/.*/;
patt.test(this.$router.currentRoute.path) ? console.log('true') : console.log('false');

https://www.w3schools.com/js/js_regexp.asp

You can use the test method to do the comparsion. I also missed that you need to escape the /

var patt = /events\/.*/;
patt.test(this.$router.currentRoute.path) ? console.log('true') : console.log('false');

https://www.w3schools.com/js/js_regexp.asp

I've started with this and I think I like it alot.

This is what I have so far on the validation tests for a record

    /**
    * @test
    * @dataProvider recordValidationProvider
    */
    public function record_form_validation($formInput, $formInputValue)
    {
        $record = factory(Record::class)->make([
            $formInput => $formInputValue
        ]);
        $this->signIn();
        $response = $this->post('/records', $record->toArray());

        $response->assertStatus(302);
        $response->assertSessionHasErrorsIn($formInput);
    }

    public function recordValidationProvider()
    {
        return [
            'title is required' => ['title', ''],
            'released is required' => ['released', ''],
            'release cant be earlier than 1800' => ['released', 1799],
            'release cant be more than one year in the future' => ['released', Carbon::now()->addYear(2)->year],
        ];
    }

@bugsysha thanx again m8 :)

In regexp the * is a quantifier and the . is a wildcard so try adding a dot infront of the *

this.$router.currentRoute.path == `/events/.*/` ? console.log('true') : console.log('false');

I will try that out tomorrow. Thnx m8.

A table with more fields like this will be intresting to try that out on.

Schema::create('books', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('title');
            $table->string('series');
            $table->unsignedInteger('part')->nullable();
            $table->unsignedBigInteger('format_id');
            $table->unsignedBigInteger('genre_id');
            $table->string('isbn');
            $table->unsignedInteger('released');
            $table->unsignedInteger('reprinted')->nullable();
            $table->unsignedInteger('pages');
            $table->text('blurb');
            $table->timestamps();

Dataproviders is a good idea I might look into that a bit more and see if that is usable in this case. On a small table with few fields I think dataproviders will function nicely but for a big table with lots of fields they migth get cluttered with big and messy arrays. I will try that out tomorrow and see how it looks and feels.

I was thinking a bit about validation testing today and normaly I do something like this.

I start with the happy path test.

    /**
    * @test
    */
    public function a_valid_author_can_be_stored()
    {
        $author = factory(Author::class)->make([
            'first_name' => 'Robert',
            'last_name' => 'Jordan',
        ]);

        $this->post('/authors', $author->toArray());
        $this->assertEquals(1, Author::count());
    }

Then I move on and create the first validation test

 /**
    * @test
    */
    public function author_first_name_is_required()
    {
        $author = factory(Author::class)->make([
            'first_name' => null,
            'last_name' => 'Jordan',
        ]);

        $this->post('/authors', $author->toArray())->assertSessionHasErrors('first_name');
        $this->assertEquals(0, Author::count());
    }

And I create one for each field and for each validation rule.

This is all well and good. However I do the same thing again for the update method.

The happy path test

 /**
    * @test
    */
    public function a_valid_author_can_be_updated()
    {
        $author = factory(Author::class)->create([
            'first_name' => 'Steven',
            'last_name' => 'Jordan'
        ]);

        $author->first_name = 'Robert';

        $this->put('/authors/' . $author->id, $author->toArray());
        $this->assertEquals('Jordan, Robert', $author->fresh()->name);
    }

and the first validation test

/**
    * @test
    */
    public function authors_first_name_is_required_to_update_an_author()
    {
        $author = factory(Author::class)->create([
            'first_name' => 'Steven',
            'last_name' => 'Jordan'
          ]);

        $author->first_name = null;

        $this->put('/authors/' . $author->id, $author->toArray())->assertSessionHasErrors(('first_name'));

        $this->assertEquals('Steven', $author->fresh()->first_name);
    }

This is all well and good but it feels a bit repetitive and actually quite boring to write. So my thought was this.

I keep the happy path tests as is and then combine the store and update validations. Something like

 /**
    * @test
    */
    public function author_first_name_is_required()
    {
    $author = factory(Author::Class)->create();
        $missingFirstName = factory(Author::class)->make([
            'first_name' => null,
            'last_name' => 'Jordan',
        ]);

        $this->post('/authors', $author->toArray())->assertSessionHasErrors('first_name');
        $this->assertDatabaseMissing('authors', ['first_name' => null]);

    $author = factory(Author::class)->make([
            'first_name' => null,
            'last_name' => 'Jordan',
        ]);
    $this->put('/authors/' . $author->id, $missingFirstNamer->toArray())->assertSessionHasErrors(('first_name'));

        $this->assertEquals('Steven', $author->fresh()->first_name);
    }

It can probably be made even cleaner and more readable but before I start doing that what is your intake on this?

I know that you should only test one thing and keep the assertions per test to a minimum but since it's the same validation rules for both store and update the could go together.

Ooh that is not a good practice at all.

I suggest you use the other domain as an api that supplies the partial instead.

This video explains it very well

https://laracasts.com/series/javascript-techniques-for-server-side-developers

Then you don't need to use an iframe at all.

Show us what you are trying to do in code and show us the error message.

Tailwind resets all the browser defaults. Then you need to apply classes to each element you want to style.

You are the god of messy code.

Take this part for example

   if ($sortBy != null) {
        if ($sortBy == SortingOptionEnum::LOWESTPRICE) {
            $pct = 'product_category_translations as t';
                $products = $products
                    ->join('product_price_lists as ppl', 'ppl.product_catalog_id', '=', 'product_catalogs.id')
                    ->join('product_catalog_product_category as c', 'c.product_catalog_id', 'product_catalogs.id')
                    ->join($pct, 't.product_category_id', '=', 'c.product_category_id')
                    ->where('t.name', $range)
                    ->groupBy('product_catalogs.id')
                    ->orderBy('ppl.price')
                    ->select('product_catalogs.*');
        }

        if ($sortBy == SortingOptionEnum::HIGHESTPRICE) {
            $pct = 'product_category_translations as t';
                $products = $products
                    ->join('product_price_lists as ppl', 'ppl.product_catalog_id', '=', 'product_catalogs.id')
                    ->join('product_catalog_product_category as c', 'c.product_catalog_id', 'product_catalogs.id')
                    ->join($pct, 't.product_category_id', '=', 'c.product_category_id')
                    ->where('t.name', $range)
                    ->groupBy('product_catalogs.id')
                    ->orderByDesc('ppl.price')->select('product_catalogs.*');
        }
    }

That could easily be cleaned up. Something like

if ($sortBy != null) {
    $sortDiretction = ($sortBy === SortingOptionEnum::LOWESTPRICE) ?  'asc' : 'desc'; 
    $pct = 'product_category_translations as t';
    $products = $products
        ->join('product_price_lists as ppl', 'ppl.product_catalog_id', '=', 'product_catalogs.id')
        ->join('product_catalog_product_category as c', 'c.product_catalog_id', 'product_catalogs.id')
        ->join($pct, 't.product_category_id', '=', 'c.product_category_id')
        ->where('t.name', $range)
        ->groupBy('product_catalogs.id')
        ->orderBy('ppl.price', $sortinDirection)
        ->select('product_catalogs.*');
}

It can of course be cleaned up even more.

@fylzero True but not likely.

My guess is that DIRECTORY_SEPARATOR is used and on Windows systems it becomes \ so I always use hardcoded /

https://dev.to/c33s/always-use--as-directory-seperator-in-php-43l7

You most likely add that backslash somewhere in your code so I suggest looking for that instead of replacing it first.

Like I said in the previous thread you can use Intervention for this which is the easiest way.

Or you can use the gd library and use getimagesize.

https://www.php.net/manual/en/function.getimagesize.php

I'd go with Intervention since it has a nice laravel wrapper.

$width = Image::make('public/foo.jpg')->width();

@fylzero yepp.

Was in a bit of a hurry and wrote the ternary wrong. I've updated the code in my previous comment.

You should probaly use the $path in this statement instead of $request->file('image')

$imgsizes = $request->file('image')->getSize();

If you divide 90788 with 1024 you get 88.66.

So you get the filesize in bytes.

I'd use number for that.

You can use varchar if you want.

Blob is for binary large object

A style reset is used to make it easier for consistensy between browsers.

All tags might have different default style depending on the browser so to make it easier and more consistent you usually reset the style so that all elements are unstyled. Then you have full control over how your page looks and feels.

Different server setups is my guess.

I would take a look at the file and directory permissions/owner. If the diretory is not writable then you can't do file_put_contents.

Tailwind resets all the browser defaults. Then you need to apply classes to each element you want to style.

I did this

<select name="genre_id" required>
            @if(old('genre_id'))
            <option value="" disabled>Select your genre</option>
            @else
            <option value="" disabled {{ isset($book) ? '' : 'selected' }}>Select your genre</option>
            @endif
            @foreach($genres as $genre)
            <option value="{{ $genre->id }}" {{ isset($book) && $book->genre_id == $genre->id ? 'selected' : '' }}>{{ $genre->genre }}</option>
            @endforeach
</select>

You should probaly use the $path in this statement instead of $request->file('image')

$imgsizes = $request->file('image')->getSize();

Not having seen any code from your application and not understanding what you mean with "opens several hours later".

Is the user closing the browser and then reopens it? Is the user just leaving the tab open in the background and comes back to it?

You can set session timeouts on the server and it might be that it invalidates the session after just a couple of minutes or so.

That is normal behaviour. The user has probably lost his session and the csrf has become invalid.

Save the product in a variable then. Something like

$factory->define(OrderProduct::class, function (Faker $faker) {
    $product =  factory(Product::class)->create();   
return [
        'order_id' => factory(Order::class),
        'product_id' => $product->id,
        'original_price' => $product->price,
        'quantity' => $faker->randomDigitNotNull,
    ];
});

You can use intervention for the image information

http://image.intervention.io/getting_started/installation#laravel

Save the product in a variable then. Something like

$factory->define(OrderProduct::class, function (Faker $faker) {
    $product =  factory(Product::class)->create();   
return [
        'order_id' => factory(Order::class),
        'product_id' => $product->id,
        'original_price' => $product->price,
        'quantity' => $faker->randomDigitNotNull,
    ];
});

Can you run composer create-project laravel/laravel laraapp?

You are the god of messy code.

Take this part for example

   if ($sortBy != null) {
        if ($sortBy == SortingOptionEnum::LOWESTPRICE) {
            $pct = 'product_category_translations as t';
                $products = $products
                    ->join('product_price_lists as ppl', 'ppl.product_catalog_id', '=', 'product_catalogs.id')
                    ->join('product_catalog_product_category as c', 'c.product_catalog_id', 'product_catalogs.id')
                    ->join($pct, 't.product_category_id', '=', 'c.product_category_id')
                    ->where('t.name', $range)
                    ->groupBy('product_catalogs.id')
                    ->orderBy('ppl.price')
                    ->select('product_catalogs.*');
        }

        if ($sortBy == SortingOptionEnum::HIGHESTPRICE) {
            $pct = 'product_category_translations as t';
                $products = $products
                    ->join('product_price_lists as ppl', 'ppl.product_catalog_id', '=', 'product_catalogs.id')
                    ->join('product_catalog_product_category as c', 'c.product_catalog_id', 'product_catalogs.id')
                    ->join($pct, 't.product_category_id', '=', 'c.product_category_id')
                    ->where('t.name', $range)
                    ->groupBy('product_catalogs.id')
                    ->orderByDesc('ppl.price')->select('product_catalogs.*');
        }
    }

That could easily be cleaned up. Something like

if ($sortBy != null) {
    $sortDiretction = ($sortBy === SortingOptionEnum::LOWESTPRICE) ?  'asc' : 'desc'; 
    $pct = 'product_category_translations as t';
    $products = $products
        ->join('product_price_lists as ppl', 'ppl.product_catalog_id', '=', 'product_catalogs.id')
        ->join('product_catalog_product_category as c', 'c.product_catalog_id', 'product_catalogs.id')
        ->join($pct, 't.product_category_id', '=', 'c.product_category_id')
        ->where('t.name', $range)
        ->groupBy('product_catalogs.id')
        ->orderBy('ppl.price', $sortinDirection)
        ->select('product_catalogs.*');
}

It can of course be cleaned up even more.

I'd probably do something like this

function getDirContents(){
    return scandir('./');
}

function getFiles($contentList)
{
    $files = [];
    $allowedTypes = ['xml'];

    foreach($contentList as $row) {
        if(is_file($row)) {
            $extension = pathinfo($row, PATHINFO_EXTENSION);
            if(in_array($extension, $allowedTypes)) {
                $files[] = $row;
            }
        }
    }

    return $files;
}

function moveFiles($files )
{
    //move code here
}

function main()
{
    $files = getDirContents();
    $xmlFiles = getFiles($files);
    moveFiles($xmlFiles);
}

main();

There is no way to securely encrypt something and still save space, To achieve that you need to first encrypt then compress it.

That is not so strange.

There are two (or more) php installed. Your webserver uses 7.4 while your client points to 4.4.

If you do which php it will give you the path to the one you are using (4.4). So you need to make your 7.4 installation default. Not knowing your system setup but something like

sudo update-alternatives --set php /usr/bin/php7.4

Should do the trick.

I would put all the common JS into one bundle/file and keep the page specific stuff in their own files. Something like

• common.js (All common JS aka JS that is used in more than one page)
• page1.js (Page1 specific js)
• page2.js (Page2 specific js)
• page3.js (Page3 specific js)

Of course it also depends a bit on the size of the files. If we are talking just a few Kb for the page specific stuff then I'd put it in the same file/bundle.

I suggest you change ->get() to ->toSql() and dump the query. Then you log into your favorite sql gui or the mysql prompt and run explain <your query> that should tell you what is taking time. It can be a bit tricky to understand but look for Full table scan and Cartesian products

The output will look something like this

MariaDB [mediabase]> explain select * from book_views;
+------+--------------------+-------+-------+---------------+---------+---------+------+------+--------------------------------------------------------+
| id   | select_type        | table | type  | possible_keys | key     | key_len | ref  | rows | Extra                                                  |
+------+--------------------+-------+-------+---------------+---------+---------+------+------+--------------------------------------------------------+
|    1 | PRIMARY            | b     | ALL   | NULL          | NULL    | NULL    | NULL | 2    |                                                        |
|    1 | PRIMARY            | g     | ALL   | PRIMARY       | NULL    | NULL    | NULL | 2    | Using where; Using join buffer (flat, BNL join)        |
|    1 | PRIMARY            | f     | ALL   | PRIMARY       | NULL    | NULL    | NULL | 2    | Using where; Using join buffer (incremental, BNL join) |
|    6 | DEPENDENT SUBQUERY | bi    | ALL   | NULL          | NULL    | NULL    | NULL | 2    | Using where                                            |
|    5 | DEPENDENT SUBQUERY | s     | ALL   | NULL          | NULL    | NULL    | NULL | 1    | Using where                                            |
|    4 | DEPENDENT SUBQUERY | a     | ALL   | PRIMARY       | NULL    | NULL    | NULL | 2    |                                                        |
|    4 | DEPENDENT SUBQUERY | ab    | ALL   | NULL          | NULL    | NULL    | NULL | 4    | Using where; Using join buffer (flat, BNL join)        |
|    3 | DEPENDENT SUBQUERY | a     | index | PRIMARY       | PRIMARY | 8       | NULL | 2    | Using index                                            |
|    3 | DEPENDENT SUBQUERY | ab    | ALL   | NULL          | NULL    | NULL    | NULL | 4    | Using where; Using join buffer (flat, BNL join)        |
+------+--------------------+-------+-------+---------------+---------+---------+------+------+--------------------------------------------------------+
9 rows in set (0.001 sec)

If I need to change data like that I use plain SQL. It's fast it's straight forward without any fuss.

In my opinion all data manipulation should be done using SQL since it's most likely a one time deal. If it is something you need to run on a regular basis then you could do a artisan command but that suggest there might be something wrong with your database model.

Is there an error message or does it just give you 0?

If you need to run it standalone you need to add the second table to your FROM clause

SELECT COUNT(Log_ns.n_s) 
FROM Log_ns,
        Magasins    
WHERE Log_ns.id_produit = Magasins.produit_id 
AND DATE(Log_ns.created_at) = DATE(Magasins.created_at)) as qte_ins

My guess is that you don't have posts that are the same.

That has nothing to do with forge.

You need to set up a ssh tunnel in TablePlus.

https://tableplus.com/blog/2019/08/ssh-tunnel-secure-database-connection.html

To put it like this.

A Question is a question regardless of how many possible answers there are.

So I would do a Question model and an Answer model.

The Answer model determines how many answers there are.

DB::getSchemaBuilder()->getColumnListing('users');

Would give you the structure of the users table.

You probably need a custom ruke for that.

https://laravel.com/docs/6.x/validation#custom-validation-rules

What version of php have you installed?

Try running laravel use [email protected] exchange the xto your version of php.

Like @jlrdw said it's optional. As an example if you build a library application you might have some default values that you want to store in the database such as formats, genres and countries. So instead of inserting them manually you can create a seeder for those tables. You can of course use plain SQL for this if you like.

The thing that I don't like is that the introduced Oracle SQL syntax for some of the new functionality in MySQL 8 and that makes the otherwise pretty clean syntax of MySQL a bit harder to read.

The easiest way to do this is to use a shared folder instead of a samba connection.

https://robertfilter.net/blog/computers/virtualbox-how-to-share-a-folder-from-windows-to-a-linux-virtual-machine.html

If you want to continue using samba you need to add the samba user to www-data and set the default user group in your samba config

https://unix.stackexchange.com/questions/164884/how-to-set-default-group-for-files-created-in-samba-share

Not really understanding your database model but here is how I would do it.

I would have a check_in and a check_out field in my reservations table. Then I would not store the number of available rooms in any table since it could become falsey. I would use a calculated value for that instead of a static one that I need to update every time I do something with the rooms.

So to get the free rooms I'd use a database view that I can easely query every time I need to check the avaiability of rooms.