[pycsw-devel] Loading sqlite records on Windows server

[Jeff McKenna]

Response from Tom on IRC:

--
 http://docs.sqlalchemy.org/en/latest/dialects/sqlite.html#connect-strings

so
database=sqlite:///C:\\Python26\\Scripts\\pycsw-workshop\\pycsw-1.4.1\\data\\cite\\records.db
type thing

--

thank Tom!

-jeff




On 2013-05-23 1:06 PM, Jeff McKenna wrote:
> Hello all,
> 
> I am having trouble on a Windows server.  I am following the Windows
> instructions at https://gist.github.com/tomkralidis/5311990
> 
> - My default.cfg file contains:
> 
>   [repository]
>   # sqlite
> 
> database=sqlite://C:/Python26/Scripts/pycsw-workshop/pycsw-1.4.1/data/cite/records.db
> 
> - GetCapabilities returns:
> 
> <!-- pycsw 1.4.1 -->
>   <ows:ExceptionReport version="1.2.0" language="en-US"
> xsi:schemaLocation="http://www.opengis.net/ows
> http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd">
>     <ows:Exception locator="service" exceptionCode="NoApplicableCode">
>       <ows:ExceptionText>Could not load repository (local): invalid
> literal for int() with base 10: ''</ows:ExceptionText>
>     </ows:Exception>
>   </ows:ExceptionReport>
> 
> Is it a problem with the "database=sqlite:" path?  What is the correct
> syntax for Windows?
> 
> Thanks,
> 
> -jeff
> 
> 
> 


-- 
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/