JSON query: date time validation in python

Question

I have a JSON data which is getting generated through python scripts as below.

JSON:

{
"name":"abc"
"insrt_dt": datetime.datetime(2020,12,15,18,35,30,31547}
"demand_dt": Timestamp('2014-05-09 00:00:00')
}

I want to do schema validation before inserting it into Mongo database.

I am able to handle "name" field , but not able to handle "insrt_dt" & "demand_dt" fields. for name: it is working as per syntax.

json schema date-time does not check correctly.

but unable to decide type and format for "insrt_dt" & "demand_dt"

can you show schema whith exists? – Daniil Loban Dec 24 '20 at 10:48 — Daniil Loban, Dec 24 '20 at 10:48
Did you mean to enter some code for *`enter code here`*? – dbc Dec 24 '20 at 17:29 — dbc, Dec 24 '20 at 17:29

score 0 · Answer 1 · answered Dec 24 '20 at 10:42

the JSON needs to be correctly formatted. In particular, missing commas. also the datetime line was closed with } and should be ).

see: https://json.org/example.html

The correct JSON should look like this:

{
"name":"abc",
"insrt_dt": datetime.datetime(2020,12,15,18,35,30,31547),
"demand_dt": Timestamp('2014-05-09 00:00:00')
}

score 0 · Answer 2 · answered Dec 24 '20 at 10:53

  import mongoose from 'mongoose';
  const { Schema } = mongoose;

  const blogSchema = new Schema({
    name: String,
    insrt_dt: { type: Date, default: Date.now },
    demand_dt: { type: Date, default: Date.now },
  });

// is Timestamp('2014-05-09 00:00:00') number ?

JSON query: date time validation in python

2 Answers2