How can I insert null value in some columns

[SergiusAC]

I need to execute INSERT query where some columns should be null. How can I do this?

My code example:

query = """
DECLARE $user_id AS String;
DECLARE $tg_user_id AS String;
DECLARE $activate_token AS String;
DECLARE $notifications_enabled AS Bool;
DECLARE $created_at AS Datetime;

INSERT INTO tg_users (user_id, tg_user_id, activate_token, notifications_enabled, created_at)
VALUES ($user_id, $tg_user_id, $activate_token, $notifications_enabled, $created_at);
"""
params = {
    "$user_id": (user_id.encode(), ydb.PrimitiveType.String),
    "$tg_user_id": None, # this column should be NULL
    "$activate_token": (activate_token.encode(), ydb.PrimitiveType.String),
    "$notifications_enabled": (notifications_enabled, ydb.PrimitiveType.Bool),
    "$created_at": (int(datetime.now().timestamp()), ydb.PrimitiveType.Datetime),
}
async with await self.tx.execute(query, params):
    pass

[vgvoleg]

You should wrap your parameter type with ydb.OptionalType()

Example:

def insert_simple_with_null(pool: ydb.QuerySessionPool):
    print("\nPerforming insert into episodes with some null values...")

    pool.execute_with_retries(
        """
        INSERT INTO episodes (series_id, season_id, episode_id, title) VALUES ($series_id, $season_id, $episode_id, $title);
        """,
        {
            "$series_id": (2, ydb.PrimitiveType.Int64),
            "$season_id": (6, ydb.PrimitiveType.Int64),
            "$episode_id": (2, ydb.PrimitiveType.Int64),
            "$title": (None, ydb.OptionalType(ydb.PrimitiveType.Utf8)),
        }
    )