m_librarian.db module

class m_librarian.db.Author(**kw)[source]

Bases: sqlobject.main.SQLObject

addBook(obj)
books
count
count_idx = <sqlobject.index.SODatabaseIndex object>
full_name_idx = <sqlobject.index.SODatabaseIndex object>
fullname
j = author
misc_name
name
q = author
removeBook(obj)
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'count': <IntCol 7fc91567bf90 count>, 'misc_name': <UnicodeCol 7fc91567bf50 misc_name>, 'name': <UnicodeCol 7fc91567bf10 name>, 'surname': <UnicodeCol 7fc91567be10 surname>}
columnList = [<SOUnicodeCol surname not null>, <SOUnicodeCol name not null>, <SOUnicodeCol misc_name not null>, <SOIntCol count not null>]
columns = {'count': <SOIntCol count not null>, 'misc_name': <SOUnicodeCol misc_name not null>, 'name': <SOUnicodeCol name not null>, 'surname': <SOUnicodeCol surname not null>}
idName = 'id'
indexDefinitions = [<DatabaseIndex 7fc915685050 {'unique': True, 'name': 'full_name_idx', 'columns': (<UnicodeCol 7fc91567be10 surname>, <UnicodeCol 7fc91567bf10 name>, <UnicodeCol 7fc91567bf50 misc_name>)}>, <DatabaseIndex 7fc915685090 {'name': 'count_idx', 'columns': (<IntCol 7fc91567bf90 count>,)}>]
indexes = [<sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>]
joinDefinitions = [<sqlobject.joins.RelatedJoin object>]
joins = [<sqlobject.joins.SORelatedJoin object>]
soClass

alias of m_librarian.db.Author

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'author'
surname
class m_librarian.db.Book(**kw)[source]

Bases: sqlobject.main.SQLObject

addAuthor(obj)
addGenre(obj)
archive
archive_file_idx = <sqlobject.index.SODatabaseIndex object>
archive_idx = <sqlobject.index.SODatabaseIndex object>
author1
author_list
authors
date
date_idx = <sqlobject.index.SODatabaseIndex object>
deleted
deleted_idx = <sqlobject.index.SODatabaseIndex object>
ext
extension
extensionID
extension_idx = <sqlobject.index.SODatabaseIndex object>
file
file_idx = <sqlobject.index.SODatabaseIndex object>
genre1name
genre1title
genre_name_list
genre_title_list
genres
j = book
lang
language
languageID
language_idx = <sqlobject.index.SODatabaseIndex object>
lib_id
q = book
removeAuthor(obj)
removeGenre(obj)
ser_no
ser_no_idx = <sqlobject.index.SODatabaseIndex object>
series
series_idx = <sqlobject.index.SODatabaseIndex object>
size
size_idx = <sqlobject.index.SODatabaseIndex object>
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'archive': <StringCol 7fc91568f990 archive>, 'date': <DateCol 7fc91568fb10 date>, 'deleted': <BoolCol 7fc91568fa90 deleted>, 'extensionID': <ForeignKey 7fc91568fad0 extension>, 'file': <UnicodeCol 7fc91568f9d0 file>, 'languageID': <ForeignKey 7fc91568fb50 language>, 'lib_id': <StringCol 7fc91568fa50 lib_id>, 'ser_no': <IntCol 7fc91568f950 ser_no>, 'series': <UnicodeCol 7fc91568f910 series>, 'size': <IntCol 7fc91568fa10 size>, 'title': <UnicodeCol 7fc91568f8d0 title>}
columnList = [<SOUnicodeCol title not null>, <SOUnicodeCol series not null>, <SOIntCol ser_no>, <SOStringCol archive not null>, <SOUnicodeCol file not null>, <SOIntCol size not null>, <SOStringCol lib_id not null>, <SOBoolCol deleted not null>, <SOForeignKey extensionID connected to Extension not null>, <SODateCol date not null>, <SOForeignKey languageID connected to Language>]
columns = {'archive': <SOStringCol archive not null>, 'date': <SODateCol date not null>, 'deleted': <SOBoolCol deleted not null>, 'extensionID': <SOForeignKey extensionID connected to Extension not null>, 'file': <SOUnicodeCol file not null>, 'languageID': <SOForeignKey languageID connected to Language>, 'lib_id': <SOStringCol lib_id not null>, 'ser_no': <SOIntCol ser_no>, 'series': <SOUnicodeCol series not null>, 'size': <SOIntCol size not null>, 'title': <SOUnicodeCol title not null>}
idName = 'id'
indexDefinitions = [<DatabaseIndex 7fc91568fb90 {'name': 'title_idx', 'columns': (<UnicodeCol 7fc91568f8d0 title>,)}>, <DatabaseIndex 7fc91568fbd0 {'name': 'series_idx', 'columns': (<UnicodeCol 7fc91568f910 series>,)}>, <DatabaseIndex 7fc91568fc50 {'name': 'ser_no_idx', 'columns': (<IntCol 7fc91568f950 ser_no>,)}>, <DatabaseIndex 7fc91568fcd0 {'name': 'archive_idx', 'columns': (<StringCol 7fc91568f990 archive>,)}>, <DatabaseIndex 7fc91568fd50 {'unique': True, 'name': 'archive_file_idx', 'columns': (<StringCol 7fc91568f990 archive>, <UnicodeCol 7fc91568f9d0 file>)}>, <DatabaseIndex 7fc91568fd90 {'name': 'file_idx', 'columns': (<UnicodeCol 7fc91568f9d0 file>,)}>, <DatabaseIndex 7fc91568fe10 {'name': 'size_idx', 'columns': (<IntCol 7fc91568fa10 size>,)}>, <DatabaseIndex 7fc91568fe90 {'name': 'deleted_idx', 'columns': (<BoolCol 7fc91568fa90 deleted>,)}>, <DatabaseIndex 7fc91568ff10 {'name': 'extension_idx', 'columns': (<ForeignKey 7fc91568fad0 extension>,)}>, <DatabaseIndex 7fc91568ff90 {'name': 'date_idx', 'columns': (<DateCol 7fc91568fb10 date>,)}>, <DatabaseIndex 7fc915696050 {'name': 'language_idx', 'columns': (<ForeignKey 7fc91568fb50 language>,)}>]
indexes = [<sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>]
joinDefinitions = [<sqlobject.joins.RelatedJoin object>, <sqlobject.joins.RelatedJoin object>]
joins = [<sqlobject.joins.SORelatedJoin object>, <sqlobject.joins.SORelatedJoin object>]
soClass

alias of m_librarian.db.Book

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'book'
title
title_idx = <sqlobject.index.SODatabaseIndex object>
class m_librarian.db.Extension(**kw)[source]

Bases: sqlobject.main.SQLObject

classmethod byName(val, connection=None)
count
count_idx = <sqlobject.index.SODatabaseIndex object>
j = extension
name
q = extension
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'count': <IntCol 7fc915624750 count>, 'name': <UnicodeCol 7fc91561ef50 name>}
columnList = [<SOUnicodeCol name not null>, <SOIntCol count not null>]
columns = {'count': <SOIntCol count not null>, 'name': <SOUnicodeCol name not null>}
idName = 'id'
indexDefinitions = [<DatabaseIndex 7fc915624790 {'name': 'count_idx', 'columns': (<IntCol 7fc915624750 count>,)}>]
indexes = [<sqlobject.index.SODatabaseIndex object>]
joinDefinitions = []
joins = []
soClass

alias of m_librarian.db.Extension

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'extension'
class m_librarian.db.Genre(**kw)[source]

Bases: sqlobject.main.SQLObject

addBook(obj)
books
classmethod byName(val, connection=None)
count
count_idx = <sqlobject.index.SODatabaseIndex object>
j = genre
name
q = genre
removeBook(obj)
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'count': <IntCol 7fc915624b90 count>, 'name': <UnicodeCol 7fc91561ddd0 name>, 'title': <UnicodeCol 7fc915624b50 title>}
columnList = [<SOUnicodeCol name not null>, <SOUnicodeCol title not null>, <SOIntCol count not null>]
columns = {'count': <SOIntCol count not null>, 'name': <SOUnicodeCol name not null>, 'title': <SOUnicodeCol title not null>}
idName = 'id'
indexDefinitions = [<DatabaseIndex 7fc915624c10 {'name': 'title_idx', 'columns': (<UnicodeCol 7fc915624b50 title>,)}>, <DatabaseIndex 7fc915624c90 {'name': 'count_idx', 'columns': (<IntCol 7fc915624b90 count>,)}>]
indexes = [<sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>]
joinDefinitions = [<sqlobject.joins.RelatedJoin object>]
joins = [<sqlobject.joins.SORelatedJoin object>]
soClass

alias of m_librarian.db.Genre

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'genre'
title
title_idx = <sqlobject.index.SODatabaseIndex object>
class m_librarian.db.Language(**kw)[source]

Bases: sqlobject.main.SQLObject

classmethod byName(val, connection=None)
count
count_idx = <sqlobject.index.SODatabaseIndex object>
j = language
name
q = language
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'count': <IntCol 7fc915624d10 count>, 'name': <UnicodeCol 7fc915624650 name>}
columnList = [<SOUnicodeCol name not null>, <SOIntCol count not null>]
columns = {'count': <SOIntCol count not null>, 'name': <SOUnicodeCol name not null>}
idName = 'id'
indexDefinitions = [<DatabaseIndex 7fc91562f490 {'name': 'count_idx', 'columns': (<IntCol 7fc915624d10 count>,)}>]
indexes = [<sqlobject.index.SODatabaseIndex object>]
joinDefinitions = []
joins = []
soClass

alias of m_librarian.db.Language

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'language'
class m_librarian.db.AuthorBook(**kw)[source]

Bases: sqlobject.main.SQLObject

author
authorID
author_idx = <sqlobject.index.SODatabaseIndex object>
book
bookID
book_idx = <sqlobject.index.SODatabaseIndex object>
j = author_book
main_idx = <sqlobject.index.SODatabaseIndex object>
q = author_book
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'authorID': <ForeignKey 7fc9156850d0 author>, 'bookID': <ForeignKey 7fc915685d10 book>}
columnList = [<SOForeignKey authorID connected to Author not null>, <SOForeignKey bookID connected to Book not null>]
columns = {'authorID': <SOForeignKey authorID connected to Author not null>, 'bookID': <SOForeignKey bookID connected to Book not null>}
idName = 'id'
indexDefinitions = [<DatabaseIndex 7fc915685d50 {'name': 'author_idx', 'columns': (<ForeignKey 7fc9156850d0 author>,)}>, <DatabaseIndex 7fc915685d90 {'name': 'book_idx', 'columns': (<ForeignKey 7fc915685d10 book>,)}>, <DatabaseIndex 7fc915685e10 {'unique': True, 'name': 'main_idx', 'columns': (<ForeignKey 7fc9156850d0 author>, <ForeignKey 7fc915685d10 book>)}>]
indexes = [<sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>]
joinDefinitions = []
joins = []
soClass

alias of m_librarian.db.AuthorBook

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'author_book'
class m_librarian.db.BookGenre(**kw)[source]

Bases: sqlobject.main.SQLObject

book
bookID
book_idx = <sqlobject.index.SODatabaseIndex object>
genre
genreID
genre_idx = <sqlobject.index.SODatabaseIndex object>
j = book_genre
main_idx = <sqlobject.index.SODatabaseIndex object>
q = book_genre
class sqlmeta(instance)

Bases: sqlobject.main.sqlmeta

childName = None
columnDefinitions = {'bookID': <ForeignKey 7fc91568f790 book>, 'genreID': <ForeignKey 7fc915696110 genre>}
columnList = [<SOForeignKey bookID connected to Book not null>, <SOForeignKey genreID connected to Genre not null>]
columns = {'bookID': <SOForeignKey bookID connected to Book not null>, 'genreID': <SOForeignKey genreID connected to Genre not null>}
idName = 'id'
indexDefinitions = [<DatabaseIndex 7fc91561ee50 {'name': 'book_idx', 'columns': (<ForeignKey 7fc91568f790 book>,)}>, <DatabaseIndex 7fc91561ee90 {'name': 'genre_idx', 'columns': (<ForeignKey 7fc915696110 genre>,)}>, <DatabaseIndex 7fc91561ef10 {'unique': True, 'name': 'main_idx', 'columns': (<ForeignKey 7fc91568f790 book>, <ForeignKey 7fc915696110 genre>)}>]
indexes = [<sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>]
joinDefinitions = []
joins = []
soClass

alias of m_librarian.db.BookGenre

style = <sqlobject.styles.MixedCaseUnderscoreStyle object>
table = 'book_genre'
m_librarian.db.open_db(db_uri=None)[source]
m_librarian.db.init_db()[source]
m_librarian.db.insert_name(table, name, **kw)[source]
m_librarian.db.insert_author(surname, name, misc_name)[source]
m_librarian.db.update_counters(pbar_cb=None)[source]