sqlite ][ where절 사용 해보기

sqlite ][ where절 사용 해보기

■ 사용법

	#
	# write by kyoung chip , jang
	# python 2.7
	#
	import os
	import sys
	import sqlite3
	def select_db_for_where( dbfile, where_val ) :
	conn = sqlite3.connect( dbfile )
	curr = conn.cursor()
	exp = """SELECT * FROM balance WHERE address = '%s'"""% where_val
	curr.execute( exp )
	for j in curr :
	yield j[0] , j[1] , j[2]
	curr.close()
	if __name__ == '__main__':
	for addr , val , height in select_db_for_where( './0x01-add-db/test.jdb' , '13Q6u4oeRbXufrSwckgTJjEQV4x5AGex8r' ) :
	print(" \n\raddr = %s " % addr )

view raw gistfile1.txt hosted with ❤ by GitHub