python 两个数据库postgresql对比
11 浏览量
2021-01-20
06:38:39
上传
评论
收藏 34KB PDF 举报
python 两个数据库两个数据库postgresql对比对比
这篇文章主要介绍了python 两个数据库postgresql对比,文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定
的参考学习价值,需要的朋友可以参考下
比较两个postgresql数据库，原理 比较数据库中各表的大小
1. 数据库查询语句
2. python字典比较
import psycopg2
import sys
class PdbModel:
def __init__(self, host, dbname, username='postgres', password='postgres', port='5432'):
self.host = host
self.dbname = dbname
self.username = username
self.password = password
self.port = port
self.conn = None
self.cursor = None
self.init_db()
def init_db(self):
try:
self.conn = psycopg2.connect(database=self.dbname, user=self.username, password=self.password,
host=self.host,
port="5432")
self.cursor = self.conn.cursor()
except Exception, e:
error_out_print("Error: connection to db %s : %s failed. check need" % (self.host, self.dbname))
print e
sys.exit(-1)
def execute_sql(self, sql, is_exist=True):
"""
execute sql and return rows
:param sql:
:return:
results of execute sql
"""
try:
standout_print('command sql : %s' % sql)
self.cursor.execute(sql)
rows = self.cursor.fetchall()
return rows
except Exception, e:
self.conn.rollback()
error_out_print("Failed: failed execute sql [%s]" % sql)
error_out_print(e)
if is_exist:
self.close()
sys.exit(-1)
else:
return None
def get_tables_size(self):
"""
select table_schema || '.' || table_name as table_full_name ,
pg_size_pretty(pg_total_relation_size('"'||table_schema||'"."'||table_name||'"')) as size
from information_schema.tables
order by pg_total_relation_size('"'||table_schema||'"."'||table_name||'"') DESC
:return:
资源评论
