UUID > Detect uuid content to ask people use dedicated type

[adriens]

Description

In some databases, we have found uuid stored as text in text based column, which is af not optimal. It would be very useful to get a new lint that :

• based on a sample of rows of column based text
• check if the content looks like a UUID, based on regular expression
• perform a WARN and tell the appropriate database type, or at least flag a UUID stored in a bad column type

Testimonial

This new lint idea has been emiited today by Emmanuel Confrere

Implemntation guidelines

public boolean isUUID(String string) {
    try {
        UUID.fromString(string);
        return true;
    } catch (Exception ex) {
        return false;
    }
}