Differences between revisions 2 and 3

Tom Boothby's sqlite-tutorial

How to create a simple database in sqlite using SAGE.

In SAGE, type

sage: import sqlite3

To create a filename for the database

conn = sqlite3.connect("/full/path/mydata.db")

This is a blank database at the moment. Now create a table with fields labeled/typed as follows:

connection.execute

This creates a sqlite3.cursor object. Now let's enter an entry into this database

E = EllipticCurve("389a")
connection.execute("...")

This is our new entry in the database mydata!

Suppose you entered something wrong and you want to delete an entry. You use the primary key to delete an entry:

To "query" all the elliptic curves of rank 2, type:

will return the first one (fetchall will return all).

-  ⇤ ← Revision 2 as of 2007-06-16 00:57:55 → 
  Size: 652
  Editor: DavidJoyner
  Comment:
+   ← Revision 3 as of 2007-06-16 01:00:53 → ⇥
  Size: 807
  Editor: DavidJoyner
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 13:
-This is a blank database at the moment
+{{{
conn = sqlite3.connect("/full/path/mydata.db")
}}}
-Line 15:
+Line 17:
+This is a blank database at the moment.
-Line 16:
+Line 19:
+{{{
connection.execute

}}}
-Line 19:
+Line 27:
-This is our new entry in the database tempdb.
+{{{
E = EllipticCurve("389a")
connection.execute("...")
}}}
This is our new entry in the database mydata!

Diff for "sqlite-tutorial"