const dbconn = require('../routes/dbconn')
const methods = require('../routes/methods')

beforeAll(() => {
    // test DB connection
    dbconn.user.query('SELECT 1 + 5 AS solution', function (err, rows) {
        expect(err).toBeNull()
        expect(rows[0].solution).toBe(6)
    })
    dbconn.project.query('SELECT 10 + 5 AS solution', function (err, rows) {
        expect(err).toBeNull()
        expect(rows[0].solution).toBe(15)
    })
})

describe("DB methohds test", () => {
/*
    test("Get a user from DB by email", () => {
        let gitlabUserData = "to-be-defined"
        methods.addGitlabUser(gitlabUserData, function(data, err){
            expect(data).not.toBeNull()
            expect(err).toBeNull()
        })
    }) */
    
    test("Get a user from DB by email", () => { // email = any email address
        methods.getUserByEmail("test@email.de", function(data, err){
            expect(data).not.toBeNull()
            expect(err).toBeNull()
        })
    })

    test("Get a user from DB by ID", () => { // ID = any integer
        methods.getUserById(100, function(data, err){
            expect(data).not.toBeNull()
            expect(err).toBeNull()
        })
    })

    test("Check user email", () => { // email = any email address
        methods.checkUserEmail("test@email.de", function(err, data){
            expect(data).not.toBeNull()
            expect(err).toBeNull()
        })
    })

    test("Get a user by token", () => { // token = any alphanumeric
        methods.checkUserEmail("1abc0qwerty", function(err, data){
            expect(data).not.toBeNull()
            expect(err).toBeNull()
        })
    })
})