Forum Archive

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!

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

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!

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()

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