Function upsertPlugin

app/src/sqlite/plugin.ts:8–28

(plugin: Plugin)

export const pluginCollectionMethods = {
	async upsertPlugin(plugin: Plugin) {
		const now = C.getDate().getTime()
		await rd.exec(
			`INSERT INTO plugin (name,version,dependencies,created,edited,script)
                   VALUES (   ?,      ?,           ?,      ?,      ?,    ?)
       ON CONFLICT(name) DO UPDATE SET
         version=excluded.version,
         dependencies=excluded.dependencies,
         edited=excluded.edited,
         script=excluded.script`,
			// lowTODO add conflict types via typescript, i.e. "point of this type is to cause an error if something is added to Plugin"
			[
				plugin.name,
				plugin.version,
				plugin.dependencies ?? null,
				now,
				now,
				new Uint8Array(await plugin.script.arrayBuffer()),
			],
		)
	},
	async getPlugins(): Promise<Plugin[]> {
		const plugins = await ky.selectFrom('plugin').selectAll().execute()
		return plugins.map(pluginEntityToDomain)