@spinajs/orm-sql - npm Package Compare versions

Comparing version 2.0.196 to 2.0.197

lib/cjs/converters.d.ts

@@ -1,2 +0,2 @@
-import { BooleanValueConverter, DatetimeValueConverter, IValueConverter } from '@spinajs/orm';
+import { BooleanValueConverter, DatetimeValueConverter, IColumnDescriptor, IValueConverter, ModelBase } from '@spinajs/orm';
 import { DateTime } from 'luxon';
@@ -12,5 +12,5 @@ export declare class SqlSetConverter implements IValueConverter {
 export declare class SqlDatetimeValueConverter extends DatetimeValueConverter {
-    toDB(value: Date | DateTime): string;
+    toDB(value: Date | DateTime, _model: ModelBase<unknown>, column: IColumnDescriptor): string | number;
     fromDB(value: string | DateTime | Date | number): DateTime;
 }
 //# sourceMappingURL=converters.d.ts.map

lib/cjs/converters.js

@@ -31,10 +31,9 @@ "use strict";
 class SqlDatetimeValueConverter extends orm_1.DatetimeValueConverter {
-    toDB(value) {
-        if (value instanceof Date) {
-            return luxon_1.DateTime.fromJSDate(value).toSQL({ includeOffset: false });
+    toDB(value, _model, column) {
+        const numericalTypes = ['int', 'tinyint', 'smallint', 'mediumint', 'bigint', 'float', 'double', 'decimal'];
+        let dt = value instanceof luxon_1.DateTime ? value : luxon_1.DateTime.fromJSDate(value);
+        if (numericalTypes.includes(column.Type)) {
+            return dt?.toUnixInteger() ?? 0;
         }
-        if (value instanceof luxon_1.DateTime) {
-            return value.toSQL({ includeOffset: false });
-        }
-        return null;
+        return dt?.toSQL({ includeOffset: false }) ?? "1970-01-01 00:00:00";
     }
@@ -41,0 +40,0 @@ fromDB(value) {

lib/mjs/converters.d.ts

@@ -1,2 +0,2 @@
-import { BooleanValueConverter, DatetimeValueConverter, IValueConverter } from '@spinajs/orm';
+import { BooleanValueConverter, DatetimeValueConverter, IColumnDescriptor, IValueConverter, ModelBase } from '@spinajs/orm';
 import { DateTime } from 'luxon';
@@ -12,5 +12,5 @@ export declare class SqlSetConverter implements IValueConverter {
 export declare class SqlDatetimeValueConverter extends DatetimeValueConverter {
-    toDB(value: Date | DateTime): string;
+    toDB(value: Date | DateTime, _model: ModelBase<unknown>, column: IColumnDescriptor): string | number;
     fromDB(value: string | DateTime | Date | number): DateTime;
 }
 //# sourceMappingURL=converters.d.ts.map

lib/mjs/converters.js

@@ -26,10 +26,9 @@ import { DatetimeValueConverter } from '@spinajs/orm';
 export class SqlDatetimeValueConverter extends DatetimeValueConverter {
-    toDB(value) {
-        if (value instanceof Date) {
-            return DateTime.fromJSDate(value).toSQL({ includeOffset: false });
+    toDB(value, _model, column) {
+        const numericalTypes = ['int', 'tinyint', 'smallint', 'mediumint', 'bigint', 'float', 'double', 'decimal'];
+        let dt = value instanceof DateTime ? value : DateTime.fromJSDate(value);
+        if (numericalTypes.includes(column.Type)) {
+            return dt?.toUnixInteger() ?? 0;
         }
-        if (value instanceof DateTime) {
-            return value.toSQL({ includeOffset: false });
-        }
-        return null;
+        return dt?.toSQL({ includeOffset: false }) ?? "1970-01-01 00:00:00";
     }
@@ -36,0 +35,0 @@ fromDB(value) {

package.json

 {
   "name": "@spinajs/orm-sql",
-  "version": "2.0.196",
+  "version": "2.0.197",
   "description": "framework orm sql language module",
@@ -55,5 +55,5 @@
   "dependencies": {
-    "@spinajs/di": "^2.0.196",
-    "@spinajs/orm": "^2.0.196",
-    "@spinajs/exceptions": "^2.0.196",
+    "@spinajs/di": "^2.0.197",
+    "@spinajs/orm": "^2.0.197",
+    "@spinajs/exceptions": "^2.0.197",
     "luxon": "^3.2.1",
@@ -60,0 +60,0 @@ "typescript-mix": "^3.1.3"

No alert changes

Improved metrics

Total package byte prevSize

402380

0.24%

Worsened metrics

Lines of code

3592

-0.06%

Dependency changes

• Updated

  @spinajs/di@^2.0.197

• Updated

  @spinajs/exceptions@^2.0.197

• Updated

  @spinajs/orm@^2.0.197