def login(params, auth, cb):
response = db.get_one('demo_users').where(
COND("username", "==", params["username"])).apply()
if response.status == 200:
res = response.result
if res["username"] == params["username"] and res["password"] == params[
"password"]:
cb(
'response', {
'ack':
True,
'token':
jwt.encode(
{
"username": res["username"],
"password": res["password"]
},
SECRET,
algorithm='HS256').decode('utf-8')
})
else:
cb('response', {'ack': False})
else:
print(response.error)
cb('response', {'ack': False})
def func(op_sel, i):
if op_sel == 0:
return db.insert('books').doc({
variables.id: i,
"name": "MyBook" + str(i),
"author": "Author" + str(i)
}).apply()
elif op_sel == 1:
return db.update('books').set({
"author": "myself" + str(i)
}).where(COND(variables.id, "==", i)).apply()
elif op_sel == 2:
return db.delete_one('books').where(COND(variables.id, "==",
i)).apply()
else:
return db.get('books').apply()
from space_api import API, COND
api = API('books-app', 'localhost:4124')
db = api.my_sql()
b = db.begin_batch()
b.add(db.insert('books').doc({"name": "MyBook", "author": "John Doe"}))
b.add(db.insert('books').doc({"name": "Book_name", "author": "John Doe"}))
b.add(db.insert('books').docs([{"name": "BookName"}, {"name": "BookName"}]))
b.add(db.delete('books').where(COND('name', '==', 'Book_name')))
response = b.apply()
print(response)
# UPDATE
from space_api import API, AND, OR, COND
api = API("books-app", "localhost:4124")
db = api.my_sql()
# The condition to be matched
condition = COND("author", "==", "author1")
# Update the books
response = db.update("books").where(condition).set({"name": "A book"}).apply()
if response.status == 200:
print("Success")
else:
print(response.error)
# ----------------------------------------------------------------------------------------------------
# UPDATE ONE
from space_api import API, AND, OR, COND
api = API("books-app", "localhost:4124")
db = api.my_sql()
# The condition to be matched
condition = COND("author", "==", "author1")
# Update the books
response = db.update_one("books").where(condition).set({"name": "A book"}).apply()
if response.status == 200:
print("Success")
print("limit one")
print(db.get_one('books').limit(2).apply())
print("skip all")
print(db.get('books').skip(2).apply())
print("skip one")
print(db.get_one('books').skip(2).apply())
print("sort all")
print(db.get('books').sort('-author').apply())
print("sort one")
print(db.get_one('books').sort('author').apply())
print("select all")
print(db.get('books').select({'author': 1}).apply())
print("select one")
print(db.get_one('books').select({'author': 1}).apply())
print("where all")
print(db.get('books').where(COND("name", "==", "Book_name")).apply())
print("where one")
print(db.get_one('books').where(COND("name", "==", "BookName")).apply())
print("distinct")
print(db.distinct("books").key("author").apply())
print("count")
print(db.count("books").apply())
print("count where")
print(db.count("books").where(COND("author", "==", "Jon Doe")).apply())
# update
print("set")
print(db.update('books').set({"author": "myself"}).apply())
print("set where")
print(
db.update('books').where(COND("author", "==", "some_author")).set({
db.insert('books').doc({
"id": 1,
"name": "MyBook" + str(1),
"author": "Author" + str(1)
}).apply())
i = initial
while True:
print(
"Insert",
db.insert('books').doc({
"id": i,
"name": "MyBook" + str(i),
"author": "Author" + str(i)
}).apply())
print(db.get('books').apply().result)
time.sleep(2)
print(
"Update",
db.update('books').set({
"author": "myself" + str(i)
}).where(COND("id", "==", i)).apply())
print(db.get('books').apply().result)
time.sleep(2)
print("Delete", db.delete_one('books').where(COND("id", "==", i)).apply())
print(db.get('books').apply().result)
time.sleep(4)
i += 1
api.close()
# READ
from space_api import API, AND, OR, COND
# Initialize api with the project name and url of the space cloud
api = API("books-app", "localhost:4124")
# Initialize database(s) you intend to use
db = api.my_sql()
# The condition to be matched
condition = COND("id", "==", "1")
# Get the books
response = db.get("books").where(condition).apply()
if response.status == 200:
print(response.result)
else:
print(response.error)
# ----------------------------------------------------------------------------------------------------
# READ ONE
from space_api import API, AND, OR, COND
# Initialize api with the project name and url of the space cloud
api = API("books-app", "localhost:4124")
# Initialize database(s) you intend to use
db = api.my_sql()
# The condition to be matched
condition = COND("author", "==", "SomeAuthor")
# DELETE
from space_api import API, COND
# Initialize api with the project name and url of the space cloud
api = API("books-app", "localhost:4124")
# Initialize database(s) you intend to use
db = api.my_sql()
# The condition to be matched
condition = COND("name", "==", "SomeAwesomeBook")
# Delete all books which match a particular condition
response = db.delete("books").where(condition).apply()
if response.status == 200:
print("Success")
else:
print(response.error)
# ----------------------------------------------------------------------------------------------------
# DELETE ONE
from space_api import API, COND
# Initialize api with the project name and url of the space cloud
api = API("books-app", "localhost:4124")
# Initialize database(s) you intend to use
db = api.my_sql()
# The condition to be matched
condition = COND("name", "==", "SomeAwesomeBook")
from space_api.utils import generate_find
from space_api import AND, COND, OR
condition = AND(COND('a', '>=', 1), COND('a', '<=', 10))
print(generate_find(condition))