DataType

Description

class lab_utils.database.DataType(value)[source]

List of accepted data types for new columns. The types are hard-coded for safety reasons: SQL insertions are potentially dangerous. See here for more information.

Attributes

DataType.bool

Boolean

DataType.double

Floating-point number, 8 bytes

DataType.float

Floating-point number, 4 bytes

DataType.int

Integer (4 bytes, range is -2,147,483,648 to +2,147,483,647)

DataType.long

Integer (8 bytes, range is -9,223,372,036,854,775,808 to +9,223,372,036,854,775,807)

DataType.short

Integer (2 bytes, range is -32,768 to +32,767)

DataType.string

String, unlimited length

DataType.time

Time stamp, with time zone information