Touch Python script for building shelf automatically

[deufeufeu]

Hi,
I just got a new Kobo Touch yesterday but the shelves feature seemed broken by the fact that I couldn't do a "check all" while searching to add books.
So I wrote a python script that will build shelves based on the directory in which your ebooks are located. For example if you have all IronThrones books in the folder /mnt/onboard/IronThrones it will make a shelf named IronThrones with all books of this folder added.
The script is here http://pastebin.com/hX2kqQ9b .
I don't have time to explain how to make it works, but I'm sure those having rooted their kobos will have no problem.

[DigitalWarS]

Anyone checked this out? This is a great feature I've been hoping for...
Yet.. I'm a newbie...
I'd need some help. Anyone available ?

[ewphoenix123]

If you don't know what to do with this, you should probably just use calibre.

https://www.mobileread.com/forums/sho...d.php?t=193184

Very userfriendly and gives you the same result.

[DigitalWarS]

Originally Posted by ewphoenix123

If you don't know what to do with this, you should probably just use calibre.

https://www.mobileread.com/forums/sho...d.php?t=193184

Very userfriendly and gives you the same result.

Thank you very much for the advice, I'll try!

[jkgeyti]

I'm having trouble running this on the kobo touch:

Traceback (most recent call last):
File "build-shelves.py", line 1, in <module>
import sqlite3
File "/mnt/onboard/.python/lib/python2.7/sqlite3/__init__.py", line 24, in <module>
from dbapi2 import *
File "/mnt/onboard/.python/lib/python2.7/sqlite3/dbapi2.py", line 27, in <module>
from _sqlite3 import *
ImportError: No module named _sqlite3

I've installed python 2.7 from the KoboWeather download
I've tried downloading a couple of armel sqlite libs, but nothing that made any difference. Can anyone help me getting sqlite to run?

Thanks in advance

[evgeniy]

This script works on Kobo Aura HD ?

[PeterT]

Should do; in effect all Kobo eReaders use the same basic software. But many people find using calibre to manage shelves a lot easier.

[lormac]

wasn't working for kobo glo, I had to tweak it a little bit, here it is:

#!/usr/bin/python

import sqlite3

conn = sqlite3.connect('KoboReader.sqlite')

c = conn.cursor()

c.execute('''SELECT DISTINCT BookID FROM content''')

import re
re_path = re.compile(r'^file:///mnt/(?P<dev>[^/]*)/(?P<path>.*)/(?P<filename>[^/]*)$')
#(r'^file:///mnt/(?P<dev>)([^/]?P<path>)([^/]?P<filename>)$')
#(r'^file:///mnt/(?P<dev>[^/]*)/(?P<path>.*)/(?P<filename>[^/]*)$')

def splitpath(p):
m = re_path.match(p)
# print('qui',m)
return (m.group('dev'), m.group('path'), m.group('filename'))

database = {}
for v in c.fetchall():
p = v[0]
if p and p.startswith('file:///mnt/'):
dev, dirpath, filename = splitpath(p)
print(dev , dirpath , filename)
if (dev,dirpath) not in database:
database[(dev,dirpath)] = []
database[(dev,dirpath)].append(filename)

for dev,dirpath in database:
shelf = dirpath.replace('/','_')
print('shelf',shelf)
c.execute("SELECT * FROM Shelf WHERE InternalName='prova'")
print(c.fetchone())
c.execute("SELECT * FROM Shelf WHERE InternalName='%s'" % shelf)
temp = c.fetchone()
print(temp)
if temp is None:
c.execute("INSERT INTO Shelf VALUES ('2014-01-27T15:09:57Z', '%s', '%s', '2014-01-27T15:09:57Z', '%s', NULL, 'false', 'true', 'false')" % (shelf,shelf,shelf))
c.execute("SELECT * FROM Shelf WHERE InternalName='%s'" % shelf)
for f in database[(dev,dirpath)]:
fullname = u'file:///mnt/%s/%s/%s' % (dev,dirpath,f)
fullname = fullname.replace("'","''")
c.execute("SELECT * FROM ShelfContent WHERE ShelfName='%s' AND ContentId='%s'" % (shelf, fullname))
r = c.fetchone()
print(r)
if r is None:
c.execute("INSERT INTO ShelfContent VALUES ('%s','%s','2014-01-27T15:09:57Z','false','false')" % (shelf,fullname))

conn.commit()
c.close()