summaryrefslogtreecommitdiff
path: root/lib/db/index.js
diff options
context:
space:
mode:
Diffstat (limited to 'lib/db/index.js')
-rw-r--r--lib/db/index.js29
1 files changed, 21 insertions, 8 deletions
diff --git a/lib/db/index.js b/lib/db/index.js
index e820758..f539b90 100644
--- a/lib/db/index.js
+++ b/lib/db/index.js
@@ -8,31 +8,31 @@ var knex = connection.knex
var User = db.User = bookshelf.Model.extend({
tableName: 'users',
- hasTimestamps: true,
+ hasTimestamps: false,
})
var Thread = db.Thread = bookshelf.Model.extend({
tableName: 'threads',
- hasTimestamps: true,
+ hasTimestamps: false,
})
var Comment = db.Comment = bookshelf.Model.extend({
tableName: 'comments',
- hasTimestamps: true,
+ hasTimestamps: false,
})
var File = db.File = bookshelf.Model.extend({
tableName: 'files',
- hasTimestamps: true,
+ hasTimestamps: false,
})
var Keyword = db.Keyword = bookshelf.Model.extend({
tableName: 'keywords',
- hasTimestamps: true,
+ hasTimestamps: false,
})
var Mailbox = db.Mailbox = bookshelf.Model.extend({
tableName: 'boxes',
- hasTimestamps: true,
+ hasTimestamps: false,
})
var Message = db.Message = bookshelf.Model.extend({
tableName: 'messages',
- hasTimestamps: true,
+ hasTimestamps: false,
})
/* PICTURES */
@@ -40,8 +40,21 @@ var Message = db.Message = bookshelf.Model.extend({
db.createUser = function(data){
return new db.User(data).save()
}
-db.getUsers = function (callback) {
+db.getUsers = function () {
return User.query(function(qb){
qb.orderBy("id", "desc")
}).fetchAll()
}
+db.getUser = function(id) {
+ var model = new User({'id': id})
+ return model.fetch()
+}
+db.getUserByUsername = function(username) {
+ var model = new User({'username': username})
+ return model.fetch()
+}
+db.getThreads = function () {
+ return User.query(function(qb){
+ qb.orderBy("id", "desc")
+ }).fetchAll()
+} \ No newline at end of file