if (CompanyfileObject == failure): File.Logerror(ErrorfileObject, module, Errormessage, error) CompanyfileData = File.Readline(CompanyfileObject, empty) Errormessage = 'No data in ' + Companyfilename if (CompanyfileData == empty): File.Logerror(ErrorfileObject, module, Errormessage, error) # Progress update Errormessage = 'Loading data from file %s' % Companyfilename File.Logerror(ErrorfileObject, module, Errormessage, info) DataCount = 0 DataInserted = 0 while (CompanyfileData != empty): SQLcommand = Db.Geninsert(Companytable, Companyfields, CompanyfileData) SQLresponse = (Db.SQLload(DbObject, DbCursor, SQLcommand, failure)) Errormessage = 'SQLresponse error for SQL command ' + '\"' + SQLcommand + '\"' if ((SQLresponse) == failure): File.Logerror(ErrorfileObject, module, Errormessage, warning) else: DataInserted += 1 CompanyfileData = File.Readline(CompanyfileObject, empty) # Increment counter and display progress message. DataCount += 1 if (DataCount % 100 == 0): print('%d lines processed' % DataCount) # Progress update Errormessage = 'Populated \'company\' table with %i of a possible %i entries' % (
File.Logerror(ErrorfileObject, module, 'Verified that all required tables have been defined', info) # Load company data from 'companies.data' file CompanyfileObject = File.Open(Companyfilename, read, failure) Errormessage = 'Could not open ' + Companyfilename if (CompanyfileObject == failure): File.Logerror(ErrorfileObject, module, Errormessage, error) CompanyfileData = File.Readline(CompanyfileObject, empty) Errormessage = 'No data in ' + Companyfilename if (CompanyfileData == empty): File.Logerror(ErrorfileObject, module, Errormessage, error) while (CompanyfileData != empty): SQLcommand = Db.Geninsert('company', Companyfields, CompanyfileData) SQLresponse = (Db.SQLload(DbObject, DbCursor, SQLcommand, failure)) Errormessage = 'SQLresponse error for SQL command ' + '\"' + SQLcommand + '\"' if ((SQLresponse) == failure): File.Logerror(ErrorfileObject, module, Errormessage, warning) CompanyfileData = File.Readline(CompanyfileObject, empty) # Progress update File.Logerror(ErrorfileObject, module, 'Populated \'company\' table ', info) Errormessage = 'Could not close ' + Companyfilename if (File.Close(CompanyfileObject, failure) == failure): File.Logerror(ErrorfileObject, module, Errormessage, warning) # Load engine data from 'engines.data' file EnginefileObject = File.Open(Enginefilename, read, failure)