Allow schema update in remote server edition

[ijreilly]

No description provided.

[greptile-apps]

Disclaimer: This comment was automatically generated with AI. It can give some useful hints as to where to look for, but sometimes it can also give very inaccurate answers so takes this with a pinch of salt :).

To allow schema updates in remote server edition, follow these steps:

1. Update DTO: Modify UpdateRemoteServerInput in src/modules/remote-server/dto/update-remote-server.input.ts to include the schema field.

@InputType()
export class UpdateRemoteServerInput {
  // existing fields
  @Field(() => String, { nullable: true })
  schema?: string;
}

2. Service Update: Update updateRemoteServer method in src/modules/remote-server/remote-server.service.ts to handle the schema field.

async updateRemoteServer(id: string, updateRemoteServerInput: UpdateRemoteServerInput): Promise<RemoteServer> {
  const { schema, ...rest } = updateRemoteServerInput;
  const remoteServer = await this.remoteServerRepository.preload({ id, ...rest });
  if (schema) {
    // handle schema update logic
  }
  return this.remoteServerRepository.save(remoteServer);
}

3. SQL Query Construction: Ensure build-update-remote-server-raw-query in src/modules/remote-server/utils/build-update-remote-server-raw-query.utils.ts constructs the correct SQL query for schema updates.

export function buildUpdateRemoteServerRawQuery(updateRemoteServerInput: UpdateRemoteServerInput): string {
  const { schema, ...rest } = updateRemoteServerInput;
  let query = 'UPDATE remote_servers SET ';
  // existing query construction
  if (schema) {
    query += `schema = '${schema}', `;
  }
  query = query.slice(0, -2); // remove trailing comma
  query += ' WHERE id = $1';
  return query;
}

4. Handle Table Creation: Update createAvailableTables method in src/modules/distant-table/distant-table.service.ts to handle the creation of available tables from the updated schema.

async createAvailableTables(schema: string): Promise<void> {
  // logic to create tables based on the schema
}

References