def readConfig(): ''' Read difxdb configuration ''' if (os.getenv("DIFXROOT") == None): sys.exit("Error: DIFXROOT environment must be defined.") configName = os.getenv("DIFXROOT") + "/conf/difxdb.ini" config = DifxDbConfig(configName) return (config)
if __name__ == "__main__": if (len(sys.argv) != 2): printUsage() expCode = upper(sys.argv[1]) try: if (os.getenv("DIFXROOT") == None): sys.exit("Error: DIFXROOT environment must be defined.") configPath = os.getenv("DIFXROOT") + "/conf/difxdb.ini" config = DifxDbConfig(configPath, create=True) # try to open the database connection connection = Connection() connection.type = config.get("Database", "type") connection.server = config.get("Database", "server") connection.port = config.get("Database", "port") connection.user = config.get("Database", "user") connection.password = config.get("Database", "password") connection.database = config.get("Database", "database") connection.echo = False dbConn = Schema(connection) session = dbConn.session() try:
# obtain experiment code from the trailing part of the path code = upper(os.path.basename(args.path)) dbConn = None settings = {} configName = 'difxdb.ini' # check for DIFXROOT environment if (os.getenv("DIFXROOT") == None): sys.exit("Error: environment variable DIFXROOT must be defined.") settings["difxRoot"] = os.getenv("DIFXROOT") settings["configFile"] = settings["difxRoot"] + "/conf/" + configName # read the configuration file config = DifxDbConfig(settings["configFile"], create=False) connection = Connection() connection.type = config.get("Database", "type") connection.server = config.get("Database", "server") connection.port = config.get("Database", "port") connection.user = config.get("Database", "user") connection.password = config.get("Database", "password") connection.database = config.get("Database", "database") connection.echo = False dbConn = Schema(connection) if args.update: expUpdate() #elif args.finalize: # expFinalize()
# parse the command line. Options will be stored in the options list. Leftover arguments will be stored in the args list (options, args) = parser.parse_args() if (options.verbose > 0): print "Using options:" for key, value in options.__dict__.items(): print "%s : %s" % (key, value) if len(args) == 0: parser.print_help() exit(0) if (getenv("DIFXROOT") == None): sys.exit("Error: DIFXROOT environment must be defined.") config = DifxDbConfig(getenv("DIFXROOT") + "/conf/difxdb.ini") # try to open the database connection connection = Connection(config) connection.echo = False try: dbConn = Schema(connection) session = dbConn.session() except Exception as e: exitOnError(e) if not isSchemaVersion(session, minSchemaMajor, minSchemaMinor): major, minor = getCurrentSchemaVersionNumber(session) exitOnError( "Current difxdb database schema is %s.%s but %s.%s is minimum requirement"
def readConfig(): if (os.getenv("DIFXROOT") == None): exitOnError("DIFXROOT environment must be defined.") #sys.exit("Error: DIFXROOT environment must be defined.") configName = os.getenv("DIFXROOT") + "/conf/difxdb.ini" config = DifxDbConfig(configName) if not config.sectionExists("difxarchive"): logger.info ("Configuration file does not contain a section for difxarchive yet. Adding a default one for you. Please edit %s and restart difxarchive." % configName) config.addSection("difxarchive") config.set('difxarchive', 'archiveserver', 'ADD_ARCHIVE_SERVER') config.set('difxarchive', 'defaultuser', 'ADD_DEFAULT_USER') config.set('difxarchive', 'archiveremotepath', 'ADD_REMOTE_PATH') config.set('difxarchive', 'refbackuppath', 'ADD_PATH') config.writeConfig() exit(0) return (config)
__date__ ="$08.12.2011 10:09:35$" if __name__ == "__main__": if len(sys.argv) < 2: sys.stderr.write('Usage: importSlots {slots_filename}') sys.exit(1) if (os.getenv("DIFXROOT") == None): sys.exit("Error: environment variable DIFXROOT must be defined.") configFile = os.getenv("DIFXROOT") + "/conf/difxdb.ini" if not os.path.isfile(configFile): sys.exit("Error: Configuration file does not exist: %s" % configFile) config = DifxDbConfig(configFile, create=False) file = open(sys.argv[1], "r") connection = Connection(config) connection.echo = False dbConn = Schema(connection) session = dbConn.session() for line in file: inDateStr = "" inDatetime = None fields = line.split()