[gdal-dev] Delete a sqlite database

[Even Rouault]

Le lundi 22 novembre 2010 10:26:26, Ludovic Granjon a écrit :
> Hi all
> I try in a python script to delete a sqlite database that I use in an
> OGR ExecuteSQL.
> Let me give you an example :
> 
> If I do :
>  >>> from osgeo import *
>  >>> import os
>  >>> datasource = ogr.Open("decoupe.shp")
>  >>> layer = datasource.GetLayer()
>  >>> joinLayer=datasource.ExecuteSQL("SELECT decoupe.FID as ligne_id,
> 
> c.lFid as ligne_id2, c.count as count FROM decoupe LEFT JOIN
> 'project.sqlite'.comptage c ON decoupe.FID=c.lFid")
> 

You probably need a datasource.ReleaseResultSet(joinLayer) at that point

>  >>> datasource.Destroy()
> 
> It seems that there still a connection to my sqlite database and I can't
> delete it.
> 
> When I try on MS Windows (There's no error on linux) :
>  >>> os.remove('project.sqlite')
> 
> I have :
> Traceback (most recent call last):
> File "<pyshell#5>", line 1, in <module>
> os.remove('project.sqlite')
> WindowsError: [Error 13] Le processus ne peut pas accéder au fichier car
> ce fichier est utilisé par un autre processus: 'project.sqlite'
> 
> 
> Do you know a way to do that ?
> 
> Thanks
> 
> Best regards
> 
> Ludovic