PySQLite Table indexing inside a functions
Kevin
kmcbrearty at yahoo.com
Thu Dec 2 17:29:52 EST 2004
Hello Everyone,
I'm using PySQLite and would like to index this insert
statement with the 'tablename'. Can anyone offer a
suggestion?
Also, this is a shot in the dark. Has anyone done
anything with nested fields. I would like each vertex
to have 3 points. currently, I'm just making 3
fields.
Regards,
Kevin
def PARSE2DB(data,tablename):
i = j = k = 0
cadu = GETdb().cursor()
FacetNum = len(data [1])
while i < FacetNum:
cadu.execute("""
insert into table = 'tablename'( V1_x, V1_y, V1_z,
V2_x, V2_y, V2_z,
V3_x, V3_y, V3_z, N_x, N_y, N_z)
values(%f, %f, %f, %f, %f, %f, %f, %f, %f, %f,
%f, %f)
""",
(data [1][i][1][0][0], data [1][i][1][0][1],data
[1][i][1][0][2],
data [1][i][1][1][0], data [1][i][1][1][1],data
[1][i][1][1][2],
data [1][i][1][2][0], data
[1][i][1][2][1],data [1][i][1][2][2],
data [1][i][0][0], data
[1][i][0][1], data [1][i][0][2])
)
i = i + 1
return
__________________________________
Do you Yahoo!?
All your favorites on one personal page Try My Yahoo!
http://my.yahoo.com
More information about the Python-list
mailing list