from pyiotdb.db import connect

ip = "ip"
port = 6668
username = 'root'
password = 'root'
conn = connect(host=ip, port=port, username=username, password=password)
cursor = conn.cursor()
cursor.execute('show  storage group')
print(cursor.rowcount)

from sqlalchemy.engine import create_engine

engine = create_engine('iotdb://root:root@ip:6668/')
connection = engine.connect()

result = connection.execute("SHOW STORAGE GROUP")

for row in result.fetchall():
    print(row['storage group'])