Database Programming

[lexberezhny]

hi,
  You can use the 'for' loop:

for item in table:
    database.query('INSERT INTO format_prices
(time,open,high,low,close,volume) VALUES
('+item[0]+','+item[1]+','+item[2]+','+item[3]+','+item[4]+','+item[5]+')')

I hope this helps.
 - lex



----- Original Message -----
From: Arnaldo Riquelme <javanet at dynacap.com>
Newsgroups: comp.lang.python
Sent: Tuesday, May 02, 2000 6:54 PM
Subject: Database Programming


> I'm very new to Python, and I've been playing with it quite a bit.
> Most of the stuff I've done includes lots of SQL and C shell staff.
>
> I have a tab delimitted file that looks like this ( foo.prn)
> =========================================================
> 19990222      86.8750      88.1250      86.6250      87.9375    24994
> 19990223      87.6875      87.8750      86.6250      87.3750    16288
> 19990224      87.0000      87.6875      85.7500      85.7500    18013
> 19990225      84.7500      85.0000      83.3750      84.4375    25336
> =========================================================
>
> I want to insert this file to database table called  format_prices with
> fields (time,open,high,low,close,volume)
> I'm using mxODBC module in win32.
>
> I created a function that reads the file and puts the contents into a list
> ======================================================
> def read_his_file(s):
>  #make sure we are in the d:\__newstocks__ directory
>  import os, string, sys
>  os.chdir("d:\__newstocks__")
>  lines = open(s).readlines()
>
>  #get rid of new line character and white spaces
>  lines = map(string.split, lines)
>  table = []
>
>  #get rid of the header
>  lines = lines[1:]
>  for i in lines:
>   prn = i[:-1]
>   table.append(prn)
>
>  return table
>  =======================================================
>
> Now I get this list [['19990222', '86.8750', '88.1250', '86.6250',
> '87.9375', '24994'].......]
>
> How do I loop thru the list and insert the date into format_prices?
> Is there some docs or tutorial that talks about issues like manipulating
> database with python.?
>
> In advance ,thanks a lot for all your help.
>
>
> Arnaldo
>
>
>