read logfile and insert in DB (bash script preferably or python)

I need a script that will pull specific data from a log file and insert into a predefined db. The script must run as a service (Ubuntu 18.04.2 LTS machine) and watch the log file since it`s constantly changes. *log file : Wed Jun 12 09:30:10 2019 876278: DEBUG: Test queues: LA|DA190612|TI093010| *Wed Jun 12 09:30:14 2019 537525: DEBUG: Test read: GO|G#253092|RN701| Wed Jun 12 09:31:10 2019 594615: DEBUG: Test queues: LA|DA190612|TI093110| Wed Jun 12 09:41:10 2019 142193: DEBUG: Test queues: LA|DA190612|TI094110| *Wed Jun 12 09:41:58 2019 862996: DEBUG: Test read: GI|G#264446|RN617|GNFirst:Loreipsum1,Last:Loreipsum2,Email:loreipsum@[login to view URL],Phone:8001112222,Checkin:12-JUN-2019| Wed Jun 12 09:42:10 2019 877281: DEBUG: Test queues: LA|DA190612|TI094210| *dictionary: GO -> Guest Out LA -> Link active GI -> Guest In * db row and column will look like this: | Room | First Name | Last Name | Email | Phone | Misc1 | Misc2 | Misc3 | * when the below data will appear in log file the script needs to alter the table for Room 701 and insert 'vacant' on all the rows. The trigger for alter table to insert 'vacant' is the word 'GO' from the log line. Wed Jun 12 09:30:14 2019 537525: DEBUG: Test read: GO|G#253092|RN701| * when the below data will appear in the log the script must alter the table for Room 617 and insert the values that are specified as: GNFirst:Loreipsum1 -> First Name * result Loreipsum1 Last:Loreipsum2 -> Last Name * db result Loreipsum2 and so on. Wed Jun 12 09:41:58 2019 862996: DEBUG: Test read: GI|G#264446|RN617|GNFirst:Loreipsum1GNFirst:Loreipsum2GNFirst:loreipsum@[login to view URL],Phone:8001112222,Checkin:12-JUN-2019| the log input might be missing some fields sometimes or be under a different format, like no email is mentioned or the phone number is under a different format. The definition will always be the same as: RN GNFirst: GNFirst: GNFirst: Phone: