Skip to main content

Translates Django ORM query system to json objects

Project description

json-queries

Nowadays, communication between API infrastructures commonly uses JSON data.

This library aims to emulate the behavior of the Django ORM, exporting such functionality to JSON objects.

Installation

pip install json-queries

Simple case of use

>> import jsonutils as js
   from datetime import datetime

>> json_data = js.JSONObject(
    {
        "data": [
            {
                "name": "Dan",
                "birthday": "1991-01-02 09:00:00",
                "publications": 15
            },
            {
                "name": "Mar",
                "birthday": "1991-03-02 12:30:00",
                "publications": 13
            },
            {
                "name": "Carl",
                "birthday": "1950-06-02 16:00:00",
                "publications": 36
            },
            {
                "name": "Vic",
                "birthday": "1986-07-02 16:00:00",
                "publications": None
            },
        ]
    }
)

# now we can navegate through this object by attribute accesion

>> json_data.data._1.name
    'Mar'

# or we can make queries as django's ORM

>> result = json_data.query(birthday__lt=datetime(1985,1,1))

>> result
    <QuerySet ['1950-06-02 16:00:00']>

>> result.first().parent
    {'name': 'Carl', 'birthday': '1950-06-02 16:00:00', 'publications': 36}

# retrieving the path of a node object

>> result.first().jsonpath
    data/2/

# testing environment

We have developed a Docker container with all the configuration options, modules and variables already setted up, so that you can test the behaviour of the package, just by typing:

```bash build.sh```
Then, on Ipython terminal, you can access `test` variable with some json data, or create new a JSONObject

# executing within docker

```docker build -t json-queries .``` To build the image
```docker run --name json-queries -it json-queries``` To run a new container instance of the image
```docker start json-queries``` To run the container, if it is stopped
```docker exec -it json-queries ipython --profile=template``` Open an Ipython session in a running container

# utils
```docker images -a | tail -n +2 | wc -l``` Count the total number of docker images


Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

json-queries-0.1.16.tar.gz (56.5 kB view details)

Uploaded Source

Built Distribution

json_queries-0.1.16-py3-none-any.whl (62.8 kB view details)

Uploaded Python 3

File details

Details for the file json-queries-0.1.16.tar.gz.

File metadata

  • Download URL: json-queries-0.1.16.tar.gz
  • Upload date:
  • Size: 56.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.1 CPython/3.10.4

File hashes

Hashes for json-queries-0.1.16.tar.gz
Algorithm Hash digest
SHA256 1e147be85f748ae1bcdc51a085d560f99e0276841b3f62c61967e1ea5ba87b40
MD5 27b855545c9230a39adcb5e0dc6b5538
BLAKE2b-256 a15505d8d382e14fd20be2bcf03778724616b0376db476f4d295ff746430ffd5

See more details on using hashes here.

File details

Details for the file json_queries-0.1.16-py3-none-any.whl.

File metadata

File hashes

Hashes for json_queries-0.1.16-py3-none-any.whl
Algorithm Hash digest
SHA256 6efc2f7230a872566a1144e4246998128f21ed4c72644e557b530256c635cba2
MD5 30ad93055d1a54151f263214124d4005
BLAKE2b-256 576720c51f02202701419167649bc07b9b00d32317d5663b76cc5d3b469d909d

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page