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