sqlchemy/constraint_test.go at master · ioito/sqlchemy · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
package sqlchemy

import (
	"testing"
)

const tableDef = `CREATE TABLE ` + "`" + `image_properties` + "`" + ` (
  ` + "`" + `id` + "`" + ` varchar(128) CHARACTER SET ascii NOT NULL,
  ` + "`" + `image_id` + "`" + ` varchar(36) NOT NULL,
  ` + "`" + `name` + "`" + ` varchar(128) NOT NULL,
  ` + "`" + `value` + "`" + ` text,
  ` + "`" + `created_at` + "`" + ` datetime NOT NULL,
  ` + "`" + `updated_at` + "`" + ` datetime NOT NULL,
  ` + "`" + `deleted_at` + "`" + ` datetime DEFAULT NULL,
  ` + "`" + `deleted` + "`" + ` tinyint(1) NOT NULL DEFAULT '0',
  ` + "`" + `description` + "`" + ` varchar(256) DEFAULT NULL,
  ` + "`" + `external_id` + "`" + ` varchar(256) DEFAULT NULL,
  ` + "`" + `is_emulated` + "`" + ` tinyint(1) NOT NULL DEFAULT '0',
  ` + "`" + `update_version` + "`" + ` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (` + "`" + `id` + "`" + `),
  UNIQUE KEY ` + "`" + `image_id` + "`" + ` (` + "`" + `image_id` + "`" + `,` + "`" + `name` + "`" + `),
  UNIQUE KEY ` + "`" + `ix_image_properties_image_id_name` + "`" + ` (` + "`" + `image_id` + "`" + `,` + "`" + `name` + "`" + `),
  KEY ` + "`" + `ix_image_properties_image_id` + "`" + ` (` + "`" + `image_id` + "`" + `(10)),
  KEY ` + "`" + `ix_image_properties_deleted` + "`" + ` (` + "`" + `deleted` + "`" + `),
  CONSTRAINT ` + "`" + `image_properties_ibfk_1` + "`" + ` FOREIGN KEY (` + "`" + `image_id` + "`" + `) REFERENCES ` + "`" + `images` + "`" + ` (` + "`" + `id` + "`" + `)
) ENGINE=InnoDB DEFAULT CHARSET=utf8`

func TestParseCreateTable(t *testing.T) {
	t.Logf("%s", tableDef)
	cons := parseConstraints(tableDef)
	if len(cons) != 1 {
		t.Errorf("fail to find constraints")
	}
	idxs := parseIndexes(tableDef)
	if len(idxs) != 4 {
		t.Errorf("fail to find indexes")
	}
}