text to DB

MRAB python at mrabarnett.plus.com
Fri Aug 13 20:09:55 CEST 2010


Praveen wrote:
> 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

Read through the file a line at a time. For the first line the book_id
is 1, for the second it's 2, etc.

Split each line on whitespace, and then for all but the first entry
(which is a name?) split on the colon to get the chapter_id and
versed_id.

Insert each tuple of (book_id, chapter_id, versed_id) into the DB. You
haven't said what type of DB it is, so I can't help you there. Just read
the documentation.



More information about the Python-list mailing list