sqlType property

String get sqlType

Implementation

String get sqlType {
  switch (this) {
    case FieldType.PRIMARY:
      return 'INTEGER PRIMARY KEY AUTOINCREMENT';
    case FieldType.FLOAT:
    case FieldType.REAL:
      return 'REAL';
    case FieldType.TEXT:
      return 'TEXT';
    case FieldType.BLOB:
      return 'BLOB';
    case FieldType.NUMERIC:
    case FieldType.DECIMAL:
      return 'NUMERIC';
    case FieldType.INTEGER:
    case FieldType.BOOLEAN:
      return 'INTEGER'; // SQLite doesn’t have a boolean type
    case FieldType.DATE:
    case FieldType.DATETIME:
      return 'TEXT'; // Store as ISO8601 string
  }
}