HGKeeper

py_ext: fix CSV Writer

18 months ago, Edouard Tisserant

d2f5eb3c7d6e

py_ext: fix CSV Writer

fix POU logic :
- SAVE is a BOOL
- invocation of py_eval on rising edge of SAVE
- remove save python argument

fix python:
- use no encoding for file open (python2)
- re-use detected dialect if any
- use no "rt+" and truncate since no need to re-sniff dialect for output file
- return "OK" instead of "#SUCCESS", preventing POU logic to ACK result
- support creating new line if writing just after last line
- support appending data on short rows

fix example:
- use a HMI:Button to trigger CSV write instead of HMI:Input +1
- reload CSVs on on each new CSV opened in file browser
- add display of CSV write output

#!/usr/bin/env python

# -*- coding: utf-8 -*-

# This file is part of Beremiz

# See COPYING file for copyrights details.

from __future__ import print_function

import sys

from base64 import b64encode

from fontTools import ttLib

# Inkscape seems to refer to font with different family name depending on platform.

# this are heuristics that would need extensive testing to be sure.

FamilyNameIDs = [1] if sys.platform.startswith('win') else [1, 16]

def GetFontTypeAndFamilyName(filename):

"""

Getting font family, format and MIME type

"""

familyname = None

uniquename = None

formatname = None

mimetype = None

font = ttLib.TTFont(filename)

# https://developer.apple.com/fonts/TrueType-Reference-Manual/RM06/Chap6name.html

for name in font["name"].names:

#print(name.nameID, name.platformID, name.langID, name.toUnicode())

if name.nameID in FamilyNameIDs and name.platformID==3 and name.langID==1033:

familyname = name.toUnicode()

if name.nameID==4 and name.platformID==3 and name.langID==1033:

uniquename = name.toUnicode()

if font.flavor :

# woff and woff2

formatname = font.flavor

mimetype = "font/" + formatname

# conditions on sfntVersion was deduced from fontTools.ttLib.sfnt

elif font.sfntVersion in ("\x00\x01\x00\x00", "true"):

formatname = "truetype"

mimetype = "font/ttf"

elif font.sfntVersion == "OTTO":

formatname = "opentype"

mimetype = "font/otf"

return familyname,uniquename,formatname,mimetype

def DataURIFromFile(filename, mimetype):

with open(filename, "rb") as fp:

data = fp.read()

return "".join([

"data:",

mimetype,

";base64,",

b64encode(data).decode().strip()])

def GetCSSFontFaceFromFontFile(filename):

familyname, uniquename, formatname, mimetype = GetFontTypeAndFamilyName(filename)

data_uri = DataURIFromFile(filename, mimetype)

css_font_face = \

"""

@font-face {{

font-family: "{}";

src: url("{}") format("{}")

}}

""".format(familyname, data_uri, formatname)

return css_font_face

# tests

if __name__ == '__main__':

print(GetCSSFontFaceFromFontFile("/usr/share/matplotlib/mpl-data/fonts/ttf/DejaVuSans.ttf"))

print(GetCSSFontFaceFromFontFile("/usr/share/fonts/opentype/urw-base35/NimbusSans-Regular.otf"))

print(GetCSSFontFaceFromFontFile("/usr/share/yelp/mathjax/fonts/HTML-CSS/TeX/woff/MathJax_SansSerif-Regular.woff"))

beremiz