On Thu, Nov 19, 2009 at 12:58 PM, Sadnem <sad...@gmx.com> wrote:
> how could i make a script that would keep watching a sqlite table and
> cheking to delete folders marked with status 0? this is an example of
> the database i'm talking about -->
> http://www.wikifortio.com/834317/example.sqlite
> Note that the folder name is exactly the same as the one under "Release"
> and that these folders wont be located on the same directory of the
> database.
Make a script in what? Not sure what you are asking but, from what I
understand, the following pseudocode should do it --
WHILE: while true
SELECT: select folder_name from table where status = 0
LOOP: loop over SELECT
unlink folder_name
end LOOP
end WHILE
the exact implementation will depend on the scripting language you are using.
> Thanks.
> Regards, Pedro.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
Puneet Kishor http://www.punkish.org
Carbon Model http://carbonmodel.org
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu
-----------------------------------------------------------------------
Assertions are politics; backing up assertions with evidence is science
=======================================================================
Sent from Madison, Wisconsin, United States
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
