export class UpdatedAtPlugin implements KyselyPlugin {

    transformQuery(args: PluginTransformQueryArgs): RootOperationNode {
        if (args.node.kind === "UpdateQueryNode") {
            const arr: ColumnUpdateNode[] = [];

            arr.push(...args.node.updates);
            arr.push(
                {
                    kind: 'ColumnUpdateNode',
                    column: {
                        kind: 'ColumnNode',
                        column: { kind: 'IdentifierNode', name: 'updated_at' }
                    },
                    value: { kind: 'ValueNode', value: '${new Date()}' }
                }
            );

            return {
                ...args.node,
                updates: arr,
            };
        }

        return args.node;
    }

    transformResult(
        args: PluginTransformResultArgs
    ): Promise<QueryResult<UnknownRow>> {
        return Promise.resolve(args.result);
    }
}

export class UpdatedAtPlugin implements KyselyPlugin {

    transformQuery(args: PluginTransformQueryArgs): RootOperationNode {
        if (args.node.kind === "UpdateQueryNode") {
            const arr: ColumnUpdateNode[] = [];

            arr.push(...args.node.updates);
            arr.push(
                {
                    kind: 'ColumnUpdateNode',
                    column: {
                        kind: 'ColumnNode',
                        column: { kind: 'IdentifierNode', name: 'updated_at' }
                    },
                    value: { kind: 'ValueNode', value: '${new Date()}' }
                }
            );

            return {
                ...args.node,
                updates: arr,
            };
        }

        return args.node;
    }

    transformResult(
        args: PluginTransformResultArgs
    ): Promise<QueryResult<UnknownRow>> {
        return Promise.resolve(args.result);
    }
}

TS2322: Type  { kind: "ValueNode"; value: string; }  is not assignable to type  OperationNode 
Object literal may only specify known properties, and  value  does not exist in type  OperationNode 
column-update-node.d.ts(6, 14): The expected type comes from property  value  which is declared here on type  ColumnUpdateNode

TS2322: Type  { kind: "ValueNode"; value: string; }  is not assignable to type  OperationNode 
Object literal may only specify known properties, and  value  does not exist in type  OperationNode 
column-update-node.d.ts(6, 14): The expected type comes from property  value  which is declared here on type  ColumnUpdateNode

await this.db.selectFrom("location")
            .where(sql`ST_DWithin(                                                         coordinates::geography,ST_MakePoint(${lat},${long}),8000)`)
            .select(
                [
                    sql<string>`ST_X(coordinates)`.as("latitude"),
                    sql<string>`ST_Y(coordinates)`.as("longitude"),
                    "name"
                ]
            )
            .execute()

await this.db.selectFrom("location")
            .where(sql`ST_DWithin(                                                         coordinates::geography,ST_MakePoint(${lat},${long}),8000)`)
            .select(
                [
                    sql<string>`ST_X(coordinates)`.as("latitude"),
                    sql<string>`ST_Y(coordinates)`.as("longitude"),
                    "name"
                ]
            )
            .execute()