summaryrefslogtreecommitdiff
path: root/scripts/import_from_csv.py
diff options
context:
space:
mode:
authorÉtienne Loks <etienne.loks@iggdrasil.net>2020-01-30 17:48:22 +0100
committerÉtienne Loks <etienne.loks@iggdrasil.net>2020-07-01 18:02:28 +0200
commitb95812657c142e26922ac8f9dbe72cbb56fc73b0 (patch)
tree9d8ed1b300d788d0893a5edbc7f530c7c486a397 /scripts/import_from_csv.py
parenta01045cb7b9523f6d0baa8ef9d537a26a189cdb4 (diff)
downloadIshtar-b95812657c142e26922ac8f9dbe72cbb56fc73b0.tar.bz2
Ishtar-b95812657c142e26922ac8f9dbe72cbb56fc73b0.zip
Clean
Diffstat (limited to 'scripts/import_from_csv.py')
-rwxr-xr-xscripts/import_from_csv.py68
1 files changed, 0 insertions, 68 deletions
diff --git a/scripts/import_from_csv.py b/scripts/import_from_csv.py
deleted file mode 100755
index 9640f1851..000000000
--- a/scripts/import_from_csv.py
+++ /dev/null
@@ -1,68 +0,0 @@
-#!/usr/bin/python
-# -*- coding: utf-8 -*-
-
-"""
-Import departements and towns from csv file
-"""
-
-DELIMITER = ","
-QUOTECHAR = '"'
-
-import sys
-import csv
-sys.path.append('.')
-
-from django.core.management import setup_environ
-import settings
-
-setup_environ(settings)
-
-from optparse import OptionParser
-
-from ishtar_common import models
-
-def insert_department(value):
- idx, label = value
- if models.Department.objects.filter(number=idx).count():
- return
- models.Department(number=idx, label=label).save()
- print idx, label, u" inserted"
-
-def insert_town(value):
- idx, label = value
- if models.Town.objects.filter(numero_insee=idx).count():
- return
- try:
- dpt = models.Department.objects.get(number=idx[:2])
- except:
- return
- models.Town(numero_insee=idx, name=label, departement=dpt).save()
- print idx, label, u" inserted"
-
-tables = {u"department":insert_department,
- u"town":insert_town}
-
-usage = u"usage: %%prog csv_file.csv table_name\n\n"\
- u"Table name must be in: %s." % u", ".join(tables.keys())
-parser = OptionParser(usage=usage)
-
-(options, args) = parser.parse_args()
-
-try:
- assert len(args) == 2
-except AssertionError:
- parser.error(u"You must provide one csv file and the table name.")
-
-try:
- assert args[1] in tables.keys()
-except AssertionError:
- parser.error(u"Incorrect table name.")
-
-try:
- values = csv.reader(open(args[0], 'rb'), delimiter=DELIMITER,
- quotechar=QUOTECHAR)
-except (IOError):
- parser.error(u"Incorrect CSV file.")
-
-for value in values:
- tables[args[1]](value)