python AttributeError 'dict' object has no attribute

Question

I get following error:

AttributeError at /filterrule/createresultset/
'dict' object has no attribute 'filter_query_json'

Here's the code:

from django.db import connections

def fetch_filter_rule_sql_from_ui_db(filter_rule_id):
    with connections['frontend'].cursor() as cursor:
        query = "SELECT id, filter_query_json FROM dmf_filter_rules WHERE id=%s LIMIT 1"
        cursor.execute(query, [filter_rule_id])
        filter_rule_sql_json = dictfetchall(cursor)[0].filter_query_json
        # filter_rule_sql_json = dictfetchall(cursor)[0][filter_query_json]
        return filter_rule_sql_json

def dictfetchall(cursor):
    "Return all rows from a cursor as a dict"
    columns = [col[0] for col in cursor.description]
    return [
        dict(zip(columns, row))
        for row in cursor.fetchall()
    ]

The output to dictfetchall(cursor)[0] is:

{
    "id": 1,
    "filter_query_json": "{\"request_id\":\"341\",\"match_status\":\"1\",\"verdict\":\"Non Match\",\"matched\":\"s_vs_r_image_class_match\"}"
}

Object looks fine to me and I confirmed the filter_query_json attribute too.

What is missing?

@roganjosh i meant inside the output object : filter_query_json — Azima
– Azima, Commented May 25, 2020 at 10:55

Paul · Accepted Answer · 2023-04-02 10:13:32Z

2

You can only get the straight value if the object is the built-in dict type. To fix this, the solution can be

filter_rule_sql_json = dictfetchall(cursor)[0].get('filter_query_json')

If your key filter_query_json does not exist, the method .get(key) would return None.

edited Apr 2, 2023 at 10:13

Paul

3703 silver badges14 bronze badges

answered May 25, 2020 at 10:47

Tuan

941 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Amir · Accepted Answer · 2020-05-25 10:48:50Z

1

change your line to filter_rule_sql_json = dictfetchall(cursor)[0]['filter_query_json']

athough I would recommend using django's database api rather than writing raw sql queries

answered May 25, 2020 at 10:48

Amir

2,1111 gold badge15 silver badges11 bronze badges

Collectives™ on Stack Overflow

python AttributeError 'dict' object has no attribute

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related