def get_product(product_id, lang='ru'): conn = sqlite3.connect(PRODUCTS_DATABASE_PATH) cur = conn.cursor() cur.execute("SELECT * FROM product WHERE id = ?", (product_id, )) product_sql_tpl = cur.fetchone() cproduct = Product() cproduct.id = product_id cproduct.name = get_name(product_id, lang) cproduct.description = get_description(product_id, lang) cproduct.dimension = get_dimension(product_sql_tpl[1], lang) cproduct.default_amount = product_sql_tpl[2] cproduct.image_filename = product_sql_tpl[3] cproduct.price = product_sql_tpl[4] conn.close() return cproduct