Odoo 中文社区

RT, Thanks.

@digitalsatori thanks a lot

CREATE OR REPLACE FUNCTION fix_mimetype
(
)
RETURNS TRIGGER AS $$
        BEGIN
        	IF  NEW.mimetype = 'text/plain'
        	    AND NEW.datas_fname LIKE '%.js'
        	THEN
        		UPDATE
        			ir_attachment
        		SET
        			mimetype = 'text/javascript'
        		WHERE
        			id = NEW.id;
        	END IF;
        	
        	RETURN NULL;
        END;

$$language plpgsql;

CREATE TRIGGER mimetype_changed AFTER INSERT OR UPDATE
ON ir_attachment FOR EACH ROW EXECUTE PROCEDURE fix_mimetype();