Skip to content

Instantly share code, notes, and snippets.

@tnguyen14
Last active February 3, 2022 04:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tnguyen14/d048d3db7c7b70a1ed24b3252e60a296 to your computer and use it in GitHub Desktop.
Save tnguyen14/d048d3db7c7b70a1ed24b3252e60a296 to your computer and use it in GitHub Desktop.
debug: "Executing (644b5306-2046-4631-ba71-4dfea8fc6a45): INSERT INTO `facilities` (`id`,`code`,`name`,`email`,`contact_number`,`street_address`,`city_town`,`division`,`type`,`created_at`,`updated_at`) VALUES ('facility-AdolescentHealthDevelopment','AdolescentHealthDevelopment','Adolescent Health Development',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-BagasauNursingStation','BagasauNursingStation','Bagasau Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-BaHealthCentre','BaHealthCentre','Ba Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-BalevutoHealthCentre','BalevutoHealthCentre','Balevuto Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-BaMissionSub-divisionalHospital','BaMissionSub-divisionalHospital','Ba Mission Sub-divisional Hospital',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-BatikiNursingStation','BatikiNursingStation','Batiki Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-BaulevuNursingStation','BaulevuNursingStation','Baulevu Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-BeqaHealthCentre','BeqaHealthCentre','Beqa Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-BoumaNursingStation','BoumaNursingStation','Bouma Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-BuaNursingStation','BuaNursingStation','Bua Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-BukuyaHealthCentre','BukuyaHealthCentre','Bukuya Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-BuretaHealthCentre','BuretaHealthCentre','Bureta Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-CakovaNursingStation','CakovaNursingStation','Cakova Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-CiciaHealthCentre','CiciaHealthCentre','Cicia Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-CikobiaNursingStation','CikobiaNursingStation','Cikobia Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-ColonialWarMemorialDivisionalHospital','ColonialWarMemorialDivisionalHospital','Colonial War Memorial Divisional Hospital',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-ColonialWarMemorialDivisionalHospital-BreastClinic','ColonialWarMemorialDivisionalHospital-BreastClinic','Colonial War Memorial Divisional Hospital - Breast Clinic',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-ColonialWarMemorialDivisionalHospital-GynaecologyClinic','ColonialWarMemorialDivisionalHospital-GynaecologyClinic','Colonial War Memorial Divisional Hospital - Gynaecology Clinic',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-CoqeloaNursingStation','CoqeloaNursingStation','Coqeloa Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-CuvuHealthCentre','CuvuHealthCentre','Cuvu Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-DaviqeleHealthCentre','DaviqeleHealthCentre','Daviqele Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-DawasamuNursingStation','DawasamuNursingStation','Dawasamu Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-DogotukiNursingStation','DogotukiNursingStation','Dogotuki Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-DravuwaluNursingStation','DravuwaluNursingStation','Dravuwalu Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-DreketiHealthCentre','DreketiHealthCentre','Dreketi Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-FulagaNursingStation','FulagaNursingStation','Fulaga Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-GaloaNursingStation','GaloaNursingStation','Galoa Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-GaseleNursingStation','GaseleNursingStation','Gasele Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-GauHealthCentre','GauHealthCentre','Gau Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-KabaraHealthCentre','KabaraHealthCentre','Kabara Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-KabaraNursingStation','KabaraNursingStation','Kabara Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-KamikamicaHealthCentre','KamikamicaHealthCentre','Kamikamica Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-KavalaHealthCentre','KavalaHealthCentre','Kavala Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-KeiyasiHealthCentre','KeiyasiHealthCentre','Keiyasi Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-KeseHealthCentre','KeseHealthCentre','Kese Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-KiaNursingStation','KiaNursingStation','Kia Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-KidneyDialysisCentre','KidneyDialysisCentre','Kidney Dialysis Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-KioaNursingStation','KioaNursingStation','Kioa Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-KomoNursingStation','KomoNursingStation','Komo Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-KoroHealthCentre','KoroHealthCentre','Koro Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-KorolevuHealthCentre','KorolevuHealthCentre','Korolevu Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-KorotasereHealthCentre','KorotasereHealthCentre','Korotasere Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-KorovisilouHealthCentre','KorovisilouHealthCentre','Korovisilou Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-KorovouHealthCentre','KorovouHealthCentre','Korovou Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-KorovouPrisonStation','KorovouPrisonStation','Korovou Prison Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-KorovouSub-divisionalHospital','KorovouSub-divisionalHospital','Korovou Sub-divisional Hospital',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-KubulauNursingStation','KubulauNursingStation','Kubulau Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LabasaDivisionalHospital','LabasaDivisionalHospital','Labasa Divisional Hospital',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LabasaGoldenAgeHome','LabasaGoldenAgeHome','Labasa Golden Age Home',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LabasaHealthCentre','LabasaHealthCentre','Labasa Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LabassHealthCentre','LabassHealthCentre','Labass Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LagiHealthCentre','LagiHealthCentre','Lagi Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LakebaHealthCentre','LakebaHealthCentre','Lakeba Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LakebaSub-divisionalHospital','LakebaSub-divisionalHospital','Lakeba Sub-divisional Hospital',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LamiHealthCentre','LamiHealthCentre','Lami Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LaselevuHealthCentre','LaselevuHealthCentre','Laselevu Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LautokaDivisionalHospital','LautokaDivisionalHospital','Lautoka Divisional Hospital',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LautokaHealthCentre','LautokaHealthCentre','Lautoka Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LautokaHubCentre','LautokaHubCentre','Lautoka Hub Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LekutuHealthCentre','LekutuHealthCentre','Lekutu Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LevukaHealthCentre','LevukaHealthCentre','Levuka Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-Levuka-I-DakuNursingStation','Levuka-I-DakuNursingStation','Levuka-I-Daku Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LevukaSub-divisionalHospital','LevukaSub-divisionalHospital','Levuka Sub-divisional Hospital',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LodoniHealthCentre','LodoniHealthCentre','Lodoni Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LomaivunaNursingStation','LomaivunaNursingStation','Lomaivuna Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LomalomaHealthCentre','LomalomaHealthCentre','Lomaloma Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LomalomaSub-divisionalHospital','LomalomaSub-divisionalHospital','Lomaloma Sub-divisional Hospital',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LomaNursingStation','LomaNursingStation','Loma Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-LomawaiHealthCentre','LomawaiHealthCentre','Lomawai Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-MakoiBirthingUnit','MakoiBirthingUnit','Makoi Birthing Unit',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-MakoiHealthCentre','MakoiHealthCentre','Makoi Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-MaloloHealthCentre','MaloloHealthCentre','Malolo Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-MataikaHouse','MataikaHouse','Mataika House',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-MatukuHealthCentre','MatukuHealthCentre','Matuku Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-MoalaHealthCentre','MoalaHealthCentre','Moala Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-MoceNursingStation','MoceNursingStation','Moce Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-MokaniHealthCentre','MokaniHealthCentre','Mokani Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-MomiHealthCentre','MomiHealthCentre','Momi Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-MoturikiNursingStation','MoturikiNursingStation','Moturiki Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-MualevuNursingStation','MualevuNursingStation','Mualevu Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-MuanikauHealthCentre','MuanikauHealthCentre','Muanikau Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-NabalebaleNursingStation','NabalebaleNursingStation','Nabalebale Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-NabasoviNursingStation','NabasoviNursingStation','Nabasovi Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-NabobucoNursingStation','NabobucoNursingStation','Nabobuco Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-NaboroNursingStation','NaboroNursingStation','Naboro Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-NaboubucoNursingStation','NaboubucoNursingStation','Naboubuco Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-NabouNursingStation','NabouNursingStation','Nabou Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-NabouwaluHealthCentre','NabouwaluHealthCentre','Nabouwalu Health Centre',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-NabouwaluSub-divisionalHospital','NabouwaluSub-divisionalHospital','Nabouwalu Sub-divisional Hospital',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00'),('facility-NacamakiNursingStation','NacamakiNursingStation','Nacamaki Nursing Station',NULL,NULL,NULL,NULL,NULL,NULL,'2022-02-03 04:09:06.780 +00:00','2022-02-03 04:09:06.780 +00:00');"; -- []
debug: 'Executing (644b5306-2046-4631-ba71-4dfea8fc6a45): ROLLBACK;'; -- []
error: ScheduledTask: SyncTask: Failed (id=51bf1f73-5c80-4831-be49-2b41b8cf326b)
error: SequelizeUniqueConstraintError: Validation error
at Query.formatError (/home/tri/github/beyondessential/tamanu/node_modules/sequelize/lib/dialects/sqlite/query.js:416:16)
at Query._handleQueryResponse (/home/tri/github/beyondessential/tamanu/node_modules/sequelize/lib/dialects/sqlite/query.js:73:18)
at Statement.afterExecute (/home/tri/github/beyondessential/tamanu/node_modules/sequelize/lib/dialects/sqlite/query.js:250:31)
at Statement.replacement (/home/tri/github/beyondessential/tamanu/node_modules/sqlite3/lib/trace.js:19:31)
at Statement.callbackTrampoline (internal/async_hooks.js:126:14)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment