I have a SQL function that works when I run it directly from an SQL script
and now I'm trying to run it with Manager.raw() in a model method. I wrote
a model instance method that worked fine:
def get_store_products_sql(self) -> list['Product']:
return Product.objects.raw(
'''SELECT prod_id AS id,
prod_name,
prod_price
FROM get_store_products(%s)''',
[self.id]
)
Now I'm trying to write a similar class method:
@classmethod
def get_products_by_color_sql(cls, color) -> list['Product']:
return Product.objects.raw(
'''SELECT prod_id AS id,
prod_name,
prod_price
FROM
get_products_by_color(%s)''',
[color]
)
This fails pretty silently without even entering
get_products_by_color(). color is a legal string and I've also tried simply
using "green" without any luck.
As I said, this isn't even getting into the get_products_by_color()
function, so I doubt that's the problem. It appears to be either a problem
with calling Manager.raw() in a class method or a problem with the color
string.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CALLzXtQ2a4wd4O69OSL1jEo1YNAuSQCPTJ%2B2LayqGYJ5kUsOHA%40mail.gmail.com.
