CODEWITHSUNDEEP
python-3.xpymongomongoengine
drake1994
drake1994

Reputation: 99

Setting default value to Null in mongoengine Model python

from pymodm import connect, fields, MongoModel, EmbeddedMongoModel
from pymongo import IndexModel, ASCENDING, TEXT,client_session
import arrow
from sqlalchemy.log import echo_property
from sqlalchemy.orm import session, sessionmaker
# from .models import *
from scrapy.utils.project import get_project_settings
import arrow
from time import sleep
from sqlalchemy.sql.expression import null

from sqlalchemy.sql.schema import PrimaryKeyConstraint


def db_connect():
    """
    Performs database connection using database settings from settings.py.
    Returns sqlalchemy engine instance
    """
    engine = connect("mongodb://localhost:27017/abcd")
    return engine

now = arrow.get(arrow.now('America/New_York')).datetime

class Live_pr(MongoModel):
    uni_identifier = fields.CharField(required=True,primary_key=True)
    symbol = fields.ListField(required=True)
    #...........
    #..........
    price_dollar = fields.FloatField(blank=True, null=True, default=None) #I want set default Null for this field
    is_new = fields.IntegerField(default=1)
    scrape_timestamp = fields.DateTimeField(default=now)

    class Meta:
        cascade = True

db_connect()

#.....
#scrapy pipeline code
#....

def process_item(self, item, spider):
    prs = Live_pr()

    prs.uni_identifier = item["uni_identifier"]
    prs.symbol = item["symbols"]
    if item["price"]:
        prs.price_dollar = item["price"]
    prs.save()

I just want to know if there is a way to set default as Null in mongoengine model."default=None" does not work.It just drops the entire field. And setting "null=true" throws this type error:

File "/home/*******/.local/lib/python3.9/site-packages/pymodm/fields.py", line 89, in init super(CharField, self).init(verbose_name=verbose_name, TypeError: init() got an unexpected keyword argument 'null'

Upvotes: 0

Views: 938

Answers (1)

Sabil
Sabil

Reputation: 4510

You can set default like this:

field2 = fields.CharField(blank=True, null=True, default=None)

Upvotes: 1

Related Questions