laravel | Блог очередного разработчика

VueJS/Laravel + Quill Editor handling base64 image upload

Опубликовано 05.04.2017

Hello,

Quill editor doing really great job with accepting images and putting it as base64.

But actually it doesnt good, especially for big images.

Your DB will be big AF and page load time will grow with each image in text.

I didnt find good or working solution from Quill side. Only some closed GitHub issues.

So i decided to make lilttle hack on backend.

My system info: VueJS Quill wrapper, Laravel 5.4

Now what we need.

Firstly install Symfony Dow Crawler

composer require symfony/dom-crawler

1	composer require symfony/dom-crawler

Then include it and some other classes in your model/controller.

use Symfony\Component\DomCrawler\Crawler;
use Illuminate\Support\Facades\Storage;
use Illuminate\Http\File;

use Symfony\Component\DomCrawler\Crawler;

use Illuminate\Support\Facades\Storage;

use Illuminate\Http\File;

And here code of extractor/file saver

$desc = $request->input('some_html'); // POST with html
$dom_desc = new Crawler($desc);
$images = $dom_desc->filterXPath('//img')->extract(array('src')); // extract images

foreach ($images as $key => $value) {
    if (strpos($value, 'base64') !== false) { // leave alone not base64 images
        $data = explode(',', $value); // split image mime and body
        $tmp_file = tempnam('/tmp', 'items'); // create tmp file path
        file_put_contents($tmp_file, base64_decode($data[1])); // fill temp file with image
        $path = Storage::putFile('public/items', new File($tmp_file)); // put file to final destination
        $desc = str_replace($value, $path, $desc); // replace src of converted file to fs path
        unlink($tmp_file); // delete temp file
    }
}

$desc = $request->input('some_html'); // POST with html

$dom_desc = new Crawler($desc);

$images = $dom_desc->filterXPath('//img')->extract(array('src')); // extract images

foreach ($images as $key => $value) {

if (strpos($value, 'base64') !== false) { // leave alone not base64 images

$data = explode(',', $value); // split image mime and body

$tmp_file = tempnam('/tmp', 'items'); // create tmp file path

file_put_contents($tmp_file, base64_decode($data[1])); // fill temp file with image

$path = Storage::putFile('public/items', new File($tmp_file)); // put file to final destination

$desc = str_replace($value, $path, $desc); // replace src of converted file to fs path

unlink($tmp_file); // delete temp file

}

And finally we got $desc html with converted base64 -> fs path

Saving to DB.

That’s all.

Full Code at gist: https://gist.github.com/S-anasol/5dde48f75a265d21123d0ab1f49d2e8a

Laravel 5.2 + JWT + Dingo API + PHPUnit

Опубликовано 12.08.2016

The token could not be parsed from the request

The token could not be parsed from the request

For some magic reasons(simulating requests) phpunit can’t pass tests with JWT token header or GET param token=?.

Solution is just add few lines to middleware or anywhere else like this.

Got it work with this code in my middleware:

if (env('APP_ENV') === 'testing') {
    JWTAuth::setRequest($request);
}

if (env('APP_ENV') === 'testing') {

JWTAuth::setRequest($request);

}

Result middleware for api auth

<?php

namespace App\Http\Middleware;

use Closure;
use Illuminate\Support\Facades\Auth;
use Illuminate\Http\Request;
use JWTAuth;

class AuthenticateApi
{
    /**
     * Handle an incoming request.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \Closure  $next
     * @param  string|null  $guard
     * @return mixed
     */
    public function handle(Request $request, Closure $next,  $guard = null)
    {
        if (env('APP_ENV') === 'testing') {
            JWTAuth::setRequest($request);
        }

        JWTAuth::parseToken();
        $user = JWTAuth::parseToken()->authenticate();

        return $next($request);
    }
}

<?php

namespace App\Http\Middleware;

use Closure;

use Illuminate\Support\Facades\Auth;

use Illuminate\Http\Request;

use JWTAuth;

class AuthenticateApi

{

/**

* Handle an incoming request.

* @param \Illuminate\Http\Request $request

* @param \Closure $next

* @param string|null $guard

* @return mixed

public function handle(Request $request, Closure $next, $guard = null)

{

if (env('APP_ENV') === 'testing') {

JWTAuth::setRequest($request);

}

JWTAuth::parseToken();

$user = JWTAuth::parseToken()->authenticate();

return $next($request);

}

Eloquent query logging outside Laravel

Опубликовано 26.04.2016

Class db does not exist eloquent

A facade root has not been set

and other terrible errors.

This post for those who like me using Eloquent outside Laravel.
With config like this:

use Devio\Eavquent\Agnostic\BootEavquent;
use Illuminate\Database\Capsule\Manager as Capsule;
use Illuminate\Events\Dispatcher;
use Illuminate\Container\Container;
use Illuminate\Support\Facades\Schema;

$capsule = new Capsule;

$capsule->addConnection([
    'driver'    => 'mysql',
    'host'      => 'localhost',
    'database'  => 'dbname',
    'username'  => 'user',
    'password'  => 'password',
    'charset'   => 'utf8',
    'collation' => 'utf8_unicode_ci',
    'prefix'    => '',
]);

// Set the event dispatcher used by Eloquent models... (optional)

$capsule->setEventDispatcher(new Dispatcher(new Container));

// Make this Capsule instance available globally via static methods... (optional)
$capsule->setAsGlobal();

// Setup the Eloquent ORM... (optional; unless you've used setEventDispatcher())
$capsule->bootEloquent();

use Devio\Eavquent\Agnostic\BootEavquent;

use Illuminate\Database\Capsule\Manager as Capsule;

use Illuminate\Events\Dispatcher;

use Illuminate\Container\Container;

use Illuminate\Support\Facades\Schema;

$capsule = new Capsule;

$capsule->addConnection([

'driver' => 'mysql',

'host' => 'localhost',

'database' => 'dbname',

'username' => 'user',

'password' => 'password',

'charset' => 'utf8',

'collation' => 'utf8_unicode_ci',

'prefix' => '',

]);

// Set the event dispatcher used by Eloquent models... (optional)

$capsule->setEventDispatcher(new Dispatcher(new Container));

// Make this Capsule instance available globally via static methods... (optional)

$capsule->setAsGlobal();

// Setup the Eloquent ORM... (optional; unless you've used setEventDispatcher())

$capsule->bootEloquent();

Sometime need to log queries or just count it.
Almost all google results show code like this:

DB::listen(function($query){});

1	DB::listen(function($query){});

But outside Laravel you will get errors written above.

I spent some time to get it work.
And now i got solution 😀

To get work query logs outside Laravel use this 🙂

// Listening to all queries
$capsule->connection()->listen(function ($query) {
  var_dump($query);
});

// Enabling query log
$capsule->connection()->enableQueryLog();

// Getting array of executed queries
$capsule->connection()->getQueryLog();

// Listening to all queries

$capsule->connection()->listen(function ($query) {

var_dump($query);

});

// Enabling query log

$capsule->connection()->enableQueryLog();

// Getting array of executed queries

$capsule->connection()->getQueryLog();