我想将详细信息(用户名、文件名、十六进制格式)存储到远程服务器sqlite中
使用python的数据库。#!/usr/bin/python
import socket
import urllib
import urllib2
import paramiko
import sqlite3
username = "e100075"
filename = "screenshot.png"
Hex_format = "FSGDSFDSSFGRSSCD"
ssh = paramiko.SSHClient()
ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
ssh.connect('hostname', username="username", password="password")
print "Connect to server...."
try:
db = sqlite3.connect('screenshoter.db')
cursor = db.cursor()
cursor.execute('''CREATE TABLE IF NOT EXISTS users(id INTEGER PRIMARY KEY, userid TEXT, activity_id TEXT, date_time TEXT, screenshot_filename TEXT, screenshot_md5 TEXT,
num_clicks INT, num_of_mouse_movements INT, num_pause