Library to store and manage nested set trees using Sequelize version 4, 5 or 6! It supports multi-root trees.
Feel free to create an issue or PR if you have a bug or idea.
P.S. Don't forget to star this library. It stimulates me to support the library! ⭐️
P.P.S. If you feel like you could help me with the library (writing docs, adding new features, testing, fixing bugs or anything else) - you are welcome! If you need any info or have a question, just email me at fremail@yandex.com
- Installation
- Getting started
- DB Table structure
- Nested Set Options
- Docs
- Docs: All functions
- Changelog
- License (MIT)
npm install --save sequelize-nested-set
Please note, you have to install Sequelize yourself.
This library works as a wrapper for sequelize.define
, it has the same params: model name, attributes (aka table fields), options, but the first 2 params are sequelize connection and DataTypes object.
const ns = require('sequelize-nested-set');
module.exports = (sequelize, DataTypes) => {
const Tag = ns(sequelize, DataTypes, 'Tag', {
label: DataTypes.STRING,
}, {
tableName: 'tag',
timestamps: false,
hasManyRoots: true,
});
// add additional methods, associations to the model
return Tag;
};
Yes, it requires a basic structure of table where you want to keep your tree.
Here are the required fields:
lft
- int, not null. You can use another column name usinglftColumnName
option.rgt
- int, not null. UsergtColumnName
option for custom column name.
If you want to store a multi-root tree (several trees in other words), you need to set hasManyRoots
option to true
and have one more column:
rootId
- column type must be the same withid
column (default: int, but you can change it usingrootColumnType
option), not null. Default field name isroot_id
, but you can also use your own withrootColumnName
option.
Some methods of this library require level
or parentId
field. If you don't have any of the fields, they will be generated on the fly which may result in high load and slow work. A simple way to optimize this issue is to add one of columns or both:
level
- int, not null. For its name you can also uselevelColumnName
option.parentId
- primary key column type, nullable. You can use another column name usingparentIdColumnName
option. Don't forget to set correctparentIdColumnType
if your Primary Key is not an integer.
There are the options to customize your nested set. All these options are optional.
hasManyRoots
(boolean, default:false
) - for cases when you want to store several trees in one table.lftColumnName
(string, default:lft
) - a column name for lft.rgtColumnName
(string, default:rgt
) - a column name for rgt.levelColumnName
(string, default:false
) - a column name for level (optional column).rootColumnName
(string, default:root_id
) - a column name for rootId. Value of this option makes sense only ifhasManyRoots
istrue
.rootColumnType
(one of DataTypes.*, default:DataTypes.INTEGER
) - a column type for rootId. It must be the same column type as the id column. Value of this option makes sense only ifhasManyRoots
istrue
.parentIdColumnName
(string, default:false
) - a column type for parentId (optional column).parentIdColumnType
(one of DataTypes.*, default:DataTypes.VIRTUAL
) - a column type for parentId. It must be the same column type as the id column.
I'm trying to keep all functions good-documented, but if you want more info about the functions with examples etc., please visit API docs in wiki.
See CHANGELOG.md for list of changes and UPGRADING.md for guide how to upgrade your code.