Database.py

import sqlite3
import calendar
import time

class Database: 
	_conn = None

	def __init__(self):
		self._conn = sqlite3.connect("url.db")
		cur = self._conn.cursor()
		cur.execute(''' CREATE TABLE IF NOT EXISTS urls (url TEXT PRIMARY KEY UNIQUE , crawlDate TEXT) ''')
		
	def __del__(self):
		self._conn.close();
	
	def addURL(self, url):
		record = (url, calendar.timegm(time.gmtime()))
		cur = self._conn.cursor()
		cur.execute(''' INSERT OR REPLACE INTO urls VALUES (?, ?)''', record)
		self._conn.commit()
		
db = Database()

db.addURL("http://google.com")