node-sql/test/dialects/join-to-tests.js at c6786135035e8c5f87fc3a931285d6ad58822305 · brianc/node-sql · 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
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
'use strict';
var Sql = require(__dirname + '/../../lib');
var sql = new Sql();

var Harness = require('./support');

var user = sql.define({
  name: 'user',
  columns: {
    id: {
      primaryKey: true
    }
  }
});

var photo = sql.define({
  name: 'photo',
  columns: {
    ownerId: {
      references: 'user'
    }
  }
});

var post = sql.define({
  name: 'post',
  columns: {
    id: {
      primaryKey: true
    },
    ownerId: {
      references: {
        table: 'user',
        column: 'id'
      }
    }
  }
});

Harness.test({
  query: user.joinTo(post),
  pg: {
    text  : '"user" INNER JOIN "post" ON ("user"."id" = "post"."ownerId")',
    string: '"user" INNER JOIN "post" ON ("user"."id" = "post"."ownerId")'
  },
  sqlite: {
    text  : '"user" INNER JOIN "post" ON ("user"."id" = "post"."ownerId")',
    string: '"user" INNER JOIN "post" ON ("user"."id" = "post"."ownerId")'
  },
  mysql: {
    text  : '`user` INNER JOIN `post` ON (`user`.`id` = `post`.`ownerId`)',
    string: '`user` INNER JOIN `post` ON (`user`.`id` = `post`.`ownerId`)'
  },
  mssql: {
    text  : '[user] INNER JOIN [post] ON ([user].[id] = [post].[ownerId])',
    string: '[user] INNER JOIN [post] ON ([user].[id] = [post].[ownerId])'
  },
  oracle: {
    text  : '"user" INNER JOIN "post" ON ("user"."id" = "post"."ownerId")',
    string: '"user" INNER JOIN "post" ON ("user"."id" = "post"."ownerId")'
  },
  params: []
});

Harness.test({
  query: post.joinTo(user),
  pg: {
    text  : '"post" INNER JOIN "user" ON ("user"."id" = "post"."ownerId")',
    string: '"post" INNER JOIN "user" ON ("user"."id" = "post"."ownerId")'
  },
  sqlite: {
    text  : '"post" INNER JOIN "user" ON ("user"."id" = "post"."ownerId")',
    string: '"post" INNER JOIN "user" ON ("user"."id" = "post"."ownerId")'
  },
  mysql: {
    text  : '`post` INNER JOIN `user` ON (`user`.`id` = `post`.`ownerId`)',
    string: '`post` INNER JOIN `user` ON (`user`.`id` = `post`.`ownerId`)'
  },
  mssql: {
    text  : '[post] INNER JOIN [user] ON ([user].[id] = [post].[ownerId])',
    string: '[post] INNER JOIN [user] ON ([user].[id] = [post].[ownerId])'
  },
  oracle: {
    text  : '"post" INNER JOIN "user" ON ("user"."id" = "post"."ownerId")',
    string: '"post" INNER JOIN "user" ON ("user"."id" = "post"."ownerId")'
  },
  params: []
});

Harness.test({
  query: user.joinTo(photo),
  pg: {
    text  : '"user" INNER JOIN "photo" ON ("user"."id" = "photo"."ownerId")',
    string: '"user" INNER JOIN "photo" ON ("user"."id" = "photo"."ownerId")'
  },
  sqlite: {
    text  : '"user" INNER JOIN "photo" ON ("user"."id" = "photo"."ownerId")',
    string: '"user" INNER JOIN "photo" ON ("user"."id" = "photo"."ownerId")'
  },
  mysql: {
    text  : '`user` INNER JOIN `photo` ON (`user`.`id` = `photo`.`ownerId`)',
    string: '`user` INNER JOIN `photo` ON (`user`.`id` = `photo`.`ownerId`)'
  },
  mssql: {
    text  : '[user] INNER JOIN [photo] ON ([user].[id] = [photo].[ownerId])',
    string: '[user] INNER JOIN [photo] ON ([user].[id] = [photo].[ownerId])'
  },
  oracle: {
    text  : '"user" INNER JOIN "photo" ON ("user"."id" = "photo"."ownerId")',
    string: '"user" INNER JOIN "photo" ON ("user"."id" = "photo"."ownerId")'
  },
  params: []
});