Update a value of a column through django orm

Question

I'm trying to update a column value through django model, backed legacy db is postgressql, the column in db is defined as: "numbers integer[] NOT NULL" in my django application's models.py i have the column as : "numbers = ArrayField(models.IntegerField())" in the code i'm trying to update as below:

user = class_name.objects.using('default').get(id=14)
user.numbers = number # here value number is a list
user.save()

this part of code is inside try and exception block i'm not seeing any errors but the save() part is not executing i.e code stops there not going to next lines

view function:

def test(number,value):
try:

user = classname.objects.using('default').get(id=value)
user.numbers = number
user.save()
return Response ({"status": "Success","statusCode": "200",
                                "statusMessage" : "role%s added to user account %s successfully." %((role),(value))},status=status.HTTP_200_OK)
except Exception as e:
logger.error("An error occurred while updating the roles, Error :%s,Reason:%s",str(e),e_msg,extra={'jobid':job_id})
                return Response({"status": "Failure", "statusCode" : "500", "statusMessage": str(e)},                          status=status.HTTP_500_INTERNAL_SERVER_ERROR)

Where is your numbers list in the view, check it's print(type(numbers)) and see whether it is a list of numbers or not. — Sunderam Dubey
– Sunderam Dubey, Commented Nov 3, 2022 at 15:08

Ajay K · Accepted Answer · 2022-11-03 09:39:56Z

0

AS numbers is a integer field you can only be able to save number(integer) in it. Not a list.

answered Nov 3, 2022 at 9:39

Ajay K

2091 silver badge11 bronze badges

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

Collectives™ on Stack Overflow

Update a value of a column through django orm

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related