def sound(soundtype=None, filespec=None):
    """Play selected sound"""

    # debugging
    # makes debug apply only to the current thread
    #try:
    #import wingdbstub
    #if wingdbstub.debugger != None:
    #import time
    #wingdbstub.debugger.StopDebug()
    #time.sleep(2)
    #wingdbstub.debugger.StartDebug()
    #import thread
    #wingdbstub.debugger.SetDebugThreads({thread.get_ident(): 1}, default_policy=0)
    ## for V19 use
    #SpssClient._heartBeat(False)
    #except:
    #pass

    # imported within function so that localization and error handling are enabled
    try:
        import winsound
    except:
        raise SystemError(_("""This command is only available on Windows"""))

    sounds = {
        None: winsound.MB_OK,
        "default": winsound.MB_OK,
        "exclamation": winsound.MB_ICONEXCLAMATION,
        "asterisk": winsound.MB_ICONASTERISK,
        "hand": winsound.MB_ICONHAND,
        "question": winsound.MB_ICONQUESTION
    }

    if filespec:
        fh = FileHandles()
        filespec = fh.resolve(filespec)
        winsound.PlaySound(filespec, winsound.SND_FILENAME)
        if soundtype is None:
            return

    winsound.MessageBeep(sounds[soundtype])
def sound(soundtype=None, filespec=None):
    """Play selected sound"""
    
        # debugging
    # makes debug apply only to the current thread
    #try:
        #import wingdbstub
        #if wingdbstub.debugger != None:
            #import time
            #wingdbstub.debugger.StopDebug()
            #time.sleep(2)
            #wingdbstub.debugger.StartDebug()
        #import thread
        #wingdbstub.debugger.SetDebugThreads({thread.get_ident(): 1}, default_policy=0)
        ## for V19 use
        #SpssClient._heartBeat(False)
    #except:
        #pass
    
    # imported within function so that localization and error handling are enabled
    try:
        import winsound
    except:
        raise SystemError(_("""This command is only available on Windows"""))
    
    sounds = {None:winsound.MB_OK, "default":winsound.MB_OK, "exclamation":winsound.MB_ICONEXCLAMATION,
        "asterisk": winsound.MB_ICONASTERISK, "hand":winsound.MB_ICONHAND,
        "question":winsound.MB_ICONQUESTION}
    
    if filespec:
        fh = FileHandles()
        filespec = fh.resolve(filespec)
        winsound.PlaySound(filespec, winsound.SND_FILENAME)
        if soundtype is None:
            return

    winsound.MessageBeep(sounds[soundtype])
def excelexport(obj, custom):
    """Export selected output items to Excel
    
    parameters:
    file - filespec for output (required)
    sheet - sheetname.  Default is "Sheet"
    action - "CreateWorkbook" | "Create Worksheet" | "ModifyWorksheet"
    location - "OverwriteAtCellRef" | "AddColumns" | "AddRows"
    startingCell - starting cell if location is overwrite.  Default is "A1"
    image - image format - "jpg" | "png" | "tiff" | "eps" | "emf" | "bmp"
    
    See OUTPUT EXPORT help for information on these options
    
    Use # in the file or sheet string to insert a sequential number on each
    save operation to avoid overwriting.
    
    The first value listed is the default if there is one.
    
    If an item would overwrite another item in the same command, an error is raised"""

    if custom["_first"]:
        custom["_first"] = False
        custom["number"] = 0
        # set defaults
        custom["sheet"] = custom.get("sheet", "Sheet")
        custom["action"] = custom.get("action", "CreateWorkbook")
        custom["location"] = custom.get("location", "OverwriteAtCellRef")
        custom["startingCell"] = custom.get("startingCell", "A1")
        image = custom.get("image", "jpg")
        if not image in imagekwds.keys():
            raise ValueError(_("""Invalid image format: %s""" % image))
        custom["image"] = imagekwds[image]

        if not "file" in custom:
            raise ValueError(_("""file parameter must be specified"""))
        # user might have too old a version for file handle support
        try:
            custom["file"] = FileHandles().resolve(custom["file"])
        except:
            pass
        count = custom["file"].count("#") + custom["sheet"].count("#")
        if count > 1:
            raise ValueError(
                _("""Only one "#" may appear in file and sheet parameters together"""
                  ))
        custom["wouldoverwrite"] = (count == 0 and custom["location"] == "OverwriteAtCellRef") or \
            (custom["file"].count("#") == 0 and custom["action"] == "CreateWorkbook")

        # desout is the designated output window
        desout = custom["_designatedOutput"]
        # error checking is left to the apis
        desout.SetOutputOptions(
            SpssClient.DocExportOption.ExcelOperationOptions, custom["action"])
        desout.SetOutputOptions(SpssClient.DocExportOption.ExcelStartingCell,
                                custom["startingCell"])
        desout.SetOutputOptions(
            SpssClient.DocExportOption.ExcelLocationOptions,
            custom["location"])

    # Process the current object
    # check for overwrite
    if custom["wouldoverwrite"] and custom["number"] > 0:
        raise ValueError(
            _("""Exporting stopped: multiple items would overwrite each other"""
              ))

    filename = custom["file"].replace("#", str(custom["number"]))
    sheetname = custom["sheet"].replace("#", str(custom["number"]))
    desout = custom["_designatedOutput"]
    desout.SetOutputOptions(SpssClient.DocExportOption.ExcelSheetNames,
                            sheetname)

    # Write graphics objects to separate files named by file and sheet name
    # since ExportToDocument api can't do images
    if obj.GetType() in [
            SpssClient.OutputItemType.CHART,
            SpssClient.OutputItemType.TREEMODEL,
            SpssClient.OutputItemType.MODEL
    ]:
        name = os.path.splitext(filename)[0] + "_" + sheetname
        obj.ExportToImage(name, custom["image"])
    else:
        obj.ExportToDocument(filename,
                             SpssClient.DocExportFormat.SpssFormatXls)
    custom["number"] = custom["number"] + 1
Exemplo n.º 4
0
def dopmml(files):
    """Display pmml files"""

    # debugging
    #makes debug apply only to the current thread
    # The global namespace qualifier depends on the PMML and is set per file
    global ns
    #try:
    #import wingdbstub
    #if wingdbstub.debugger != None:
    #import time
    #wingdbstub.debugger.StopDebug()
    #time.sleep(2)
    #wingdbstub.debugger.StartDebug()
    #import thread
    #wingdbstub.debugger.SetDebugThreads({thread.get_ident(): 1}, default_policy=0)
    ## for V19 use
    #SpssClient._heartBeat(False)
    #except:
    #pass
    fh = FileHandles()
    files = fh.resolve(
        files)  # note that files might be a wildcard file expression
    spss.StartProcedure("STATS PMML DISPLAY", "STATSPMMLINFO")
    didone = False
    try:
        for fnumber, f in enumerate(glob.glob(files)):
            text = Text("""STATS_PMML_DISPLAY-""" + str(fnumber))
            didone = True
            try:
                try:
                    tree = ElementTree.parse(f)
                    root = tree.getroot()
                    first = True
                except:
                    raise ValueError(
                        _("""Invalid xml.  Error: %s File: %s""") %
                        (sys.exc_info()[1].message, f))
                # Discriminant xml is not tagged as pmml
                if not (root.tag.endswith("PMML")
                        or root.tag.endswith("spss-ml")):
                    text.addtext("""%f is not a PMML file""" % f)
                    continue

                ftime = time.ctime(os.stat(f).st_mtime)
                text.title = _("""Summary Information: %s""") % f
                text.addtext(
                    _("""Summary Model Information for File: %s\nmodified: %s\n"""
                      ) % (f, ftime))
                for ch in root.getchildren():
                    if first:
                        first = False
                        # find the namespace - there ought to be a better way :-)
                        thetag = re.match(r"\{.*\}", ch.tag)
                        if thetag:
                            ns = thetag.group()
                        else:
                            ns = ""
                    chtag = re.sub(r"""\{.*\}""", "", ch.tag)
                    if chtag == "Header":
                        doHeader(chtag, ch)
                    elif chtag == "TransformationDictionary":
                        displayTransformations(ch, text)
                    elif chtag == "MiningModel":
                        displayMining(ch, text)
                    elif chtag in [
                            'DataDictionary', 'Extension', 'dictionary'
                    ]:
                        continue
                    elif chtag == "model" and ch.find(
                            "./" + ns + 'discriminant-model') is not None:
                        disc = ch.find("./" + ns + 'discriminant-model')
                        prints['discriminant-model'](disc, text)
                    elif chtag not in prints:
                        text.addtext(
                            _("""Cannot display element: %s""") % chtag)
                    else:
                        prints[chtag](ch, text)
            finally:
                text.printit()
                del (text)  # should not be necessary
    finally:
        spss.EndProcedure()
    if not didone:
        raise ValueError(
            _("""No files were found to process.  File Specification: %s""") %
            files)
def dopmml(files):
    """Display pmml files"""
    
    # debugging
    #makes debug apply only to the current thread
    # The global namespace qualifier depends on the PMML and is set per file
    global ns
    #try:
        #import wingdbstub
        #if wingdbstub.debugger != None:
            #import time
            #wingdbstub.debugger.StopDebug()
            #time.sleep(2)
            #wingdbstub.debugger.StartDebug()
        #import thread
        #wingdbstub.debugger.SetDebugThreads({thread.get_ident(): 1}, default_policy=0)
        ## for V19 use
        #SpssClient._heartBeat(False)
    #except:
        #pass
    fh = FileHandles()
    files = fh.resolve(files)   # note that files might be a wildcard file expression
    spss.StartProcedure("STATS PMML DISPLAY", "STATSPMMLINFO")
    didone = False
    try:
        for fnumber, f in enumerate(glob.glob(files)):
            text = Text("""STATS_PMML_DISPLAY-""" + str(fnumber) )
            didone = True
            try:
                try:
                    tree = ElementTree.parse(f)
                    root = tree.getroot()
                    first = True
                except:
                    raise ValueError(_("""Invalid xml.  Error: %s File: %s""") % (sys.exc_info()[1].message, f))
                # Discriminant xml is not tagged as pmml
                if not (root.tag.endswith("PMML") or root.tag.endswith("spss-ml")):
                    text.addtext("""%f is not a PMML file""" % f)
                    continue
      
                ftime = time.ctime(os.stat(f).st_mtime)
                text.title = _("""Summary Information: %s""") % f
                text.addtext( _("""Summary Model Information for File: %s\nmodified: %s\n""") % (f, ftime))
                for ch in root.getchildren():
                    if first:
                        first = False
                        # find the namespace - there ought to be a better way :-)
                        thetag = re.match(r"\{.*\}", ch.tag)
                        if thetag:
                            ns = thetag.group()
                        else:
                            ns = ""                    
                    chtag = re.sub(r"""\{.*\}""", "", ch.tag)
                    if chtag == "Header":
                        doHeader(chtag, ch)
                    elif chtag == "TransformationDictionary":
                        displayTransformations(ch, text)
                    elif chtag == "MiningModel":
                        displayMining(ch, text)
                    elif chtag in ['DataDictionary', 'Extension', 'dictionary']:
                        continue
                    elif chtag == "model" and ch.find("./" + ns + 'discriminant-model') is not None:
                        disc = ch.find("./" + ns + 'discriminant-model')
                        prints['discriminant-model'](disc, text)
                    elif chtag not in prints:
                        text.addtext( _("""Cannot display element: %s""") % chtag)
                    else:                
                        prints[chtag](ch, text)
            finally:
                text.printit()
                del(text)   # should not be necessary
    finally:
        spss.EndProcedure()
    if not didone:
        raise ValueError( _("""No files were found to process.  File Specification: %s""") % files)