[ckan-dev] ckanpackager stats.db (Aaron D Borden)

[Luke Tully]

Actually I meant to refer to the ckanpackager service at
https://github.com/NaturalHistoryMuseum/ckanpackager


This line specifically

STATS_DB = 'sqlite:////var/lib/ckanpackager/stats.db'




On March 30, 2019 at 7:00:04 AM, ckan-dev-request at lists.okfn.org (
ckan-dev-request at lists.okfn.org) wrote:

Send ckan-dev mailing list submissions to
ckan-dev at lists.okfn.org

To subscribe or unsubscribe via the World Wide Web, visit
https://lists.okfn.org/mailman/listinfo/ckan-dev
or, via email, send a message with subject or body 'help' to
ckan-dev-request at lists.okfn.org

You can reach the person managing the list at
ckan-dev-owner at lists.okfn.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of ckan-dev digest..."


Today's Topics:

1. Re: ckanpackager stats.db (Aaron D Borden)
2. Catch Select-Queries On Datastore (Hakan Solmaz)


----------------------------------------------------------------------

Message: 1
Date: Fri, 29 Mar 2019 06:40:33 -0700
From: Aaron D Borden <adborden at a14n.net>
To: Luke Tully <luke at luketully.ca>
Cc: ckan-dev at lists.okfn.org
Subject: Re: [ckan-dev] ckanpackager stats.db
Message-ID: <mailman.6.1553947201.24619.ckan-dev at lists.okfn.org>
Content-Type: text/plain; charset=utf-8

Are you referring to this extension?

https://github.com/NaturalHistoryMuseum/ckanext-ckanpackager/blob/master/README.md#database-initialisation


-- 
Human and hacker
Aaron D Borden
Sent from my mobileOn Mar 28, 2019 4:57 PM, Luke Tully <luke at luketully.ca>
wrote:
>
> Anyone using ckanext-ckanpackager/ckanpackager?
>
> Stats appear to be logged based on the existence of a stats.db, but I
haven't found anything indicating how the DB is created, and ckanpackager
seems to fail if the DB doesn't exist.

------------------------------

Message: 2
Date: Thu, 28 Mar 2019 15:42:20 +0000
From: Hakan Solmaz <hakansolmaz06 at outlook.com>
To: "ckan-dev at lists.okfn.org" <ckan-dev at lists.okfn.org>
Subject: [ckan-dev] Catch Select-Queries On Datastore
Message-ID:
<
VI1PR0901MB099267A560194653F672B3C7B1590 at VI1PR0901MB0992.eurprd09.prod.outlook.com>


Content-Type: text/plain; charset="iso-8859-1"

Hi everyone,



I set up the datastore with datapusher in my local ckan-instance. So if I
upload e.g. a CSV file over the UI it is converted into a database table.
As we know, you can use the UI to query a subset of a dataset. My aim is to
store this Select-Queries inside the datastore in an additional database
table . So to this I should hook into ckan and "catch" the Select queries.
Ckan has Datastore API and there is datastore_search method. This method
returns query_dict. This is just a dictionary and this should be converted
into a sql query. Is there another option to this? Is there a method in
CKAN that already has these queries as SQL queries?

Kind Regards,
Hakan

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <
http://lists.okfn.org/pipermail/ckan-dev/attachments/20190328/2a80cf43/attachment-0001.html>


------------------------------

Subject: Digest Footer

_______________________________________________
ckan-dev mailing list
ckan-dev at lists.okfn.org
https://lists.okfn.org/mailman/listinfo/ckan-dev
Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev


------------------------------

End of ckan-dev Digest, Vol 101, Issue 29
*****************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20190401/40860a5c/attachment.html>