#!/usr/bin/python
# -*- coding: utf-8 -*-

import sqlite3 as lite
import sys

con = None
try:
    con = lite.connect('test.db')
    cur = con.cursor()
    #cur.execute('SELECT SQLITE_VERSION()')
    #data = cur.fetchone()
    #print "SQLite version: %s" % data                
    cur.execute("CREATE TABLE host(id INT PRIMARY KEY, ip TEXT, mac TEXT, type TEXT, hostname TEXT, vendor TEXT )")
    cur.execute("CREATE TABLE scan_check(id INT PRIMARY KEY, id_host INT, timestamp TEXT)")
except lite.Error, e:
    print "Error %s:" % e.args[0]
    sys.exit(1)

finally:
    if con:
        con.close()