Merge pull request #36 from benjaminVadon/master

Add replace SQL statement
xavierlacot · Mar 7, 2013 · aedb75e · aedb75e
2 parents 931bea4 + 7a261b6
commit aedb75e
Showing 1 changed file with 9 additions and 2 deletions.
diff --git a/joli.js b/joli.js
@@ -493,6 +493,8 @@ var joliCreator = function() {
                     return 'delete from ' + this.data.from;
                 case 'insert_into':
                     return 'insert into ' + this.data.from + ' (' + this.data.set.join(', ') + ') values (' + this.data.values.join(', ') + ')';
+                case 'replace':
+                    return 'replace into ' + this.data.from + ' (' + this.data.set.join(', ') + ') values (' + this.data.values.join(', ') + ')';
                 case 'select':
                     var join = '';
 
@@ -509,7 +511,7 @@ var joliCreator = function() {
                 case 'update':
                     return 'update ' + this.data.from + ' set ' + this.data.set.join(', ');
                 default:
-                    throw ("Operation type Error. joli.query operation type must be an insert, a delete, a select or an update.");
+                    throw ("Operation type Error. joli.query operation type must be an insert, a delete, a select, a replace or an update.");
             }
         },
         getQuery: function() {
@@ -667,6 +669,11 @@ var joliCreator = function() {
             this.data.order = order;
             return this;
         },
+        replace: function(table) {
+            this.data.operation = 'replace';
+            this.data.from = table;
+            return this;
+        },
         select: function(columns) {
             this.data.operation = 'select';
 
@@ -894,4 +901,4 @@ if (typeof exports === 'object' && exports) {
 
         return joli;
     };
-}
+}