ERP 2.50:Acceptance Testing/Attribute set script postgreSQL
Script for 2.40/2.3x
CREATE OR REPLACE FUNCTION create_attributeSet()
RETURNS void AS
$BODY$ DECLARE
v_attributeset_id NUMERIC(10);
v_client_id NUMERIC(10);
BEGIN
SELECT MAX(AD_CLIENT_ID) INTO v_client_id FROM AD_CLIENT;
SELECT COALESCE(MAX(M_ATTRIBUTESET_ID),999999)+1 INTO v_attributeset_id FROM M_ATTRIBUTESET;
INSERT INTO M_ATTRIBUTESET (M_ATTRIBUTESET_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED,CREATEDBY, UPDATED, UPDATEDBY, NAME, ISLOT, ISGUARANTEEDATE, ISSERNO)
VALUES(v_attributeset_id, v_client_id, 0, 'Y', now(), 100,now(),100,'Lots','Y','Y','N');
PERFORM AD_UPDATE_SEQUENCE();
END ; $BODY$
LANGUAGE 'plpgsql' VOLATILE;
SELECT create_attributeSet();
DROP FUNCTION create_attributeSet();
Script for 2.50
CREATE OR REPLACE FUNCTION create_attributeSet()
RETURNS void AS
$BODY$ DECLARE
v_attributeset_id varchar(32);
v_client_id varchar(32);
BEGIN
SELECT AD_CLIENT_ID INTO v_client_id FROM AD_CLIENT WHERE created=(SELECT max(created) FROM ad_client);
SELECT get_uuid() INTO v_attributeset_id;
INSERT INTO M_ATTRIBUTESET (M_ATTRIBUTESET_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED,CREATEDBY, UPDATED, UPDATEDBY, NAME, ISLOT, ISGUARANTEEDATE, ISSERNO)
VALUES(v_attributeset_id, v_client_id, 0, 'Y', now(), 100,now(),100,'Lots','Y','Y','N');
END ; $BODY$
LANGUAGE 'plpgsql' VOLATILE;
SELECT create_attributeSet();
DROP FUNCTION create_attributeSet();