7 use DBIC::SqlMakerTest;
9 my $schema = DBICTest->init_schema;
11 $schema->storage->_sql_maker->limit_dialect ('GenericSubQ');
13 my $rs = $schema->resultset ('BooksInLibrary')->search ({}, {
14 '+columns' => [{ owner_name => 'owner.name' }],
17 order_by => 'me.title',
23 SELECT id, source, owner, title, price,
26 SELECT me.id, me.source, me.owner, me.title, me.price,
27 owner.name AS owner_name
29 JOIN owners owner ON owner.id = me.owner
35 FROM books rownum__emulation
36 WHERE rownum__emulation.title < me.title
40 [ [ 'source', 'Library' ] ],
44 [ $rs->get_column ('title')->all ],
45 ['Best Recipe Cookbook', 'Dynamical Systems'],
46 'Correct columns selected with rows',
49 $schema->storage->_sql_maker->quote_char ('"');
50 $schema->storage->_sql_maker->name_sep ('.');
52 $rs = $schema->resultset ('BooksInLibrary')->search ({}, {
53 order_by => { -desc => 'title' },
54 '+select' => ['owner.name'],
55 '+as' => ['owner.name'],
64 SELECT "id", "source", "owner", "title", "price",
67 SELECT "me"."id", "me"."source", "me"."owner", "me"."title", "me"."price",
68 "owner"."name" AS "owner__name"
70 JOIN "owners" "owner" ON "owner"."id" = "me"."owner"
71 WHERE ( "source" = ? )
76 FROM "books" "rownum__emulation"
77 WHERE "rownum__emulation"."title" > "me"."title"
81 [ [ 'source', 'Library' ] ],
85 [ $rs->get_column ('title')->all ],
86 [ 'Dynamical Systems', 'Best Recipe Cookbook' ],
87 'Correct columns selected with rows',
90 $rs = $schema->resultset ('BooksInLibrary')->search ({}, {
92 'select' => ['owner.name'],
93 'as' => ['owner_name'],
103 SELECT "owner"."name" AS "owner_name", "title"
105 JOIN "owners" "owner" ON "owner"."id" = "me"."owner"
106 WHERE ( "source" = ? )
111 FROM "books" "rownum__emulation"
112 WHERE "rownum__emulation"."title" < "me"."title"
113 ) BETWEEN 1 AND 4294967295
116 [ [ 'source', 'Library' ] ],
120 [ $rs->get_column ('owner_name')->all ],
122 'Correct columns selected with rows',
126 $rs = $schema->resultset('Artist')->search({}, {
131 local $rs->result_source->{name} = "weird \n newline/multi \t \t space containing \n table";
134 ${$rs->as_query}->[0],
135 qr| weird \s \n \s newline/multi \s \t \s \t \s space \s containing \s \n \s table|x,
136 'Newlines/spaces preserved in final sql',