[ckan-dev] How the database should be reset?

Dave Caraway dave at fogmine.com
Fri Aug 30 11:40:11 UTC 2013


hi richard,

not sure if this helps, but i've seen ghost entries before due to solr
being out of sync. i used paster command to reindex solr to fix.

-Dave



On Aug 29, 2013, at 3:38 PM, Richard Gomes <rgomes.info at gmail.com> wrote:

 hello,

I loaded test data provided by CKAN into the database.

I don't know if this is relavant... anyway, for your information:
After that I did some tests using the FileStore API, when I associated
documents to one of the datasets, like this:
      1 base_location='http://ckan.localdomain:5000/api'
      2 api_key= ...
      3 http_user='rgomes'
      4 http_pass=...
      5
      6
      7 def filelist(folder='.'):
      8     import os
      9     for root, dir, files in os.walk(folder):
     10         for file in files:
     11             path = '%s/%s' % (root, file)
     12             yield path
     13     return
     14
     15
     16 import ckanclient
     17 cli = ckanclient.CkanClient(base_location=base_location,
api_key=api_key, http_user=http_user, http_pass=http_pass, is_verbose=True)
     18
     19 pkg = 'warandpeace'
     20 for path in filelist('/home/rgomes/tmp/upload'):
     21     print path
     22     print cli.add_package_resource(pkg, path)


Then I've tried to recreate the database from scratch, like this:

#!/bin/bash

set -x
sudo -u postgres dropdb ${CKAN_DATABASE}
sudo -u postgres dropuser ${CKAN_USERNAME}

sudo -u postgres createuser -S -D -R -P ${CKAN_USERNAME}
sudo -u postgres createdb -O ${CKAN_USERNAME} ${CKAN_DATABASE} -E utf-8

paster db init -c $CKAN_ETC/default/development.ini
paster sysadmin add rgomes -c $CKAN_ETC/default/development.ini
set +x


Notice that I didn't loaded the test data after that!


For my surprise, CKAN says that there are 2 datasets available.
The datasets are not actually listed, but it says that there are 2 datasets
available.
The faceted search tags associates 2 datasets to david and 1 to roger,
etc... like if the datasets where still there.

Any idea about how this sort of information survived a complete wipe out of
database tables ?

Thanks

-- 
Richard Gomes
http://rgomes.info
http://www.linkedin.com/in/rgomes
mobile: +44(77)9955-6813
inum <http://www.inum.net/>: +883(5100)0800-9804

 _______________________________________________
ckan-dev mailing list
ckan-dev at lists.okfn.org
http://lists.okfn.org/mailman/listinfo/ckan-dev
Unsubscribe: http://lists.okfn.org/mailman/options/ckan-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20130830/d501be24/attachment-0001.html>


More information about the ckan-dev mailing list