🌱 Seedpress Express API

Seedpress is a headless Node JS API server built with Express, for PostgreSQL using Sequelize ORM. It generally follows the logic and conventions of the Wordpress schema. Seedpress authenticates users using JSON web tokens managed by Passport. It's production ready, and should work as a great starter for any content based Progressive Web Application.

Hosting

Heroku

Testing

Features

[X] Authentication with JSON Web Token
[X] Email, Password validations
[X] User login and registration
[X] Full API and Unit test coverage
[X] Page and Term models with belongsToMany two way relationship
[X] Easily deployable to Heroku (Procfile)

Schema

Post
- id
- postTitle
- postSlug
- postType
- postDate
- postContent
- postAuthor
- postImage
- postMedia
- postStatus
- postExpiry
- postFrequency
- postTerms
- createdAt
- updatedAt
Terms
- id
- termType
- termName
- createdAt
- updatedAt
PostTerms
- termId
- postId
- createdAt
- updatedAt

To run locally

Make sure to install and run PostgreSQL first. There are a list of package.json scripts that include core sequelize migrations and seeds.

brew update
brew install postgres

Then you'll need to adjust the config file config/config.js to suit your setup.

Then run yarn reset and your db will create from scratch and seed data under the db name seedpress_dev.

Running yarn dev will start your dev server where needed.

Testing

You'll need to setup the test server using yarn resettest. To trigger the mocha/chai tests enter:

yarn test

Postman

There is a postman collection file for API testing and development in test/seedpress-api.postman_collection.json. It contains scripts and basic CRUD for:

/auth
- [POST] Register (/register)
- [POST] Login (/login)
/posts
- [POST] Single post (/ - with auth)
- [PATCH] Single post (/:slug - with auth)
- [DEL] Single post (/:slug - with auth)
- [GET] All posts (/)
- [GET] Single post (/:slug)

To deploy on Heroku

heroku login
heroku create
git push heroku master

Sequelize ORM

Seedpress uses Sequelise ORM to interact with Postgres. Install globally on your dev machine using yarn global sequelize-cli then run commands with sequelize or alternately run commands locally in your dev folder with the built in dev package ./node_modules/.bin/sequelize init.

Project Name	Stars	Repos Using This	Packages Using This	Most Recent Commit	Total Releases	Latest Release	Open Issues	License	Language
Tuql	543			2 years ago			13	mit	JavaScript
Automatically create a GraphQL server from a SQLite database or a SQL file
Egg Graphql	313	13	2	3 years ago	13	May 13, 2020	9	mit	JavaScript

Graphql Tools Sequelize	91	12	7	4 months ago	66	May 21, 2020	1		JavaScript
Integration of GraphQL-Tools and Sequelize ORM
Sequelize Mig	58		1	a month ago	25	March 30, 2021	31	mit	JavaScript
Sequelize migration generator and es6 init tool (Planned)
Seedpress Cms	55			5 years ago				mit	JavaScript
A headless CMS built in Express for PostgresQL using Sequelize. Generally follows the Wordpress post and term schema.
Graphcraft	51	1	2	5 days ago	89	March 01, 2020	7	mit	JavaScript
Rapildy build and extend GraphQL API based on Sequelize models. This library helps you focus on business logic while taking care of GraphQL schema automatically.
Node_acl_sequelize	46	5	1	3 years ago	11	July 10, 2019	3	mit	JavaScript
Node Acl Sequelize Backend
Sequelize Version	42	1		2 years ago	49	April 16, 2019	5	mit	JavaScript
Automatically version (audit, log) your sequelize models
Jsonapi Store Relationaldb	31	1		4 years ago	21	December 12, 2017	20	mit	JavaScript
A relational database handler for jsonapi-server
Sequelize Express Example	30			6 years ago			1		JavaScript
An example for the usage of Sequelize within an Express.js application with schema generation from existing table

Seedpress Cms