public function run()
{
//Seed for drugs
$penicillin = Drug::create(array('name' => "PENICILLIN"));
$ampicillin = Drug::create(array('name' => "AMPICILLIN"));
$clindamycin = Drug::create(array('name' => "CLINDAMYCIN"));
$tetracycline = Drug::create(array('name' => "TETRACYCLINE"));
$ciprofloxacin = Drug::create(array('name' => "CIPROFLOXACIN"));
$trimeth = Drug::create(array('name' => "TRIMETHOPRIM/SULFA"));
$nitrofurantoin = Drug::create(array('name' => "NITROFURANTOIN"));
$chloramphenicol = Drug::create(array('name' => "CHLORAMPHENICOL"));
$cefazolin = Drug::create(array('name' => "CEFAZOLIN"));
$gentamicin = Drug::create(array('name' => "GENTAMICIN"));
$amoxicillin = Drug::create(array('name' => "AMOXICILLIN-CLAV"));
$cephalothin = Drug::create(array('name' => "CEPHALOTHIN"));
$cefuroxime = Drug::create(array('name' => "CEFUROXIME"));
$cefotaxime = Drug::create(array('name' => "CEFOTAXIME"));
$piperacillin = Drug::create(array('name' => "PIPERACILLIN"));
$cefixime = Drug::create(array('name' => "CEFIXIME"));
$ceftazidime = Drug::create(array('name' => "CEFTAZIDIME"));
$cefriaxone = Drug::create(array('name' => "CEFRIAXONE"));
$levofloxacin = Drug::create(array('name' => "LEVOFLOXACIN"));
$merodenem = Drug::create(array('name' => "MERODENEM"));
$tazo = Drug::create(array('name' => "PIPERACILLIN/TAZO"));
$imedenem = Drug::create(array('name' => "IMEDENEM"));
$oxacillin = Drug::create(array('name' => "OXACILLIN (CEFOXITIN)"));
$erythromycin = Drug::create(array('name' => "ERYTHROMYCIN"));
$vancomycin = Drug::create(array('name' => "VANCOMYCIN"));
$cefoxitin = Drug::create(array('name' => "CEFOXITIN"));
$tobramycin = Drug::create(array('name' => "TOBRAMYCIN"));
$sulbactam = Drug::create(array('name' => "AMPICILLIN-SULBACTAM"));
$this->command->info('Drugs table seeded');
//Seed for organisims
$staphylococci = Organism::create(array('name' => "Staphylococci species"));
$gramnegative = Organism::create(array('name' => "Gram negative cocci"));
$pseudomonas = Organism::create(array('name' => "Pseudomonas aeruginosa"));
$enterococcus = Organism::create(array('name' => "Enterococcus species"));
$pneumoniae = Organism::create(array('name' => "Streptococcus pneumoniae"));
$streptococcus = Organism::create(array('name' => "Streptococcus species viridans group"));
$beta = Organism::create(array('name' => "Beta-haemolytic streptococci"));
$haemophilus = Organism::create(array('name' => "Haemophilus influenzae"));
$naisseria = Organism::create(array('name' => "Naisseria menengitidis"));
$salmonella = Organism::create(array('name' => "Salmonella species"));
$shigella = Organism::create(array('name' => "Shigella"));
$vibrio = Organism::create(array('name' => "Vibrio cholerae"));
$grampositive = Organism::create(array('name' => "Gram positive cocci"));
$this->command->info('Organisms table seeded');
// Seed for organism_drugs
// Staphylococci species
DB::table('organism_drugs')->insert(array("organism_id" => $staphylococci->id, "drug_id" => $penicillin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $staphylococci->id, "drug_id" => $oxacillin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $staphylococci->id, "drug_id" => $cefoxitin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $staphylococci->id, "drug_id" => $erythromycin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $staphylococci->id, "drug_id" => $clindamycin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $staphylococci->id, "drug_id" => $trimeth->id));
DB::table('organism_drugs')->insert(array("organism_id" => $staphylococci->id, "drug_id" => $cefazolin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $staphylococci->id, "drug_id" => $cephalothin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $staphylococci->id, "drug_id" => $chloramphenicol->id));
DB::table('organism_drugs')->insert(array("organism_id" => $staphylococci->id, "drug_id" => $nitrofurantoin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $staphylococci->id, "drug_id" => $tetracycline->id));
DB::table('organism_drugs')->insert(array("organism_id" => $staphylococci->id, "drug_id" => $vancomycin->id));
$this->command->info('Staphylococci species seeded');
// Gram negative cocci
DB::table('organism_drugs')->insert(array("organism_id" => $gramnegative->id, "drug_id" => $ampicillin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $gramnegative->id, "drug_id" => $cefazolin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $gramnegative->id, "drug_id" => $gentamicin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $gramnegative->id, "drug_id" => $amoxicillin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $gramnegative->id, "drug_id" => $cephalothin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $gramnegative->id, "drug_id" => $cefuroxime->id));
DB::table('organism_drugs')->insert(array("organism_id" => $gramnegative->id, "drug_id" => $cefotaxime->id));
DB::table('organism_drugs')->insert(array("organism_id" => $gramnegative->id, "drug_id" => $ciprofloxacin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $gramnegative->id, "drug_id" => $trimeth->id));
DB::table('organism_drugs')->insert(array("organism_id" => $gramnegative->id, "drug_id" => $nitrofurantoin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $gramnegative->id, "drug_id" => $chloramphenicol->id));
DB::table('organism_drugs')->insert(array("organism_id" => $gramnegative->id, "drug_id" => $tetracycline->id));
$this->command->info('Gram negative cocci seeded');
// Pseudomonas aeruginosa
DB::table('organism_drugs')->insert(array("organism_id" => $pseudomonas->id, "drug_id" => $ceftazidime->id));
DB::table('organism_drugs')->insert(array("organism_id" => $pseudomonas->id, "drug_id" => $gentamicin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $pseudomonas->id, "drug_id" => $tobramycin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $pseudomonas->id, "drug_id" => $piperacillin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $pseudomonas->id, "drug_id" => $ciprofloxacin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $pseudomonas->id, "drug_id" => $merodenem->id));
DB::table('organism_drugs')->insert(array("organism_id" => $pseudomonas->id, "drug_id" => $tazo->id));
$this->command->info('Pseudomonas aeruginosa seeded');
// Enterococcus species
DB::table('organism_drugs')->insert(array("organism_id" => $enterococcus->id, "drug_id" => $ampicillin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $enterococcus->id, "drug_id" => $gentamicin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $enterococcus->id, "drug_id" => $nitrofurantoin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $enterococcus->id, "drug_id" => $ciprofloxacin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $enterococcus->id, "drug_id" => $tetracycline->id));
DB::table('organism_drugs')->insert(array("organism_id" => $enterococcus->id, "drug_id" => $chloramphenicol->id));
DB::table('organism_drugs')->insert(array("organism_id" => $enterococcus->id, "drug_id" => $vancomycin->id));
$this->command->info('Enterococcus species seeded');
// Streptococcus pneumoniae
DB::table('organism_drugs')->insert(array("organism_id" => $pneumoniae->id, "drug_id" => $penicillin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $pneumoniae->id, "drug_id" => $cefriaxone->id));
DB::table('organism_drugs')->insert(array("organism_id" => $pneumoniae->id, "drug_id" => $cefuroxime->id));
DB::table('organism_drugs')->insert(array("organism_id" => $pneumoniae->id, "drug_id" => $erythromycin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $pneumoniae->id, "drug_id" => $trimeth->id));
DB::table('organism_drugs')->insert(array("organism_id" => $pneumoniae->id, "drug_id" => $chloramphenicol->id));
DB::table('organism_drugs')->insert(array("organism_id" => $pneumoniae->id, "drug_id" => $tetracycline->id));
DB::table('organism_drugs')->insert(array("organism_id" => $pneumoniae->id, "drug_id" => $levofloxacin->id));
$this->command->info('Streptococcus pneumoniae seeded');
// Streptococcus species viridans group
DB::table('organism_drugs')->insert(array("organism_id" => $streptococcus->id, "drug_id" => $penicillin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $streptococcus->id, "drug_id" => $cefriaxone->id));
DB::table('organism_drugs')->insert(array("organism_id" => $streptococcus->id, "drug_id" => $vancomycin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $streptococcus->id, "drug_id" => $chloramphenicol->id));
DB::table('organism_drugs')->insert(array("organism_id" => $streptococcus->id, "drug_id" => $clindamycin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $streptococcus->id, "drug_id" => $erythromycin->id));
$this->command->info('Streptococcus species viridans group seeded');
// Beta-haemolytic streptococci
DB::table('organism_drugs')->insert(array("organism_id" => $beta->id, "drug_id" => $penicillin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $beta->id, "drug_id" => $erythromycin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $beta->id, "drug_id" => $clindamycin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $beta->id, "drug_id" => $cefriaxone->id));
DB::table('organism_drugs')->insert(array("organism_id" => $beta->id, "drug_id" => $chloramphenicol->id));
DB::table('organism_drugs')->insert(array("organism_id" => $beta->id, "drug_id" => $vancomycin->id));
$this->command->info('Beta-haemolytic streptococci seeded');
// Haemophilus influenzae
DB::table('organism_drugs')->insert(array("organism_id" => $haemophilus->id, "drug_id" => $ampicillin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $haemophilus->id, "drug_id" => $trimeth->id));
DB::table('organism_drugs')->insert(array("organism_id" => $haemophilus->id, "drug_id" => $sulbactam->id));
DB::table('organism_drugs')->insert(array("organism_id" => $haemophilus->id, "drug_id" => $cefriaxone->id));
DB::table('organism_drugs')->insert(array("organism_id" => $haemophilus->id, "drug_id" => $chloramphenicol->id));
$this->command->info('Haemophilus influenzae seeded');
// Naisseria menengitidis
DB::table('organism_drugs')->insert(array("organism_id" => $naisseria->id, "drug_id" => $penicillin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $naisseria->id, "drug_id" => $cefriaxone->id));
DB::table('organism_drugs')->insert(array("organism_id" => $naisseria->id, "drug_id" => $chloramphenicol->id));
$this->command->info('Neisseria menengitidis seeded');
// Salmonella species
DB::table('organism_drugs')->insert(array("organism_id" => $salmonella->id, "drug_id" => $ampicillin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $salmonella->id, "drug_id" => $ciprofloxacin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $salmonella->id, "drug_id" => $trimeth->id));
$this->command->info('Salmonella species seeded');
// Shigella
DB::table('organism_drugs')->insert(array("organism_id" => $shigella->id, "drug_id" => $ampicillin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $shigella->id, "drug_id" => $ciprofloxacin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $shigella->id, "drug_id" => $trimeth->id));
$this->command->info('Shigella seeded');
// Vibrio cholerae
DB::table('organism_drugs')->insert(array("organism_id" => $vibrio->id, "drug_id" => $ampicillin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $vibrio->id, "drug_id" => $ciprofloxacin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $vibrio->id, "drug_id" => $trimeth->id));
$this->command->info('Vibrio cholerae seeded');
// Gram positive cocci
DB::table('organism_drugs')->insert(array("organism_id" => $grampositive->id, "drug_id" => $cefoxitin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $grampositive->id, "drug_id" => $clindamycin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $grampositive->id, "drug_id" => $erythromycin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $grampositive->id, "drug_id" => $oxacillin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $grampositive->id, "drug_id" => $penicillin->id));
DB::table('organism_drugs')->insert(array("organism_id" => $grampositive->id, "drug_id" => $tetracycline->id));
DB::table('organism_drugs')->insert(array("organism_id" => $grampositive->id, "drug_id" => $trimeth->id));
DB::table('organism_drugs')->insert(array("organism_id" => $grampositive->id, "drug_id" => $vancomycin->id));
$this->command->info('Gram positive cocci seeded');
}
