|
Size: 652
Comment:
|
Size: 807
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 13: | 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! |
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).