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 new_comment(parent, subject, message, user=1, sub_node='', sub_msg=0):
if user == None:
user = 1
row = db.insert(
'insert into message (user_id, parent, subject, message, node_src, node_src_msg_id, create_date) values (?, ?, ?, ?, ?, ?, CURRENT_TIMESTAMP)',
(user, parent, subject, message, sub_node, sub_msg))
#socketio.emit('feed', get_message(row), room='feed', json=True)
return row
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 make_subscription(node, message):
curver = get_curver()
return db.insert(
'insert into subscriber (node_id, message_id, subscribed_at) values (?, ?, ?)',
(node, message, curver))
def add_remote_user(node, their_user_id, handle):
return db.insert(
'insert into user (node_id, ext_user_id, user_handle, create_date) values (?, ?, ?, CURRENT_TIMESTAMP)',
(node, their_user_id, handle))
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))