Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import sqlite3 # modulo de conexion con sqlite3
- class Product:
- #conexion con la base de datos
- db_lab = 'vitasis.db'
- #contenedor 2 ORDEN DE SERVICIO
- frame2 = LabelFrame(self.wind, text = 'Orden de servicio', labelanchor = N, font = ('Verdana', 16, 'bold'))
- frame2.grid(row = 1, column = 1, padx = 5, pady = 20, ipadx = 30, sticky = W)
- frame2.configure(background = 'gray')
- Label(frame2, text = 'Número de Orden', bg = 'gray').grid(row = 1, column = 1, pady = 3, sticky = W + E)
- self.message1 = Label(frame2, text = '', fg = 'red', font = ('Verdana', 18), bg = 'gray')
- self.message1.grid(row = 2, column = 1, pady = 3, sticky = W + E)
- self.folio = 6 # quiero quitar este valor predefinido y usar el valor que tiene la ultima fila de mi base de datos e incrementarlo en una unidad para indicar que es una nueva orden de servicio.
- self.message1['text'] = '{}'.format(self.folio)
- # Ejecutar consulta
- def run_query(self, query, parameters = ()):
- with sqlite3.connect(self.db_lab) as conn:
- cursor = conn.cursor()
- result = cursor.execute(query, parameters)
- conn.commit()
- return result
- # Consulta de datos
- query = 'SELECT * FROM paciente ORDER BY folio DESC'
- db_rows = self.run_query(query)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement