Extend Laravel seeder and populate your DB with CSV data.
PHP
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
src
tests
.gitignore
.travis.yml
LICENSE.md
README.md
composer.json
phpunit.xml

README.md

Laravel-Extend-Seeder

Travis

Extend Laravel seeder and populate your DB with CSV data.

Installation

PHP 5.4+ or HHVM 3.3+, Composer and Laravel 5.0+ are required.

To get the latest version of Laravel-Extend-Seeder, simply add the following line to the require block of your composer.json file.

"lanin/laravel-extend-seeder": "dev-master"

You'll then need to run composer install or composer update to download it and have the autoloader updated.

Once it was installed you don't have to register any ServiceProvider, Facade or publish any configs.

All you have to do is to extend your base Seeder class with \Lanin\ExtendSeeder\Seeder and you are good to go!

class Seeder extends \Lanin\ExtendSeeder\Seeder { }

Preparing

Every time you try to seed lots of data, you have to unguard your models. Now you don't have to do it. They will be unguarded automatically in the boot method, that fires right on the start. Also it will disable query log, that extremely slows data import.

Environment protection

If you are afraid to corrupt your production database with seeding it with test data, even if artisan asks you if you want to do it, you can specify protected $environment variable in your seeder. Boot method will check if current environment doesn't match the set one and throw an exception, so you can be sure you don't break your production data.

Seeding

After you extended your base seeder, you will receive two additional methods

seedModel($model)

The best place for this method is the run method of your main DatabaseSeeder.

By default you have to fire call method that will resolve a specified seeder as {$tableName}TableSeeder and launch it, and there resolve your models and do all the stuff.

This method will do it for you. It will find related seeder by model's table and pass your model to it.

Hint: This method returns resolved seeder object, so you can chain your seed methods.

Example:

class Account extends \Illuminate\Database\Eloquent\Model {
	protected $table = 'accounts';
}

class DatabaseSeeder extends Seeder {

	/**
	 * Seed your database.
	 */
	public function run()
	{
		$this->seedModel(\App\Account::class);
	}
}

class AccountsTableSeeder extends Seeder {

	/**
	 * Seed model.
	 */
	public function run()
	{
		$this->getModel()->truncate();
	}
}

seedWithCsv($csvFile = '', $model = null)

This method seeds your database with data from the related csv files.

By default, it tries to find them in your /database/seeds/csv directory.

Files have to be names as {$databaseName}_{$tableName}.csv, but you can always overwrite this behaviour.

Note! If you are using the same seeds to seed mysql and sqlite databases (ie. while testing), you have to define your database name manually, or Seeder will try to find csv files like database.sqlite_your_table.csv. You can do it via \Lanin\ExtendSeeder\Seeder::setDatabaseName('database_name'); method.

If you are calling this method via table seeder, that was called via seedModel, it already knows everything about your model and can resolve related csv file iteslf.

Example:

class AccountsTableSeeder extends Seeder {

	/**
	 * Seed model with CSV.
	 */
	public function run()
	{
		$this->seedWithCsv();
	}
}

Full example you can find in the tests/CsvSeederTest.php

Hacks

You can leave TableSeeders empty and chain csv import via basic seeder.

class DatabaseSeeder extends Seeder {

	/**
	 * Seed your database.
	 */
	public function run()
	{
		$this->seedModel(\App\Account::class)->seedWithCsv();
	}
}

class AccountsTableSeeder extends Seeder {

	/**
	 * Seed model.
	 */
	public function run()
	{

	}
}

You don't even have to create TableSeeders and seed right in your basic seeder.

class DatabaseSeeder extends Seeder {

	/**
	 * Seed your database.
	 */
	public function run()
	{
		$this->setModel(\App\Account::class)->seedWithCsv();
	}
}

If you want to have your csv files to be set in another location you can use static method setCsvPath($csvPath), where you can specify relative from your base_path path.

Contributing

Please feel free to fork this package and contribute by submitting a pull request to enhance the functionalities.