const dbconn = require('../config/dbconn');

var methods = {
    getAllMailinglists: function(callback:any) {
        dbconn.project.query('CALL getAllLists', function (err:any, rows:any){
            if (err) throw err;
            callback(rows[0], err);
	    })
    },
    getProjectOverviewById: function(projectId:number, callback:any) {
        dbconn.project.query('CALL GetProjectInformationByProjectID(' + projectId+ ')', function (err:any, rows:any){
            if (err) throw err;
            callback(rows[0], err);
    	})
    },
    getProjectImagesById: function(projectId:number, callback:any) {
        dbconn.project.query('CALL getImagesByProjectID(' + projectId+ ')', function (err:any, rows:any){
            if (err) throw err;
            callback(rows[0], err);
        })
    }
};

export = methods;