def testBrowser(self):
        self.m_logger.info('Testing browser capabilities')

        self.send_response(200)
        self.send_header("Content-type", "text/html")
        self.end_headers()

        # construct the browser capabilities test page
        l_pageTemplate = EcTemplate(EcRequestHandler.cm_templateString)

        l_oldPath = self.path
        while re.search('&y=.*&', l_oldPath):
            l_oldPath = re.sub('&y=.*&', '&', self.path)
        while re.search('\?y=.*&', l_oldPath):
            l_oldPath = re.sub('\?y=.*&', '?', self.path)
        l_oldPath = re.sub('[&\?]y=.*$', '', l_oldPath)

        l_response = l_pageTemplate.substitute(
            NewTarget=re.sub('/&y', '/?y', '.' + l_oldPath + '&y={0}'.format(self.m_terminalID)),
            NewTargetRestart=re.sub('/&y', '/?y', '.' + l_oldPath + '&y=restart'),
            TestingBrowserMsg=se3_utilities.get_user_string(self.m_contextDict, 'TestingBrowserMsg'),
            GainAccess1Msg=se3_utilities.get_user_string(self.m_contextDict, 'GainAccess1Msg'),
            ThisLinkMsg=se3_utilities.get_user_string(self.m_contextDict, 'ThisLinkMsg')
        )
        # In NewTarget the re.sub above is there to handle the case where the path is a bare "/"

        self.m_logger.debug('l_response: {0}'.format(l_response))

        l_bytes = bytes(l_response, 'utf-8')
        self.m_logger.debug('Bytes to send: {0}'.format(len(l_bytes)))

        # and send it
        self.wfile.write(l_bytes)
    def badBrowserMessage(self, p_dbConnection):
        self.m_logger.info('Sending bad browser message')

        self.send_response(200)
        self.send_header("Content-type", "text/html")
        self.end_headers()

        # since the browser is bad, delete the terminal ID (and the test terminal ID if different)
        if 'y' in self.m_contextDict.keys():
            l_testTID = self.m_contextDict['y']
        else:
            l_testTID = ''

        l_query = """
            DELETE FROM `TB_TERMINAL`
            WHERE `TERMINAL_ID` = '{0}' or `TERMINAL_ID` = '{1}'
            ;""".format(self.m_terminalID, l_testTID)

        self.m_logger.debug('l_query: {0}'.format(l_query))
        try:
            l_cursor = p_dbConnection.cursor()
            l_cursor.execute(l_query)
            # the cursor is executed and THEN, the connection is committed
            p_dbConnection.commit()
            l_cursor.close()
        except Exception as l_exception:
            self.m_logger.warning(self.pack_massage('Something went wrong while attempting ' +
                                  'to execute this query: {0} Error: {1}'.format(
                                      l_query, l_exception.args)))

        # construct the bad browser page
        l_pageTemplate = EcTemplate(EcRequestHandler.cm_badBrowserPage)

        l_oldPath = self.path
        while re.search('&y=.*&', l_oldPath):
            l_oldPath = re.sub('&y=.*&', '&', self.path)
        while re.search('\?y=.*&', l_oldPath):
            l_oldPath = re.sub('\?y=.*&', '?', self.path)
        l_oldPath = re.sub('[&\?]y=.*$', '', l_oldPath)

        l_response = l_pageTemplate.substitute(
            LinkPrevious='.' + l_oldPath,
            NewTargetRestart=re.sub('/&y', '/?y', '.' + l_oldPath + '&y=restart'),
            BadBrowserMsg=se3_utilities.get_user_string(self.m_contextDict, 'BadBrowserMsg'),
            GainAccessMsg=se3_utilities.get_user_string(self.m_contextDict, 'GainAccessMsg'),
            ThisLinkMsg=se3_utilities.get_user_string(self.m_contextDict, 'ThisLinkMsg')
        )
        # In NewTarget the re.sub above is there to handle the case where the path is a bare "/"

        # In NewTargetRestart the re.sub() removes the y=xxxxx parameter (terminal ID used to test browser
        # capabilities). It handles both the case where y is at the end of several parameters (&y=) and
        # the case where y is directly located after / (/?y=)

        # and send it
        self.wfile.write(bytes(l_response, 'utf-8'))
Пример #3
0
def get_toc(p_previousContext, p_context, p_dbConnectionPool):
    g_loggerSE3.info("Getting TOC response")
    g_loggerSE3.debug("p_previousContext: {0}".format(p_previousContext))
    g_loggerSE3.debug("p_context: {0}".format(p_context))

    l_dbConnection = p_dbConnectionPool.getConnection()

    l_response = ""

    # Ta1 : Quran, surah number order
    # Ta2 : Quran, revelation order
    # Tb  : NT
    # Tc  : OT
    # T   : all scripture

    # For Quran, chapter ordering based on ST_ORDER (Surah number) or ST_ORDER_ALT (Revelation order)
    if p_context["K"] == "Ta1":
        # Query for Quran only: long chapter names + Translit. No need for the Book ID
        l_query = """
            select
                N_CHAPTER
                , ST_NAME_OR
                , ST_NAME_OR2
                , ST_NAME_EN
                , ST_NAME_FR
            from TB_CHAPTER
            where ID_BOOK = 'Qur'
            order by ST_ORDER
            ;"""
    elif p_context["K"] == "Ta2":
        l_query = """
            select
                N_CHAPTER
                , ST_NAME_OR
                , ST_NAME_OR2
                , ST_NAME_EN
                , ST_NAME_FR
            from TB_CHAPTER
            where ID_BOOK = 'Qur'
            order by ST_ORDER_ALT
            ;"""
    else:
        if p_context["K"] == "Tb":
            l_cond = 'ID_GROUP_0 = "NT"'
            # title for NT
            l_response += '<h1 class="TocTitle">{0}</h1>\n'.format(
                se3_utilities.get_user_string(p_context, "m_tocNTTitle")
            )
        elif p_context["K"] == "Tc":
            l_cond = 'ID_GROUP_0 = "OT"'
            # title for OT
            l_response += '<h1 class="TocTitle">{0}</h1>\n'.format(
                se3_utilities.get_user_string(p_context, "m_tocOTTitle")
            )
        else:
            l_cond = "true"
            # title for All scripture
            l_response += '<h1 class="TocTitle">{0}</h1>\n'.format(
                se3_utilities.get_user_string(p_context, "m_tocAllTitle")
            )

        # Query for All scripture or Bible: only chapter names + Book ID
        l_query = """
            select
                ID_BOOK
                , N_CHAPTER_COUNT
                , ST_NAME_EN
                , ST_NAME_FR
            from TB_BOOK
            where {0}
            order by ID_GROUP_0, N_ORDER
            ;""".format(
            l_cond
        )

    g_loggerSE3.debug("l_query: {0}".format(l_query))
    try:
        l_cursor = l_dbConnection.cursor(buffered=True)
        l_cursor.execute(l_query)

        # Quran only (2 columns with Surah names)
        if p_context["K"][0:2] == "Ta":
            # title for Quran (depending on Surah order)
            l_response += '<h1 class="TocTitle">{0}</h1><div class="QuranToc"><div class="QuranTocCol1">\n'.format(
                se3_utilities.get_user_string(p_context, "m_tocQuranTitle")
                if p_context["K"] == "Ta1"
                else se3_utilities.get_user_string(p_context, "m_tocQuranTitleRev")
            )

            l_chapterCount = 1
            for l_chapter, l_nameOr, l_nameOr2, l_nameEn, l_nameFr in l_cursor:

                l_tocLink = se3_utilities.makeLinkCommon(
                    p_context, "Qur", l_chapter, "1", l_chapter, p_command="P", p_class="TocLink", p_v2="x"
                )

                l_response += ('<p class="QuranSurah">' + l_tocLink + ": {0} - {1}</p>\n").format(
                    l_nameFr if p_context["z"] == "fr" else l_nameEn, l_nameOr2
                )

                # column break 1-57 / 58-114
                if l_chapterCount == 57:
                    l_response += '</div><div class="QuranTocCol2">\n'

                l_chapterCount += 1

            l_response += "</div></div>\n"
        # Bible & All scripture (Book name + list of chapter numbers)
        else:
            for l_bookId, l_chapterCount, l_nameEn, l_nameFr in l_cursor:

                l_chapLinks = " ".join(
                    [
                        se3_utilities.makeLinkCommon(
                            p_context, l_bookId, i, "1", i, p_command="P", p_class="TocLink", p_v2="x"
                        )
                        for i in range(1, l_chapterCount + 1)
                    ]
                )

                l_response += '<p class="TocBook">{0}: {1}</p>\n'.format(
                    l_nameFr if p_context["z"] == "fr" else l_nameEn, l_chapLinks
                )

        l_cursor.close()

    except Exception as l_exception:
        g_loggerSE3.warning("Something went wrong {0}".format(l_exception.args))

    p_dbConnectionPool.releaseConnection(l_dbConnection)

    return l_response, p_context, ec_app_params.g_appTitle
Пример #4
0
def internal_get_header_controls(p_context):
    # number of version selection checkboxes per column
    l_segmentLength = 10
    # Max number of versions to display in the status display
    l_selectedLimit = 4

    # Bible version list for the status display (beginning)
    l_statusDisplay = "<b>{0}</b>: ".format(se3_utilities.get_user_string(p_context, "m_bible"))

    # Bible versions selection checkboxes (beginning)
    l_bibleVersionControl = '<div class="VersionSegment">' + '<div class="VersionSelector"><b>{0}</b>:</div>'.format(
        se3_utilities.get_user_string(p_context, "m_bibleVersions")
    )

    # produce both the status display Bible version list and the Bible version selection checkbox block
    l_segmentCount = 1
    l_verMask = 1
    l_selectedCount = 0
    l_selectedList = [v[0] for v in se3_utilities.get_version_list(p_context, False, "B")]
    for l_versionId, l_language, l_default, l_labelShort, l_labelTiny, l_basmalat in se3_utilities.getVersionList("B"):
        # Bible selection checkboxes
        # Each checkbox row is enclosed in a <div class="VersionSelector"> together with its label
        # The checkbox format is:
        #
        # <input type="checkbox" value="" class="ToggleVersion" name="" ver_mask="xx" bible_quran="B" yy>
        #
        # xx = hexadecimal bit mask indicating the version
        # yy = 'checked' if version selected or nothing otherwise
        l_bibleVersionControl += (
            '<div class="VersionSelector">'
            + '<input type="checkbox" value="" '
            + 'class="ToggleVersion ToggleVersionBible" name="" ver_mask="{2}" '
            + 'bible_quran="B" {1}>&nbsp{0}</div>\n'
        ).format(l_labelShort, "checked" if l_versionId in l_selectedList else "", l_verMask)

        # status display Bible version list
        if l_versionId in l_selectedList and l_selectedCount < l_selectedLimit:
            l_statusDisplay += l_labelTiny + ", "
            l_selectedCount += 1

        l_segmentCount += 1
        l_verMask *= 2
        # column break if column height reached
        if l_segmentCount % l_segmentLength == 0:
            l_segmentCount = 0
            l_bibleVersionControl += '</div><div class="VersionSegment">'

    l_statusDisplay = re.sub(",\s$", "", l_statusDisplay)
    # adding ... at the end of the status display if there are more Bible versions than the limit
    if len(l_selectedList) > l_selectedLimit:
        l_statusDisplay += ", ... "
    else:
        l_statusDisplay += " "

    l_bibleVersionControl += ' <input type="button" id="UnselectAllBible" value="{0}"></div>\n'.format(
        se3_utilities.get_user_string(p_context, "m_unselectAll")
    )
    l_bibleVersionControl = re.sub('<div class="VersionSegment"></div>$', "", l_bibleVersionControl)

    # Quran versions selection checkboxes (beginning)
    l_quranVersionControl = '<div class="VersionSegment">' + '<div class="VersionSelector"><b>{0}</b>:</div>'.format(
        se3_utilities.get_user_string(p_context, "m_quranVersions")
    )

    # Quran version list for the status display (beginning)
    l_statusDisplay += "<b>{0}</b>: ".format(se3_utilities.get_user_string(p_context, "m_quran"))

    # produce both the status display Quran version list and the Quran version selection checkbox block
    l_segmentCount = 1
    l_verMask = 1
    l_selectedCount = 0
    l_selectedList = [v[0] for v in se3_utilities.get_version_list(p_context, False, "Q")]
    for l_versionId, l_language, l_default, l_labelShort, l_labelTiny, l_basmalat in se3_utilities.getVersionList("Q"):
        # Quran selection checkboxes
        # Each checkbox row is enclosed in a <div class="VersionSelector"> together with its label
        # The checkbox format is:
        #
        # <input type="checkbox" value="" class="ToggleVersion" name="" ver_mask="xx" bible_quran="B" yy>
        #
        # xx = hexadecimal bit mask indicating the version
        # yy = 'checked' if version selected or nothing otherwise
        l_quranVersionControl += (
            '<div class="VersionSelector"><input type="checkbox" value="" '
            + 'class="ToggleVersion ToggleVersionQuran" name="" ver_mask="{2}" '
            + 'bible_quran="Q" {1}>&nbsp{0}</div>\n'
        ).format(l_labelShort, "checked" if l_versionId in l_selectedList else "", l_verMask)

        # status display Quran version list
        if l_versionId in l_selectedList and l_selectedCount < l_selectedLimit:
            l_statusDisplay += l_labelTiny + ", "
            l_selectedCount += 1

        l_segmentCount += 1
        l_verMask *= 2
        # column break if column height reached
        if l_segmentCount % l_segmentLength == 0:
            l_segmentCount = 0
            l_quranVersionControl += '</div><div class="VersionSegment">'

    l_statusDisplay = re.sub(",\s$", "", l_statusDisplay)
    # adding ... at the end of the status display if there are more Quran versions than the limit
    if len(l_selectedList) > l_selectedLimit:
        l_statusDisplay += ", ... "

    l_quranVersionControl += ' <input type="button" id="UnselectAllQuran" value="{0}"></div>\n'.format(
        se3_utilities.get_user_string(p_context, "m_unselectAll")
    )
    l_quranVersionControl = re.sub('<div class="VersionSegment"></div>$', "", l_quranVersionControl)

    # parameter checkboxes (same formatting as version checkboxes)
    l_paramControl = '<div class="VersionSegment">' + '<div class="VersionSelector"><b>{0}</b>:</div>'.format(
        se3_utilities.get_user_string(p_context, "m_paramControl")
    )

    # list of tuples used to feed the loop below. Contains all the necessary elements for each parameter checkbox
    l_tmpList = [
        # the substitution is because some labels have '·' instead of ' ' in order to separate words
        (se3_utilities.get_user_string(p_context, "sv_AllVersions"), p_context["a"], se3_utilities.g_svAllVersions),
        (se3_utilities.get_user_string(p_context, "m_DisplayLxx"), p_context["x"], se3_utilities.g_svDisplayLxx),
        (se3_utilities.get_user_string(p_context, "m_DisplayNasb"), p_context["n"], se3_utilities.g_svDisplayNasb),
        (se3_utilities.get_user_string(p_context, "m_DisplayKJV"), p_context["k"], se3_utilities.g_svDisplayKjv),
        (se3_utilities.get_user_string(p_context, "p_displayGround"), p_context["g"], se3_utilities.g_pDisplayGround),
        (se3_utilities.get_user_string(p_context, "p_parallelVersions"), p_context["r"], se3_utilities.g_pParallel),
    ]

    for l_label, l_condition, l_mask in l_tmpList:
        l_paramControl += (
            '<div class="VersionSelector"><input type="checkbox"  value="" '
            + 'class="ToggleParameter" name="" param_mask="{2}" '
            + "{1}>&nbsp{0}</div>\n"
        ).format(
            # the substitution is because some labels have '·' instead of ' ' in order to separate words
            re.sub("·", " ", l_label),
            "checked" if l_condition else "",
            l_mask,
        )

    l_paramControl += "</div>"

    return l_bibleVersionControl, l_quranVersionControl, l_paramControl, l_statusDisplay
Пример #5
0
def internal_get_labels(p_context):
    l_substituteVar = dict()

    # Search form labels and current values
    l_substituteVar["label_search"] = se3_utilities.get_user_string(p_context, "m_labelSearch")
    l_substituteVar["label_wholeWords"] = se3_utilities.get_user_string(p_context, "m_labelWholeWords")
    l_substituteVar["label_caseSensitive"] = se3_utilities.get_user_string(p_context, "m_labelCaseSensitive")
    l_substituteVar["label_exclude"] = se3_utilities.get_user_string(p_context, "m_labelExclude")
    l_substituteVar["label_searchScope"] = se3_utilities.get_user_string(p_context, "m_labelSearchScope")

    # Search mode value labels
    l_substituteVar["label_searchMode"] = se3_utilities.get_user_string(p_context, "m_labelSearchMode")
    l_substituteVar["label_searchMode0"] = se3_utilities.get_user_string(p_context, "m_labelSearchMode0")
    l_substituteVar["label_searchMode1"] = se3_utilities.get_user_string(p_context, "m_labelSearchMode1")
    l_substituteVar["label_searchMode2"] = se3_utilities.get_user_string(p_context, "m_labelSearchMode2")

    # Search mode current value
    l_substituteVar["inputValue_e0"] = ""
    l_substituteVar["inputValue_e1"] = ""
    l_substituteVar["inputValue_e2"] = ""
    l_substituteVar["inputValue_e" + p_context["e"]] = "selected"

    # Quran scope value labels
    l_substituteVar["label_searchScopeQ"] = se3_utilities.get_user_string(p_context, "m_labelSearchScopeQ")
    l_substituteVar["label_searchScopeQ0"] = se3_utilities.get_user_string(p_context, "m_labelSearchScopeQ0")
    l_substituteVar["label_searchScopeQ1"] = se3_utilities.get_user_string(p_context, "m_labelSearchScopeQ1")

    # Quran scope current value
    l_substituteVar["inputValue_h0"] = ""
    l_substituteVar["inputValue_h1"] = ""
    l_substituteVar["inputValue_h" + p_context["h"]] = "selected"

    # NT scope value labels
    l_substituteVar["label_searchScopeNT"] = se3_utilities.get_user_string(p_context, "m_labelSearchScopeNT")
    l_substituteVar["label_searchScopeNT0"] = se3_utilities.get_user_string(p_context, "m_labelSearchScopeNT0")
    l_substituteVar["label_searchScopeNT1"] = se3_utilities.get_user_string(p_context, "m_labelSearchScopeNT1")
    l_substituteVar["label_searchScopeNT2"] = se3_utilities.get_user_string(p_context, "m_labelSearchScopeNT2")
    l_substituteVar["label_searchScopeNT3"] = se3_utilities.get_user_string(p_context, "m_labelSearchScopeNT3")
    l_substituteVar["label_searchScopeNT4"] = se3_utilities.get_user_string(p_context, "m_labelSearchScopeNT4")

    # NT scope current value
    l_substituteVar["inputValue_i0"] = ""
    l_substituteVar["inputValue_i1"] = ""
    l_substituteVar["inputValue_i2"] = ""
    l_substituteVar["inputValue_i3"] = ""
    l_substituteVar["inputValue_i4"] = ""
    l_substituteVar["inputValue_i" + p_context["i"]] = "selected"

    # OT scope value labels
    l_substituteVar["label_searchScopeOT"] = se3_utilities.get_user_string(p_context, "m_labelSearchScopeOT")
    l_substituteVar["label_searchScopeOT0"] = se3_utilities.get_user_string(p_context, "m_labelSearchScopeOT0")
    l_substituteVar["label_searchScopeOT1"] = se3_utilities.get_user_string(p_context, "m_labelSearchScopeOT1")
    l_substituteVar["label_searchScopeOT2"] = se3_utilities.get_user_string(p_context, "m_labelSearchScopeOT2")
    l_substituteVar["label_searchScopeOT3"] = se3_utilities.get_user_string(p_context, "m_labelSearchScopeOT3")
    l_substituteVar["label_searchScopeOT4"] = se3_utilities.get_user_string(p_context, "m_labelSearchScopeOT4")
    l_substituteVar["label_searchScopeOT5"] = se3_utilities.get_user_string(p_context, "m_labelSearchScopeOT5")

    # OT scope current value
    l_substituteVar["inputValue_j0"] = ""
    l_substituteVar["inputValue_j1"] = ""
    l_substituteVar["inputValue_j2"] = ""
    l_substituteVar["inputValue_j3"] = ""
    l_substituteVar["inputValue_j4"] = ""
    l_substituteVar["inputValue_j5"] = ""
    l_substituteVar["inputValue_j" + p_context["j"]] = "selected"

    # TOC labels
    l_substituteVar["toc_allScripture"] = se3_utilities.get_user_string(p_context, "m_tocAllScripture")
    l_substituteVar["toc_Quran"] = se3_utilities.get_user_string(p_context, "m_quran")
    l_substituteVar["toc_QuranRev"] = se3_utilities.get_user_string(p_context, "m_tocQuranRev")
    l_substituteVar["toc_NT"] = se3_utilities.get_user_string(p_context, "m_labelSearchScopeNT")
    l_substituteVar["toc_OT"] = se3_utilities.get_user_string(p_context, "m_labelSearchScopeOT")
    l_substituteVar["toc_toc"] = se3_utilities.get_user_string(p_context, "m_tocToc")

    # Lexicon labels
    l_substituteVar["lex_Arabic"] = se3_utilities.get_user_string(p_context, "m_lexArabic")
    l_substituteVar["lex_Greek"] = se3_utilities.get_user_string(p_context, "m_lexGreek")
    l_substituteVar["lex_Hebrew"] = se3_utilities.get_user_string(p_context, "m_lexHebrew")
    l_substituteVar["lex_lex"] = se3_utilities.get_user_string(p_context, "m_lexLex")

    # Apply button label
    l_substituteVar["ApplyLabel"] = se3_utilities.get_user_string(p_context, "m_ApplyLabel")

    # Left panel section collapse buttons in open and closed positions
    l_substituteVar["CollapsarShow"] = se3_utilities.get_user_string(p_context, "m_CollapsarShow")
    l_substituteVar["CollapsarHide"] = se3_utilities.get_user_string(p_context, "m_CollapsarHide")

    return l_substituteVar