<div dir="ltr"><div><div><div>No This doesn't work since DBIx converts this into below quries<br><br></div>SELECT * FROM User WHERE GroupId = 712;<br></div>SELECT * FROM User WHERE Id = 1;<br>DELETE FROM User WHERE Id = 1;<br>
SELECT * FROM User WHERE Id = 2;<br>DELETE FROM User WHERE Id = 2;<br>SELECT * FROM User WHERE Id = 3;<br>DELETE FROM User WHERE Id = 3;<br><br><br></div>and so on<br><br>So if we have 100 Users it would 201 (1 + 100 + 100) queries.<br>
</div><div class="gmail_extra"><br clear="all"><div><div dir="ltr"><div><br></div>Best Regards, <br>Sheeju Alex<br>
<div style="display:inline"></div></div></div>
<br><br><div class="gmail_quote">On Thu, Aug 28, 2014 at 5:38 PM, Will Crawford <span dir="ltr"><<a href="mailto:billcrawford1970@gmail.com" target="_blank">billcrawford1970@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
$schema->resultset('User')->search({GroupId => 712})->delete;<br>
<div><div class="h5"><br>
On 28 August 2014 13:01, Sheeju Alex <<a href="mailto:sheejuec7@gmail.com">sheejuec7@gmail.com</a>> wrote:<br>
> Hi All,<br>
><br>
> Is there any way in DBIx to delete all rows from resultset in a single<br>
> query, it looks like delete and delete_all will delete the resultset row by<br>
> row.<br>
><br>
> my $rs = $schema->resultset('User')->search({GroupId => 712});<br>
> $rs->delete_all;<br>
><br>
> If there are 100 Users in User table then the above statement will delete in<br>
> 100 query instead is there a way to delete in single query.<br>
><br>
> DELETE FROM User WHERE GroupId = 712;<br>
><br>
><br>
> Best Regards,<br>
> Sheeju Alex<br>
><br>
</div></div>> _______________________________________________<br>
> List: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class" target="_blank">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class</a><br>
> IRC: <a href="http://irc.perl.org#dbix-class" target="_blank">irc.perl.org#dbix-class</a><br>
> SVN: <a href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/" target="_blank">http://dev.catalyst.perl.org/repos/bast/DBIx-Class/</a><br>
> Searchable Archive:<br>
> <a href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk" target="_blank">http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk</a><br>
<br>
_______________________________________________<br>
List: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class" target="_blank">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class</a><br>
IRC: <a href="http://irc.perl.org#dbix-class" target="_blank">irc.perl.org#dbix-class</a><br>
SVN: <a href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/" target="_blank">http://dev.catalyst.perl.org/repos/bast/DBIx-Class/</a><br>
Searchable Archive: <a href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk" target="_blank">http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk</a><br>
</blockquote></div><br></div>