getVarcharPreferredSize method

int getVarcharPreferredSize(String? column)

Returns the preferred VARCHAR size for a column name.

Implementation

int getVarcharPreferredSize(String? column) {
  if (column == null) return 1024;

  column = column.trim();
  if (column.isEmpty) return 1024;

  column = normalizeColumnName(column);
  if (column.isEmpty) return 1024;

  switch (column) {
    case 'tel':
    case 'cel':
    case 'cell':
    case 'phone':
    case 'celphone':
    case 'cellphone':
    case 'zip':
    case 'zipcode':
    case 'postalcode':
      return 32;

    case 'name':
    case 'firstname':
    case 'middlename':
    case 'lastname':
    case 'city':
      return 128;

    case 'address':
    case 'email':
      return 254;

    case 'hash':
    case 'pass':
    case 'passhash':
    case 'password':
    case 'passwordhash':
    case 'passphrase':
    case 'passphrasehash':
      return 512;

    case 'title':
    case 'description':
      return 1024;

    case 'http':
    case 'https':
    case 'url':
      return 2048;

    case 'text':
    case 'html':
    case 'xml':
    case 'json':
    case 'yaml':
    case 'yml':
    case 'data':
    case 'content':
    case 'base64':
      return 65535;

    default:
      return 1024;
  }
}