faunadb_orm
Advanced tools
npm install fauna_orm
yarn add fauna_orm
const faunaORM = require('fauna_orm ');
let orm = new faunaORM(schema, 'secret');
let NewSchema = {
Customer: {
fields: {
email: {
indexes: {
find: 'findByemail',
},
},
age: {
indexes: {
find: 'findByage',
range: 'rangeByage',
rangeAll: 'rangeByageAll',
},
},
gender: {
indexes: {
find: 'findBygender',
},
},
eyeColor: {
indexes: {
find: 'findByeyeColor',
},
},
isActive: {
indexes: {
find: 'findByisActive',
},
},
},
relations: {
addresses: {
collection: 'Address',
at: 'AddressToCustomer',
index: 'AddressRefByCustomerRef',
},
orders: {
collection: 'Order',
at: 'CustomerToOrder',
index: 'OrderRefByCustomerRef',
},
},
views: {},
},
AddressToCustomer: {
fields: {
fromRef: {
collection: 'Address',
indexes: {
find: 'AddressToCustomerRefByAddressRef',
relation: 'AddressRefByCustomerRef',
},
},
toRef: {
collection: 'Customer',
indexes: {
find: 'AddressToCustomerRefByCustomerRef',
relation: 'CustomerRefByAddressRef',
},
},
},
},
Address: {
fields: {
state: {
indexes: {
find: 'findByState',
},
},
country: {
indexes: {
find: 'findByCountry',
},
},
},
relations: {
customer: {
collection: 'Customer',
at: 'AddressToCustomer',
index: 'CustomerRefByAddressRef',
},
},
views: {},
},
CustomerToOrder: {
fields: {
fromRef: {
collection: 'Customer',
indexes: {
find: 'CustomerToOrderRefByCustomerRef',
relation: 'CustomerRefByOrderRef',
},
},
toRef: {
collection: 'Order',
indexes: {
find: 'CustomerToOrderRefByOrderRef',
relation: 'OrderRefByCustomerRef',
},
},
},
},
Order: {
fields: {
orderNumber: {
indexes: {
find: 'findByorderNumber',
range: null,
rangeAll: null,
},
},
orderDate: {
indexes: {
find: 'findByorderDate',
range: 'rangeByorderDate',
rangeAll: 'rangeByorderDateAll',
},
},
},
relations: {
customer: {
collection: 'Customer',
at: 'CustomerToOrder',
index: 'CustomerRefByOrderRef',
},
orderitems: {
collection: 'OrderItem',
at: 'OrderToOrderItem',
index: 'OrderItemRefByOrderRef',
},
},
views: {},
},
OrderToOrderItem: {
fields: {
fromRef: {
collection: 'Order',
indexes: {
find: 'OrderToOrderItemRefByOrderRef',
relation: 'OrderRefByOrderItemRef',
},
},
toRef: {
collection: 'OrderItem',
indexes: {
find: 'OrderToOrderItemRefByOrderItemRef',
relation: 'OrderItemRefByOrderRef',
},
},
},
},
OrderItem: {
fields: {
unitPrice: {
indexes: {
find: 'findByunitPrice',
range: 'rangeByunitPrice',
rangeAll: 'rangeByunitPriceAll',
},
},
quantity: {
indexes: {
find: 'findByquantity',
range: 'rangeByquantity',
rangeAll: 'rangeByquantityAll',
},
},
},
relations: {
order: {
collection: 'Order',
at: 'OrderToOrderItem',
index: 'OrderRefByOrderItemRef',
},
product: {
collection: 'Product',
at: 'OrderItemToProduct',
index: 'ProductRefByOrderItemRef',
},
},
views: {},
},
OrderItemToProduct: {
fields: {
fromRef: {
collection: 'OrderItem',
indexes: {
find: 'OrderItemToProductRefByOrderItemRef',
relation: 'OrderItemRefByProductRef',
},
},
toRef: {
collection: 'Product',
indexes: {
find: 'OrderItemToProductRefByProductRef',
relation: 'ProductRefByOrderItemRef',
},
},
},
},
Product: {
fields: {
unitPrice: {
indexes: {
find: 'findByProductunitPrice',
range: 'rangeByProductunitPrice',
rangeAll: 'rangeByProductunitPriceAll',
},
},
productName: {
indexes: {
find: 'findByproductName',
range: null,
rangeAll: null,
},
},
},
relations: {
orderitems: {
collection: 'OrderItem',
at: 'OrderItemToProduct',
index: 'OrderItemRefByProductRef',
},
supplier: {
collection: 'Supplier',
at: 'ProductToSupplier',
index: 'SupplierRefByProductRef',
},
},
views: {},
},
ProductToSupplier: {
fields: {
fromRef: {
collection: 'Supplier',
indexes: {
find: 'ProductToSupplierRefBySupplierRef',
relation: 'SupplierRefByProductRef',
},
},
toRef: {
collection: 'Product',
indexes: {
find: 'ProductToSupplierRefByProductRef',
relation: 'ProductRefBySupplierRef',
},
},
},
},
Supplier: {
fields: {},
relations: {
products: {
collection: 'Product',
at: 'ProductToSupplier',
index: 'ProductRefBySupplierRef',
},
},
views: {},
},
}
let query = orm.transform();
//Simple equal satement single parameter, return ref
let filter = {
email: "grayburt@exosis.com",
gender {
$eq: "female"
},
isActive: {
$ne: true
},
date: {
$range: [3245235234, 34532452345]
}
country: {
$nin: ['Mexico', "Canada", "England"]
},
$and: [{
age: {
$lte: 10
}
},
{
age: {
$gte: 50
}
},
],
or: [{
eyeColor: "green",
},
{
eyeColor: "brown",
},
],
not: [{
state: "New York",
},
{
state: "California",
},
]
}
//Return refs
let query = orm.collection('COLLECTION_NAME')
.where(filter)
.run();
//Return full documents
let query = orm.collection('COLLECTION_NAME')
.where(filter)
.getDoc()
.run();
//Limit to 20.
//Return full documents.
let query = orm.collection('COLLECTION_NAME')
.where(filter)
.limit(20)
.getDoc()
.run();
//Limit to 20.
//Paginate
//Return full documents.
let query = orm.collection('COLLECTION_NAME')
.where(filter)
.limit(20)
.after("AFTER_DOCUMET_ID")
.before("BEFORE_DOCUMET_ID")
.getDoc()
.run();
//Simple equal satement single parameter, return full documents
let query = orm.collection('COLLECTION_NAME')
.where(filter)
.run();
``
`
#### Nested Insert
`
``
javascript
let insertDocument = {
firstname: 'Santino',
lastname: 'Ortiz',
email: 'Gunnerfffffghhgg22.Gleichner@gmail.com',
age: 14,
gender: 'female',
isActive: true,
phone: '18802876350',
address: {
create: {
street: '6245 Rohan Extension',
street2: 'Suite 101',
state: 'Pakistan',
city: 'Western Sahara',
country: 'Madagascar',
},
},
orders: {
create: {
orderdate: '1972-11-04T15:45:00.266Z',
ordernumber: '5e71407b0fdab829807727f0',
totalamount: 3424.67,
orderitems: {
create: [{
unitprice: 21.69,
quantity: 65,
product: {
connect: {
id: '5350192081779138715',
},
},
},
{
unitprice: 231.69,
quantity: 4,
product: {
connect: {
id: '32524523452345325345',
},
},
},
{
unitprice: 651.69,
quantity: 34,
product: {
connect: {
id: '3453245324532453245345',
},
},
},
],
},
},
},
};
let insert = orm2
.collection('COLLECTION_NAME')
.insert(insertDocument)
.run()
//create database
let query = orm.database('DATABASE_NAME')
.create()
.run();
//list all database
let query = orm.database()
.all()
.run();
//get single database
let query = orm.database("DATABASE_NAME")
.get()
.run();
//rename single database
let query = orm.database("OLD_DATABASE_NAME")
.renameTo('NEW_DATABASE_NAME')
.run();
//delete database
let query = orm.database("DATABASE_NAME")
.delete()
.run();
//annotate database
let query = orm.database("DATABASE_NAME")
.annotate({
key: "value"
})
.run();
//create key
let query = orm.key()
.create("DATABASE_NAME", "ROLE_NAME", "KEY_NAME", "KEY_DATA")
.run();
//list all key
let query = orm.key()
.all()
.run();
//get single key
let query = orm.key("KEY_ID")
.get()
.run();
//delete key
let query = orm.key("KEY_ID")
.delete()
.run();
//create collection
let query = orm.collection('COLLECTION_NAME')
.create()
.run();
//list all collection
let query = orm.collection()
.all()
.run();
//get single collection
let query = orm.collection("COLLECTION_NAME")
.get()
.run();
//rename single collection
let query = orm.collection("OLD_COLLECTION_NAME")
.renameTo('NEW_COLLECTION_NAME')
.run();
//delete collection
let query = orm.collection("COLLECTION_NAME")
.delete()
.run();
//create document
let query = orm.collection("COLLECTION_NAME")
.document.create({
foo: "bar"
})
.run();
//create document with id
let query = orm.collection("COLLECTION_NAME")
.document.create({
id: "DOCUMENT_ID",
foo: "bar"
})
.run();
//create many document
let query = orm.collection("COLLECTION_NAME")
.document
.createMany([{
foo: "bar"
}, {
baz: "faz"
}])
.run();
//list all document
let query = orm.collection("COLLECTION_NAME")
.document
.all()
.run();
//get single document
let query = orm.collection("COLLECTION_NAME")
.document
.get("DOCUMENT_ID")
.run();
//update single collection
let query = orm.collection("COLLECTION_NAME")
.document
.update('DOCUMENT_ID', {
foo: "bar"
})
.run();
//replace single document
let query = orm.collection("COLLECTION_NAME")
.document
.replace('DOCUMENT_ID', {
foo: "bar"
})
.run();
//delete document
let query = orm.collection("COLLECTION_NAME")
.document.
delete()
.run();
//create index
let query = orm.index('INDEX_NAME')
.create("COLLECTION_NAME")
.run();
//create index with terms
let query = orm.index('INDEX_NAME')
.create("COLLECTION_NAME", ["email", "name", "address.city"])
.run();
//create index with terms, ref and ts
let query = orm.index('INDEX_NAME')
.create("COLLECTION_NAME", ["email", "ref", "ts"])
.run();
//create index with values
let query = orm.index('INDEX_NAME')
.create("COLLECTION_NAME", null, ["email", "name", "address.city"])
.run();
//create index with values, ref, ts
let query = orm.index('INDEX_NAME')
.create("COLLECTION_NAME", null, ["email", "ref", "ts"])
.run();
//create unique index
let query = orm.index('INDEX_NAME')
.create('collection', "email", null, true)
.run();
//list all collection
let query = orm.index().all().run();
//get single collection
let query = orm.index("INDEX_NAME")
.get()
.run();
//rename single collection
let query = orm.index("INDEX_NAME")
.renameTo('INDEX_NAME')
.run();
//delete collection
let query = orm.index("INDEX_NAME")
.delete()
.run();
FAQs
An NoSQL-friendly ORM for Fauna Database
We found that faunadb_orm demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Axios compromise traced to social engineering, showing how attacks on maintainers can bypass controls and expose the broader software supply chain.
Security News
Node.js has paused its bug bounty program after funding ended, removing payouts for vulnerability reports but keeping its security process unchanged.
Security News
The Axios compromise shows how time-dependent dependency resolution makes exposure harder to detect and contain.