From ff21a5c75f090d5c27446eeaa6fb3ff6f82c5ab4 Mon Sep 17 00:00:00 2001 From: =Corey Hulen Date: Sun, 12 Jul 2015 14:56:44 -0800 Subject: Fixes mm-1420 adding postgres support --- store/sql_audit_store.go | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'store/sql_audit_store.go') diff --git a/store/sql_audit_store.go b/store/sql_audit_store.go index dd9312007..a595d50e2 100644 --- a/store/sql_audit_store.go +++ b/store/sql_audit_store.go @@ -31,7 +31,7 @@ func (s SqlAuditStore) UpgradeSchemaIfNeeded() { } func (s SqlAuditStore) CreateIndexesIfNotExists() { - s.CreateIndexIfNotExists("idx_user_id", "Audits", "UserId") + s.CreateIndexIfNotExists("idx_audits_user_id", "Audits", "UserId") } func (s SqlAuditStore) Save(audit *model.Audit) StoreChannel { @@ -73,8 +73,8 @@ func (s SqlAuditStore) Get(user_id string, limit int) StoreChannel { } var audits model.Audits - if _, err := s.GetReplica().Select(&audits, "SELECT * FROM Audits WHERE UserId = ? ORDER BY CreateAt DESC LIMIT ?", - user_id, limit); err != nil { + if _, err := s.GetReplica().Select(&audits, "SELECT * FROM Audits WHERE UserId = :user_id ORDER BY CreateAt DESC LIMIT :limit", + map[string]interface{}{"user_id": user_id, "limit": limit}); err != nil { result.Err = model.NewAppError("SqlAuditStore.Get", "We encounted an error finding the audits", "user_id="+user_id) } else { result.Data = audits -- cgit v1.2.3-1-g7c22