router.get('/desdevideo/:idvideo', function (req, res, next ) {
db.loadDatabase();
dbVideos.loadDatabase();
var idVideo = req.params.idvideo;
var pagina = req.query.pagina || 1;
var desde = ( parseInt ( pagina ) - 1 ) * TAM_PAGINA;
async.parallel([
function (done ) {
db.find( { idVideo: idVideo }).limit(TAM_PAGINA).skip(desde).exec(done);
},
function ( done ) {
db.count( { idVideo: idVideo }).exec( done );
}
], function (err, resultados ) {
if ( err ) {
return next (err);
} else {
var totalRegistros = resultados[1];
var totalPaginas = Math.ceil ( totalRegistros / TAM_PAGINA );
res.render('imagenes', {
totalRegistros: totalRegistros,
totalPaginas: totalPaginas,
pagina: pagina,
imagenes: resultados[0],
slug: 'i/desdevideo/' + idVideo
});
}
});
})
this._configureMetasDb(db2, (error) => {
if (error) {
return callback(error);
}
this._metasCollection=db2;
debug("initializeDb", "RepositoriesDb path=", path3);
var db3 = new Datastore({
filename : path3
});
db3.loadDatabase((error) => {
if (error) {
return callback(error);
}
this._configureRepositoriesDb(db3, (error) => {
if (error) {
return callback(error);
}
this._repositoriesCollection=db3;
callback();
});
});
});
fs.unlink(dbFile, function (err) {
if (err && err.code != 'ENOENT') {
callback(err);
} else {
db.loadDatabase(callback);
}
});
function loadHistory(){
document.getElementById("history").style.display = 'block';
var entriesShownLimit = 10;
//get all documents
db.loadDatabase(function(err){
if(!err){
db.find({username: '******'}).sort({ entryDate: -1 })
.limit(entriesShownLimit).exec(function (err, entries) {
//populate entries
document.getElementById('mainbox').innerHTML = "";
entries.forEach(function(entry){
var dd = entry.entryDate.getDate();
var mm = entry.entryDate.getMonth()+1; //January is 0!
var yyyy = entry.entryDate.getFullYear();
var realDate = mm + "/" + dd + "/" + yyyy;
document.getElementById('mainbox').innerHTML += "<div class='entry'> \
<div class='entryDate'>" + realDate + "</div> \
<div class='entryText'><p>" + entry.text.replace(/\n/g, "</br>") + "</p></div> \
</div>";
});
});
} else {
alert("Database retrieval error: " + err);
}
});
}
document.getElementById("submitEntry").addEventListener("click", function (e) {
console.log(document.getElementById("journalEntry").value);
var entry = {
entryDate: new Date(),
text: document.getElementById("journalEntry").value,
title: "No title field yet",
picture: "not implemented",
audio: "not implemented",
username: "******"
};
db.loadDatabase(function (err) {
if(!err){
db.insert(entry, function(err, result){
if(!err){
console.log(result);
//email entry to user's email here
emailer("*****@*****.**", "*****@*****.**", "greeneggsandham400", result.entryDate, result.text)
} else {
alert("Database insertion error: " + err);
}
});
} else {
alert("Database error: " + err);
}
});
document.getElementById("journalEntry").value = "<img src='C:/Users/spence95/Pictures/Mae/mae'/ style='width:200px;'>";
});
/**
* Get a collection by name
*
* @param {String} name
* @param {Function} cb
* @return {void}
*/
collection(name, cb) {
const collections = this.collections;
if (typeof collections[name] === 'undefined') {
let collectionPath = null;
let log = 'memory';
if (typeof this.dir !== 'undefined' && this.dir !== null) {
collectionPath = path.join(this.dir, name + '.db');
log = collectionPath;
}
this.logger.debug('[bass-nedb] - loading collection "' + name + '" from: ' + log);
const collection = new Datastore({ filename: collectionPath });
collection.loadDatabase((err) => {
if (err === null) {
collections[name] = collection;
cb(null, collection);
} else {
cb(err);
}
});
} else {
cb(null, collections[name]);
}
}
router.get('/', function(req, res, next) {
db.loadDatabase( function (err) {
var pagina = req.query.pagina || 1;
var desde = ( pagina - 1) * TAM_PAGINA;
async.parallel( [
function ( done ) {
db.find({}).limit(TAM_PAGINA).skip(desde).sort( { fecha: -1 }).exec( done );
},
function ( done ) {
db.count({}).exec( done );
}
], function ( err, resultados ) {
if ( err ) {
return next ( err );
} else {
var totalRegistros = resultados[1];
var totalPaginas = Math.ceil ( totalRegistros / TAM_PAGINA );
res.render('imagenes', {
totalRegistros: totalRegistros,
totalPaginas: totalPaginas,
pagina: pagina,
imagenes: resultados[0],
slug: 'i'
});
}
});
});
});
function get(query, callback) {
db.loadDatabase();
db.find(query, function (err, doc) {
if (err) console.log(err);
else callback(doc);
});
}
set : function (query) {
settingsdb.loadDatabase();
settingsdb.insert(query, function (err, doc) {
if(err) throw err;
console.log('Setting inserted : ', doc);
});
},
export const initDB = (filename = path.join(__dirname, '../data.db')) => {
db = new Datastore({
filename: filename,
autoload: true
})
db.loadDatabase()
}
return new Promise(function (resolve, reject) {
newCust.loadDatabase()
oldCust.loadDatabase()
oldCust.count({}, function (err, c) {
if (err) {
reject('Counting error, ' + err)
} else if (c) {
count = c
}
})
oldCust.find({}, function (err, docs) {
if (err) {
reject('Customization fetch error, ' + err)
} else if (docs) {
docs.map((old) => {
var doc = {
_id: old._id,
replies: {
permissions: old.responses.no_permission_response,
welcome: old.responses.welcome_message,
nsfw: old.responses.nsfw_disallowed_response,
timeout: 'default'
},
settings: {
welcoming: old.settings.welcoming,
prefix: false
}
}
newCust.insert(doc, function (err, doc) {
if (err) {
reject('Insertion failiure, ' + err)
} else if (doc) {
counter++
if (counter >= count) {
load.stop()
Logger.info('Customization transfer complete, transferred ' + counter + ' documents.')
count = 0
counter = 0
resolve()
}
}
})
})
}
})
})
get : function (query, callback) {
settingsdb.loadDatabase();
settingsdb.find(query, function (err, doc) {
if (err) throw err;
if (doc.length == 0) callback([{setting : undefined}]);
else callback(doc);
});
},
check_update.on('message', function(msg){
if (msg === 'finish') {
c.loadDatabase();
c.find({}, function(err, docs) {
console.log(docs);
fs.unlink('file');
})
}
});
return new Promise(function (resolve, reject) {
newPerms.loadDatabase()
oldPerms.loadDatabase()
oldPerms.count({}, function (err, c) {
if (err) {
reject('Counting error, ' + err)
} else if (c) {
count = c
}
})
oldPerms.find({}, function (err, docs) {
if (err) {
reject('Permission fetch error, ' + err)
} else if (docs) {
docs.map((old) => {
var doc = {
_id: old._id,
superUser: old.superUser,
blacklisted: false,
perms: {
level1: old.permissions.level1,
level2: old.permissions.level2,
level3: old.permissions.level3,
nsfw: old.nsfw_permissions.allowed
}
}
newPerms.insert(doc, function (err, doc) {
if (err) {
reject('Insertion failiure, ' + err)
} else if (doc) {
counter++
if (counter >= count) {
load.stop()
Logger.info('Permission transfer complete, transferred ' + counter + ' documents.')
count = 0
counter = 0
resolve()
}
}
})
})
}
})
})
router.get('/detalles/:id', function ( req, res, next ) {
dbVideos.loadDatabase();
db.loadDatabase();
var datos = {};
var idImagen = req.params.id;
db.findOne( { _id: req.params.id }).exec( function ( err, imagen ) {
if ( err ) {
return next(err);
}
imagen.nombreVideo = path.basename( imagen.video );
res.render('imagen', {
imagen: imagen
});
});
});
(function() {
//=====================================================================
// private variables
//=====================================================================
var DataStore = require('nedb');
var path = require('path');
var voteDb = new DataStore({filename: path.join(__dirname, '../db/vote.db')});
voteDb.loadDatabase();
function getVoteByLinkAndUser(linkId, userName, func) {
voteDb.findOne({ $and: [{linkId: linkId}, {userName: userName}]}, func);
}
function removeVoteByLinkAndUser(linkId, userName, func) {
voteDb.remove({ $and: [{linkId: linkId}, {}, {userName: userName}]}, func);
}
function insertVote(vote, func) {
voteDb.insert(vote, func);
}
function doVote(linkId, userName, value) {
var vote = {linkId: linkId, userName: userName, vote: value};
getVoteByLinkAndUser(linkId, userName, function(err, voteDb) {
if (voteDb) {
if (voteDb.value !== value) {
removeVoteByLinkAndUser(linkId, userName, function(err, numRemoved) {
});
}
}
else {
insertVote(vote, function(err, voteDb) {
});
}
})
}
function getVotesByUserName(userName, func) {
voteDb.find({userName: userName}, func);
}
function deleteVotesByUserName(userName, func) {
voteDb.find({userName: userName}, {multi: true}, func);
}
var VoteStore = {};
VoteStore.doVote = doVote;
VoteStore.getVotesByUserName = getVotesByUserName;
VoteStore.deleteVotesByUserName = deleteVotesByUserName;
module.exports = VoteStore;
}());
function set(files) {
db.loadDatabase();
try {;
allocateDirectory(files);
}
catch (err) {
console.log(err);
}
}
factories.push(function (name, path, callback) {
var store = new Nedb({ filename: path });
store.loadDatabase(function (error) {
tables[name] = {
name: name,
path: path,
store: store,
error: error
};
callback();
});
}.bind(null, name, paths[name]));
getDatastore = function() {
var Datastore = require('nedb');
db = new Datastore({ 'filename': this.cachePath, 'autoload':true });
db.loadDatabase(function (err) { // Callback is optional
if (err != null) {
console.log('error when loadDatabase :: '+err);
}
});
console.log('datastore get');
return db;
}
return new Promise(function (resolve, reject) {
newUser.loadDatabase()
oldUser.loadDatabase()
oldUser.count({}, function (err, c) {
if (err) {
reject('Counting error, ' + err)
} else if (c) {
count = c
}
})
oldUser.find({}, function (err, docs) {
if (err) {
reject('User database fetch error, ' + err)
} else if (docs) {
docs.map((old) => {
var doc = {
_id: old._id,
names: old.known_names,
blacklisted: false
}
newUser.insert(doc, function (err, doc) {
if (err) {
reject('Insertion failiure, ' + err)
} else if (doc) {
counter++
if (counter >= count) {
load.stop()
Logger.info('User database transfer complete, transferred ' + counter + ' documents.')
resolve('All transfers completed!')
count = 0
counter = 0
}
}
})
})
}
})
})
function Config() {
if (!(this instanceof Config)) {
return new Config();
}
db.loadDatabase(function (err) {
if (err) {
return this.emit('error', err);
}
this.emit('loaded', db);
}.bind(this));
}
router.delete("/service", function (req, res) {
if (validator(req.body.service, serviceSchemas.registry).valid) {
servicesDB.loadDatabase(function(e) {
servicesDB.remove(req.body.service, { multi: true }, function (err, numRemoved) {
if (!err) {
res.json(resjson.success(numRemoved, "Serviços desregistrados"));
} else {
res.json(resjson.error(err, "aqui"));
}
});
});
} else {
res.json(resjson.error());
}
});
router.post("/service", function (req, res) {
if (validator(req.body.service, serviceSchemas.registry).valid) {
servicesDB.loadDatabase(function(e) {
servicesDB.insert(req.body.service, function (err, newDoc) {
if (!err) {
res.json(resjson.success(newDoc, "Serviço registrado"));
} else {
res.json(resjson.error(err));
}
});
});
} else {
res.json(resjson.error());
}
});
function loadDatabaseIfNeeded(config, callback) {
if (db !== null) {
callback();
return;
}
var dbDatafile = path.join(xCraft.xcraftRoot, config.dbfile);
xLog.verb('loading datafile: ' + dbDatafile);
db = new Datastore({filename: dbDatafile});
db.loadDatabase(function(err) {
logErrorIfNeeded(err);
xLog.verb('loaded');
callback();
});
}
router.get('/', function(req, res, next) {
datastore.loadDatabase(function(err) {
if (err) {
return next({
status: 500,
message: err
});
}
var pledges = datastore.getAllData().sort(function(a, b) {
return a.firstName.localeCompare(b.firstName);
});
res.status(200).json({
pledges: pledges
});
});
});
function isTweetQueued(tweetData){
var deferred = q.defer();
tweetQueue_db.loadDatabase();
tweetQueue_db.findOne({id : tweetData.id}, function (err, doc) {
if (err){ //if theres an error, just let it check next time
deferred.resolve(true);
}
else if (doc === null){ //if nothing was found, return false
deferred.resolve(false);
}
else { // otherwise return true
deferred.resolve(true);
}
});
return deferred.promise;
}
jwt.verify(token, "ayy lmao", function(err, decoded) {
if (err) {
return next({
status: 401,
message: err
})
}
var reqID = decoded.id;
datastore.loadDatabase(function(err) {
if (err) {
return next({
status: 500,
message: err
});
}
datastore.find({
id: reqID
}, function(err, docs) {
if (err) {
return next({
status: 500,
message: err
});
}
if (!docs[0].isMaster) {
return next({
status: 401,
message: "Unauthorized"
})
}
datastore.remove({
id: id
}, {}, function(err, numRemoved) {
if (err) {
return next({
status: 500,
message: err
});
}
res.sendStatus(204);
});
});
});
});
var init = function (userDataStorageDir) {
var deferred = Q.defer();
var mainStorePath = pathUtil.resolve(userDataStorageDir, 'articles');
var metadataPath = pathUtil.resolve(userDataStorageDir, 'articles_metadata.db');
metadataDb = new Nedb({ filename: metadataPath });
metadataDb.loadDatabase(function (err) {
if (!err) {
mainDb = scatteredStore.create(mainStorePath, function (err) {
if (!err) {
deferred.resolve();
}
});
}
});
return deferred.promise;
};
isDisplayQueuedPromise.done(function(isDisplayQueuedRes){
if(isDisplayQueuedRes){
deferred.resolve({toQueue: false, data:tweetData});
}
else{
displayedTweets_db.loadDatabase();
displayedTweets_db.findOne({id : tweetData.id}, function (err, doc) {
if (err){ //if theres an error, just let it check next time
deferred.resolve({toQueue: false, data:tweetData});
}
else if (doc === null){ //value not found, queue up
//console.log(tweetData.text, "not displayed");
deferred.resolve({toQueue: true, data:tweetData});
}
else { //value found, do not queue it up
//console.log(tweetData.text, "previously displayed");
deferred.resolve({toQueue: false, data:tweetData});
}
});
}
});
router.get('/:pledge_id', function(req, res, next) {
var id = req.params.pledge_id;
datastore.loadDatabase(function(err) {
if (err) {
return next({
status: 500,
message: err
});
}
datastore.find({
id: id
}, function(err, docs) {
if (err) {
return next({
status: 500,
message: err
});
}
res.status(200).json({
pledge: docs[0]
});
});
});
});