document_workflow

# Save incoming data.
user = User();
user.id = <id>
user.first_name = <firstName>
user.last_name = <lastName>
db.users.save(user)

# Output API data - get a list of users.
output = User.find({}, { limit: 15 })

# Add a field to the table and save incoming data
user = User();
user.id = <id>
user.first_name = <firstName>
user.last_name = <lastName>
user.email = <email>
db.users.save(user)

# Output API data - get a list of users.
output = User.find({}, { limit: 15 })

sql_workflow

# Create the SQL schema.
CREATE TABLE users (id int, first_name varchar(255), last_name varchar(255))

# Save incoming data
INSERT INTO users SET first_name = <firstName>, last_name = <lastName>

# Output API data.
results = SELECT first_name, last_name FROM users LIMIT 15

users = array()
for (cursor : results) {
  user = User();
  user.id = cursor.id
  user.first_name = cursor.first_name
  user.last_name = cursor.last_name
  users.push(user)
}

output = json_encoder(users)

# Add a field to the table.
ALTER TABLE users ADD email VARCHAR(255);

# Save incoming data
INSERT INTO users SET first_name = <firstName>, last_name = <lastName>, email = <email>

# Output API data.
results = SELECT first_name, last_name, email FROM users LIMIT 15

users = array()
for (cursor : results) {
  user = User();
  user.id = cursor.id
  user.first_name = cursor.first_name
  user.last_name = cursor.last_name
  user.email = cursor.email
  users.push(user)
}

output = json_encoder(users)