def printProgress(str):
sys.stdout.write(str)
sys.stdout.flush()
def closeCVS(file):
if file != None:
file.close()
#
#start processing
#
openHabItemsREST = getOpenHabItems(
) #read all items over REST API in json format
db = config.openDataBase() #open configured data base
openHabItemsDB = getDataBaseItems(db) # read all data base items
#create CSV file
file, csvWriter = openCSV(config.rootPath, 'openHABdbStat.csv',
['No.'] + jsonEntries + dbEntries)
#go over all REST items and put them in CSV file
index = 0
printProgress('[')
for elem in openHabItemsREST:
#ignore groups
if elem['type'] == 'Group': continue
printProgress('.')
index = index + 1
c = [str(index)]
#!/usr/bin/python
# ################################################################
#
# OpenHAB dbTools python script to calculate db size
# Created by Oliver Albold 2019
#
# ################################################################
import MySQLdb
import sys
import dbtoolsconfig as config
#open tha data base
db = config.openDataBase()
# you must create a Cursor object. It will let you execute all the queries you need
cur = db.cursor()
# get size of openhab
cur.execute(
'SELECT table_schema "Database Name" , SUM( data_length + index_length)/1024/1024 "Database Size (MB)" FROM information_schema.TABLES where table_schema = "openhab";'
)
# go over all entries of 'items' table
for item in cur.fetchall():
#select all old entries
if item[0] == config.dbTable:
print("OpenHAB database size %.2fMB" % (item[1]))
size = item[1]
#cleanup
config.closeDataBase(db)