old_contents: #!/usr/bin/env python
  
  try:
  	import sqlite3
  except ImportError as e:
  	raise ImportError('Error importing %s' % e)
  
  class Database():
  	def __init__(self):
  		
  		#vars
  		self.autOsintDB = 'AutOSINT.db'
  
  	def createdatabase(self):
  
  		# Database Connection
  
  		try:
  			connection = sqlite3.connect(self.autOsintDB)
  			c = connection.cursor()
  
  			#Create table
  			c.execute('''CREATE TABLE client(
  				ID INTEGER PRIMARY KEY,
  				name text, 
  				contact text, 
  				Timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
  				UNIQUE(name))''')
  
  
  			c.execute('''CREATE TABLE domains(
  				ID INTEGER PRIMARY KEY, 
  				name text, 
  				client_id integer, 
  				FOREIGN KEY(client_id) REFERENCES client(ID))''')
  
  			c.execute('''CREATE TABLE whois(
  				ID INTEGER PRIMARY KEY,
  				contact text,
  				client_id integer,
  				FOREIGN KEY(client_id) REFERENCES client(ID)''')
  
  
  
  			# Commit and close connection to database
  			connection.commit()
  			connection.close()
  
  		except sqlite3.Error as e:
  			print(" [-] Database Error: %s" % e.args[0])
  
  def main():
  	createDb = Database()
  	createDb.createdatabase()
  
  
  if __name__ == '__main__':
  	main()
  
new_contents: #!/usr/bin/env python
  
  try:
  	import sqlite3
  except ImportError as e:
  	raise ImportError('Error importing %s' % e)
  
  class Database():
  	def __init__(self):
  		
  		#vars
  		self.autOsintDB = 'AutOSINT.db'
  
  	def createdatabase(self):
  
  		# Database Connection
  
  		try:
  			connection = sqlite3.connect(self.autOsintDB)
  			c = connection.cursor()
  
  			#Create table
  			c.execute('''CREATE TABLE client(
  				ID INTEGER PRIMARY KEY,
  				name text, 
  				domain text, 
  				Timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,
  				UNIQUE(name))''')
  
  			c.execute('''CREATE TABLE whois(
  				ID INTEGER PRIMARY KEY,
  				contact text,
  				client_id integer,
  				FOREIGN KEY(client_id) REFERENCES client(ID)''')
  
  
  
  			# Commit and close connection to database
  			connection.commit()
  			connection.close()
  
  		except sqlite3.Error as e:
  			print(" [-] Database Error: %s" % e.args[0])
  
  def main():
  	createDb = Database()
  	createDb.createdatabase()
  
  
  if __name__ == '__main__':
  	main()
  
subject: add db setup scritp