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()