Connecting to MySQL database with Python
I'm looking to make a naming change to approximately 600 datapoints. I wish to trim the names down that were imported and the easiest way that I know how is to use a Python script. Where would I find the mysql database connection configuration for Mango Enterprise.
phildunlap last edited by
You can find the connection details for your Mango instance in the Mango/overrides/properties/env.properties or Mango/classes/env.properties files. By default Mango uses the H2 database in embedded mode which would only allow another connection if Mango was stopped. I'm not sure if there is a nice library to connect Python to H2. It's assuredly easier with MySQL.
Usually I do the python work on a JSON export, because JSON is very easy to work with.
You can also use the /sqlConsole.shtm page if you are an SQL wizard.
Script environments in Mango have a JsonEmport script utility that can import json and make this kind of modification.
Have you checked out the bulk data point edit page in the new UI?