FilesExpand file tree

main

/

schema_examples.mjs

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

138 lines (126 loc) · 3.89 KB

main

/

schema_examples.mjs

Copy path

Top

File metadata and controls

• Code
• Blame

138 lines (126 loc) · 3.89 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

/**

* @typedef {Object} SchemaExample

* @property {string} current

* @property {string} desired

*/

/**

* @type {Record<string, SchemaExample>}

*/

export const schemaExamples = {

mysql: {

current: `CREATE TABLE authors (

id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(255) NOT NULL

) Engine=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE books (

id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,

title VARCHAR(255) NOT NULL,

author_id BIGINT UNSIGNED NOT NULL,

price DECIMAL(10, 2) NOT NULL,

CONSTRAINT fk_books_author FOREIGN KEY (author_id) REFERENCES authors(id)

) Engine=InnoDB DEFAULT CHARSET=utf8mb4;`,

desired: `CREATE TABLE authors (

id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(255) NOT NULL

) Engine=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE books (

id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,

title VARCHAR(255) NOT NULL,

author_id BIGINT UNSIGNED NOT NULL,

price DECIMAL(10, 2) NOT NULL,

stock INT NOT NULL DEFAULT 0,

CONSTRAINT fk_books_author FOREIGN KEY (author_id) REFERENCES authors(id),

CONSTRAINT chk_price CHECK (price > 0),

CONSTRAINT chk_stock CHECK (stock >= 0),

INDEX idx_author (author_id),

INDEX idx_price (price)

) Engine=InnoDB DEFAULT CHARSET=utf8mb4;`,

},

postgres: {

current: `CREATE TABLE authors (

id BIGSERIAL PRIMARY KEY,

name VARCHAR(255) NOT NULL

);

CREATE TABLE books (

id BIGSERIAL PRIMARY KEY,

title VARCHAR(255) NOT NULL,

author_id BIGINT NOT NULL,

price DECIMAL(10, 2) NOT NULL,

CONSTRAINT fk_books_author FOREIGN KEY (author_id) REFERENCES authors(id)

);`,

desired: `CREATE TABLE authors (

id BIGSERIAL PRIMARY KEY,

name VARCHAR(255) NOT NULL

);

CREATE TABLE books (

id BIGSERIAL PRIMARY KEY,

title VARCHAR(255) NOT NULL,

author_id BIGINT NOT NULL,

price DECIMAL(10, 2) NOT NULL,

stock INT NOT NULL DEFAULT 0,

CONSTRAINT fk_books_author FOREIGN KEY (author_id) REFERENCES authors(id),

CONSTRAINT chk_price CHECK (price > 0),

CONSTRAINT chk_stock CHECK (stock >= 0)

);

CREATE INDEX idx_books_author ON books(author_id);

CREATE INDEX idx_books_price ON books(price);`,

},

sqlite3: {

current: `CREATE TABLE authors (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL

);

CREATE TABLE books (

id INTEGER PRIMARY KEY AUTOINCREMENT,

title TEXT NOT NULL,

author_id INTEGER NOT NULL,

price REAL NOT NULL,

CONSTRAINT fk_books_author FOREIGN KEY (author_id) REFERENCES authors(id)

);`,

desired: `CREATE TABLE authors (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL

);

CREATE TABLE books (

id INTEGER PRIMARY KEY AUTOINCREMENT,

title TEXT NOT NULL,

author_id INTEGER NOT NULL,

price REAL NOT NULL,

stock INTEGER NOT NULL DEFAULT 0,

CONSTRAINT fk_books_author FOREIGN KEY (author_id) REFERENCES authors(id),

CONSTRAINT chk_price CHECK (price > 0),

CONSTRAINT chk_stock CHECK (stock >= 0)

);

CREATE INDEX idx_books_author ON books(author_id);

CREATE INDEX idx_books_price ON books(price);`,

},

mssql: {

current: `CREATE TABLE authors (

id BIGINT IDENTITY(1,1) PRIMARY KEY,

name NVARCHAR(255) NOT NULL

);

CREATE TABLE books (

id BIGINT IDENTITY(1,1) PRIMARY KEY,

title NVARCHAR(255) NOT NULL,

author_id BIGINT NOT NULL,

price DECIMAL(10, 2) NOT NULL,

CONSTRAINT fk_books_author FOREIGN KEY (author_id) REFERENCES authors(id)

);`,

desired: `CREATE TABLE authors (

id BIGINT IDENTITY(1,1) PRIMARY KEY,

name NVARCHAR(255) NOT NULL

);

CREATE TABLE books (

id BIGINT IDENTITY(1,1) PRIMARY KEY,

title NVARCHAR(255) NOT NULL,

author_id BIGINT NOT NULL,

price DECIMAL(10, 2) NOT NULL,

stock INT NOT NULL DEFAULT 0,

CONSTRAINT fk_books_author FOREIGN KEY (author_id) REFERENCES authors(id),

CONSTRAINT chk_price CHECK (price > 0),

CONSTRAINT chk_stock CHECK (stock >= 0)

);

CREATE INDEX idx_books_author ON books(author_id);

CREATE INDEX idx_books_price ON books(price);`,

},

};