Writing an Insert with CASE using Model in Jet

[aghchan]

Hi,

Is it possible to write this in a more idiomatic way in jet? this current insert statement has some *string values that I could fix with a custom function but if there was a way to just use .MODEL() and have the case statement for the handle field specifically that would be ideal.

Thanks

now := time.Now().UTC()
        user := model.User{
		ID:           id,
		Email:        email,
		DisplayName:  displayName,
		AvatarURL:    avatarURL,
		GoogleUserID: googleUserID,
		PhoneNumber:  phoneNumber,
		Website:      website,
		Description:  description,
		Handle:       &handle,
		DateCreated:  now,
		LastUpdated:  now,
	}

	statement := USER.INSERT(
		USER.ID,
		USER.DisplayName,
		USER.AvatarURL,
		USER.Email,
		USER.GoogleUserID,
		USER.PhoneNumber,
		USER.Website,
		USER.Description,
		USER.Handle,
		USER.DateCreated,
		USER.LastUpdated,
	).VALUES(
		user.ID,
		user.DisplayName,
		user.AvatarURL,
		user.Email,
		user.GoogleUserID,
		user.PhoneNumber,
		user.Website,
		user.Description,
		postgres.CASE().
			WHEN(
				postgres.EXISTS(
					SELECT(USER.Handle).
						FROM(USER).
						WHERE(USER.Handle.EQ(String(handle))),
				),
			).
			THEN(String(handle+" || nextval('"+string(postgres.Sequence_UserHandle)+"')")).
			ELSE(String(handle)),
		user.DateCreated,
		user.LastUpdated,
	)

[houtn11]

This looks more like a job for a trigger function.

[aghchan]

good point! thanks @houten11