pii should not be required to auto-assign faker transformers

[amontanez24]

Environment Details

Please indicate the following details about the environment in which you found the bug:

• SDV version: 1.0.0.dev
• Python version: Any
• Operating System: Any

Error Description

When updating the sdtype of a column to one of the non-default types, the code will crash when attempting to assign transformers. The only way to fix this is by setting pii to True explicitly, but that should be the default. In other words, the transformer should be correctly assigned even when pii is not provided in the update_column call.

Steps to reproduce

data = pd.DataFrame(data={
    'id': ['N', 'A', 'K', 'F', 'P'],
    'numerical': [1, 2, 3, 2, 1],
    'categorical': ['A', 'A', 'B', 'B', 'B']
})

metadata = SingleTableMetadata()
metadata.detect_from_dataframe(data)

metadata.update_column(
    column_name='id',
    sdtype='first_name'
)
metadata.set_primary_key('id')
s = GaussianCopulaSynthesizer(metadata)
s.auto_assign_transformers(data)

The code above should run the same as the code below

data = pd.DataFrame(data={
    'id': ['N', 'A', 'K', 'F', 'P'],
    'numerical': [1, 2, 3, 2, 1],
    'categorical': ['A', 'A', 'B', 'B', 'B']
})

metadata = SingleTableMetadata()
metadata.detect_from_dataframe(data)

metadata.update_column(
    column_name='id',
    sdtype='first_name',
    pii=True
)
metadata.set_primary_key('id')
s = GaussianCopulaSynthesizer(metadata)
s.auto_assign_transformers(data)