atsuya046/query.py

Created December 20, 2013 11:17

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/atsuya046/8053450.js"></script>
Save atsuya046/8053450 to your computer and use it in GitHub Desktop.

Download ZIP

sqliteのクエリを組み立てるとき、配列の長さの分だけ"?"を作る

Raw

	for row in csv.reader(data):
	params = ', '.join(map(lambda s: '?', row))
	c.execute('''insert into %s values (%s) ''' % (table_name, params), row)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment