Ubuntu on Run Python connection PG, error Importerror:no module named PSYCOPG2

Ubuntu on Run Python connection PG, error Importerror:no module named PSYCOPG2


root@pgproxy1:~# python/home/zxw/pgwritertest_m.py
Traceback (most recent call last):
File "/home/zxw/pgwritertest_m.py", line 4, in <module>
Import PSYCOPG2
Importerror:no module named PSYCOPG2


Install as follows:
1
root@pgproxy1:~# Apt-cache Search PSYCOPG2
Python-psycopg2-python Module for PostgreSQL
Python-psycopg2-dbg-python Module for PostgreSQL (debug extension)
Python-psycopg2-doc-python Module for PostgreSQL (documentation package)
Python3-psycopg2-python 3 Module for PostgreSQL
Python3-psycopg2-dbg-python 3 Module for PostgreSQL (debug extension)


2
root@pgproxy1:~# python-v
Python 2.7.3


3
root@pgproxy1:~# apt-get install-y python-psycopg2 python-psycopg2-doc python-psycopg2-dbg
Reading Package Lists ... Done
Building Dependency Tree
Reading state information ... Done
...
Processing triggers for libc-bin ...
Ldconfig deferred processing now taking place
root@pgproxy1:~#


4
The script is as follows:
#--encoding:utf-8--
Import time
Import threading
Import PSYCOPG2
Import Queue
Import datetime

This interface can refer to its official website:

http://initd.org/psycopg/


Class Pgwritertest (threading. Thread):
"" Initialize "" "" "
def __init__ (SELF,CONNSTR):
Self.conn = Psycopg2.connect (CONNSTR)
Self.cursor = Self.conn.cursor ()

Self.dbnum = 4
Self.connarray = []
Self.cursorarray = []


For I in Range (0,self.dbnum):
#DB Port
Dbidstr = '%02d '% (9900 + i)
if (i = = 0 or i = = 2):
Dstdb = ' host=ip1 user=dbusername password=pwd dbname=dbname port= ' + dbidstr
Else
Dstdb = ' host=ip2 user=dbusername password=pwd dbname=dbname port= ' + dbidstr
print ' Connect ' + dstdb

Dstconn = Psycopg2.connect (DSTDB)
Self.connArray.append (Dstconn)
Dstcursor = Dstconn.cursor ()
Self.cursorArray.append (Dstcursor)

# Run the constructor of the parent class
Threading. Thread.__init__ (self)


"" Write Data to Database "" "" ""
def read (self,t_id):
sql = ' SELECT * from Get_cont (' +str (t_id) + ') '
Self.cursor.execute (SQL)
DataList = []
For row in Self.cursor.fetchall ():
Datalist.append (Row)
return DataList

"" Write Data to Database "" "" ""
def save (Self,t_id,data):
sql = ' SELECT write_cont (%s,character (255)%s,%d,now ():: timestamp)) '
params = []
Params.append (t_id)
Params.append (Data[1])
Params.append (Data[2])
Params.append (Data[3])


#print params
#取db_ins_id
db_ins_id = 0
db_ins_id = t_id% self.dbnum
Try
Print str (Datetime.datetime.now ()) + "DB" + str (db_ins_id) + "" + str (t_id) + "before insert"
Insert_sql = ' SELECT write_cont (%s,character (255)%s,%d,now ():: timestamp)) '
Self.cursorarray[db_ins_id].execute (Insert_sql,params)
Self.cursorarray[db_ins_id].execute ("COMMIT")
Print str (Datetime.datetime.now ()) + "DB" + str (db_ins_id) + "" + str (t_id) + "inserted"
Return True


Except Exception,ex:
Print ("Save error:%s"% str (ex))
Print ("Save t_id:%s\t"% str (t_id))
Print ("Error cont:%s"% str (params))
#self. Log.write ("error param:%s"% str (params))
#self. Log.write ("error t_id:%s"% data.get (' t_id ', '))
Self.cursorarray[db_ins_id].execute ("ROLLBACK")
Return False



#测试读取
"""
Try
Searchsql = ' Select t_id from Get_cont (' + str (t_id) + ') '
Self.cursorarray[db_ins_id].execute (Searchsql)
data = Self.cursorarray[db_ins_id].fetchone ()
if (data = = None or int (data[0))!= t_id):
print ' Insert error for ' +str (db_ins_id) + Searchsql
Except Exception,searchex:
Print str (searchex) + ' for ' + searchsql
"""
Return True
if __name__ = = "__main__":
Pgtest = Pgwritertest (' host=ip user=dbuser password=pwd dbname=dbname ')
start_time = str (Datetime.datetime.now ())
For I in Range (1,10):
t_id = 1000 + i;
Print str (Datetime.datetime.now ()) + "getting"
rows = Pgtest.read (t_id)

Print str (Datetime.datetime.now ()) + "gotten"
#print Rows[0]
Pgtest.save (T_id,rows[0])
Print Start_time

Print str (Datetime.datetime.now ())

-----------------
Reprint please the Source:
Blog.csdn.net/beiigang