api.zip_testes

const photoConverter = row => ({ id: row.photo_id, postDate: new Date(row.photo_post_date), url: row.photo_url, description: row.photo_description, allowComments: row.photo_allow_comments == 'true' ? true : false, likes: row.likes, comments: row.comments, userId: row.user_id, }); const commentConverter = row => ({ date: row.comment_date, text: row.comment_text, userName: row.user_name }) const maxRows = 12; class PhotoDao { constructor(db) { this._db = db; } listAllFromUser(userName, page) { const from = (page - 1) * maxRows; let limitQuery = ''; if (page) limitQuery = `LIMIT ${from}, ${maxRows}`; return new Promise((resolve, reject) => { this._db.all(` SELECT p.*, (SELECT COUNT(c.comment_id) FROM comment as c WHERE c.photo_id = p.photo_id ) as comments, (SELECT COUNT(l.like_id) FROM like as l WHERE l.photo_id = p.photo_id ) as likes FROM photo AS p JOIN user AS u ON p.user_id = u.user_id WHERE u.user_name = ? ORDER BY p.photo_post_date DESC ${limitQuery} ; `, [userName], (err, rows) => { const photos = rows.map(photoConverter) if (err) { console.log(err); return reject('Can`t list photos'); } console.log('photos retornadas'); resolve(photos); }); }); } add(photo, user_id) { return new Promise((resolve, reject) => { this._db.run(` INSERT INTO photo ( photo_post_date, photo_url, photo_description, photo_allow_comments, user_id ) values (?,?,?,?,?) `, [ new Date(), photo.url, photo.description, photo.allowComments, user_id ], function (err) { if (err) { console.log(err); return reject('Can`t add photo'); } resolve(this.lastID); }); }); } findById(id) { return new Promise((resolve, reject) => this._db.get(` SELECT p.*, (SELECT COUNT(c.comment_id) FROM comment as c WHERE c.photo_id = p.photo_id ) as comments, (SELECT COUNT(l.like_id) FROM like as l WHERE l.photo_id = p.photo_id ) as likes FROM photo AS p WHERE p.photo_id = ? ORDER BY p.photo_post_date DESC; `, [id], (err, row) => { if (err) { console.log(err); return reject('Can`t find photo'); } if (row) { resolve(photoConverter(row)); } else { resolve(null); } } )); } remove(id) { return new Promise((resolve, reject) => this._db.run( `DELETE FROM photo where photo_id = ?`, [id], err => { if (err) { console.log(err); return reject('Can`t remove photo'); } resolve(); } )); } addComment(text, photoId, userId) { return new Promise((resolve, reject) => { this._db.run(` INSERT INTO comment ( comment_date, comment_text, photo_id, user_id ) values (?,?,?, ?) `, [ new Date(), text, photoId, userId, ], function (err) { if (err) { console.log(err); return reject('Can`t add comment'); } resolve(this.lastID); }); }); } getCommentsFromPhoto(photoId) { return new Promise((resolve, reject) => { this._db.all( ` SELECT c.comment_date, c.comment_text, u.user_name FROM comment as c JOIN user as u ON u.user_id = c.user_id WHERE c.photo_id = ? ORDER BY c.comment_date DESC `, [photoId], (err, rows) => { if (err) { console.log(err); return reject('Can`t load comments'); } const comments = rows.map(commentConverter); return resolve(comments); } ); }); } findCommentById(commentId) { return new Promise((resolve, reject) => { this._db.get( ` SELECT c.comment_date, c.comment_text, u.user_name FROM comment as c JOIN user as u ON u.user_id = c.user_id WHERE c.comment_id = ? `, [commentId], (err, row) => { console.log(row); if (err) { console.log(err); return reject('Can`t load comment'); } return resolve(commentConverter(row)); } ); }); } likeById(photoId, userId) { return new Promise((resolve, reject) => this._db.run( ` INSERT OR IGNORE INTO like (photo_id, user_id) VALUES (?, ?) `, [photoId, userId], function(err) { if (err) { console.log(err); return reject('Cant like photo'); } resolve(!!this.changes); } )); } } module.exports = PhotoDao;