def verify_node(node, nickname, cur):
nrec = db.query(
'select node_id, nickname, latest from nodes where node_id=?',
(node, ),
one=True)
if nrec == None:
db.insert(
'insert into nodes (node_id, nickname, latest) values (?, ?, ?)',
(node, nickname, cur))
else:
db.do('update nodes set latest=? where node_id=?', (cur, node))
return 1
def verify_session(node, ip, port, connectable=1):
srec = db.query('select session_id, ip, port from session where node_id=?',
(node, ),
one=True)
if srec != None:
if srec['ip'] != ip or srec['port'] != port:
db.do('delete from session where session_id=?',
(srec['session_id'], ))
srec = None
else:
return srec['session_id']
session = db.insert(
'insert into session (node_id, ip, port, connectable, started) values (?, ?, ?, ?, CURRENT_TIMESTAMP)',
(node, ip, port, connectable))
return session
def rename_user(userid, handle):
db.do('update user set user_handle=? where user_id=?', (handle, userid))
def update_swarm(node, ip, port):
db.do('delete from swarm where ip=? and port=?', (ip, port))
db.insert(
'insert into swarm (ip, port, node_id, last_contact) values (?, ?, ?, CURRENT_TIMESTAMP)',
(ip, port, node))
def update_session(sessid, their_session):
db.do('update session set their_session=? where session_id=?',
(their_session, sessid))
def set_nickname(nickname):
db.do('update user set user_handle=? where user_id=1', (nickname, ))
return