print('data source:\t{}'.format(datasource.caption or datasource.name))

print('version:\t{}'.format(datasource.version))

print()

for connection in datasource.connections:

print('server:\t{}'.format(connection.server))

print('dbname:\t{}'.format(connection.dbname))

print('username:\t{}'.format(connection.username))

print('dbclass:\t{}'.format(connection.dbclass))

print('port:\t{}'.format(connection.port))

print('query_band:\t{}'.format(connection.query_band))

print('initial_sql:\t{}'.format(connection.initial_sql))

print()

# for field in datasource.fields.value():

# print(field.name)

print('{} total fields in your data source'.format(len(datasource.fields)))

# for count, field in enumerate(datasource.fields.values()):

# print ('{} {} {}'.format((count + 1), field.name, field.datatype))

# if field.calculation:

# print(' the formula is {}'.format(field.calculation))

# if field.default_aggregation:

# print(' the default aggregation is {}'.format(field.default_aggregation))

# if field.description:

# print(' the description is {}'.format(field.description))

for field in datasource.fields.values():

field_attributes = [field.id,

field.caption,

field.alias,

field.datatype,

field.role,

field.is_quantitative,

field.is_ordinal,

field.is_nominal,

field.calculation,

field.default_aggregation,

field.description]