A set of features for eloquent built on top of calebporzio/sushi.
You can install the package via composer:
composer require inmanturbo/futomaki
<?php
use Illuminate\Database\Eloquent\Model;
use Inmanturbo\Futomaki\HasCsv;
class Post extends Model
{
use HasCsv;
protected $schema = [
'id' => 'id',
'title' => 'string',
'content' => 'text',
];
protected function csvFileName()
{
return 'posts.csv';
}
protected function csvDirectory()
{
return storage_path('csv');
}
}
HasCsv uses sushi (array driver) under the hood, and supports defining a $rows property as well. A csv file will automatically be created using the defined $rows.
use Illuminate\Database\Eloquent\Model;
use Inmanturbo\Futomaki\HasCsv;
class PostWithCsv extends Model
{
use HasCsv;
protected $guarded = [];
protected $schema = [
'id' => 'id',
'title' => 'string',
'content' => 'text',
];
protected $rows = [
[
'id' => 1,
'title' => 'Post 1',
'content' => 'Content 1',
],
[
'id' => 2,
'title' => 'Post 2',
'content' => 'Content 2',
],
];
}
Implementing your own getCsvRows()
method is supported as well.
use Illuminate\Database\Eloquent\Model;
use Inmanturbo\Futomaki\HasCsv;
class PostWithCsv extends Model
{
use HasCsv;
protected $guarded = [];
protected $schema = [
'id' => 'id',
'title' => 'string',
'content' => 'text',
];
public function getCsvRows()
{
return [
['id' => 1,'title' => 'Post 1', 'content' => 'Content 1'],
['id' => 2,'title' => 'Post 2','content' => 'Content 2'],
];
}
}
HasFutomakiWrites is a trait which leverages eloquent's saving()
and deleting()
hooks to support writing sushi's changes out to another database, or api, etc.
Example Below.
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;
use Inmanturbo\Futomaki\Futomaki;
use Inmanturbo\Futomaki\HasFutomakiWrites;
class PostWithFutomakiWrites extends Model
{
use Futomaki;
use HasFutomakiWrites;
public $timestamps = true;
public $guarded = [];
protected $schema = [
'id' => 'id',
'title' => 'string',
'content' => 'text',
];
public function getRows()
{
return DB::connection('remote_posts')->table('posts')->get()->map(fn ($remoteItem) => [
'id' => $remoteItem->id,
'title' => $remoteItem->title,
'content' => $remoteItem->body,
])->toArray();
}
public function futomakiSaving()
{
$values = [
'id' => $this->id,
'title' => $this->title,
'body' => $this->content,
];
DB::connection('remote_posts')->transaction(function () {
DB::connection('remote_posts')->table('posts')->upsert($values, $this->getKeyName());
});
}
public function futomakiDeleting()
{
DB::connection('remote_posts')
->table('posts')
->where($this->getKeyName(), $this->getKey())
->delete();
}
}
composer test
Please see CHANGELOG for more information on what has changed recently.
Please see CONTRIBUTING for details.
Please review our security policy on how to report security vulnerabilities.
The MIT License (MIT). Please see License File for more information.