one thing i like about django and python in general is that i can read
to the source code very easy and come up with some sort of a solution.
the reason i want to keep it a queryset is that i want to perform a
filter even further.
i have come up with a rather simple solution but ineficient. the sql
query is this:
class CustomQuery(sql.Query):
"""
Temporary QuerySet used for making a custom sql that can't be done
in the
ordinary way.
"""
def __init__(self, model, connection, first_value, second_value,
detail_id, where=WhereNode):
# sql.Query.__init__(self, model, connection, where=WhereNode )
super(CustomQuery, self).__init__(model, connection,
where=WhereNode)
self.first_value = first_value
self.second_value = second_value
self.detail_id = detail_id
def as_sql(self, with_limits=True, with_col_aliases=False):
return ('select "products_product"."id",
"products_product"."category_id", "products_product"."product_name",
"products_product"."description", "products_product"."code",
"products_product"."price", "products_product"."stock",
"products_product"."warranty", "products_product"."measuring_unit_id",
"products_product"."vat_code_id", "products_product"."deleted" FROM
"products_product" JOIN "products_productdetails" ON
("products_product"."id" = "products_productdetails"."product_id")
WHERE ("products_productdetails"."detail_id" = %s and
"products_productdetails"."detail_value" SIMILAR TO %s AND cast
("products_productdetails"."detail_value" AS Integer) > %s AND cast
("products_productdetails"."detail_value" AS Integer) <%s )',
(self.detail_id,'[1 2 3 4 5 6 7 8 9 0]+', self.first_value,
self.second_value))
i give this custom query to the existing products queryset and all is
well except that i can't to another filter on this... probably because
as_sql is a hard coded function.. :)) at least i have tried.... hope
you can help
and the question:
"You say you can't change the
field type to something numeric type because have to store "anything"
in
that field, but what do you expect to happen in the filter if
detail_value is "elephant", say? "
it is actually exactly what i want to do. if it's a "elephant" i have
to deal with the situation :)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
