Experimental Physics and
Industrial Control System

1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 <2016> 2017 2018 2019 2020 2021 2022 2023 2024	Index	1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 <2016> 2017 2018 2019 2020 2021 2022 2023 2024
<== Date ==>		<== Thread ==>

Subject:	Re: Question about "import MySQLdb" module problem in CSS python script
From:	"Kasemir, Kay" <[email protected]>
To:	lzf neu <[email protected]>
Cc:	"[email protected]" <[email protected]>
Date:	Sun, 18 Sep 2016 15:00:51 +0000

Hi:

CSS BOY scripts are executed in jython, not python.

Most of the default python modules are also available in jython, but when you install python modules with binary dependencies like numpy, MySQL_python, .. those are not available in jython.

In jython you can instead call all the Java modules included in CS-Studio, for example the RDBUtil which allows access to Oracle, Postgres, MySQL.

But you shouldn’t really do that in a BOY script, because it’ll execute on the UI thread. Database operations are too slow, they will cause your complete UI to freeze.

The display tool was meant to display PVs, not to perform database operations.

If you do enjoy writing python code that interacts with MySQL, just do that outside of the display tool, then add a pcaspy CA server to provide the results as PVs, and display those PVs in CSS BOY.

-Kay

On Sep 18, 2016, at 8:56 AM, lzf neu <[email protected]> wrote:

Hi all,

I want to import MySQLdb module in CSS to operate the mysql database.

In order to do this, I have looked up the CSS manual and add the MySQLdb module path ("/usr/lib64/python2.7/site-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg/") in the PYTHONPATH that obtained from sys.path;

The content of python script that I wrote only contain two lines:

from org.csstudio.opibuilder.scriptUtil import PVUtil
import MySQLdb

however, when running the python script in CSS, an error occured and print out the following message:

Traceback (most recent call last):

File "<script>", line 2, in <module>
File "/usr/lib64/python2.7/site-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg/MySQLdb/__init__.py", line 19, in <module>
File "/usr/lib64/python2.7/site-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg/_mysql.py", line 7, in <module>
File "/usr/lib64/python2.7/site-packages/MySQL_python-1.2.5-py2.7-linux-x86_64.egg/_mysql.py", line 6, in __bootstrap__
ImportError: No module named _mysql

If I import MySQLdb module directly in python terminal window and everything is OK and no error occurred !

Any help will be appreciated and thanks in advance !

Zhefu

Replies:: 答复: Question about "import MySQLdb" module problem in CSS python script lzf neu

References:: Question about "import MySQLdb" module problem in CSS python script lzf neu

Navigate by Date:: Prev: Re: Question about "import MySQLdb" module problem in CSS python script Matt Newville; Next: 答复: Question about "import MySQLdb" module problem in CSS python script lzf neu; Index: 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 <2016> 2017 2018 2019 2020 2021 2022 2023 2024
Navigate by Thread:: Prev: 答复: Question about "import MySQLdb" module problem in CSS python script lzf neu; Next: 答复: Question about "import MySQLdb" module problem in CSS python script lzf neu; Index: 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 <2016> 2017 2018 2019 2020 2021 2022 2023 2024

ANJ, 18 Sep 2016

· Home · News · About · Base · Modules · Extensions · Distributions · Download ·
· Search · EPICS V4 · IRMIS · Talk · Bugs · Documents · Links · Licensing ·

Experimental Physics and Industrial Control System

Experimental Physics and
Industrial Control System