merge_insert_values_test.go

package gofixtures

import (
	"testing"

	"strings"

	"github.com/theplant/testingutils"
)

func TestMergeInsertValues(t *testing.T) {

	stmts := mergeInsertValues(splitSqls(strings.NewReader(`

INSERT INTO color_groups (id, created_at, updated_at, deleted_at, name, color) VALUES
(3, '2016-12-08 05:47:44.712578+00', '2016-12-08 05:50:53.444824+00', NULL, '黑', '#000000');
INSERT INTO color_groups (id, created_at, updated_at, deleted_at, name, color) VALUES
(2, '2016-12-08 05:42:47.762055+00', '2016-12-08 05:50:53.461951+00', NULL, '青', '#0000ff');
INSERT INTO color_groups (id, created_at, updated_at, deleted_at, name, color) VALUES
(1, '2016-12-08 05:42:33.443295+00', '2016-12-08 05:50:53.468694+00', NULL, '茶', '#8b4513');

INSERT INTO colors (id, created_at, updated_at, deleted_at, name, code, color_group_id) VALUES
(3, '2016-11-25 07:30:19.093333+00', '2016-12-02 07:30:55.425407+00', NULL, 'ﾍﾞｰｼﾞｭ', '003', 0),
(1, '2016-11-25 07:29:53.095315+00', '2016-12-02 07:32:36.315175+00', NULL, 'ﾈｲﾋﾞｰ', '001', 0),
(4, '2016-11-27 06:45:05.98972+00', '2016-12-07 03:36:33.968816+00', NULL, 'ﾌﾞﾗｳﾝ', '004', 0),
(2, '2016-11-25 07:30:06.139782+00', '2016-12-08 06:34:15.068886+00', NULL, '赤', '002', 0);

INSERT INTO public.variant_property_values (id, created_at, updated_at, variant_property_id, name, value, language_code) VALUES (35, '2017-05-25 11:32:33.489867', '2017-05-25 11:32:33.489867', 6, '023', '023', '');
INSERT INTO public.variant_property_values (id, created_at, updated_at, variant_property_id, name, value, language_code) VALUES (36, '2017-05-25 11:32:33.506489', '2017-05-25 11:32:33.506489', 6, '00S', '00S', '');

    `)))

	expected := `INSERT INTO color_groups (id, created_at, updated_at, deleted_at, name, color) VALUES
(3, '2016-12-08 05:47:44.712578+00', '2016-12-08 05:50:53.444824+00', NULL, '黑', '#000000'),
(2, '2016-12-08 05:42:47.762055+00', '2016-12-08 05:50:53.461951+00', NULL, '青', '#0000ff'),
(1, '2016-12-08 05:42:33.443295+00', '2016-12-08 05:50:53.468694+00', NULL, '茶', '#8b4513')

INSERT INTO colors (id, created_at, updated_at, deleted_at, name, code, color_group_id) VALUES
(3, '2016-11-25 07:30:19.093333+00', '2016-12-02 07:30:55.425407+00', NULL, 'ﾍﾞｰｼﾞｭ', '003', 0),
(1, '2016-11-25 07:29:53.095315+00', '2016-12-02 07:32:36.315175+00', NULL, 'ﾈｲﾋﾞｰ', '001', 0),
(4, '2016-11-27 06:45:05.98972+00', '2016-12-07 03:36:33.968816+00', NULL, 'ﾌﾞﾗｳﾝ', '004', 0),
(2, '2016-11-25 07:30:06.139782+00', '2016-12-08 06:34:15.068886+00', NULL, '赤', '002', 0)

INSERT INTO public.variant_property_values (id, created_at, updated_at, variant_property_id, name, value, language_code) VALUES
(35, '2017-05-25 11:32:33.489867', '2017-05-25 11:32:33.489867', 6, '023', '023', ''),
(36, '2017-05-25 11:32:33.506489', '2017-05-25 11:32:33.506489', 6, '00S', '00S', '')`
	if diff := testingutils.PrettyJsonDiff(expected, strings.Join(stmts, "\n\n")); len(diff) > 0 {
		t.Error(diff)
	}

}