old_contents: import os
  import sys
  import transaction
  
  from sqlalchemy import engine_from_config
  
  from pyramid.paster import (
      get_appsettings,
      setup_logging,
      )
  
  from ..models import (
      DBSession,
      Study,
      Tree,
      Curator,
      Taxonomy,
      Base,
      )
  
  
  def usage(argv):
      cmd = os.path.basename(argv[0])
      print('usage: %s <config_uri> [var=value]\n'
            '(example: "%s development.ini")' % (cmd, cmd))
      sys.exit(1)
  
  
  def main(argv=sys.argv):
      if len(argv) < 2:
          usage(argv)
      config_uri = argv[1]
      #options = parse_vars(argv[2:])
      setup_logging(config_uri)
      settings = get_appsettings(config_uri)
      engine = engine_from_config(settings, 'sqlalchemy.')
      DBSession.configure(bind=engine)
      Base.metadata.drop_all(engine)
      Base.metadata.create_all(engine)
      #with transaction.manager:
          #model = MyModel(name='one', value=1)
          #DBSession.add(model)
  
new_contents: import os
  import sys
  import transaction
  
  from sqlalchemy import engine_from_config
  
  from pyramid.paster import (
      get_appsettings,
      setup_logging,
      )
  
  from ..models import (
      DBSession,
      Study,
      Tree,
      Curator,
      Taxonomy,
      Base,
      )
  
  
  def usage(argv):
      cmd = os.path.basename(argv[0])
      print('usage: %s <config_uri> [var=value]\n'
            '(example: "%s development.ini")' % (cmd, cmd))
      sys.exit(1)
  
  
  def main(argv=sys.argv):
      if len(argv) < 2:
          usage(argv)
      config_uri = argv[1]
      #options = parse_vars(argv[2:])
      setup_logging(config_uri)
      settings = get_appsettings(config_uri)
      engine = engine_from_config(settings, 'sqlalchemy.')
      DBSession.configure(bind=engine)
      #Base.metadata.drop_all(engine)
      Base.metadata.create_all(engine)
      #with transaction.manager:
          #model = MyModel(name='one', value=1)
          #DBSession.add(model)
  
subject: remove drop_all