I have this for Manufacturer seed
class ManufacturerTableSeeder extends Seeder {
public function run()
{
DB::table('manufacturers')->delete();
$now = date('Y-m-d H:i:s');
$records = [
'Toyota',
'Ford',
'Porsche',
'Dodge',
'Tesla',
'Audi',
'Mercedes'
];
for($i = 0; $i < count($records); $i++)
{
DB::table('manufacturers')->insert(
array(
'name' => $records[$i],
'created_at' => $now,
'updated_at' => $now
)
);
}
}
}
That works. I want to do something similar with Models seed class, to avoid repetition, right? I have this
class ModelTableSeeder extends Seeder {
public function run()
{
DB::table('models')->delete();
$now = date('Y-m-d H:i:s');
$records = [
['Echo', DB::table('manufacturers')->where('name', '=', 'Toyota')->get('id')]
];
for($i = 0; $i < count($records); $i++)
{
DB::table('models')->insert(
array(
'name' => $records[$i][0],
'manufacturer_id' => $records[$i][1],
'created_at' => $now,
'updated_at' => $now
)
);
}
}
}
but it doesn't work:
[ErrorException]
Argument 1 passed to Illuminate\Database\Grammar::columnize() must be of th
e type array, string given, called in /home/vagrant/Site/Laravel/vendor/lar
avel/framework/src/Illuminate/Database/Query/Grammars/Grammar.php on line 1
05 and defined
I don't get it. I thought I was passing a string not an array in the Manufacturer seeder, and that works fine. What am I doing that's so wrong?
class ModelTableSeeder extends Seeder {
public function run()
{
DB::table('models')->delete();
$now = date('Y-m-d H:i:s');
$records = [
['Echo', 'Toyota']
];
for($i = 0; $i < count($records); $i++)
{
DB::table('models')->insert(
array(
'name' => $records[$i][0],
'manufacturer_id' => DB::table('manufacturers')->where('name', '=', $records[$i][1])->get('id'),
'created_at' => $now,
'updated_at' => $now
)
);
}
}
}
That's not working either.
Hi,
I think the problem is the way you use the get method. It's argument should be an array: https://github.com/laravel/framework/blob/4.2/src/Illuminate/Database/Query/Builder.php#L1332
So, try
$records = [
['Echo', DB::table('manufacturers')->where('name', '=', 'Toyota')->get(['id'])]
];
Oh THAT's what the error's referring to! Brilliant thank you
Could definitely have a nicer error message there :)
Ok unfortunately it's still not quite working when I specify id as an array element.
<?php
class ModelTableSeeder extends Seeder {
public function run()
{
DB::table('models')->delete();
$records = [
['Echo', 'Toyota']
];
for($i = 0; $i < count($records); $i++)
{
$manufacturer_id = DB::table('manufacturers')->where('name', '=', $records[$i][1])->get(['id']);
DB::table('models')->insert(
array(
'name' => $records[$i][0],
'manufacturer_id' => $manufacturer_id,
'created_at' => new DateTime,
'updated_at' => new DateTime
)
);
}
}
}
I get this error:
"preg_replace(): Parameter mismatch, pattern is a string while replacement is an array." :(
$records = [['Echo', 'Toyota']];
$manufacturer_id = DB::table('manufacturers')
->where('name', '=', $records[0][1])
->get(['id']);
var_dump($manufacturer_id);
This gives an stdClass and I need to fetch the ID value and convert it to a string. How do I do that? Here's the output:
array (size=1)
0 =>
object(stdClass)[158]
public 'id' => int 2
What I ended up with:
public function run()
{
DB::table('models')->delete();
$records = [
['Echo', 'Toyota']
];
for($i = 0; $i < count($records); $i++)
{
$manufacturer = DB::table('manufacturers')
->where('name', '=', $records[$i][1])
->select('id')->first();
DB::table('models')->insert(
array(
'name' => $records[$i][0],
'manufacturer_id' => $manufacturer->id,
'created_at' => new DateTime,
'updated_at' => new DateTime
)
);
}
}
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast