Handle django string formatted sqlite datetime

pjoe · pjoe · commit b264b83a9ed1 · 2013-07-01T18:38:39.000+08:00
diff --git a/lib/Drivers/DML/sqlite.js b/lib/Drivers/DML/sqlite.js
@@ -207,6 +207,13 @@ Driver.prototype.valueToProperty = function (value, property) {
 				return null;
 			}
 			break;
+		case "date":
+			if (typeof value === 'string') {
+				if (value.indexOf('Z', value.length - 1) === -1) {
+					return new Date(value + 'Z');
+				}
+			}
+			return new Date(value);
 		default:
 			return value;
 	}
@@ -218,6 +225,48 @@ Driver.prototype.propertyToValue = function (value, property) {
 			return (value) ? 1 : 0;
 		case "object":
 			return JSON.stringify(value);
+		case "date":
+			if (this.config.query.strdates) {
+				if (value instanceof Date) {
+					var year = value.getUTCFullYear();
+					var month = value.getUTCMonth() + 1;
+					if (month < 10) {
+						month = '0' + month;
+					}
+					var date = value.getUTCDate();
+					if (date < 10) {
+						date = '0' + date;
+					}
+					var strdate = year + '-' + month + '-' + date;
+					if (property.time === false) {
+						return strdate;
+					}
+
+					var hours = value.getUTCHours();
+					if (hours < 10) {
+						hours = '0' + hours;
+					}
+					var minutes = value.getUTCMinutes();
+					if (minutes < 10) {
+						minutes = '0' + minutes;
+					}
+					var seconds = value.getUTCSeconds();
+					if (seconds < 10) {
+						seconds = '0' + seconds;
+					}
+					var millis = value.getUTCMilliseconds();
+					if (millis < 10) {
+						millis = '0' + millis;
+					}
+					if (millis < 100) {
+						millis = '0' + millis;
+					}
+					strdate += ' ' + hours + ':' + minutes + ':' + seconds + '.' + millis + '000';
+					return  strdate; 
+				}
+
+			}
+			return value;
 		default:
 			return value;
 	}
