linux下安装dmpython

操作系统版本：

[root@dca dmPython.egg-info]# cat /etc/redhat-release

CentOS Linux release 7.6.1810 (Core)

数据库版本：

SQL> select * from v$version;

LINEID BANNER

---

1 DM Database Server 64 V8

2 DB Version: 0x7000c

python版本

[root@dca dmPython.egg-info]# python -V

Python 2.7.5

添加环境变量

[root@dca ~]# vi .bash_profile

export LD_LIBRARY_PATH=“$LD_LIBRARY_PATH:/dm/dmdbms/bin”

export DM_HOME=“/dm/dmdbms”

安装dmPython

数据库安装好后，dmPython包位于/dm/dmdbms/drivers/python/dmPython

[root@dca ~]# cd /dm/dmdbms/drivers/python/dmPython/

[root@dca dmPython]# python setup.py install

连接数据库

[root@dca ~]# python

Python 2.7.5 (default, Nov 16 2020, 22:23:17)

[GCC 4.8.5 20150623 (Red Hat 4.8.5-44)] on linux2

Type “help”, “copyright”, “credits” or “license” for more information.

import dmPython

open fail! path:./libcrypto.so

–连接数据库

conn=dmPython.connect(user=‘SYSDBA’,password=‘123456789’,server= ‘LOCALHOST’,port=5236)

–建立游标

cursor = conn.cursor()

–查询

cursor.execute(‘select * from u1’)

<builtin.DmdbCursor on <dmPython.Connection to SYSDBA@LOCALHOST:5236>>

values = cursor.fetchall()

values

[(11L, datetime.date(1991, 9, 5), ‘cccc’)]

–关闭游标

cursor.close()

–关闭查询

conn.close()

https://eco.dameng.com