def select_parts_by_value(self, val, connection):
''' Return the Part(s) of given value in a list. '''
parts = []
try:
cur = connection.cursor()
sql = 'SELECT * FROM parts WHERE value=? INTERSECT SELECT * FROM parts WHERE project=?'
params = (val, self.name)
for row in cur.execute(sql, params):
parts.append(Part.new_from_row(row, connection, self))
finally:
cur.close()
return parts
def select_parts_by_value(self, val, connection): ''' Return the Part(s) of given value in a list. ''' parts = [] try: cur = connection.cursor() sql = 'SELECT * FROM parts WHERE value=? INTERSECT SELECT * FROM parts WHERE project=?' params = (val, self.name) for row in cur.execute(sql, params): parts.append(Part.new_from_row(row, connection, self)) finally: cur.close() return parts
def select_parts_by_name(self, name, connection):
''' Return the Part(s) of given name. '''
parts = []
try:
cur = connection.cursor()
#sql = 'SELECT * FROM parts WHERE name=? INTERSECT SELECT * FROM parts WHERE project=?'
sql = 'SELECT * FROM parts WHERE name=? AND project=?'
params = (name, self.name)
for row in cur.execute(sql, params):
parts.append(Part.new_from_row(row, connection, self))
finally:
cur.close()
return parts
def select_parts_by_name(self, name, connection): ''' Return the Part(s) of given name. ''' parts = [] try: cur = connection.cursor() #sql = 'SELECT * FROM parts WHERE name=? INTERSECT SELECT * FROM parts WHERE project=?' sql = 'SELECT * FROM parts WHERE name=? AND project=?' params = (name, self.name) for row in cur.execute(sql, params): parts.append(Part.new_from_row(row, connection, self)) finally: cur.close() return parts
def select_parts_by_product(self, prod, connection): ''' Return the Part(s) of given product in a list. ''' parts = [] try: cur = connection.cursor() if prod is None or prod == '' or len(prod) == 0 or prod == 'NULL': sql = 'SELECT * FROM parts WHERE project=? AND product IS NULL' params = (self.name,) else: sql = 'SELECT * FROM parts WHERE product=? AND project=?' params = (prod, self.name,) for row in cur.execute(sql, params): parts.append(Part.new_from_row(row, connection, self)) finally: cur.close() return parts
def select_parts_by_product(self, prod, connection):
''' Return the Part(s) of given product in a list. '''
parts = []
try:
cur = connection.cursor()
if prod is None or prod == '' or len(prod) == 0 or prod == 'NULL':
sql = 'SELECT * FROM parts WHERE project=? AND product IS NULL'
params = (self.name, )
else:
sql = 'SELECT * FROM parts WHERE product=? AND project=?'
params = (
prod,
self.name,
)
for row in cur.execute(sql, params):
parts.append(Part.new_from_row(row, connection, self))
finally:
cur.close()
return parts
