<p>我对这件事已经束手无策了。在</p>
<p>所以我创建了一个脚本,从操作系统捕获数据,并将其插入字典中。下一步应该是将这些数据插入postgres数据库。但是,当执行for循环遍历数据时,我得到了以下错误。在</p>
<blockquote>
<p>/usr/bin/python2.7
/home/gmastrokostas/PycharmProjects/learning/Violent_Python.py
Traceback (most recent call last): File
"/home/gmastrokostas/PycharmProjects/learning/Violent_Python.py", line
52, in
for db_loop in eval(server_info): TypeError: eval() arg 1 must be a string or code object</p>
</blockquote>
<p>下面是postgres表脚本和python脚本。表的名称是SERVERS,列是“hostname”、“OS”、“RAM”、“CPU”。在</p>
<p><strong>创建表的SQL脚本-PostgreSQL 9.4</strong></p>
<pre><code>CREATE TABLE servers
(
hostname character varying(50),
"OS" character varying(25),
"RAM" numeric(4,2),
"CPU" character varying(50)
)
WITH (
OIDS=FALSE
);
ALTER TABLE servers
OWNER TO dbuser;
</code></pre>
<p><strong>PYTHON脚本</strong></p>
^{pr2}$