How can you use SQL queries on pydroid app?

• # This code demonstrates a SQLite connection on Android.
  # You can use it in the Code Playground or another app like Pydroid3.
  
  import sqlite3
  conn = sqlite3.connect('pythonexample.db')
  # If running in Pydroid, the above will save to the Pydroid directory on your device
  # You could also specify a folder on your device if you have permission to save there. For example:
  # conn = sqlite3.connect('/storage/emulated/0/Download/pythonexample.db')
  # Change the above to whatever your download folder is on your device. You'll usually have permission to write there on Android.
  
  c = conn.cursor()
  
  # Create a table
  c.execute('''CREATE TABLE trainingclass
               (sitename text, classname text, classrating text, userscore real)''')
  
  # Insert a row of sample data
  c.execute("INSERT INTO trainingclass VALUES ('Sololearn','Python','5 Stars',70.12)")
  
  # Save the changes
  conn.commit()
  
  t = ('Python',)
  c.execute('SELECT * FROM trainingclass WHERE classname=?', t)
  print(c.fetchone())
  
  # Close the connection
  conn.close()
  
  # After running this code, I was able to open the database from a SQLite client on Android.
  

  After creating the database in Python, I was able to open it and view the data in a SQLite client on Android. https://code.sololearn.com/cj1rrKA7KgDw/?ref=app

Back to code snippet queries related python