Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import sqlite3
- class SQLite:
- def __init__(self):
- """ Constructor """
- self.__nuevaConn()
- def __nuevaConn(self):
- try:
- self.conn = sqlite3.connect('bd/bdPlayer.db')
- self.cursor = self.conn.cursor()
- except sqlite3.Error, e:
- print "Error al abrir BD:", e.args[0]
- print "Terminando Aplicacion"
- quit()
- def setLista(self, nombre):
- return self.__NuevaLista(nombre)
- def __NuevaLista(self, nombre):
- n =(str(nombre), )
- try:
- self.__nuevaConn()
- self.cursor.execute('INSERT INTO listas (lis_nombre) VALUES(?)', n)
- self.conn.commit()
- self.cursor.close()
- return 1
- except sqlite3.Error, e:
- print "Error al guardar Lista:", e.args[0], n
- return 0
- self.conn.close()
- def getListas(self):
- return self.__Listas()
- def __Listas(self):
- listas = []
- try:
- self.__nuevaConn()
- self.cursor.execute('SELECT * FROM listas')
- for row in self.cursor.fetchall():
- listmp = [row[0], row[1]]
- listas.append(listmp)
- self.cursor.close()
- return listas
- except sqlite3.Error, e:
- print "Error al leer listas:", e.args[0]
- return 0
- self.conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement