Skip to content

Instantly share code, notes, and snippets.

@astro-gokart

astro-gokart/schema

Created April 12, 2015 04:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save astro-gokart/64e2c48b16d33f13fbbc to your computer and use it in GitHub Desktop.
Save astro-gokart/64e2c48b16d33f13fbbc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
schema
import sqlite3
db = sqlite3.connect('agralert.db')
db.execute("CREATE TABLE agr (id INTEGER PRIMARY KEY, lat REAL, long REAL, title TEXT)")
db.execute("INSERT INTO agr (lat,long,title) VALUES (45.4,50.23, 'CHEESE')")
db.commit()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment