summaryrefslogtreecommitdiff
path: root/helsinki.program/management/commands/importhosts.py
diff options
context:
space:
mode:
authorJohannes Raggam <raggam-nl@adm.at>2011-03-26 20:35:14 (GMT)
committerJohannes Raggam <raggam-nl@adm.at>2011-03-26 20:35:14 (GMT)
commitd277b4a96830dac291fa77c710ffcba1c802407d (patch)
tree4209a83efd4ab96b028b7daa8e89630dfe383e90 /helsinki.program/management/commands/importhosts.py
parentfaa08b0b5ff0da35708fdbfc0cf2475a051ee6e4 (diff)
refactor project structure
Diffstat (limited to 'helsinki.program/management/commands/importhosts.py')
-rw-r--r--helsinki.program/management/commands/importhosts.py34
1 files changed, 0 insertions, 34 deletions
diff --git a/helsinki.program/management/commands/importhosts.py b/helsinki.program/management/commands/importhosts.py
deleted file mode 100644
index 39a8afd..0000000
--- a/helsinki.program/management/commands/importhosts.py
+++ /dev/null
@@ -1,34 +0,0 @@
-from django.core.management.base import NoArgsCommand
-
-import MySQLdb
-
-from helsinki.program.models import Host
-
-USER = 'helsinki'
-PASSWD = 'helsinki'
-DB = 'helsinki'
-
-class Command(NoArgsCommand):
- help = 'Import hosts from current program'
-
- def handle_noargs(self, **options):
- connection = MySQLdb.connect(user=USER, passwd=PASSWD, db=DB)
- cursor = connection.cursor()
-
- cursor.execute("""SELECT DISTINCT macher
-FROM sendungen
-WHERE letzter_termin > current_date AND macher != '' AND titel NOT LIKE 'Musikprogramm'""")
-
- counter = 0
-
- for row in cursor.fetchall():
- for macher in row[0].split(','):
- host = Host(name=macher.strip())
- host.save()
-
- counter += 1
-
- cursor.close()
- connection.close()
-
- print '%i hosts imported' % counter