³ò Pt¡Ic @sèdZddkZyddklZWnHej o<yddklZWqqej odGHdZqqXnXddkZddkZddk Z ddk Z ei i ei dƒZei i ei dƒZdd d„ƒYZdS( s<librarybackend.py - Comic book library backend using sqlite.iÿÿÿÿN(tdbapi2s+! Could neither find pysqlite2 nor sqlite3.s library.dbtlibrary_coverstLibraryBackendcBseZdZd„Zddd„Zd„Zd„Zd„Zd„Z d„Z d„Z dd „Z d „Z d „Zd „Zd „Zdd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„ZRS(s_The LibraryBackend handles the storing and retrieval of library data to and from disk. cCs¬d„}titƒ|_||i_t|i_|iidƒiƒp|i ƒn|iidƒiƒp|i ƒn|iidƒiƒp|i ƒndS(NcSs#t|ƒdjo |dSn|S(s\Return rows as sequences only when they have more than one element. ii(tlen(tcursortrow((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pyt row_factorys spragma table_info(Book)spragma table_info(Collection)spragma table_info(Contain)( Rtconnectt_db_patht_conRtstrt text_factorytexecutetfetchallt_create_table_bookt_create_table_collectiont_create_table_contain(tselfR((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pyt__init__s   cCs¢|djoC|djo|iidƒ}q˜|iidd|fƒ}nI|djo|iid|fƒ}n |iid|d|fƒ}|iƒS(sÙReturn a sequence with all the books in , or *ALL* books if is None. If is not None, we only return books where the occurs in the path. s5select id from Book order by paths[select id from Book where path like ? order by paths%%%s%%s…select id from Book where id in (select book from Contain where collection = ?) order by paths©select id from Book where id in (select book from Contain where collection = ?) and path like ? order by pathN(tNoneR R R (Rt collectiont filter_stringtcur((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pytget_books_in_collection0s        c Cs~y"|iid|fƒiƒ}Wn tj od|GHdSnXti|dtdtƒ}|djo d|GHn|S(srReturn a pixbuf with a thumbnail of the cover of , or None if the cover can not be fetched. s2select path from Book where id = ?s! Non-existant book #%dtcreatetdst_dirs! Could not get cover for %sN( R R tfetchonet ExceptionRt thumbnailt get_thumbnailtTruet _cover_dir(Rtbooktpathtthumb((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pytget_book_coverIs     cCs"|iid|fƒ}|iƒS(s^Return the filesystem path to , or None if isn't in the library. s.select path from Book where id = ?(R R R(RR R((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pyt get_book_pathXs cCsF|iid|fƒ}|iƒ}|djodSnti|ƒS(sSReturn the name of , or None if isn't in the library. s.select name from Book where id = ?N(R R RRtencodingt to_unicode(RR Rtname((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pyt get_book_name`s    cCs"|iid|fƒ}|iƒS(s^Return the number of pages in , or None if isn't in the library. s/select pages from Book where id = ?(R R R(RR R((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pytget_book_pagesks cCs"|iid|fƒ}|iƒS(s]Return the archive format of , or None if isn't in the library. s0select format from Book where id = ?(R R R(RR R((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pytget_book_formatss cCs"|iid|fƒ}|iƒS(s\Return the size of in bytes, or None if isn't in the library. s.select size from Book where id = ?(R R R(RR R((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pyt get_book_size{s cCsE|djo|iidƒ}n|iid|fƒ}|iƒS(s…Return a sequence with all the subcollections in , or all top-level collections if is None. sdselect id from Collection where supercollection isnull order by namesaselect id from Collection where supercollection = ? order by nameN(RR R R (RRR((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pytget_collections_in_collectionƒs     cCs|iidƒ}|iƒS(sˆReturn a sequence with all collections (flattened hierarchy). The sequence is sorted alphabetically by collection name. s3select id from Collection order by name(R R R (RR((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pytget_all_collections‘s  cCsC|iid|fƒ}|iƒ}|djodSnt|ƒS(seReturn the name field of the , or None if the collection does not exist. s4select name from Collection where id = ?N(R R RRtunicode(RRRR'((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pytget_collection_name™s    cCs"|iid|fƒ}|iƒS(sŸReturn the collection called , or None if no such collection exists. Names are unique, so at most one such collection can exist. s4select id from Collection where name = ?(R R R(RR'R((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pytget_collection_by_name¤s cCs"|iid|fƒ}|iƒS(s+Return the supercollection of .s?select supercollection from Collection where id = ?(R R R(RRR((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pytget_supercollection­s c CsPtii|ƒ}tii|ƒ}ti|ƒ}|djotSn|\}}}ti |dt dt ƒ|i i d|fƒiƒ}yY|dj o&|i i d|||||fƒn#|i i d|||||fƒWn#tij od|GHtSnX|dj o2|i i d|fƒiƒ} |i| |ƒnt S( säAdd the archive at to the library. If is not None, it is the collection that the books should be put in. Return True if the book was successfully added (or was already added). RRs.select id from Book where path = ?spupdate Book set name = ?, pages = ?, format = ?, size = ? where path = ?sqinsert into Book (name, path, pages, format, size) values (?, ?, ?, ?, ?)s&! Could not add book %s to the librarys2select id from Book where path = ?N(tosR!tabspathtbasenametarchivetget_archive_infoRtFalseRRRRR R RRtErrortadd_book_to_collection( RR!RR'tinfotformattpagestsizetoldR ((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pytadd_book³s0         cCsDy|iid|fƒtSWntij od|GHnXtS(swAdd a new collection with to the library. Return True if the collection was successfully added. s8insert into Collection (name) values (?)s! Could not add collection %s(R R RRR8R7(RR'((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pytadd_collectionÕs  cCs^y|iid||fƒWn:tij on&tij od||fGHnXdS(sPut into .sDinsert into Contain (collection, book) values (?, ?)s(! Could not add book %s to collection %sN(R R Rt DatabaseErrorR8(RR R((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pyR9ás cCsD|djo|iid|fƒn|iid||fƒdS(s}Put into , or put in the root if is None. sYupdate Collection set supercollection = NULL where id = ?sVupdate Collection set supercollection = ? where id = ?N(RR R (Rt subcollectiontsupercollection((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pytadd_collection_to_collectionìs    cCs\y!|iid||fƒtSWn4tij on tij od|GHnXtS(s_Rename the to . Return True if the renaming was successful. s;update Collection set name = ? where id = ?s#! Could not rename collection to %s(R R RRRAR8R7(RRR'((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pytrename_collectionùs cCs½|i|ƒ}|djotSn|dtdƒ}x)|i|ƒo|dtdƒ}q;W|i|ƒdjotSn|iid|fƒiƒ}|iid||fƒt S(sšDuplicate the by creating a new collection containing the same books. Return True if the duplication was successful. t s(Copy)s4select id from Collection where name = ?syinsert or ignore into Contain (collection, book) select ?, book from Contain where collection = ?N( R/RR7t_R0R@R R RR(RRR't copy_nametcopy_collection((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pytduplicate_collections   cCsc|i|ƒ}|dj oti|dtƒn|iid|fƒ|iid|fƒdS(s#Remove the from the library.Rsdelete from Book where id = ?s"delete from Contain where book = ?N(R$RRtdelete_thumbnailRR R (RR R!((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pyt remove_books  cCsF|iid|fƒ|iid|fƒ|iid|fƒdS(s6Remove the (sans books) from the library.s#delete from Collection where id = ?s(delete from Contain where collection = ?sRupdate Collection set supercollection = NULL where supercollection = ?N(R R (RR((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pytremove_collection#s    cCs|iid||fƒdS(s Remove from .sAdelete from Contain where book = ? and collection = ?N(R R (RR R((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pytremove_book_from_collection+s cCs|iiƒ|iiƒdS(s!Commit changes and close cleanly.N(R tcommittclose(R((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pyRP0s cCs|iidƒdS(Nsîcreate table book ( id integer primary key, name string, path string unique, pages integer, format integer, size integer, added date default current_date)(R R (R((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pyR5s cCs|iidƒdS(Ns‚create table collection ( id integer primary key, name string unique, supercollection integer)(R R (R((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pyR?s cCs|iidƒdS(NsŽcreate table contain ( collection integer not null, book integer not null, primary key (collection, book))(R R (R((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pyREs N(t__name__t __module__t__doc__RRRR#R$R(R)R*R+R,R-R/R0R1R?R@R9RDRERJRLRMRNRPRRR(((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pyRs6          "       ((RSR2tsqlite3Rt ImportErrort pysqlite2RR5t constantsR%RR!tjointDATA_DIRRRR(((sN/home/sork/Pontus/Programmering/Python/Comix/comix-4.0.4/src/librarybackend.pyss