old_contents: #!/usr/bin/python
  #
  # Parse the DMSt index list from DMSt-WO_2012.pdf
  #
  
  import sys
  import os
  import transaction
  from paste.deploy.loadwsgi import appconfig
  from skylines.config.environment import load_environment
  from skylines.model import DBSession, Airport
  from skylines.lib.waypoints.welt2000 import get_database
  
  sys.path.append(os.path.dirname(sys.argv[0]))
  
  conf_path = '/etc/skylines/production.ini'
  if len(sys.argv) > 1:
      conf_path = sys.argv[1]
      del sys.argv[1]
  
  if len(sys.argv) != 1:
      print >>sys.stderr, "Usage: %s [config.ini]" % sys.argv[0]
      sys.exit(1)
  
  conf = appconfig('config:' + os.path.abspath(conf_path))
  load_environment(conf.global_conf, conf.local_conf)
  
  welt2000 = get_database()
  
  i = 0
  
  for airport_w2k in welt2000:
      if (airport_w2k.type != 'airport' and
              airport_w2k.type != 'glider_site' and
              airport_w2k.type != 'ulm'):
          continue
  
      i += 1
      if i % 100 == 0:
          DBSession.flush()
          print str(i) + ": " + airport_w2k.country_code + " " + airport_w2k.name
  
      airport = Airport()
      airport.location = airport_w2k
      airport.altitude = airport_w2k.altitude
  
      airport.name = airport_w2k.name
      airport.short_name = airport_w2k.short_name
      airport.icao = airport_w2k.icao
      airport.country_code = airport_w2k.country_code
      airport.surface = airport_w2k.surface
      airport.runway_len = airport_w2k.runway_len
      airport.runway_dir = airport_w2k.runway_dir
      airport.frequency = airport_w2k.freq
      airport.type = airport_w2k.type
  
      DBSession.add(airport)
  
  DBSession.flush()
  
  transaction.commit()
  
new_contents: #!/usr/bin/python
  #
  # Parse the DMSt index list from DMSt-WO_2012.pdf
  #
  
  import sys
  import os
  import transaction
  from paste.deploy.loadwsgi import appconfig
  from skylines.config.environment import load_environment
  from skylines.model import DBSession, Airport
  from skylines.lib.waypoints.welt2000 import get_database
  
  sys.path.append(os.path.dirname(sys.argv[0]))
  
  conf_path = '/etc/skylines/production.ini'
  if len(sys.argv) > 1:
      conf_path = sys.argv[1]
      del sys.argv[1]
  
  welt2000_path = None
  if len(sys.argv) > 1:
      welt2000_path = sys.argv[1]
      del sys.argv[1]
  
  if len(sys.argv) != 1:
      print >>sys.stderr, "Usage: %s [config.ini] [WELT2000.TXT]" % sys.argv[0]
      sys.exit(1)
  
  conf = appconfig('config:' + os.path.abspath(conf_path))
  load_environment(conf.global_conf, conf.local_conf)
  
  welt2000 = get_database(path=welt2000_path)
  
  i = 0
  
  for airport_w2k in welt2000:
      if (airport_w2k.type != 'airport' and
              airport_w2k.type != 'glider_site' and
              airport_w2k.type != 'ulm'):
          continue
  
      i += 1
      if i % 100 == 0:
          DBSession.flush()
          print str(i) + ": " + airport_w2k.country_code + " " + airport_w2k.name
  
      airport = Airport()
      airport.location = airport_w2k
      airport.altitude = airport_w2k.altitude
  
      airport.name = airport_w2k.name
      airport.short_name = airport_w2k.short_name
      airport.icao = airport_w2k.icao
      airport.country_code = airport_w2k.country_code
      airport.surface = airport_w2k.surface
      airport.runway_len = airport_w2k.runway_len
      airport.runway_dir = airport_w2k.runway_dir
      airport.frequency = airport_w2k.freq
      airport.type = airport_w2k.type
  
      DBSession.add(airport)
  
  DBSession.flush()
  
  transaction.commit()
  
subject: allow usage of local WELT2000 file