ejemplo de código sqlite en python

Ejemplo 1: instalar sqlite3 python

pip install pysqlite3

Ejemplo 2: cómo instalar sqlite3 en python

pip install sqlite

Ejemplo 3: cómo instalar sqlite3 en python

if you are using python3, sqlite3 is built in into it.

Ejemplo 4: python sqlite3

import sqlite3 as lite 
import sys 
 
try: 
    con = lite.connect('products.db') 
    cur = con.cursor()     
    cur.execute("CREATE TABLE drinks(Id INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT, Price REAL)") 
    cur.execute("CREATE TABLE fruits(Id INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT, Price REAL)") 
    con.commit() 
             
except e: 
    if con: 
        con.rollback() 
     
    print("Unexpected error %s:" % e.args[0]) 
    sys.exit(1) 
finally: 
    if con: 
        con.close()

Ejemplo 5: conexión sqlite python

import sqlite3

try:
    sqliteConnection = sqlite3.connect('SQLite_Python.db')
    cursor = sqliteConnection.cursor()
    print("Database created and Successfully Connected to SQLite")

    sqlite_select_Query = "select sqlite_version();"
    cursor.execute(sqlite_select_Query)
    record = cursor.fetchall()
    print("SQLite Database Version is: ", record)
    cursor.close()

except sqlite3.Error as error:
    print("Error while connecting to sqlite", error)
finally:
    if (sqliteConnection):
        sqliteConnection.close()
        print("The SQLite connection is closed")

Ejemplo 6: cómo instalar sqlite3 en python

$chmod +x sqlite.py
$./sqlite.py
Open database successfully

---

---

Utiliza Nuestro Buscador