def initialize_system_logging(opts):
# set up the logger for external programs
if opts.check_commands:
logformat = "%(message)s"
else:
logformat = "%(levelname)s %(asctime)s %(message)s"
if opts.logfileName is not None:
system.rename_logfile(opts.logfileName)
system.setup_logger(logfilename=opts.logfileName, logformat=logformat)
else:
system.setup_logger(logformat=logformat)
if (opts.check_commands):
system.set_check_commands(True)
def initialize_system_logging(opts):
# set up the logger for external programs
if opts.check_commands:
logformat = "%(message)s"
else:
logformat = "%(levelname)s %(asctime)s %(message)s"
if opts.logfileName is not None:
system.rename_logfile(opts.logfileName)
system.setup_logger(logfilename=opts.logfileName, logformat=logformat)
else:
system.setup_logger(logformat=logformat)
if (opts.check_commands):
system.set_check_commands(True)
__author__ = 'andrew.sielen'
import database
import system as syt
if __name__ == "__main__": syt.setup_logger()
"""
Standalone file, to fix various database issues I have come across
"""
def fix_no_unique_key_in_bl_categories():
"""
A unique key wasn't originally setup for bl_categories
So, first, comb through the parts table and update all the bl_ids with the proper ones
2) Rebuild the bl_categories table with the proper index
3) Rebuild the parts table with the proper foreign key
@return:
"""
# Step 1
# Remove bad ids from parts database by finding the correct ones and sqapping
print("Distinct Parts: {}".format(database.run_sql('SELECT COUNT(DISTINCT bl_category) FROM parts;', one=True)))
sql_bl_categories_fix = 'SELECT id, (SELECT MIN(bl.id) FROM bl_categories AS bl WHERE bl_categories.bl_category_id=bl.bl_category_id GROUP BY bl.bl_category_id) AS new_id FROM bl_categories;'
bl_categories_fix_lookup = syt.list_to_dict(database.run_sql(sql_bl_categories_fix))
syt.log_info("Running cleanup loop")
loop_count = 0
for bad_value in bl_categories_fix_lookup:
sql_update = 'UPDATE parts SET bl_category={} WHERE bl_category={};'.format(bl_categories_fix_lookup[bad_value], bad_value)
database.run_sql(sql_update)
loop_count += 1
parser.add_option("--log-commands", help="Specify if the script logs only command lines not executing those", action="store_true", dest="log_commands")
parser.add_option("--verbose", help="Print out logs to cosnole", action="store_true", dest="verbose", default=False)
(opts, args) = parser.parse_args()
# set up the logger for external programs
if opts.log_commands:
logformat = "%(message)s"
else:
logformat = "%(levelname)s %(asctime)s %(message)s"
if opts.logfileName is not None:
system.rename_logfile(opts.logfileName)
system.setup_logger(logfilename=opts.logfileName, logformat=logformat)
else:
system.setup_logger(logformat=logformat)
# argument processing
if (len(args) < 2):
parser.print_help()
else:
csvfile = args[0]
outputdir = args[1]
#bmsfile = args[1]
if (not os.path.isdir("%s/Processing/1.MeasurementandSPHARM" % (outputdir))):
os.makedirs("%s/Processing/1.MeasurementandSPHARM" % (outputdir))
import system
import sys
import logging
system.setup_logger(logfilename="test.log")
retcode = system.run_process("/devel/linux/SPHARM-PDM/spharm-pdm-build-joowhi/bin/GenParaMeshCLP %s %s %s" % (sys.argv[1], sys.argv[2], sys.argv[3]), verbose=True)
print "Return Code = ", retcode
help="Print out logs to cosnole",
action="store_true",
dest="verbose",
default=False)
(opts, args) = parser.parse_args()
# set up the logger for external programs
if opts.log_commands:
logformat = "%(message)s"
else:
logformat = "%(levelname)s %(asctime)s %(message)s"
if opts.logfileName is not None:
system.rename_logfile(opts.logfileName)
system.setup_logger(logfilename=opts.logfileName, logformat=logformat)
else:
system.setup_logger(logformat=logformat)
# argument processing
if (len(args) < 2):
parser.print_help()
else:
csvfile = args[0]
outputdir = args[1]
#bmsfile = args[1]
if (not os.path.isdir("%s/Processing/1.MeasurementandSPHARM" %
(outputdir))):
os.makedirs("%s/Processing/1.MeasurementandSPHARM" % (outputdir))
import system
import sys
import logging
system.setup_logger(logfilename="test.log")
retcode = system.run_process(
"/devel/linux/SPHARM-PDM/spharm-pdm-build-joowhi/bin/GenParaMeshCLP %s %s %s"
% (sys.argv[1], sys.argv[2], sys.argv[3]),
verbose=True)
print "Return Code = ", retcode
