I have a text file in this format PRA 1:13 2:20 3:5 SRA 1:45 2:75 3:9 TRA 1:2 2:65 3:45 pattern is- Book Chapter:Verses now i have my DB schema like this book_id chapter_id versed_id 1 1 13 1 2 20 1 3 5 2 1 45 2 2 75 2 3 9 3 1 2 3 2 65 3 3 45 I want to write a pyhton script which read the text file and dump to DB could any one give me suggestion