#!/usr/bin/python2.5
"""
Copyright (C) 2008 Norman Messtorff <normes@normes.org>

This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2
of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
"""

import time,  os
from Database import Database

class Compare(Database):
	"""Comparing two databases"""
	def __init__(self, localdb, remotedb):
		Database.__init__(self, localdb)
		if not os.path.exists(localdb):
			self.debug(1, "Database '" +localdb+ "' not existing")
		if not os.path.exists(remotedb):
			self.debug(1, "Database '" +remotedb+ "' not existing")
		self.localdb = localdb
		self.remotedb = remotedb
		self.debug(4, "Class Compare initialized")
	
	def run(self):
		"""Comparing two databases and print all different rows"""
		self.sql_listcompare()
		for item in self.sql_fetchall():
			print str(item)
		localdb.sql_close()
		remotedb.sql_close()