How to make columns optional?

[Tar8117]

Hi !
I have a table.

from piccolo.columns import Boolean, Integer, Varchar, Email
from piccolo.table import Table


class Student(Table):
    last_name = Varchar(null=True, length=100)
    first_name = Varchar(null=True, length=100)
    phone_number = Varchar(null=True, length=100, unique=True)
    personal_email = Email(null=True, unique=True)
    cohort_number = Integer(null=True)
    tg_id = Integer(null=True, unique=True)
    tg_login = Varchar(null=True, unique=True)
    begin_work_with_bot = Boolean()
    communication_info = Boolean()
    communication_teamwork = Boolean()
    communication_neformal = Boolean()
    communication_feedback = Boolean()

So, I want my columns to be optional, when creating new fields in my table. For example, I want to create empty fields.
BTW, when I used 0.84.0 version, and didn't use new Email column type, I could create empty fields in my table, without additional parameters (as null = True and etc.), but now I'm trying to make columns optional by using null = True, but it doesn't work. Is there any way to make columns optional?

[dantownsend]

When you change a column to have null=True, make sure you create a migration and apply it.

One important thing to be aware of is columns like Varchar (and derived columns like Email) have a default value of '' (i.e. an empty string).

So if you want value of null if no value is specified, use this:

class MyTable(Table):
    my_column = Varchar(null=True, default=None)

Does that help?

[dantownsend]

Or just use Varchar until we get it properly fixed.

[Tar8117]

Thank you very much

[dantownsend]

If you install the latest version of Piccolo and Piccolo API, the problem should be fixed.

When running your code I noticed one thing you should be aware of - you have a few unique columns. If you get an 'Internal Server Error' it's because of a unique constraint (i.e. adding a row with a value which already exists). We're working on showing a proper error message for unique constraint errors.

[dantownsend]

When running your code I noticed one thing you should be aware of - you have a few unique columns. If you get an 'Internal Server Error' it's because of a unique constraint (i.e. adding a row with a value which already exists). We're working on showing a proper error message for unique constraint errors.

If you install the latest version of piccolo_api this is now fixed.

[Tar8117]

Thank you a lot. I will try today