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 [ [ { sqlt_datatype => 'varchar', sqlt_size => 100, dbic_colname => 'source' }
45 [ $rs->get_column ('title')->all ],
46 ['Best Recipe Cookbook', 'Dynamical Systems'],
47 'Correct columns selected with rows',
50 $schema->storage->_sql_maker->quote_char ('"');
51 $schema->storage->_sql_maker->name_sep ('.');
53 $rs = $schema->resultset ('BooksInLibrary')->search ({}, {
54 order_by => { -desc => 'title' },
55 '+select' => ['owner.name'],
56 '+as' => ['owner.name'],
65 SELECT "id", "source", "owner", "title", "price",
68 SELECT "me"."id", "me"."source", "me"."owner", "me"."title", "me"."price",
69 "owner"."name" AS "owner__name"
71 JOIN "owners" "owner" ON "owner"."id" = "me"."owner"
72 WHERE ( "source" = ? )
77 FROM "books" "rownum__emulation"
78 WHERE "rownum__emulation"."title" > "me"."title"
82 [ [ { sqlt_datatype => 'varchar', sqlt_size => 100, dbic_colname => 'source' }
87 [ $rs->get_column ('title')->all ],
88 [ 'Dynamical Systems', 'Best Recipe Cookbook' ],
89 'Correct columns selected with rows',
92 $rs = $schema->resultset ('BooksInLibrary')->search ({}, {
94 'select' => ['owner.name'],
95 'as' => ['owner_name'],
105 SELECT "owner"."name" AS "owner_name", "title"
107 JOIN "owners" "owner" ON "owner"."id" = "me"."owner"
108 WHERE ( "source" = ? )
113 FROM "books" "rownum__emulation"
114 WHERE "rownum__emulation"."title" < "me"."title"
115 ) BETWEEN 1 AND 4294967295
118 [ [ { sqlt_datatype => 'varchar', sqlt_size => 100, dbic_colname => 'source' }
123 [ $rs->get_column ('owner_name')->all ],
125 'Correct columns selected with rows',
129 $rs = $schema->resultset('Artist')->search({}, {
134 local $rs->result_source->{name} = "weird \n newline/multi \t \t space containing \n table";
137 ${$rs->as_query}->[0],
138 qr| weird \s \n \s newline/multi \s \t \s \t \s space \s containing \s \n \s table|x,
139 'Newlines/spaces preserved in final sql',