def handle(self, *args, **kwargs):
"""Import the data for lizard_blockbox from the source."""
import_helpers.flush_database(self.stdout)
import_helpers.parse_trajectory_classification_excelfile(
os.path.join(DATA_DIR, "excelsheets/trajectindeling/Trajectindeling.xls"), self.stdout
)
import_helpers.import_city_names(
os.path.join(DATA_DIR, "excelsheets/gidslocaties/Gidslocaties.xls"), self.stdout
)
import_helpers.import_vertex_xls(
os.path.join(
DATA_DIR,
"excelsheets/waterstandsopgave/" "Verzamelsheet Wateropgave DPR_17_Blokkendoos_geenFiguren.xls",
),
self.stdout,
)
import_helpers.link_vertices_with_namedreaches()
maatregeldir = os.path.join(DATA_DIR, "excelsheets/maatregelen")
for maatregelxls in os.listdir(maatregeldir):
if maatregelxls.lower().endswith(".xls"):
import_helpers.import_measure_xls(os.path.join(maatregeldir, maatregelxls), self.stdout)
import_helpers.import_measure_table_xls(
os.path.join(DATA_DIR, "excelsheets/eigenschappen/tabel_met_eigenschappen.xls"), self.stdout
)
import_helpers.import_excluding_measures_xls(
os.path.join(
DATA_DIR, "excelsheets/elkaar uitsluitende maatregelen", "Maatregelen die elkaar uitsluiten.xls"
),
self.stdout,
)
import_helpers.import_including_measures_xls(
os.path.join(DATA_DIR, "excelsheets/elkaar uitsluitende maatregelen", "pakketten.xls"), self.stdout
)
import_helpers.import_trajectory_names_xls(
os.path.join(DATA_DIR, "excelsheets/trajectindeling/hoofdtrajecten.xls"), self.stdout
)
def handle(self, *args, **options):
flush = options['flush']
if flush:
import_helpers.flush_database(self.stdout)
if len(args) == 0:
if not flush:
print "Pass a directory as argument."
sys.exit(1)
sys.exit(0)
if os.path.isdir(args[0]):
excelpaths = latest_xls(args[0])
else:
excelpaths = args
for excelpath in excelpaths:
import_helpers.import_measure_xls(excelpath, self.stdout)
