Python Db.Geninsert Beispiele

Beispiel #1

Datei: load_companies.py Projekt: Nigel-Mark-Smith/process_vacancies

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' % (

Beispiel #2

Datei: initialize_database.py Projekt: Nigel-Mark-Smith/process_vacancies

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)