def create_user(user):
user["type"] = "user"
user["name"] = user.get("name", "")
user["salt"] = "".join(
random.choice(string.ascii_uppercase + string.digits)
for x in range(10))
user["password"] = hashlib.sha1(user["password"] +
user["salt"]).hexdigest()
user["datetime"] = datetime.datetime.now().isoformat()
user["createtime"] = int(time.time())
new_id = nomagic._new_key()
while True:
new_user = nomagic._get_entity_by_id(new_id)
if not new_user:
break
else:
new_id = nomagic._new_key()
rowcount = nomagic._node(new_id).execute_rowcount(
"INSERT INTO entities (id, body) VALUES(%s, %s)", new_id,
nomagic._pack(user))
assert rowcount
#update indexes: email
# assert "@" in email
# rowcount = conn.execute_rowcount("INSERT INTO index_login (login, entity_id) VALUES(%s, %s)", email, new_id)
# assert rowcount
return (new_id, user)
def create_user(user):
email = user["email"]
assert not conn.get("SELECT * FROM index_login WHERE login = %s", email)
user["type"] = "user"
user["name"] = user.get("name", "")
user["salt"] = "".join(random.choice(string.ascii_uppercase + string.digits) for x in range(10))
if "password" in user:
user["password"] = hashlib.sha1(user["password"] + user["salt"]).hexdigest()
user["title"] = ""
user["department"] = ""
user["locatiion"] = ""
user["mobile"] = ""
user["tel"] = ""
user["about"] = ""
user["profile_img"] = ""
user["datetime"] = datetime.datetime.now().isoformat()
new_id = nomagic._new_key()
assert nomagic._node(new_id).execute_rowcount("INSERT INTO entities (id, body) VALUES(%s, %s)", new_id, nomagic._pack(user))
#update indexes: email
assert "@" in email
assert conn.execute_rowcount("INSERT INTO index_login (login, entity_id) VALUES(%s, %s)", email, new_id)
return (new_id, user)
def new_comment(user_id, entity_id, data):
entity = nomagic._get_entity_by_id(entity_id)
data["type"] = "comment"
data["likes"] = []
data["user_id"] = user_id
data["activity_id"] = entity_id
data["datetime"] = datetime.datetime.now().isoformat()
data["comment_ids"] = []
if entity["type"] == "comment":
data["activity_id"] = entity.get("activity_id")
else:
data["activity_id"] = entity_id
#content valid
assert data.get("content")
new_comment_id = nomagic._new_key()
assert nomagic._node(new_comment_id).execute_rowcount(
"INSERT INTO entities (id, body) VALUES(%s, %s)", new_comment_id,
nomagic._pack(data))
comment_ids = entity.get("comment_ids", [])
comment_ids.append(new_comment_id)
entity["comment_ids"] = comment_ids
nomagic._update_entity_by_id(entity_id, entity)
return comment_ids, dict(data,
id=new_comment_id,
like_count=0,
like=False,
user=nomagic._get_entity_by_id(user_id))
def new_status(user_id, data):
now = datetime.datetime.now()
data["type"] = "status"
data["user_id"] = user_id
data["datetime"] = now.isoformat()
data["likes"] = []
data["comment_ids"] = []
assert data.get("title")
new_id = nomagic._new_key()
assert nomagic._node(new_id).execute_rowcount(
"INSERT INTO entities (id, body) VALUES(%s, %s)", new_id,
nomagic._pack(data))
user = nomagic._get_entity_by_id(user_id)
activity = user.get("activity", [])
activity.append(new_id)
user["activity"] = activity
nomagic._update_entity_by_id(user_id, user)
data["user"] = user
data["like_count"] = 0
data["like"] = False
data["comment_count"] = 0
assert conn.execute_rowcount(
"INSERT INTO index_posts (user_id, entity_id) VALUES(%s, %s)", user_id,
new_id)
return new_id, data
def new_status(user_id, data):
now = datetime.datetime.now()
data["type"] = "status"
data["user_id"] = user_id
data["datetime"] = now.isoformat()
data["likes"] = []
data["comment_ids"] = []
assert data.get("title")
new_id = nomagic._new_key()
assert nomagic._node(new_id).execute_rowcount("INSERT INTO entities (id, body) VALUES(%s, %s)", new_id, nomagic._pack(data))
user = nomagic._get_entity_by_id(user_id)
activity = user.get("activity", [])
activity.append(new_id)
user["activity"] = activity
nomagic._update_entity_by_id(user_id, user)
data["user"] = user
data["like_count"] = 0
data["like"] = False
data["comment_count"] = 0
assert conn.execute_rowcount("INSERT INTO index_posts (user_id, entity_id) VALUES(%s, %s)", user_id, new_id)
return new_id, data
def create_user(user):
email = user["email"]
login = conn.get("SELECT * FROM index_login WHERE login = %s", email)
assert not login
user["type"] = "user"
user["name"] = user.get("name", "")
user["salt"] = "".join(random.choice(string.ascii_uppercase + string.digits) for x in range(10))
user["password"] = hashlib.sha1(user["password"] + user["salt"]).hexdigest()
user["title"] = ""
user["department"] = ""
user["locatiion"] = ""
user["mobile"] = ""
user["tel"] = ""
user["about"] = ""
user["profile_img"] = ""
user["datetime"] = datetime.datetime.now().isoformat()
new_id = nomagic._new_key()
rowcount = nomagic._node(new_id).execute_rowcount("INSERT INTO entities (id, body) VALUES(%s, %s)", new_id, nomagic._pack(user))
assert rowcount
#update indexes: email
assert "@" in email
rowcount = conn.execute_rowcount("INSERT INTO index_login (login, entity_id) VALUES(%s, %s)", email, new_id)
assert rowcount
return (new_id, user)
def new_comment(user_id, entity_id, data):
entity = nomagic._get_entity_by_id(entity_id)
data["type"] = "comment"
data["likes"] = []
data["user_id"] = user_id
data["activity_id"] = entity_id
data["datetime"] = datetime.datetime.now().isoformat()
data["comment_ids"] = []
if entity["type"] == "comment":
data["activity_id"] = entity.get("activity_id")
else:
data["activity_id"] = entity_id
#content valid
assert data.get("content")
new_comment_id = nomagic._new_key()
assert nomagic._node(new_comment_id).execute_rowcount("INSERT INTO entities (id, body) VALUES(%s, %s)", new_comment_id, nomagic._pack(data))
comment_ids = entity.get("comment_ids", [])
comment_ids.append(new_comment_id)
entity["comment_ids"] = comment_ids
nomagic._update_entity_by_id(entity_id, entity)
return comment_ids, dict(data, id=new_comment_id, like_count=0, like=False, user=nomagic._get_entity_by_id(user_id))
def create_user(user):
user["type"] = "user"
user["name"] = user.get("name", "")
user["password"] = ""
user["salt"] = ''.join(random.choice(string.ascii_uppercase + string.digits) for x in range(10))
user["title"] = ""
user["department"] = ""
user["locatiion"] = ""
user["mobile"] = ""
user["tel"] = ""
user["about"] = ""
user["profile_img"] = ""
user["datetime"] = datetime.datetime.now().isoformat()
new_id = nomagic._new_key()
assert ring[nomagic._number(new_id)].execute_rowcount("INSERT INTO entities (id, body) VALUES(%s, %s)", new_id, nomagic._pack(user))
#do we need a user_id index? currently no
#user_id = conn.execute("INSERT INTO index_user_id (entity_id) VALUES(%s)", new_id)
#update indexes: email
email = user["email"]
assert "@" in email
assert conn.execute_rowcount("INSERT INTO index_login (login, entity_id) VALUES(%s, %s)", email, new_id)
"""
email_host = email.split("@")[1]
organization_id, organization = nomagic.feeds.get_organization_by_email_host(email_host)
users = organization.get("users", [])
users.append(new_id)
organization["users"] = users
_update_entity_by_id(organization_id, organization)
"""
return (new_id, user)
def create_event(event):
order["type"] = "event"
order["owner"] = order.get("owner", "")
order["datetime"] = datetime.datetime.now().isoformat()
order["createtime"] = int(time.time())
new_id = nomagic._new_key()
while True:
new_order = nomagic._get_entity_by_id(new_id)
if not new_order:
break
else:
new_id = nomagic._new_key()
rowcount = nomagic._node(new_id).execute_rowcount(
"INSERT INTO entities (id, body) VALUES(%s, %s)", new_id,
nomagic._pack(order))
assert rowcount
return (new_id, order)
def create_comment(comment):
comment["type"] = "comment"
comment["owner"] = comment.get("owner", "")
comment["owner_type"] = comment.get("owner_type", "entity")
comment["datetime"] = datetime.datetime.now().isoformat()
comment["createtime"] = int(time.time())
new_id = nomagic._new_key()
while True:
new_comment = nomagic._get_entity_by_id(new_id)
if not new_comment:
break
else:
new_id = nomagic._new_key()
rowcount = nomagic._node(new_id).execute_rowcount(
"INSERT INTO entities (id, body) VALUES(%s, %s)", new_id,
nomagic._pack(comment))
assert rowcount
return (new_id, comment)
def create_chat(chat):
chat["type"] = "chat"
chat["owner"] = chat.get("owner", "")
chat["owner_type"] = chat.get("owner_type", "entity")
chat["editors"] = chat.get("editors", [])
chat["helpers"] = chat.get("helpers", {})
chat["comment_members"] = chat.get("comment_members", [])
chat["notifyers"] = chat.get("notifyers", [])
chat["blackers"] = chat.get("blackers", [])
chat["datetime"] = datetime.datetime.now().isoformat()
chat["createtime"] = int(time.time())
new_id = nomagic._new_key()
while True:
new_chat = nomagic._get_entity_by_id(new_id)
if not new_chat:
break
else:
new_id = nomagic._new_key()
rowcount = nomagic._node(new_id).execute_rowcount(
"INSERT INTO entities (id, body) VALUES(%s, %s)", new_id,
nomagic._pack(chat))
assert rowcount
return (new_id, chat)
def create_user(user):
user["type"] = "user"
user["name"] = user.get("name", "")
user["password"] = ""
user["salt"] = ''.join(
random.choice(string.ascii_uppercase + string.digits)
for x in range(10))
user["title"] = ""
user["department"] = ""
user["locatiion"] = ""
user["mobile"] = ""
user["tel"] = ""
user["about"] = ""
user["profile_img"] = ""
user["datetime"] = datetime.datetime.now().isoformat()
new_id = nomagic._new_key()
assert ring[nomagic._number(new_id)].execute_rowcount(
"INSERT INTO entities (id, body) VALUES(%s, %s)", new_id,
nomagic._pack(user))
#do we need a user_id index? currently no
#user_id = conn.execute("INSERT INTO index_user_id (entity_id) VALUES(%s)", new_id)
#update indexes: email
email = user["email"]
assert "@" in email
assert conn.execute_rowcount(
"INSERT INTO index_login (login, entity_id) VALUES(%s, %s)", email,
new_id)
"""
email_host = email.split("@")[1]
organization_id, organization = nomagic.feeds.get_organization_by_email_host(email_host)
users = organization.get("users", [])
users.append(new_id)
organization["users"] = users
_update_entity_by_id(organization_id, organization)
"""
return (new_id, user)
