#!/bin/env python3

from owlready2 import *
onto_path.append('.')
onto = get_ontology('immobilier.owl')
onto.load()

from pyexcel_ods import get_data
data = get_data('habitations.ods')
sheet = data['Feuille1']
bien = None
bienname = None
i = 0
for l in sheet:
	classname = getattr(onto, l[1])
	print(classname)
	if l[0]:
		bienname = l[0]
		bien = classname(bienname)
	else:
		piecename = bienname+'_'+str(i)
		i += 1
		piece = classname(piecename)
		bien.estConstitueDe.append(piece)

onto.save('immobilier_instances.owl')