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>

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)

Базовые классы: 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'

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'

class m_librarian.db.AuthorBook(**kw)

Базовые классы: 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)

Базовые классы: 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.insert_author(surname, name, misc_name)

m_librarian.db.update_counters(pbar_cb=None)