diff options
| author | Jules Laplace <jules@okfoc.us> | 2015-09-03 16:35:07 -0400 |
|---|---|---|
| committer | Jules Laplace <jules@okfoc.us> | 2015-09-03 16:35:07 -0400 |
| commit | 976bdace6704b60bc984635917ee56f17797c10a (patch) | |
| tree | f2451b3f23c87d3e14c1eb8e3d92cda321db8103 /lib/db/index.js | |
| parent | f768ab296c07ce93efe9f2507cdf4b795aa10013 (diff) | |
able to log in
Diffstat (limited to 'lib/db/index.js')
| -rw-r--r-- | lib/db/index.js | 29 |
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 |
