123456789101112131415161718192021 |
- #!/usr/bin/python
- # -*- coding: utf-8 -*-
- import sqlite3 as lite
- import sys
- import os
- from sh import du
- from PIL import Image
- #CREATE TABLE
- con = lite.connect('fossil.db')
- with con:
- cur = con.cursor()
- cur.execute("CREATE TABLE Fossil(Id INT, Name TEXT, Description TEXT, Size INT, Left INT, Top INT, Front INT)")
- #cur.execute("INSERT INTO Cars VALUES(1,'Audi',52642)")
- #cur.execute("INSERT INTO Cars VALUES(2,'Mercedes',57127)")
- #cur.execute("INSERT INTO Cars VALUES(3,'Skoda',9000)")
- #cur.execute("INSERT INTO Cars VALUES(4,'Volvo',29000)")
- #cur.execute("INSERT INTO Cars VALUES(5,'Bentley',350000)")
- #cur.execute("INSERT INTO Cars VALUES(6,'Citroen',21000)")
- #cur.execute("INSERT INTO Cars VALUES(7,'Hummer',41400)")
- #cur.execute("INSERT INTO Cars VALUES(8,'Volkswagen',21600)")
|