public function run()
{
// FKの無効化
DB::statement('SET FOREIGN_KEY_CHECKS=0;');
DB::table('votes')->truncate();
$faker = Faker::create('en_US');
for ($i = 0; $i < 100; $i++) {
Vote::create(['title' => $faker->sentence(), 'body' => $faker->paragraph(), 'is_published' => rand(0, 1), 'created_at' => Carbon::today()]);
}
// FKを元に戻す
DB::statement('SET FOREIGN_KEY_CHECKS=1;');
}
public function run()
{
// FKの無効化
DB::statement('SET FOREIGN_KEY_CHECKS=0;');
DB::table('choices')->truncate();
$faker = Faker::create('ja_JP');
$votes = Vote::all()->toArray();
foreach ($votes as $key => $vote) {
Choice::create(['chc1' => $faker->sentence(), 'chc2' => $faker->sentence(), 'chc3' => $faker->sentence(), 'chc4' => $faker->sentence(), 'chc5' => $faker->sentence(), "vote_id" => $vote['id'], 'created_at' => Carbon::today(), 'isDispOther' => rand(0, 1)]);
}
// FKを元に戻す
DB::statement('SET FOREIGN_KEY_CHECKS=1;');
}
public function deleteVote($token, $delete_vote_id)
{
$userId = User::select("id")->where("token", "=", $token)->first()['id'];
if (!$userId) {
return \Response::json(["error" => "400", "message" => "invalid token error."]);
}
Log::info("token : {$token}. voteid : {$delete_vote_id}");
$vote = Vote::where('id', '=', $delete_vote_id)->where('user_id', '=', User::where('token', '=', $token)->first()["id"])->first();
if (!$vote) {
return \Response::json(["error" => "400", "message" => "this vote is not exists."]);
}
$vote->delete();
return \Response::json(["status" => "200", "id" => $delete_vote_id]);
}
