1UP Add SteemSQL

main repository: https://github.com/therealFlauwy/1UP
fork repository: https://github.com/ederaleng/1UP

Contribution addSteemSQL

SteemSQL was added to the code of the 1up project according to different time bases and these were saved within the project's own database

requirements:mssql

the only requirement was mssql to perform the query to the STEEMSQL database, the internal configuration of the code was made with the information of steemsql and the configuration was made.

const configSqlSteem= {
    user: config.userSteemSQL,
    password: config.passwordSteemSQL,
    server: config.serverSteemSQL,
    database: config.databaseSteemSQL,
    connectionTimeout: 300000,
    requestTimeout: 300000,
    opciones : {
        encrypt : false
    }
};
sql.connect(configSqlSteem, (err)=>{
    if (err) console.log(err);
})

also a timer was added with the following configurations that for each community it would look for the post that there would be of the first 6 days of not having a post in the first 6 days, it was looking for the post that had a date between 6 and 12 days inside the tag of the community these required the following information as author, permlink, category, title, body, ID, img to be saved each time they were had through a function were stored one by one within the database of 1up

Live Demo
1up has a demo which is updated every time a code update is done which you can see at the following address:

Live Demo

Pull Request
add SteemSQL to code

GitHub Account
https://github.com/ederaleng