Skip to content

Expressjs project built to track errors in any type of app

License

Notifications You must be signed in to change notification settings

blackshibe/turret

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

24 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Turret

Expressjs project built to track errors in production applications.

Configuration

Configure the MySQL database:

create database turret;
use turret;

create table accounts(
    user INT NOT NULL AUTO_INCREMENT,
    username VARCHAR(60) NOT NULL,
    password VARCHAR(60) NOT NULL,
    PRIMARY KEY ( user )
);

create table issues(
    issueid INT NOT NULL AUTO_INCREMENT,
    time TIMESTAMP NOT NULL,
    content VARCHAR(256) NOT NULL,

    PRIMARY KEY (issueid)
);

create table events(
    eventid INT NOT NULL AUTO_INCREMENT,
    issueid INT NOT NULL,
    user INT NOT NULL,
    time TIMESTAMP NOT NULL,

    PRIMARY KEY (eventid),
    FOREIGN KEY (issueid) REFERENCES issues(issueid)
);

Desired result:

Accounts:

Field Type Null Key Default Extra
user int(11) NO PRI NULL auto_increment
username varchar(60) NO NULL
password varchar(60) NO NULL

Issues:

Field Type Null Key Default Extra
issueid int(11) NO PRI NULL auto_increment
time timestamp NO CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
content varchar(256) NO NULL

Events:

Field Type Null Key Default Extra
eventid int(11) NO PRI NULL auto_increment
issueid int(11) NO MUL NULL
time timestamp NO CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
user int(11) NO NULL

then, add an .env file:

DB_HOST=your host
DB_USER=your user
DB_PASS=your password
SECRET=your secret

ADMIN_USER=admin
ADMIN_PASS=admin
^ these 2 are only needed for a first time run;
^ best to remove them after you log-in

and run:

git clone https://github.com/blackshibe/turret
cd turret
npm install
npm run debug

.spy is a file extension specifically to allow expressjs to render via the render function. use HTML highlighting.

About

Expressjs project built to track errors in any type of app

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published