flask.cfg

# Web-interface port. Default is 5000
FLASK_PORT = 5000

# Proxy for online updates. Default is None
#HTTP_PROXY = 'http://127.0.0.1:3128/'

# URL list for online updates. Each group is randomized, but groups are tried in sequence.
JSONAPI_URL_LIST = [
    ['http://gen.lib.rus.ec/json.php'],
    ['http://libgen.io/json.php'],
]
JSONAPI_RETRY_COUNT = 3
JSONAPI_RETRY_DELAY = 1

VIEW_URL="http://gen.lib.rus.ec/book/index.php?md5={md5}"
MIRROR_LIST=[
  "http://libgen.io/get?md5={md5}",
  "http://bookzz.org/md5/{md5}",
  "http://golibgen.io/view.php?id={id}",
  "http://bookfi.net/md5/{md5}",
]
EDIT_URL="http://libgen.io/librarian/registration?md5={md5}"

DELTA_MERGE_THRESHOLD = 10000

# MySQL connection to Sphinx

MYSQL_DATABASE_HOST='127.0.0.1'
MYSQL_DATABASE_PORT=5306
MYSQL_DATABASE_USER='root'
MYSQL_DATABASE_PASSWORD=''
MYSQL_DATABASE_DB=''
MYSQL_DATABASE_CHARSET='utf8'

INDEX_TABLE='libgenmain,libgendelta'

# CSV update file

CSV_FIELDS = [
    'ID', 'Title', 'VolumeInfo', 'Series', 'Periodical', 'Author', 'Year',
    'Edition', 'Publisher', 'City', 'Pages', 'PagesInFile', 'Language',
    # 'Topic', 'Library', 'Issue',
    'Identifier',
    # 'ISSN', 'ASIN', 'UDC', 'LBC', 'DDC', 'LCC', 'Doi', 'Googlebookid', 'OpenLibraryID',
    # 'Commentary', 'DPI', 'Color', 'Cleaned', 'Orientation', 'Paginated', 'Scanned', 'Bookmarked', 'Searchable',
    'Filesize', 'Extension', 'MD5', 'Generic',
    'Visible',
    # 'Locator', 'Local',
    'TimeAdded', 'TimeLastModified',
    # 'Coverurl', 'Tags',
    'IdentifierWODash',
]

# Sphinx indexer pipe

SPHINX_VISIBLE_ENUM={ '':0, 'no':1, 'ban': 2, 'del': 3 }
SPHINX_ATTR_DUPLICATE=["Title","VolumeInfo","Series","Periodical","Author","Year","Publisher","Language","Identifier","Extension","MD5"]
SPHINX_ATTR_SUFFIX="Attr"
SPHINX_FIELDS=[
    'ID',
    
    # Fields
    
    "Title",
    "VolumeInfo",
    "Series",
    "Periodical",
    "Author",
    "Year",
    # "Edition",
    "Publisher",
    # "City",
    # "Pages",
    # "PagesInFile",
    "Language",
    # "Topic",
    # "Library",
    # "Issue",
    "Identifier",
    # "ISSN",
    # "ASIN",
    # "UDC",
    # "LBC",
    # "DDC",
    # "LCC",
    # "Doi",
    # "Googlebookid",
    # "OpenLibraryID",
    # "Commentary",
    # "DPI",
    # "Color",
    # "Cleaned",
    # "Orientation",
    # "Paginated",
    # "Scanned",
    # "Bookmarked",
    # "Searchable",
    # "Filesize",
    "Extension",
    "MD5",
    # "Generic",
    # "Visible",
    # "Locator",
    # "Local",
    # "TimeAdded",
    # "TimeLastModified",
    # "Coverurl",
    # "Tags",
    "IdentifierWODash",

    # Attributes

    'TitleAttr',
    'VolumeInfoAttr',
    'SeriesAttr',
    'PeriodicalAttr',
    'AuthorAttr',
    'YearAttr',
    'Edition',
    'PublisherAttr',
    'City',
    'Pages',
    'PagesInFile',
    'LanguageAttr',
#   'Topic',
#   'Library',
#   'Issue',
    'IdentifierAttr',
#   'ISSN',
#   'ASIN',
#   'UDC',
#   'LBC',
#   'DDC',
#   'LCC',
#   'Doi',
#   'Googlebookid',
#   'OpenLibraryID',
#   'Commentary',
#   'DPI',              # uint
#   'Color',
#   'Cleaned',
#   'Orientation',
#   'Paginated',
#   'Scanned',
#   'Bookmarked',
#   'Searchable',
    'Filesize',         # bigint
    'ExtensionAttr',
    'MD5Attr',
    'Generic',
    'Visible',
#   'Locator',
#   'Local',
    'TimeAdded',        # timestamp
    'TimeLastModified', # timestamp
#   'Coverurl',
#   'Tags',
    #'IdentifierWODashAttr',    # don't add this as attribute because it is actually the copy of 'Identifier',
]

# Search API

# Fields are prepended to query as Sphinx multiple-field search operator: @(field1,field2,...) http://sphinxsearch.com/docs/current.html#extended-syntax
FIELD_LIST={
    't': 'title',
    'a': 'author',
    's': 'series',
    'p': 'periodical',
    'u': 'publisher',
    'y': 'year',
    'v': 'volumeinfo',
    'L': 'language',
    '5': 'md5',
    'i': 'identifier,identifierwodash',
    'e': 'extension',
}

SORT_DEFAULT='title'
SORT_LIST={
    'title': "TitleAttr ASC, SeriesAttr ASC, PeriodicalAttr ASC, AuthorAttr ASC, ID ASC",
    'series': "SeriesAttr ASC, PeriodicalAttr ASC, TitleAttr ASC, AuthorAttr ASC, ID ASC",
    'relevance': "WEIGHT() DESC, ID ASC",
    'added': "ID DESC",
    'modified': "TimeLastModified DESC, ID DESC",
    'year': "YearAttr DESC, TitleAttr ASC, SeriesAttr ASC, PeriodicalAttr ASC, AuthorAttr ASC",
    '-year': "YearAttr ASC, TitleAttr ASC, SeriesAttr ASC, PeriodicalAttr ASC, AuthorAttr ASC",
    'size': "Filesize ASC, TitleAttr ASC, SeriesAttr ASC, PeriodicalAttr ASC, AuthorAttr ASC",
    '-size': "Filesize DESC, TitleAttr ASC, SeriesAttr ASC, PeriodicalAttr ASC, AuthorAttr ASC",
}

VISIBLE_LIST={
    'n': '1',
    'b': '2',
}

# Double-formatted: %%()s is quoted and escaped, %()s is passed as-is
SEARCH_QUERY="""
    SELECT
        ID, MD5Attr as MD5,
        SeriesAttr as Series,PeriodicalAttr as Periodical,TitleAttr as Title,AuthorAttr as Author,PublisherAttr as Publisher,
        Edition,VolumeInfoAttr as VolumeInfo,
        IdentifierAttr as Identifier,
        YearAttr as Year,Pages,LanguageAttr as Language,Filesize,ExtensionAttr as Extension,
        Visible, TimeAdded, TimeLastModified
    FROM %(table)s
    WHERE MATCH(%%(query)s) %(visible)s
    ORDER BY %(sort)s
    LIMIT 1000
    OPTION max_matches = 1000
"""