[Midnightbsd-cvs] mports [19032] trunk/Tools/magus/ready_ports.sql: add a copy of ready ports

[laffer1 at midnightbsd.org]

Revision: 19032
          http://svnweb.midnightbsd.org/mports/?rev=19032
Author:   laffer1
Date:     2015-05-16 10:08:31 -0400 (Sat, 16 May 2015)
Log Message:
-----------
add a copy of ready ports

Added Paths:
-----------
    trunk/Tools/magus/ready_ports.sql

Added: trunk/Tools/magus/ready_ports.sql
===================================================================
--- trunk/Tools/magus/ready_ports.sql	                        (rev 0)
+++ trunk/Tools/magus/ready_ports.sql	2015-05-16 14:08:31 UTC (rev 19032)
@@ -0,0 +1 @@
+ALTER ALGORITHM=UNDEFINED DEFINER=`ctriv`@`%` SQL SECURITY DEFINER VIEW `ready_ports` AS select `ports`.`id` AS `id`,`ports`.`run` AS `run`,`ports`.`name` AS `name`,`ports`.`pkgname` AS `pkgname`,`ports`.`version` AS `version`,`ports`.`description` AS `description`,`ports`.`license` AS `license`,`ports`.`www` AS `www`,`ports`.`status` AS `status`,`ports`.`updated` AS `updated`,(select count(0) AS `COUNT(*)` from `depends` where (`depends`.`dependency` = `ports`.`id`)) AS `priority` from `ports` where ((`ports`.`status` = _latin1'untested') and (not(`ports`.`id` in (select `locks`.`port` AS `port` from `locks` where (`locks`.`port` = `ports`.`id`)))) and ((not(`ports`.`id` in (select `depends`.`port` AS `port` from `depends` where (`depends`.`port` = `ports`.`id`)))) or (not(`ports`.`id` in (select `depends`.`port` AS `port` from `depends` where ((not(`depends`.`dependency` in (select `ports`.`id` AS `dep_id` from `ports` where ((`ports`.`id` = `depends`.`dependency`) and ((`ports`.`status` = _latin1'pass') or (`ports`.`status` = _latin1'warn')))))) or `depends`.`dependency` in (select `locks`.`port` AS `port` from `locks` where (`locks`.`port` = `ports`.`id`)))))))) order by (select count(0) AS `COUNT(*)` from `depends` where (`depends`.`dependency` = `ports`.`id`)) desc


Property changes on: trunk/Tools/magus/ready_ports.sql
___________________________________________________________________
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
Added: svn:mime-type
## -0,0 +1 ##
+text/plain
\ No newline at end of property