from django.db import models
from django.db.models import Q
from django.core import serializers


class Product(models.Model):
    categories = models.ManyToManyField(Category,
                                        related_name='products',
                                        blank=True, verbose_name=u"категории")
    related_products = models.ManyToManyField('Product',
                                              blank=True,
                                              verbose_name="связанные продукты")

    sku = models.CharField(u'артикул', max_length=128, validators=[validators.check_bad_symbols], unique=True)

    price = models.DecimalField(u'цена', max_digits=12, decimal_places=4)

    slug = models.SlugField(u'slug', max_length=80, db_index=True, unique=True)

    name = models.CharField(u'название', max_length=128)
    title = models.CharField(u'заголовок страницы (<title>)', max_length=256, blank=True)
    description = models.TextField(u'описание', blank=True)

def live_search(request, template_name="shop/livesearch_results.html"):
    q = request.GET.get("q", "")
    query = Product.objects.filter(
        Q(sku__contains=q) |
        Q(name__contains=q) |
        Q(description__contains=q))
    data = serializers.serialize("json", query)
    return data