SQLite3

[Haspario]

Can this be used in pythonista to create a database with file access? I have only had success making a connection to memory if that makes sense!

[omz]

Yes, it should be possible to create SQLite database files with Pythonista. What does your code look like?

[Haspario]

I am new to python but have worked out where I was going wrong. I thought I needed to make a connection to a specific file path.

Here's my (very) basic database code, still only just getting my head around it!

<pre>
import sqlite3

conn = sqlite3.connect("mydatabase.db")

cursor = conn.cursor()

conn.execute("""DROP TABLE IF EXISTS alicelist""")

cursor.execute("""CREATE TABLE alicelist
(name text, character text, scenes text)
""")

alicelist = [('Kate Threlfall', 'Alice', '10'),
('Ailsa', 'Mother/White Queen', '5'),
('Chloe Harley', 'Sister/Red Queen','5'),
('Olivia Pewsey', 'Tweedle Dum', '4'),
('Anna Winstanley', 'Tweedle Dee', '4')]
cursor.executemany("INSERT INTO alicelist VALUES (?,?,?)", alicelist)
conn.commit()

print "\nHere's a listing of all the records in the table:\n"
for row in cursor.execute("SELECT rowid, * FROM alicelist ORDER BY character"):
print row

print cursor.fetchall()
</pre>

[Haspario]

P.s. Pythonista is a fantastic resource and really helping me get to grips with python. Many thanks