text to DB

Praveen praveen.python.plone at gmail.com
Fri Aug 13 18:46:34 CEST 2010


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



More information about the Python-list mailing list