| 6dd74de | | | 1 | import { imgSnapshotTest, renderGraph } from '../../helpers/util.ts'; |
| 6dd74de | | | 2 | |
| 6dd74de | | | 3 | describe('Entity Relationship Diagram', () => { |
| 6dd74de | | | 4 | it('should render a simple ER diagram', () => { |
| 6dd74de | | | 5 | imgSnapshotTest( |
| 6dd74de | | | 6 | ` |
| 6dd74de | | | 7 | erDiagram |
| 6dd74de | | | 8 | CUSTOMER ||--o{ ORDER : places |
| 6dd74de | | | 9 | ORDER ||--|{ LINE-ITEM : contains |
| 6dd74de | | | 10 | `, |
| 6dd74de | | | 11 | { logLevel: 1 } |
| 6dd74de | | | 12 | ); |
| 6dd74de | | | 13 | }); |
| 6dd74de | | | 14 | |
| 6dd74de | | | 15 | it('should render an ER diagram with a recursive relationship', () => { |
| 6dd74de | | | 16 | imgSnapshotTest( |
| 6dd74de | | | 17 | ` |
| 6dd74de | | | 18 | erDiagram |
| 6dd74de | | | 19 | CUSTOMER ||..o{ CUSTOMER : refers |
| 6dd74de | | | 20 | CUSTOMER ||--o{ ORDER : places |
| 6dd74de | | | 21 | ORDER ||--|{ LINE-ITEM : contains |
| 6dd74de | | | 22 | `, |
| 6dd74de | | | 23 | { logLevel: 1 } |
| 6dd74de | | | 24 | ); |
| 6dd74de | | | 25 | }); |
| 6dd74de | | | 26 | |
| 6dd74de | | | 27 | it('should render an ER diagram with multiple relationships between the same two entities', () => { |
| 6dd74de | | | 28 | imgSnapshotTest( |
| 6dd74de | | | 29 | ` |
| 6dd74de | | | 30 | erDiagram |
| 6dd74de | | | 31 | CUSTOMER ||--|{ ADDRESS : "invoiced at" |
| 6dd74de | | | 32 | CUSTOMER ||--|{ ADDRESS : "receives goods at" |
| 6dd74de | | | 33 | `, |
| 6dd74de | | | 34 | { logLevel: 1 } |
| 6dd74de | | | 35 | ); |
| 6dd74de | | | 36 | }); |
| 6dd74de | | | 37 | |
| 6dd74de | | | 38 | it('should render a cyclical ER diagram', () => { |
| 6dd74de | | | 39 | imgSnapshotTest( |
| 6dd74de | | | 40 | ` |
| 6dd74de | | | 41 | erDiagram |
| 6dd74de | | | 42 | A ||--|{ B : likes |
| 6dd74de | | | 43 | B ||--|{ C : likes |
| 6dd74de | | | 44 | C ||--|{ A : likes |
| 6dd74de | | | 45 | `, |
| 6dd74de | | | 46 | { logLevel: 1 } |
| 6dd74de | | | 47 | ); |
| 6dd74de | | | 48 | }); |
| 6dd74de | | | 49 | |
| 6dd74de | | | 50 | it('should render a not-so-simple ER diagram', () => { |
| 6dd74de | | | 51 | imgSnapshotTest( |
| 6dd74de | | | 52 | ` |
| 6dd74de | | | 53 | erDiagram |
| 6dd74de | | | 54 | CUSTOMER }|..|{ DELIVERY-ADDRESS : has |
| 6dd74de | | | 55 | CUSTOMER ||--o{ ORDER : places |
| 6dd74de | | | 56 | CUSTOMER ||--o{ INVOICE : "liable for" |
| 6dd74de | | | 57 | DELIVERY-ADDRESS ||--o{ ORDER : receives |
| 6dd74de | | | 58 | INVOICE ||--|{ ORDER : covers |
| 6dd74de | | | 59 | ORDER ||--|{ ORDER-ITEM : includes |
| 6dd74de | | | 60 | PRODUCT-CATEGORY ||--|{ PRODUCT : contains |
| 6dd74de | | | 61 | PRODUCT ||--o{ ORDER-ITEM : "ordered in" |
| 6dd74de | | | 62 | `, |
| 6dd74de | | | 63 | { logLevel: 1 } |
| 6dd74de | | | 64 | ); |
| 6dd74de | | | 65 | }); |
| 6dd74de | | | 66 | |
| 6dd74de | | | 67 | it('should render multiple ER diagrams', () => { |
| 6dd74de | | | 68 | imgSnapshotTest( |
| 6dd74de | | | 69 | [ |
| 6dd74de | | | 70 | ` |
| 6dd74de | | | 71 | erDiagram |
| 6dd74de | | | 72 | CUSTOMER ||--o{ ORDER : places |
| 6dd74de | | | 73 | ORDER ||--|{ LINE-ITEM : contains |
| 6dd74de | | | 74 | `, |
| 6dd74de | | | 75 | ` |
| 6dd74de | | | 76 | erDiagram |
| 6dd74de | | | 77 | CUSTOMER ||--o{ ORDER : places |
| 6dd74de | | | 78 | ORDER ||--|{ LINE-ITEM : contains |
| 6dd74de | | | 79 | `, |
| 6dd74de | | | 80 | ], |
| 6dd74de | | | 81 | { logLevel: 1 } |
| 6dd74de | | | 82 | ); |
| 6dd74de | | | 83 | }); |
| 6dd74de | | | 84 | |
| 6dd74de | | | 85 | it('should render an ER diagram with blank or empty labels', () => { |
| 6dd74de | | | 86 | imgSnapshotTest( |
| 6dd74de | | | 87 | ` |
| 6dd74de | | | 88 | erDiagram |
| 6dd74de | | | 89 | BOOK }|..|{ AUTHOR : "" |
| 6dd74de | | | 90 | BOOK }|..|{ GENRE : " " |
| 6dd74de | | | 91 | AUTHOR }|..|{ GENRE : " " |
| 6dd74de | | | 92 | `, |
| 6dd74de | | | 93 | { logLevel: 1 } |
| 6dd74de | | | 94 | ); |
| 6dd74de | | | 95 | }); |
| 6dd74de | | | 96 | |
| 6dd74de | | | 97 | it('should render an ER diagrams when useMaxWidth is true (default)', () => { |
| 6dd74de | | | 98 | renderGraph( |
| 6dd74de | | | 99 | ` |
| 6dd74de | | | 100 | erDiagram |
| 6dd74de | | | 101 | CUSTOMER ||--o{ ORDER : places |
| 6dd74de | | | 102 | ORDER ||--|{ LINE-ITEM : contains |
| 6dd74de | | | 103 | `, |
| 6dd74de | | | 104 | { er: { useMaxWidth: true } } |
| 6dd74de | | | 105 | ); |
| 6dd74de | | | 106 | cy.get('svg').should((svg) => { |
| 6dd74de | | | 107 | expect(svg).to.have.attr('width', '100%'); |
| 6dd74de | | | 108 | // expect(svg).to.have.attr('height', '465'); |
| 6dd74de | | | 109 | const style = svg.attr('style'); |
| 6dd74de | | | 110 | expect(style).to.match(/^max-width: [\d.]+px;$/); |
| 6dd74de | | | 111 | const maxWidthValue = parseFloat(style.match(/[\d.]+/g).join('')); |
| 6dd74de | | | 112 | // use within because the absolute value can be slightly different depending on the environment ±6% |
| 6dd74de | | | 113 | expect(maxWidthValue).to.be.within(140 * 0.96, 140 * 1.06); |
| 6dd74de | | | 114 | }); |
| 6dd74de | | | 115 | }); |
| 6dd74de | | | 116 | |
| 6dd74de | | | 117 | it('should render an ER when useMaxWidth is false', () => { |
| 6dd74de | | | 118 | renderGraph( |
| 6dd74de | | | 119 | ` |
| 6dd74de | | | 120 | erDiagram |
| 6dd74de | | | 121 | CUSTOMER ||--o{ ORDER : places |
| 6dd74de | | | 122 | ORDER ||--|{ LINE-ITEM : contains |
| 6dd74de | | | 123 | `, |
| 6dd74de | | | 124 | { er: { useMaxWidth: false } } |
| 6dd74de | | | 125 | ); |
| 6dd74de | | | 126 | cy.get('svg').should((svg) => { |
| 6dd74de | | | 127 | const width = parseFloat(svg.attr('width')); |
| 6dd74de | | | 128 | // use within because the absolute value can be slightly different depending on the environment ±6% |
| 6dd74de | | | 129 | expect(width).to.be.within(140 * 0.96, 140 * 1.06); |
| 6dd74de | | | 130 | // expect(svg).to.have.attr('height', '465'); |
| 6dd74de | | | 131 | expect(svg).to.not.have.attr('style'); |
| 6dd74de | | | 132 | }); |
| 6dd74de | | | 133 | }); |
| 6dd74de | | | 134 | |
| 6dd74de | | | 135 | it('should render entities that have no relationships', () => { |
| 6dd74de | | | 136 | renderGraph( |
| 6dd74de | | | 137 | ` |
| 6dd74de | | | 138 | erDiagram |
| 6dd74de | | | 139 | DEAD_PARROT |
| 6dd74de | | | 140 | HERMIT |
| 6dd74de | | | 141 | RECLUSE |
| 6dd74de | | | 142 | SOCIALITE }o--o{ SOCIALITE : "interacts with" |
| 6dd74de | | | 143 | RECLUSE }o--o{ SOCIALITE : avoids |
| 6dd74de | | | 144 | `, |
| 6dd74de | | | 145 | { er: { useMaxWidth: false } } |
| 6dd74de | | | 146 | ); |
| 6dd74de | | | 147 | }); |
| 6dd74de | | | 148 | |
| 6dd74de | | | 149 | it('should render entities with and without attributes', () => { |
| 6dd74de | | | 150 | renderGraph( |
| 6dd74de | | | 151 | ` |
| 6dd74de | | | 152 | erDiagram |
| 6dd74de | | | 153 | BOOK { string title } |
| 6dd74de | | | 154 | AUTHOR }|..|{ BOOK : writes |
| 6dd74de | | | 155 | BOOK { float price } |
| 6dd74de | | | 156 | `, |
| 6dd74de | | | 157 | { logLevel: 1 } |
| 6dd74de | | | 158 | ); |
| 6dd74de | | | 159 | }); |
| 6dd74de | | | 160 | |
| 6dd74de | | | 161 | it('should render entities with generic and array attributes', () => { |
| 6dd74de | | | 162 | renderGraph( |
| 6dd74de | | | 163 | ` |
| 6dd74de | | | 164 | erDiagram |
| 6dd74de | | | 165 | BOOK { |
| 6dd74de | | | 166 | string title |
| 6dd74de | | | 167 | string[] authors |
| 6dd74de | | | 168 | type~T~ type |
| 6dd74de | | | 169 | } |
| 6dd74de | | | 170 | `, |
| 6dd74de | | | 171 | { logLevel: 1 } |
| 6dd74de | | | 172 | ); |
| 6dd74de | | | 173 | }); |
| 6dd74de | | | 174 | |
| 6dd74de | | | 175 | it('should render entities with length in attributes type', () => { |
| 6dd74de | | | 176 | renderGraph( |
| 6dd74de | | | 177 | ` |
| 6dd74de | | | 178 | erDiagram |
| 6dd74de | | | 179 | CLUSTER { |
| 6dd74de | | | 180 | varchar(99) name |
| 6dd74de | | | 181 | string(255) description |
| 6dd74de | | | 182 | } |
| 6dd74de | | | 183 | `, |
| 6dd74de | | | 184 | { logLevel: 1 } |
| 6dd74de | | | 185 | ); |
| 6dd74de | | | 186 | }); |
| 6dd74de | | | 187 | |
| 6dd74de | | | 188 | it('should render entities and attributes with big and small entity names', () => { |
| 6dd74de | | | 189 | renderGraph( |
| 6dd74de | | | 190 | ` |
| 6dd74de | | | 191 | erDiagram |
| 6dd74de | | | 192 | PRIVATE_FINANCIAL_INSTITUTION { |
| 6dd74de | | | 193 | string name |
| 6dd74de | | | 194 | int turnover |
| 6dd74de | | | 195 | } |
| 6dd74de | | | 196 | PRIVATE_FINANCIAL_INSTITUTION ||..|{ EMPLOYEE : employs |
| 6dd74de | | | 197 | EMPLOYEE { bool officer_of_firm } |
| 6dd74de | | | 198 | `, |
| 6dd74de | | | 199 | { logLevel: 1 } |
| 6dd74de | | | 200 | ); |
| 6dd74de | | | 201 | }); |
| 6dd74de | | | 202 | |
| 6dd74de | | | 203 | it('should render entities with attributes that begin with asterisk', () => { |
| 6dd74de | | | 204 | imgSnapshotTest( |
| 6dd74de | | | 205 | ` |
| 6dd74de | | | 206 | erDiagram |
| 6dd74de | | | 207 | BOOK { |
| 6dd74de | | | 208 | int *id |
| 6dd74de | | | 209 | string name |
| 6dd74de | | | 210 | varchar(99) summary |
| 6dd74de | | | 211 | } |
| 6dd74de | | | 212 | BOOK }o..o{ STORE : soldBy |
| 6dd74de | | | 213 | STORE { |
| 6dd74de | | | 214 | int *id |
| 6dd74de | | | 215 | string name |
| 6dd74de | | | 216 | varchar(50) address |
| 6dd74de | | | 217 | } |
| 6dd74de | | | 218 | `, |
| 6dd74de | | | 219 | { loglevel: 1 } |
| 6dd74de | | | 220 | ); |
| 6dd74de | | | 221 | }); |
| 6dd74de | | | 222 | |
| 6dd74de | | | 223 | it('should render entities with keys', () => { |
| 6dd74de | | | 224 | renderGraph( |
| 6dd74de | | | 225 | ` |
| 6dd74de | | | 226 | erDiagram |
| 6dd74de | | | 227 | AUTHOR_WITH_LONG_ENTITY_NAME { |
| 6dd74de | | | 228 | string name PK |
| 6dd74de | | | 229 | } |
| 6dd74de | | | 230 | AUTHOR_WITH_LONG_ENTITY_NAME }|..|{ BOOK : writes |
| 6dd74de | | | 231 | BOOK { |
| 6dd74de | | | 232 | float price |
| 6dd74de | | | 233 | string author FK |
| 6dd74de | | | 234 | string title PK |
| 6dd74de | | | 235 | } |
| 6dd74de | | | 236 | `, |
| 6dd74de | | | 237 | { logLevel: 1 } |
| 6dd74de | | | 238 | ); |
| 6dd74de | | | 239 | }); |
| 6dd74de | | | 240 | |
| 6dd74de | | | 241 | it('should render entities with comments', () => { |
| 6dd74de | | | 242 | renderGraph( |
| 6dd74de | | | 243 | ` |
| 6dd74de | | | 244 | erDiagram |
| 6dd74de | | | 245 | AUTHOR_WITH_LONG_ENTITY_NAME { |
| 6dd74de | | | 246 | string name "comment" |
| 6dd74de | | | 247 | } |
| 6dd74de | | | 248 | AUTHOR_WITH_LONG_ENTITY_NAME }|..|{ BOOK : writes |
| 6dd74de | | | 249 | BOOK { |
| 6dd74de | | | 250 | string author |
| 6dd74de | | | 251 | string title "author comment" |
| 6dd74de | | | 252 | float price "price comment" |
| 6dd74de | | | 253 | } |
| 6dd74de | | | 254 | `, |
| 6dd74de | | | 255 | { logLevel: 1 } |
| 6dd74de | | | 256 | ); |
| 6dd74de | | | 257 | }); |
| 6dd74de | | | 258 | |
| 6dd74de | | | 259 | it('should render entities with keys and comments', () => { |
| 6dd74de | | | 260 | renderGraph( |
| 6dd74de | | | 261 | ` |
| 6dd74de | | | 262 | erDiagram |
| 6dd74de | | | 263 | AUTHOR_WITH_LONG_ENTITY_NAME { |
| 6dd74de | | | 264 | string name PK "comment" |
| 6dd74de | | | 265 | } |
| 6dd74de | | | 266 | AUTHOR_WITH_LONG_ENTITY_NAME }|..|{ BOOK : writes |
| 6dd74de | | | 267 | BOOK { |
| 6dd74de | | | 268 | string description |
| 6dd74de | | | 269 | float price "price comment" |
| 6dd74de | | | 270 | string title PK "title comment" |
| 6dd74de | | | 271 | string author FK |
| 6dd74de | | | 272 | } |
| 6dd74de | | | 273 | `, |
| 6dd74de | | | 274 | { logLevel: 1 } |
| 6dd74de | | | 275 | ); |
| 6dd74de | | | 276 | }); |
| 6dd74de | | | 277 | |
| 6dd74de | | | 278 | it('should render entities with aliases', () => { |
| 6dd74de | | | 279 | renderGraph( |
| 6dd74de | | | 280 | ` |
| 6dd74de | | | 281 | erDiagram |
| 6dd74de | | | 282 | T1 one or zero to one or more T2 : test |
| 6dd74de | | | 283 | T2 one or many optionally to zero or one T3 : test |
| 6dd74de | | | 284 | T3 zero or more to zero or many T4 : test |
| 6dd74de | | | 285 | T4 many(0) to many(1) T5 : test |
| 6dd74de | | | 286 | T5 many optionally to one T6 : test |
| 6dd74de | | | 287 | T6 only one optionally to only one T1 : test |
| 6dd74de | | | 288 | T4 0+ to 1+ T6 : test |
| 6dd74de | | | 289 | T1 1 to 1 T3 : test |
| 6dd74de | | | 290 | `, |
| 6dd74de | | | 291 | { logLevel: 1 } |
| 6dd74de | | | 292 | ); |
| 6dd74de | | | 293 | }); |
| 6dd74de | | | 294 | |
| 6dd74de | | | 295 | it('1433: should render a simple ER diagram with a title', () => { |
| 6dd74de | | | 296 | imgSnapshotTest( |
| 6dd74de | | | 297 | `--- |
| 6dd74de | | | 298 | title: simple ER diagram |
| 6dd74de | | | 299 | --- |
| 6dd74de | | | 300 | erDiagram |
| 6dd74de | | | 301 | CUSTOMER ||--o{ ORDER : places |
| 6dd74de | | | 302 | ORDER ||--|{ LINE-ITEM : contains |
| 6dd74de | | | 303 | `, |
| 6dd74de | | | 304 | {} |
| 6dd74de | | | 305 | ); |
| 6dd74de | | | 306 | }); |
| 6dd74de | | | 307 | |
| 6dd74de | | | 308 | it('should render entities with entity name aliases', () => { |
| 6dd74de | | | 309 | imgSnapshotTest( |
| 6dd74de | | | 310 | ` |
| 6dd74de | | | 311 | erDiagram |
| 6dd74de | | | 312 | p[Person] { |
| 6dd74de | | | 313 | varchar(64) firstName |
| 6dd74de | | | 314 | varchar(64) lastName |
| 6dd74de | | | 315 | } |
| 6dd74de | | | 316 | c["Customer Account"] { |
| 6dd74de | | | 317 | varchar(128) email |
| 6dd74de | | | 318 | } |
| 6dd74de | | | 319 | p ||--o| c : has |
| 6dd74de | | | 320 | `, |
| 6dd74de | | | 321 | { logLevel: 1 } |
| 6dd74de | | | 322 | ); |
| 6dd74de | | | 323 | }); |
| 6dd74de | | | 324 | |
| 6dd74de | | | 325 | it('should render relationship labels with line breaks', () => { |
| 6dd74de | | | 326 | imgSnapshotTest( |
| 6dd74de | | | 327 | ` |
| 6dd74de | | | 328 | erDiagram |
| 6dd74de | | | 329 | p[Person] { |
| 6dd74de | | | 330 | string firstName |
| 6dd74de | | | 331 | string lastName |
| 6dd74de | | | 332 | } |
| 6dd74de | | | 333 | a["Customer Account"] { |
| 6dd74de | | | 334 | string email |
| 6dd74de | | | 335 | } |
| 6dd74de | | | 336 | |
| 6dd74de | | | 337 | b["Customer Account Secondary"] { |
| 6dd74de | | | 338 | string email |
| 6dd74de | | | 339 | } |
| 6dd74de | | | 340 | |
| 6dd74de | | | 341 | c["Customer Account Tertiary"] { |
| 6dd74de | | | 342 | string email |
| 6dd74de | | | 343 | } |
| 6dd74de | | | 344 | |
| 6dd74de | | | 345 | d["Customer Account Nth"] { |
| 6dd74de | | | 346 | string email |
| 6dd74de | | | 347 | } |
| 6dd74de | | | 348 | |
| 6dd74de | | | 349 | p ||--o| a : "has<br />one" |
| 6dd74de | | | 350 | p ||--o| b : "has<br />one<br />two" |
| 6dd74de | | | 351 | p ||--o| c : "has<br />one<br/>two<br />three" |
| 6dd74de | | | 352 | p ||--o| d : "has<br />one<br />two<br/>three<br />...<br/>Nth" |
| 6dd74de | | | 353 | `, |
| 6dd74de | | | 354 | { logLevel: 1 } |
| 6dd74de | | | 355 | ); |
| 6dd74de | | | 356 | }); |
| 6dd74de | | | 357 | |
| 6dd74de | | | 358 | describe('Include char sequence "graph" in text (#6795)', () => { |
| 6dd74de | | | 359 | it('has a label with char sequence "graph"', () => { |
| 6dd74de | | | 360 | imgSnapshotTest( |
| 6dd74de | | | 361 | ` |
| 6dd74de | | | 362 | erDiagram |
| 6dd74de | | | 363 | p[Photograph] { |
| 6dd74de | | | 364 | varchar(12) jobId |
| 6dd74de | | | 365 | date dateCreated |
| 6dd74de | | | 366 | } |
| 6dd74de | | | 367 | `, |
| 6dd74de | | | 368 | { flowchart: { defaultRenderer: 'elk' } } |
| 6dd74de | | | 369 | ); |
| 6dd74de | | | 370 | }); |
| 6dd74de | | | 371 | }); |
| 6dd74de | | | 372 | |
| 6dd74de | | | 373 | describe('Special characters and numbers syntax', () => { |
| 6dd74de | | | 374 | it('should render ER diagram with numeric entity names', () => { |
| 6dd74de | | | 375 | imgSnapshotTest( |
| 6dd74de | | | 376 | ` |
| 6dd74de | | | 377 | erDiagram |
| 6dd74de | | | 378 | 1 ||--|| ORDER : places |
| 6dd74de | | | 379 | ORDER ||--|{ 2 : contains |
| 6dd74de | | | 380 | 2 ||--o{ 3.5 : references |
| 6dd74de | | | 381 | `, |
| 6dd74de | | | 382 | { logLevel: 1 } |
| 6dd74de | | | 383 | ); |
| 6dd74de | | | 384 | }); |
| 6dd74de | | | 385 | |
| 6dd74de | | | 386 | it('should render ER diagram with "u" character in entity names and cardinality', () => { |
| 6dd74de | | | 387 | imgSnapshotTest( |
| 6dd74de | | | 388 | ` |
| 6dd74de | | | 389 | erDiagram |
| 6dd74de | | | 390 | CUSTOMER ||--|| u : has |
| 6dd74de | | | 391 | u ||--|| ORDER : places |
| 6dd74de | | | 392 | PROJECT u--o{ TEAM_MEMBER : "parent" |
| 6dd74de | | | 393 | `, |
| 6dd74de | | | 394 | { logLevel: 1 } |
| 6dd74de | | | 395 | ); |
| 6dd74de | | | 396 | }); |
| 6dd74de | | | 397 | |
| 6dd74de | | | 398 | it('should render ER diagram with decimal numbers in relationships', () => { |
| 6dd74de | | | 399 | imgSnapshotTest( |
| 6dd74de | | | 400 | ` |
| 6dd74de | | | 401 | erDiagram |
| 6dd74de | | | 402 | 2.5 ||--|| 1.5 : has |
| 6dd74de | | | 403 | CUSTOMER ||--o{ 3.14 : references |
| 6dd74de | | | 404 | 1.0 ||--|{ ORDER : contains |
| 6dd74de | | | 405 | `, |
| 6dd74de | | | 406 | { logLevel: 1 } |
| 6dd74de | | | 407 | ); |
| 6dd74de | | | 408 | }); |
| 6dd74de | | | 409 | |
| 6dd74de | | | 410 | it('should render ER diagram with numeric entity names and attributes', () => { |
| 6dd74de | | | 411 | imgSnapshotTest( |
| 6dd74de | | | 412 | ` |
| 6dd74de | | | 413 | erDiagram |
| 6dd74de | | | 414 | 1 { |
| 6dd74de | | | 415 | string name |
| 6dd74de | | | 416 | int value |
| 6dd74de | | | 417 | } |
| 6dd74de | | | 418 | 1 ||--|| ORDER : places |
| 6dd74de | | | 419 | ORDER { |
| 6dd74de | | | 420 | float price |
| 6dd74de | | | 421 | string description |
| 6dd74de | | | 422 | } |
| 6dd74de | | | 423 | `, |
| 6dd74de | | | 424 | { logLevel: 1 } |
| 6dd74de | | | 425 | ); |
| 6dd74de | | | 426 | }); |
| 6dd74de | | | 427 | |
| 6dd74de | | | 428 | it('should render complex ER diagram with mixed special entity names', () => { |
| 6dd74de | | | 429 | imgSnapshotTest( |
| 6dd74de | | | 430 | ` |
| 6dd74de | | | 431 | erDiagram |
| 6dd74de | | | 432 | CUSTOMER ||--o{ 1 : places |
| 6dd74de | | | 433 | 1 ||--|{ u : contains |
| 6dd74de | | | 434 | 1.5 |
| 6dd74de | | | 435 | u ||--|| 2.5 : processes |
| 6dd74de | | | 436 | 2.5 { |
| 6dd74de | | | 437 | string id |
| 6dd74de | | | 438 | float value |
| 6dd74de | | | 439 | } |
| 6dd74de | | | 440 | u { |
| 6dd74de | | | 441 | varchar(50) name |
| 6dd74de | | | 442 | int count |
| 6dd74de | | | 443 | } |
| 6dd74de | | | 444 | `, |
| 6dd74de | | | 445 | { logLevel: 1 } |
| 6dd74de | | | 446 | ); |
| 6dd74de | | | 447 | }); |
| 6dd74de | | | 448 | it('should render ER diagram with standalone numeric entities', () => { |
| 6dd74de | | | 449 | imgSnapshotTest( |
| 6dd74de | | | 450 | `erDiagram |
| 6dd74de | | | 451 | PRODUCT ||--o{ ORDER-ITEM : has |
| 6dd74de | | | 452 | 1.5 |
| 6dd74de | | | 453 | u |
| 6dd74de | | | 454 | 1 |
| 6dd74de | | | 455 | `, |
| 6dd74de | | | 456 | { logLevel: 1 } |
| 6dd74de | | | 457 | ); |
| 6dd74de | | | 458 | }); |
| 6dd74de | | | 459 | }); |
| 6dd74de | | | 460 | |
| 6dd74de | | | 461 | it('should render edge labels correctly when flowchart htmlLabels is false', () => { |
| 6dd74de | | | 462 | imgSnapshotTest( |
| 6dd74de | | | 463 | ` |
| 6dd74de | | | 464 | erDiagram |
| 6dd74de | | | 465 | CUSTOMER ||--o{ ORDER : places |
| 6dd74de | | | 466 | ORDER ||--|{ LINE-ITEM : contains |
| 6dd74de | | | 467 | CUSTOMER ||--|{ ADDRESS : "invoiced at" |
| 6dd74de | | | 468 | CUSTOMER ||--|{ ADDRESS : "receives goods at" |
| 6dd74de | | | 469 | ORDER ||--o{ INVOICE : "liable for" |
| 6dd74de | | | 470 | `, |
| 6dd74de | | | 471 | { logLevel: 1, flowchart: { htmlLabels: false } } |
| 6dd74de | | | 472 | ); |
| 6dd74de | | | 473 | }); |
| 6dd74de | | | 474 | |
| 6dd74de | | | 475 | it('should render ER diagram with "1" cardinality alias before relationship operators', () => { |
| 6dd74de | | | 476 | imgSnapshotTest( |
| 6dd74de | | | 477 | ` |
| 6dd74de | | | 478 | erDiagram |
| 6dd74de | | | 479 | CUSTOMER 1--1 ORDER : "exactly one" |
| 6dd74de | | | 480 | ORDER 1--o{ LINE-ITEM : "one to many" |
| 6dd74de | | | 481 | PRODUCT 1--|{ CATEGORY : "one or more" |
| 6dd74de | | | 482 | USER 1..1 PROFILE : "exactly one optional" |
| 6dd74de | | | 483 | `, |
| 6dd74de | | | 484 | { logLevel: 1 } |
| 6dd74de | | | 485 | ); |
| 6dd74de | | | 486 | }); |
| 6dd74de | | | 487 | |
| 6dd74de | | | 488 | it('should render ER diagram with "1" cardinality using all 4 relationship operator styles', () => { |
| 6dd74de | | | 489 | imgSnapshotTest( |
| 6dd74de | | | 490 | ` |
| 6dd74de | | | 491 | erDiagram |
| 6dd74de | | | 492 | A 1--1 B : "solid-solid" |
| 6dd74de | | | 493 | C 1..1 D : "dotted-dotted" |
| 6dd74de | | | 494 | E 1.-1 F : "dotted-solid" |
| 6dd74de | | | 495 | G 1-.1 H : "solid-dotted" |
| 6dd74de | | | 496 | `, |
| 6dd74de | | | 497 | { logLevel: 1 } |
| 6dd74de | | | 498 | ); |
| 6dd74de | | | 499 | }); |
| 6dd74de | | | 500 | }); |