Is there any way I can update a schema to mark a field as required?

joaovq · April 2, 2021, 7:53pm

Hey guys, I’m trying to find out if there is any way I can update an existing schema to mark some fields as required.

Thanks in advance

dblythy · April 3, 2021, 11:38am

You can add something like this in serverStartComplete.

async serverStartComplete() {
  const options = { required: true, defaultValue: 'hello world' };
  const schema = new Parse.Schema('ClassName')
  schema.addString('field', options);
  await schema.update();
}

joaovq · April 3, 2021, 12:09pm

Hey @dblythy, thanks for the reply. It would work if I didn’t have a schema already set with a field called “field”.

My problem is that a already have many schemas and I want to update the fields to set them as required.

Do you know any solution for that?

dblythy · April 3, 2021, 1:17pm

const schema = new Parse.Schema('ClassName')
schema.deleteField('field');
await schema.update();
// now field won't exist in schema, add back in.
schema.addString('field', options);
await schema.update();

joaovq · April 4, 2021, 2:43pm

@dblythy that works, but since the field will be removed there will be data loss. I was looking for a solution with no data loss.

dblythy · April 4, 2021, 2:58pm

Ah, okay. As far as I can tell, it’s not possible. Maybe you could open an issue in the Parse Server repo?

github.com

parse-community/parse-server/blob/master/src/Controllers/SchemaController.js#L835


  submittedFields: SchemaFields,
  classLevelPermissions: any,
  indexes: any,
  database: DatabaseController
) {
  return this.getOneSchema(className)
    .then(schema => {
      const existingFields = schema.fields;
      Object.keys(submittedFields).forEach(name => {
        const field = submittedFields[name];
        if (existingFields[name] && field.__op !== 'Delete') {
          throw new Parse.Error(255, `Field ${name} exists, cannot update.`);
        }
        if (!existingFields[name] && field.__op === 'Delete') {
          throw new Parse.Error(255, `Field ${name} does not exist, cannot delete.`);
        }
      });

      delete existingFields._rperm;
      delete existingFields._wperm;
      const newSchema = buildMergedSchemaObject(existingFields, submittedFields);

dblythy · April 4, 2021, 3:02pm

Alternatively, you could update the _SCHEMA collection manually. I’m not sure if this will have complications.

Add this to “_metadata”:

 "fields_options" : {
  "field" : {
    "required" : true,
    "defaultValue" : "hello world"
  }
}

joaovq · April 5, 2021, 5:40pm

@dblythy that woks with no data loss. It’s gonna be a lit be tedious to do that for many fields in 73 classes but it’s a solution hahah. Thank you so much for helping me.