python: tuple gets converted to list in mysql insert query

Question

I am trying to insert a tuple into mysql table using python, but tuple gets converted to list in mysql table.

settings: {
      'AEROSPIKE_CONN_SETTINGS' : {
        'hosts': [ ('aerospike.qgraph-vpc.io', 3000) ],
        'policies': {
           'timeout': 3000
        }
      }
    }
db = MySQLdb.connect(host='localhost', user='test', passwd='abcd', db='testdb')
cursor = db.cursor(MySQLdb.cursors.DictCursor)
insert_query = '''INSERT INTO test_table (`settings`) VALUES ('{}')'''.format(json.dumps(settings))
cursor.execute(insert_query)
cursor.connection.commit()

after executing the above code data gets inserted in the following format

settings:{ 
  "AEROSPIKE_CONN_SETTINGS": {
    "hosts": [["127.0.0.1", 3000]]
  }
}

It should be in the following format

settings:{ 
  "AEROSPIKE_CONN_SETTINGS": {
    "hosts": [("127.0.0.1", 3000)]
  } 
}

what is wrong or how can I insert in the expected format. I am reading the settings from mysql table in some other python component to connect to aerospike.

Please see this question and answers: stackoverflow.com/questions/15721363/… — mechanical_meat
– mechanical_meat, Commented Mar 27, 2017 at 16:55
This question isn't related to Aerospike. The fact that you are storing Aerospike configuration is just circumstantial. I suggest removing the tag. If Aerospike's python client rejects connecting with a list rather than tuple then ask that question separately. — kporter
– kporter, Commented Mar 27, 2017 at 17:24

Daniel Roseman · Accepted Answer · 2017-03-27 17:04:55Z

2

There is no such thing as a tuple in JSON.

Note however, from the point of view of your Python code there is no practical difference between a list and a tuple. It's fine to let it be converted.

answered Mar 27, 2017 at 17:04

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

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

1 Comment

rahulk9 Over a year ago

yes it does make difference, while connecting to aerospike a tuple is request. I just converted list back to tuple in python code after reading from mysql.

Collectives™ on Stack Overflow

python: tuple gets converted to list in mysql insert query

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related