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!
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)
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"):
P.s. Pythonista is a fantastic resource and really helping me get to grips with python. Many thanks