om-showroom half-serious task list

[David Reyes Samblas Martinez]

2009/9/7 Sebastian Krzyszkowiak <seba.dos1 at gmail.com>:
> On 9/7/09, David Reyes Samblas Martinez <david at tuxbrain.com> wrote:
>> [2]select count(*) from package where NOT  (package Like '%-doc' or
>> package Like '%-dev' or package Like '%-dbg'  or package Like 'font-%'
>>  or package Like 'task-%' or package Like 'ttf-%'  or package Like
>> '%-locale%' or package Like 'locale-%' or package Like 'lib%' or
>> package Like 'kernel-%' or package Like 'perl-%' or package Like
>> 'python-%' or package Like 'pulseaudio-%' or package Like
>> 'util-linux-%' or package Like 'e-wm-%' or package Like 'alsa-utils-%'
>> or package Like 'abiword-%' or package Like 'evas-%' or package Like
>> 'etk-%' or package Like 'ecore-%' or package Like 'e2fsprogs-%' or
>> package Like 'connman-%' or package Like 'classpath-%' or package Like
>> 'edbus-%' or package Like 'edje-%' or package Like 'efrecet-%' or
>> package Like 'emotion-%' or package Like 'epsilon-%' or package Like
>> 'ewl-%' or package Like 'finch-%' or package Like 'frameworkd-%' or
>> package Like 'gdk-%' or package Like 'glibc-%' or package Like
>> 'gnome-vfs-%' or package Like 'gpsd-%' or package Like 'gst-%' or
>> package Like 'gtk-%' or package Like 'iputils-%' or package Like
>> 'midpath-%' or package Like 'openssh-%' or package Like 'pam-%' or
>> package Like 'pango-%' or package Like 'pidgin-%' or package Like
>> 'ppp-%' or package Like 'pulseaudio-%' or package Like 'tzdata-%' or
>> package Like 'xserver-%')  Order by  package asc
>
> I think you should leave e-wm-theme-* packages. And you have
> pulseaudio-% listed two times :)
ok this happens to not do things in order :) fixed in the following query
also mateining e-wm-theme packages

select * from package where NOT  (package Like '%-doc' or package Like
'%-dev' or package Like '%-dbg'  or package Like 'font-%'  or package
Like 'task-%' or package Like 'ttf-%'  or package Like '%-locale%' or
package Like 'locale-%' or package Like 'lib%' or package Like
'kernel-%' or package Like 'perl-%' or package Like 'python-%'  or
package Like 'util-linux-%' or package Like 'alsa-utils-%' or package
Like 'abiword-%' or package Like 'evas-%' or package Like 'etk-%' or
package Like 'ecore-%' or package Like 'e2fsprogs-%' or package Like
'connman-%' or package Like 'classpath-%' or package Like 'edbus-%' or
package Like 'edje-%' or package Like 'efrecet-%' or package Like
'emotion-%' or package Like 'epsilon-%' or package Like 'ewl-%' or
package Like 'finch-%' or package Like 'frameworkd-%' or package Like
'gdk-%' or package Like 'glibc-%' or package Like 'gnome-vfs-%' or
package Like 'gpsd-%' or package Like 'gst-%' or package Like 'gtk-%'
or package Like 'iputils-%' or package Like 'midpath-%' or package
Like 'openssh-%' or package Like 'pam-%' or package Like 'pango-%' or
package Like 'pidgin-%' or package Like 'ppp-%' or package Like
'pulseaudio-%' or package Like 'tzdata-%' or package Like 'xserver-%'
or (package Like 'e-wm-%' and not (package Like 'e-wm-theme%')))

>
> --
> Sebastian Krzyszkowiak
> dos
>
> _______________________________________________
> Openmoko community mailing list
> community at lists.openmoko.org
> http://lists.openmoko.org/mailman/listinfo/community
>



-- 
David Reyes Samblas Martinez
http://www.tuxbrain.com
Open ultraportable & embedded solutions
Openmoko, Openpandora,  Arduino
Hey, watch out!!! There's a linux in your pocket!!!