/** * Run the database seeds. * * @return void */ public function run() { // if (App::environment() === 'production') { exit('Do not seed in production environment'); } DB::statement('SET FOREIGN_KEY_CHECKS = 0'); // disable foreign key constraints DB::table('option_groups')->truncate(); OptionGroup::create(['id' => 1, 'name' => 'Habit Status', 'sectionId' => 1]); OptionGroup::create(['id' => 2, 'name' => 'Food Preferences', 'sectionId' => 1]); OptionGroup::create(['id' => 3, 'name' => 'Non-Veg Foods', 'sectionId' => 1]); OptionGroup::create(['id' => 4, 'name' => 'Junk Foods', 'sectionId' => 1]); OptionGroup::create(['id' => 5, 'name' => 'Chronic Diseases', 'sectionId' => 2]); OptionGroup::create(['id' => 6, 'name' => 'Menstural Information', 'sectionId' => 4]); OptionGroup::create(['id' => 7, 'name' => 'Familiy Planning Methods', 'sectionId' => 4]); OptionGroup::create(['id' => 8, 'name' => 'Clinical Investigations', 'sectionId' => 4]); OptionGroup::create(['id' => 9, 'name' => 'Feeding Methods', 'sectionId' => 4]); DB::statement('SET FOREIGN_KEY_CHECKS = 1'); // enable foreign key constraints }
public function addOptionGroup(Request $request) { $optionGroup['name'] = $request->input('name'); $optionGroup['sectionId'] = $request->input('sectionId'); try { $result = OptionGroup::create($optionGroup); } catch (\Exception $e) { return response()->json(['error' => ['message' => 'Could not save optionGroup' . $e->getMessage(), 'code' => 101]]); } return response()->json(['optionGroup' => $result]); }