操作系统版本:
[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