Set the datasource on grafana dashboards

setDatasource.py

#!/usr/bin/env python

import sqlite3
import json

"""
Quick quick script to set the datasource for grafana dashboards
"""

OLD_DATASOURCE = 'null'
NEW_DATASOURCE = 'graphite'
SQLITE_DB = '/opt/grafana/data/grafana.db'
conn = None

try:
    conn = sqlite3.connect(SQLITE_DB)
    cur = conn.cursor()

    cur.execute('SELECT id, data FROM dashboard;')

    data = cur.fetchall()
except:
    raise

for dash_id, dash_data in data:
    dash = json.loads(dash_data)

    for row in dash['rows']:
        for panel in row['panels']:
            try:
                datasource = panel['datasource']
            except KeyError:
                print("Skipping dashboard: {}, row: {}, panel: {}".format(
                    dash['title'], row['title'], panel['title']))
            if not datasource or datasource == OLD_DATASOURCE:
                print("Updating dashboard: {}, row: {}, panel: {}".format(
                    dash['title'], row['title'], panel['title']))
                panel['datasource'] = NEW_DATASOURCE

                cur.execute("UPDATE dashboard SET data=? WHERE id=?", (json.dumps(dash), dash_id))