In [37]:

    

import os
import django

os.environ.setdefault("DJANGO_SETTINGS_MODULE", "mfiles_project.settings.local")
from django.conf import settings
django.setup()


    

In [38]:

    

from mfiles_sync.models import *
import mfiles_docs.models as dm


    

In [39]:

    

docs = Document.objects.filter(properties__pdef__name='Language',properties__txt_value='English')


    

In [40]:

    

d = docs[0]


    

    




DEBUG:django.db.backends:(0.000) QUERY = 'SELECT "mfmeta_doc"."id", "mfmeta_doc"."vault_id", "mfmeta_doc"."mfiles_id", "mfmeta_doc"."name", "mfmeta_doc"."ext", "mfmeta_doc"."size", "mfmeta_doc"."created", "mfmeta_doc"."modified" FROM "mfmeta_doc" INNER JOIN "mfmeta_docprop" ON ( "mfmeta_doc"."id" = "mfmeta_docprop"."doc_id" ) INNER JOIN "mfmeta_prop" ON ( "mfmeta_docprop"."prop_id" = "mfmeta_prop"."id" ) INNER JOIN "mfmeta_propdef" ON ( "mfmeta_prop"."pdef_id" = "mfmeta_propdef"."id" ) WHERE ("mfmeta_propdef"."name" = %s AND "mfmeta_prop"."txt_value" = %s) LIMIT 1' - PARAMS = ('Language', 'English'); args=('Language', 'English')

In [43]:

    

dm.Document.objects.get(pk=1)


    

    




DEBUG:django.db.backends:(0.000) QUERY = 'SELECT "mfdoc_doc"."id", "mfdoc_doc"."mfiles_id", "mfdoc_doc"."vault", "mfdoc_doc"."un_number", "mfdoc_doc"."date_publication", "mfdoc_doc"."date_last_update", "mfdoc_doc"."period_start", "mfdoc_doc"."period_end", "mfdoc_doc"."copyright", "mfdoc_doc"."author", "mfdoc_doc"."meeting", "mfdoc_doc"."programmes", "mfdoc_doc"."country" FROM "mfdoc_doc" WHERE "mfdoc_doc"."id" = %s LIMIT 21' - PARAMS = (1,); args=(1,)






    




---------------------------------------------------------------------------
DoesNotExist                              Traceback (most recent call last)
<ipython-input-43-1951e06fa1d6> in <module>()
----> 1 dm.Document.objects.get(pk=1)
      2 

/Users/amazurov/Dev/mfiles_project/venv/lib/python3.4/site-packages/django/db/models/manager.py in manager_method(self, *args, **kwargs)
     90         def create_method(name, method):
     91             def manager_method(self, *args, **kwargs):
---> 92                 return getattr(self.get_queryset(), name)(*args, **kwargs)
     93             manager_method.__name__ = method.__name__
     94             manager_method.__doc__ = method.__doc__

/Users/amazurov/Dev/mfiles_project/venv/lib/python3.4/site-packages/django/db/models/query.py in get(self, *args, **kwargs)
    355             raise self.model.DoesNotExist(
    356                 "%s matching query does not exist." %
--> 357                 self.model._meta.object_name)
    358         raise self.model.MultipleObjectsReturned(
    359             "get() returned more than one %s -- it returned %s!" % (

DoesNotExist: Document matching query does not exist.

In [ ]:

    

d.property("Language")