Etiqueta: sqlite

macos / skype / sqlite

Acesso Skype sqlite MacOS

sqlite3 “/Users/{#os_user}/Library/Application Support/Skype/{#skype_user}/main.db” histórico de mensagens consulta sql select conversations.id as “chat_id”, conversations.displayname as “chater”, messages.from_dispname as “authoe”, strftime(‘%d.%m.%Y %H:%M:%S’,messages.timestamp, ‘unixepoch’, ‘localtime’) as “created_at”, messages.body_xml as “message_body” from conversations inner …

Continuar lendo
python / sqlite

Use SQLite com Python

con= sqlite3.connect(“sql3.db”)#se non esiste lo creacursore=con.cursor()cursore.execute(“create table language (name text, mark integer )”)con.commit()cursore.execute(“insert into language values (?,?)”,[“python”,10])cursore.execute(“insert into language values (?,?)”,[“perl”,3])con.commit()cursore.execute(“select * from language”)for row in cursore: print (row)

Continuar lendo