sql server - Django - OneToOneField can be Null? -

-

i'm trying fetch messages 365 api , save them on initialmessage model. when ever try so, keep getting message:

django.db.utils.integrityerror: ('23000', "[23000] [microsoft][sql server native client 11.0][sql server]violation of unique key constraint 'uq__assignme__f9cc0897dc370444'. cannot insert duplicate key in object 'dbo.assignment_initialmessage'. duplicate key value (). (2627) (sqlparamdata)")

unique key constraint refering relationship model claim (claim = models.onetoonefield(claim, null=true, blank=true, default=none)

this model:

class initialmessage(models.model): json = models.textfield() att_url = models.charfield(max_length = 254, default='https://outlook.office365.com/api/v1.0/me/messages/{0}/attachments') send_url = models.charfield(max_length = 254, default='https://outlook.office365.com/api/v1.0/me/sendmail') update_url = models.charfield(max_length = 254, default='https://outlook.office365.com/api/v1.0/me/messages/{0}') id_email = models.charfield(max_length = 254,unique=false) subject = models.textfield() body_content = models.textfield() body_type = models.textfield() importance = models.charfield(max_length = 254) hasattachments = models.booleanfield(default=false) parentfolderid = models.charfield(max_length = 254) e_from = models.textfield() sender = models.textfield() conversationid = models.textfield() categories = models.textfield() datetimesent = models.datetimefield() datetimereceived = models.datetimefield()  status = models.charfield(max_length=2, choices=initialmessage_status, default='p') claim = models.onetoonefield(claim, null=true, blank=true, default=none)  def load_json(self):     m_json = json.loads(self.json)      try:         email = initialmessage.objects.get(id_email = m_json['id'])     except initialmessage.doesnotexist:         email = none      if email none:         self.id_email = m_json['id']         self.subject = m_json['subject']         self.body_content = m_json['body']['content']         self.body_type = m_json['body']['contenttype']         self.importance = m_json['importance']         self.hasattachments = m_json['hasattachments']         self.parentfolderid = m_json['parentfolderid']         self.e_from = m_json['from']         self.sender = m_json['sender']         self.conversationid = m_json['conversationid']         self.categories = m_json['categories']         self.datetimesent = m_json['datetimesent']         self.datetimereceived = m_json['datetimereceived']         self.save()     else:         m_json = 'duplicated'     return m_json

and code i'm using save each new email:

log.debug('fetching messages.')     response = requests.get(self.inbox_url,auth=self.auth,params={'$filter':self.filters})     log.info('response o365: %s', str(response))     message in response.json()['value']:         m = initialmessage(json = json.dumps(message)).load_json()     log.debug('all messages retrieved , put in list.')     return true

have ideas? help!


Comments

Post a Comment

Popular posts from this blog

python - pip install -U PySide error -

-
does know how avoid following error when running pip install -u pyside per official website instructions here: https://pypi.python.org/pypi/pyside/#installing-pyside-on-a-mac-os-x-system note have done brew install qt successfully. you using pip version 7.0.3, version 7.1.2 available. should consider upgrading via 'pip install --upgrade pip' command. collecting pyside using cached pyside-1.2.4.tar.gz installing collected packages: pyside running setup.py install pyside complete output command /applications/anaconda/bin/python -c "import setuptools, tokenize;__file__='/private/var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-build-cpxemt/pyside/setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record /var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-0r7hri-record/install-record.txt --single-version-externally-managed --compile: ...
Read more

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

-
simple question: i'm trying initialize array within c++ class declaration: using namespace std; #include <string> class myclass{ public: string myarray[] = {"a","b","c"}; }; and i'm getting error: error: brace-enclosed initializer not allowed here before ‘{’ token no, without complied c++11 compiler, cannot initialize member array in declaration. have initialize array member in constructor. , don't use open array if know number of elements initialize array.
Read more

apache - setting document root in antoher partition on ubuntu -

-
i place apache document root inside partition of ubuntu hard drive, keep getting forbidden message, when place home directory woking find, how be? group or owner affected ? here mysite.conf , apache2.conf when place document root in home folder (working) #site-available/mysite.conf documentroot /home/jono/www #/etc/apache2/apache2.conf <directory /home/jono/www/> options indexes followsymlinks allowoverride none require granted </directory> bu when change document root partition keep getting forbidden messasge #site-available/mysite.conf documentroot /media/jono/website_data/www #/etc/apache2/apache2.conf <directory /media/jono/website_data/www/> options indexes followsymlinks allowoverride none require granted </directory> is owner/group access affected ? or there problem ? at last it's working, have grant access www:data accesing whole directory @mark-b, using chown -r www-data:www-data whole directory is...
Read more