m_librarian.db module¶
-
class
m_librarian.db.
Author
(**kw)[исходный код]¶ - Базовые классы:
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)¶ - Базовые классы:
sqlobject.main.sqlmeta
-
childName
= None¶
-
columnDefinitions
= {'count': <IntCol 7f4d874b9950 count>, 'misc_name': <UnicodeCol 7f4d874b9910 misc_name>, 'name': <UnicodeCol 7f4d874b98d0 name>, 'surname': <UnicodeCol 7f4d874b97d0 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 7f4d874b2a50 {'unique': True, 'name': 'full_name_idx', 'columns': (<UnicodeCol 7f4d874b97d0 surname>, <UnicodeCol 7f4d874b98d0 name>, <UnicodeCol 7f4d874b9910 misc_name>)}>, <DatabaseIndex 7f4d874b2a90 {'name': 'count_idx', 'columns': (<IntCol 7f4d874b9950 count>,)}>]¶
-
indexes
= [<sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>]¶
-
joinDefinitions
= [<sqlobject.joins.RelatedJoin object>]¶
-
joins
= [<sqlobject.joins.SORelatedJoin object>]¶
-
soClass
¶ псевдоним класса
m_librarian.db.Author
-
style
= <sqlobject.styles.MixedCaseUnderscoreStyle object>¶
-
table
= 'author'¶
-
-
surname
¶
-
-
class
m_librarian.db.
Book
(**kw)[исходный код]¶ - Базовые классы:
sqlobject.main.SQLObject
-
addAuthor
(obj)¶
-
addGenre
(obj)¶
-
archive
¶
-
archive_file_idx
= <sqlobject.index.SODatabaseIndex object>¶
-
archive_idx
= <sqlobject.index.SODatabaseIndex object>¶
-
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)¶ - Базовые классы:
sqlobject.main.sqlmeta
-
childName
= None¶
-
columnDefinitions
= {'archive': <StringCol 7f4d874ce350 archive>, 'date': <DateCol 7f4d874ce4d0 date>, 'deleted': <BoolCol 7f4d874ce450 deleted>, 'extensionID': <ForeignKey 7f4d874ce490 extension>, 'file': <UnicodeCol 7f4d874ce390 file>, 'languageID': <ForeignKey 7f4d874ce510 language>, 'lib_id': <StringCol 7f4d874ce410 lib_id>, 'ser_no': <IntCol 7f4d874ce310 ser_no>, 'series': <UnicodeCol 7f4d874ce2d0 series>, 'size': <IntCol 7f4d874ce3d0 size>, 'title': <UnicodeCol 7f4d874ce290 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 7f4d874ce550 {'name': 'title_idx', 'columns': (<UnicodeCol 7f4d874ce290 title>,)}>, <DatabaseIndex 7f4d874ce590 {'name': 'series_idx', 'columns': (<UnicodeCol 7f4d874ce2d0 series>,)}>, <DatabaseIndex 7f4d874ce610 {'name': 'ser_no_idx', 'columns': (<IntCol 7f4d874ce310 ser_no>,)}>, <DatabaseIndex 7f4d874ce690 {'name': 'archive_idx', 'columns': (<StringCol 7f4d874ce350 archive>,)}>, <DatabaseIndex 7f4d874ce710 {'unique': True, 'name': 'archive_file_idx', 'columns': (<StringCol 7f4d874ce350 archive>, <UnicodeCol 7f4d874ce390 file>)}>, <DatabaseIndex 7f4d874ce750 {'name': 'file_idx', 'columns': (<UnicodeCol 7f4d874ce390 file>,)}>, <DatabaseIndex 7f4d874ce7d0 {'name': 'size_idx', 'columns': (<IntCol 7f4d874ce3d0 size>,)}>, <DatabaseIndex 7f4d874ce850 {'name': 'deleted_idx', 'columns': (<BoolCol 7f4d874ce450 deleted>,)}>, <DatabaseIndex 7f4d874ce8d0 {'name': 'extension_idx', 'columns': (<ForeignKey 7f4d874ce490 extension>,)}>, <DatabaseIndex 7f4d874ce950 {'name': 'date_idx', 'columns': (<DateCol 7f4d874ce4d0 date>,)}>, <DatabaseIndex 7f4d874ce9d0 {'name': 'language_idx', 'columns': (<ForeignKey 7f4d874ce510 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
¶ псевдоним класса
m_librarian.db.Book
-
style
= <sqlobject.styles.MixedCaseUnderscoreStyle object>¶
-
table
= 'book'¶
-
-
title
¶
-
title_idx
= <sqlobject.index.SODatabaseIndex object>¶
-
-
class
m_librarian.db.
Extension
(**kw)[исходный код]¶ - Базовые классы:
sqlobject.main.SQLObject
-
classmethod
byName
(val, connection=None)¶
-
count
¶
-
count_idx
= <sqlobject.index.SODatabaseIndex object>¶
-
j
= extension¶
-
name
¶
-
q
= extension¶
-
class
sqlmeta
(instance)¶ - Базовые классы:
sqlobject.main.sqlmeta
-
childName
= None¶
-
columnDefinitions
= {'count': <IntCol 7f4d87462090 count>, 'name': <UnicodeCol 7f4d874da8d0 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 7f4d874620d0 {'name': 'count_idx', 'columns': (<IntCol 7f4d87462090 count>,)}>]¶
-
indexes
= [<sqlobject.index.SODatabaseIndex object>]¶
-
joinDefinitions
= []¶
-
joins
= []¶
-
soClass
¶ псевдоним класса
m_librarian.db.Extension
-
style
= <sqlobject.styles.MixedCaseUnderscoreStyle object>¶
-
table
= 'extension'¶
-
-
classmethod
-
class
m_librarian.db.
Genre
(**kw)[исходный код]¶ - Базовые классы:
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)¶ - Базовые классы:
sqlobject.main.sqlmeta
-
childName
= None¶
-
columnDefinitions
= {'count': <IntCol 7f4d87462510 count>, 'name': <UnicodeCol 7f4d874d7790 name>, 'title': <UnicodeCol 7f4d874624d0 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 7f4d87462590 {'name': 'title_idx', 'columns': (<UnicodeCol 7f4d874624d0 title>,)}>, <DatabaseIndex 7f4d87462610 {'name': 'count_idx', 'columns': (<IntCol 7f4d87462510 count>,)}>]¶
-
indexes
= [<sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>]¶
-
joinDefinitions
= [<sqlobject.joins.RelatedJoin object>]¶
-
joins
= [<sqlobject.joins.SORelatedJoin object>]¶
-
soClass
¶ псевдоним класса
m_librarian.db.Genre
-
style
= <sqlobject.styles.MixedCaseUnderscoreStyle object>¶
-
table
= 'genre'¶
-
-
title
¶
-
title_idx
= <sqlobject.index.SODatabaseIndex object>¶
-
-
class
m_librarian.db.
Language
(**kw)[исходный код]¶ - Базовые классы:
sqlobject.main.SQLObject
-
classmethod
byName
(val, connection=None)¶
-
count
¶
-
count_idx
= <sqlobject.index.SODatabaseIndex object>¶
-
j
= language¶
-
name
¶
-
q
= language¶
-
class
sqlmeta
(instance)¶ - Базовые классы:
sqlobject.main.sqlmeta
-
childName
= None¶
-
columnDefinitions
= {'count': <IntCol 7f4d87462690 count>, 'name': <UnicodeCol 7f4d874daf50 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 7f4d87462dd0 {'name': 'count_idx', 'columns': (<IntCol 7f4d87462690 count>,)}>]¶
-
indexes
= [<sqlobject.index.SODatabaseIndex object>]¶
-
joinDefinitions
= []¶
-
joins
= []¶
-
soClass
¶ псевдоним класса
m_librarian.db.Language
-
style
= <sqlobject.styles.MixedCaseUnderscoreStyle object>¶
-
table
= 'language'¶
-
-
classmethod
-
class
m_librarian.db.
AuthorBook
(**kw)[исходный код]¶ - Базовые классы:
sqlobject.main.SQLObject
-
book
¶
-
bookID
¶
-
book_idx
= <sqlobject.index.SODatabaseIndex object>¶
-
j
= author_book¶
-
main_idx
= <sqlobject.index.SODatabaseIndex object>¶
-
q
= author_book¶
-
class
sqlmeta
(instance)¶ - Базовые классы:
sqlobject.main.sqlmeta
-
childName
= None¶
-
columnDefinitions
= {'authorID': <ForeignKey 7f4d874b2590 author>, 'bookID': <ForeignKey 7f4d874c76d0 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 7f4d874c7710 {'name': 'author_idx', 'columns': (<ForeignKey 7f4d874b2590 author>,)}>, <DatabaseIndex 7f4d874c7750 {'name': 'book_idx', 'columns': (<ForeignKey 7f4d874c76d0 book>,)}>, <DatabaseIndex 7f4d874c77d0 {'unique': True, 'name': 'main_idx', 'columns': (<ForeignKey 7f4d874b2590 author>, <ForeignKey 7f4d874c76d0 book>)}>]¶
-
indexes
= [<sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>]¶
-
joinDefinitions
= []¶
-
joins
= []¶
-
soClass
¶ псевдоним класса
m_librarian.db.AuthorBook
-
style
= <sqlobject.styles.MixedCaseUnderscoreStyle object>¶
-
table
= 'author_book'¶
-
-
-
class
m_librarian.db.
BookGenre
(**kw)[исходный код]¶ - Базовые классы:
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)¶ - Базовые классы:
sqlobject.main.sqlmeta
-
childName
= None¶
-
columnDefinitions
= {'bookID': <ForeignKey 7f4d874ce150 book>, 'genreID': <ForeignKey 7f4d874cea90 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 7f4d874d7cd0 {'name': 'book_idx', 'columns': (<ForeignKey 7f4d874ce150 book>,)}>, <DatabaseIndex 7f4d874da7d0 {'name': 'genre_idx', 'columns': (<ForeignKey 7f4d874cea90 genre>,)}>, <DatabaseIndex 7f4d874da850 {'unique': True, 'name': 'main_idx', 'columns': (<ForeignKey 7f4d874ce150 book>, <ForeignKey 7f4d874cea90 genre>)}>]¶
-
indexes
= [<sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>, <sqlobject.index.SODatabaseIndex object>]¶
-
joinDefinitions
= []¶
-
joins
= []¶
-
soClass
¶ псевдоним класса
m_librarian.db.BookGenre
-
style
= <sqlobject.styles.MixedCaseUnderscoreStyle object>¶
-
table
= 'book_genre'¶
-
-
-
m_librarian.db.
open_db
(db_uri=None)[исходный код]¶
-
m_librarian.db.
init_db
()[исходный код]¶
-
m_librarian.db.
insert_name
(table, name, **kw)[исходный код]¶
-
m_librarian.db.
update_counters
(pbar_cb=None)[исходный код]¶