Default enrichment idea: search and replace

[simonw]

The simplest form of exact match search and replace, to work exclusively against text columns.

[simonw]

I built a weird half-baked version of this in a unit test for secrets just now:

datasette-enrichments/tests/conftest.py

Lines 64 to 102 in ea7de74

	class SecretReplacePlugin(Enrichment):
	name = "Replace string with a secret"
	slug = "secretreplace"
	description = "Replace a string with a secret"
	secret = Secret(
	name="STRING_SECRET",
	description="The secret to use in the replacement",
	)
	async def get_config_form(self, db, table):
	choices = [(col, col) for col in await db.table_columns(table)]
	class ConfigForm(Form):
	column = SelectField("Column", choices=choices)
	string = StringField("String to be replaced")
	return ConfigForm
	async def enrich_batch(
	self,
	datasette,
	db: Database,
	table: str,
	rows: List[dict],
	pks: List[str],
	config: dict,
	job_id: int,
	):
	secret = await self.get_secret(datasette, config)
	for row in rows:
	await db.execute_write(
	"update [{}] set [{}] = ? where {}".format(
	table,
	config["column"],
	" and ".join('"{}" = ?'.format(pk) for pk in pks),
	),
	[row[config["column"]].replace(config["string"], secret)]
	+ [row[pk] for pk in pks],
	)