comparison pylearn/dbdict/newstuff.py @ 609:7cee8c7f0449

added -f flag to sqlschedule and sqlschedule_filemerge
author Olivier Breuleux <breuleuo@iro.umontreal.ca>
date Fri, 16 Jan 2009 15:53:22 -0500
parents 52a99d83f06d
children e8cb4bde30a7
comparison
equal deleted inserted replaced
604:52a99d83f06d 609:7cee8c7f0449
633 633
634 634
635 635
636 636
637 parser_sqlschedule = OptionParser(usage = '%prog sqlschedule [options] <tablepath> <experiment> <parameters>') 637 parser_sqlschedule = OptionParser(usage = '%prog sqlschedule [options] <tablepath> <experiment> <parameters>')
638 parser_sqlschedule.add_option('-f', '--force', action = 'store_true', dest = 'force', default = False,
639 help = 'force adding the experiment to the database even if it is already there')
638 640
639 def runner_sqlschedule(options, dbdescr, experiment, *strings): 641 def runner_sqlschedule(options, dbdescr, experiment, *strings):
640 """ 642 """
641 Schedule a job to run using the sql command. 643 Schedule a job to run using the sql command.
642 644
684 try: 686 try:
685 resolve(experiment) 687 resolve(experiment)
686 except: 688 except:
687 raise UsageError('The first parameter to sqlschedule must be a valid, importable symbol.') 689 raise UsageError('The first parameter to sqlschedule must be a valid, importable symbol.')
688 state['dbdict.experiment'] = experiment 690 state['dbdict.experiment'] = experiment
689 sql.add_experiments_to_db([state], db, verbose = 1) 691 sql.add_experiments_to_db([state], db, verbose = 1, add_dups = options.force)
690 692
691 runner_registry['sqlschedule'] = (parser_sqlschedule, runner_sqlschedule) 693 runner_registry['sqlschedule'] = (parser_sqlschedule, runner_sqlschedule)
692 694
693 695
694 696
695 parser_sqlschedule_filemerge = OptionParser(usage = '%prog sqlschedule_filemerge [options] <tablepath> <experiment> <parameters|files>') 697 parser_sqlschedule_filemerge = OptionParser(usage = '%prog sqlschedule_filemerge [options] <tablepath> <experiment> <parameters|files>')
698 parser_sqlschedule_filemerge.add_option('-f', '--force', action = 'store_true', dest = 'force', default = False,
699 help = 'force adding the experiment to the database even if it is already there')
696 700
697 def runner_sqlschedule_filemerge(options, dbdescr, experiment, mainfile, *other_files): 701 def runner_sqlschedule_filemerge(options, dbdescr, experiment, mainfile, *other_files):
698 """ 702 """
699 Schedule a job to run using the sql command using parameter files. 703 Schedule a job to run using the sql command using parameter files.
700 704
728 try: 732 try:
729 resolve(experiment) 733 resolve(experiment)
730 except: 734 except:
731 raise UsageError('The first parameter to sqlschedule_filemerge must be a valid, importable symbol.') 735 raise UsageError('The first parameter to sqlschedule_filemerge must be a valid, importable symbol.')
732 state['dbdict.experiment'] = experiment 736 state['dbdict.experiment'] = experiment
733 sql.add_experiments_to_db([state], db, verbose = 1) 737 sql.add_experiments_to_db([state], db, verbose = 1, add_dups = options.force)
734 738
735 runner_registry['sqlschedule_filemerge'] = (parser_sqlschedule_filemerge, runner_sqlschedule_filemerge) 739 runner_registry['sqlschedule_filemerge'] = (parser_sqlschedule_filemerge, runner_sqlschedule_filemerge)
736 740
737 741
738 742