meterReadingBackup_02b module

class meterReadingBackup_02b.DatabaseManager(credentials)

Bases: object

The Card class represents a single database accessed across a specific mysql connector. It is initialised by passing a set of credentials for opening a connection to a MySQL server; these credentials are passed as a dictionary which defines the values for the ‘user’, ‘password’, ‘host’, ‘port’ and ‘database’ variables to be used to access an existing database on a MySQL server and the value of the ‘raise_on_warnings’ flag to be used over the connection to that database. The class supports query and update functions for a specific (Readings) table in the database, and ‘serverInfo’ and ‘close’ functions for the connection. Work ongoing!

close()

newTable(tableName, tableColumns)

query(sqlCode)

serverInfo()

update(sqlCode, data)

meterReadingBackup_02b.cls()

meterReadingBackup_02b.dateSuffix(date)

meterReadingBackup_02b.formatReading(result, fuelFlag)

meterReadingBackup_02b.main()

meterReadingBackup_02b.printReadings(readings, fuelString)