Stock and Type are no longer updated

[Bouni]

This issue was introduced by #503

get_part_details no longer yield any results

kicad-jlcpcb-tools/library.py

Lines 384 to 398 in ec4aee0

	def get_part_details(self, lcsc):
	"""Get the part details for a list of LCSC numbers using optimized FTS5 querying."""
	with contextlib.closing(sqlite3.connect(self.partsdb_file)) as con:
	con.row_factory = sqlite3.Row # To access columns by names
	cur = con.cursor()
	results = []
	query = '''SELECT "LCSC Part", "Stock", "Library Type" FROM parts WHERE parts MATCH ?'''
	# Use parameter binding to prevent SQL injection and handle the query more efficiently
	for number in lcsc:
	# Each number needs to be wrapped in double quotes for exact match in FTS5
	match_query = f'"LCSC Part:{number}"'
	cur.execute(query, (match_query,))
	results.extend(cur.fetchall())
	return results