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, a Integrated Development Environment for

# programming IEC 61131-3 automates supporting plcopen standard and CanFestival.

# See COPYING file for copyrights details.

# This program is free software; you can redistribute it and/or

# modify it under the terms of the GNU General Public License

# as published by the Free Software Foundation; either version 2

# of the License, or (at your option) any later version.

# This program is distributed in the hope that it will be useful,

# but WITHOUT ANY WARRANTY; without even the implied warranty of

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

# GNU General Public License for more details.

# You should have received a copy of the GNU General Public License

# along with this program; if not, write to the Free Software

# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.

import os

import sys

def AbsFile(file):

if isinstance(file, str):

file = str(file, sys.getfilesystemencoding())

return file

def AbsDir(file):

return os.path.dirname(os.path.realpath(file))

def AbsNeighbourFile(file, *args):

return os.path.join(AbsDir(file), *args)

def AbsParentDir(file, level=1):

path = AbsDir(file)

for dummy in range(0, level):

path = os.path.dirname(path)

return path

def ThirdPartyPath(name, *suffixes):

"""

Return folder where to find sibling projects like Modbus, CanFestival, BACnet

"""

env_name = name.upper() + "_PATH"

if env_name in os.environ:

return os.path.join(os.environ[env_name], *suffixes)

return os.path.join(AbsParentDir(__file__, 2), name, *suffixes)

def Bpath(*names):

"""

Return path of files in Beremiz project

"""

return os.path.join(AbsParentDir(__file__, 1), *names)

beremiz