SlothDB
A typescript ORM that uses annotation and classes to describe the database
Features
- Built using annotations
- Simple field support (update and read doc values)
- URI fields - string fields which value depends on other fields
- Versatile PouchDB support
- Views and index support
- Relation support : oneToMany, manyToOne and cascading removal
Usage
Describing the document schema
Simply use an interface to describe the document schema, with at least an _id
string field
Describing the entity class
The entity class needs to extend BaseEntity
and requires the SlothEntity annotation (passing the database name).
Describing the fields
Add your document fields to the entity class and decorate them using SlothField
. The assigned value will be used as a default value.
age: number = 18
Describing your URIs
It is common practice to generate string URIs from the other document values and use it as an _id
or on other indices for easier sorting and relationship description (especially oneToMany). The SlothURI decorator takes at least two arguments: the first one is the root, which is a constant string value. Using the database name when not describing relation is recommended. For example students/john-doe
has the students
root, but does not describe any relationship. If your document belongs to a parent document then a root that includes all documents types would be recommended, for example university
would cover students, marks and courses. The other values are field names, included in you document, to be used to build the URI in the following order. Each specified field will then be stringified and slugified using toString()
and limax
.
For example:
@SlothURI('students', 'surname', 'name')
_id: string = ''
Please note we are assigning a default value to the _id
field that will get ignored.
This is the equivalent of a students/:surname/:name
DocURI.
PouchDB Factory
A PouchFactory is a simple function that returns a PouchDB instance for a given database name. Every function in SlothDatabase
except withRoot
requires as an argument a PouchFactory. Entities are attached a PouchFactory in the constructor, so the entity functions (save()
, remove()
, etc) does not require a factory. A simple factory would be (name: string) => new PouchDB(name)
Database operations
await author.save author.age = 42 await author.save await author.remove
Relationships
SlothDB supports for now one type of relationship: belongsTo/oneToMany (which is the same relationship, but with a different perspective).
The annotation SlothRel
can be used on the field that describes a belongsTo relationship, that-is-to-say the field value is a string representing the parent document _id
field. The SlothField decorator is not usable with this annotation. If the target field is included in SlothURI, then the string value of this field (which is the _id
of the parent document) will have its root removed in order to include it in the URI. The value is not slugified using limax, so /
are not escaped. For example students/mit/john-doe
will become mit/john-doe
and a mark URI for this student would become marks/mit/john-doe/chemistry/2018-04-20
whereas the original URI has only 3 parts (student, course, date).
To describe a belongsTo relationship you can use SlothRel with a belongsTo
object:
student_id: string = ''
The belongsTo
value is just a simple function that returns the parent SlothDatabase instance, to avoid circular dependency conflicts.
If the cascade
option is not present or true
, removing all child document of a single parent will also remove the parent.
The annotation SlothRel can also be used on a non-document field, with the hasMany
function, which returns the SlothDatabase instance of the child entity. The target field is a function that returns a child instance. This function should null, the annotation will replace it with an impl:
albums:Album
The SlothRel uses the withRoot
function of SlothDatabase
which return a SlothDatabase that prefixes the startkey argument of the allDocs calls with the current document _id
hence the id needs to be described using the same root and the first key of the child's _id
must be the parent id field.
Views and indexes
The SlothView
annotation describes a CouchDB map function. It takes as an argument a function (doc, emit) => void
, the view name (default to by_<field name>
) and the optional design document identifier (default to views
). Please note that this function does not modify any behavior of the target, so the decorated field requires another decorator (like SlothField
or SlothURI
) and the choice of the decorated field is purely semantic and decorating another field will only change the view name. Depending on the typescript target, you might want to use es5 functions (avoid fat-arrow functions).
The SlothIndex
is a function that applies the SlothView decorator with emit(doc['${key}'].toString())
as a function to create a basic index on the decorated field.
The SlothDatabase
class takes as a third generic argument extending a string that describes the possible view values. The queryDocs
function then takes as an argument the string constrained by the generic parameter. It is then recommended to use an enum to identify views:
...
Full example
Then to use
jrrTolkien._id === 'library/jrr-tolkien'jrrTolkien.name === 'JRR Tolkien' await jrrTolkien.exists === falseawait jrrTolkien.saveawait jrrTolkien.exists === true lotr._id === 'library/jrr-tolkien/the-lord-of-the-rings' await golding.exists === true await Book.putfactory, booksStartingWithLord.length === 2
NPM scripts
npm t
: Run test suitenpm start
: Runnpm run build
in watch modenpm run test:watch
: Run test suite in interactive watch modenpm run test:prod
: Run linting and generate coveragenpm run build
: Generate bundles and typings, create docsnpm run lint
: Lints codenpm run commit
: Commit using conventional commit style (husky will tell you to use it if you haven't 😉)