Re: DJango 1.8 test case fails with IntegrityError error

2015-09-21 Thread Jose Paul 
Hi Simon,

I am working on this support .

But the test case generates sql with null values for non null fields.

We cannot change the model ,because this is part of python ,i believe.

The problem might be the schema generated for the table from the model .
I can see only one field as non null in DB2.

Is this different from other database?.

Thanks,
Jose

On Monday, September 21, 2015 at 8:37:51 PM UTC+5:30, Simon Charette wrote:
>
> Hi Jose,
>
> I looks like ibm_db_django doesn't support Django 1.6+ yet 
> .
>
> Simon
>
> Le lundi 21 septembre 2015 07:14:39 UTC-4, Jose Paul a écrit :
>>
>> I am trying to run DJango 1.8 test cases with DB2
>>
>> Several insert statement fails 
>>
>> Here is the insert command generated by test case.
>>
>> INSERT INTO "AUTH_USER" ("PASSWORD", "LAST_LOGIN", "IS_SUPERUSER", 
>> "USERNAME", "FIRST_NAME", "LAST_NAME", "EMAIL", "IS_STAFF", "IS_ACTIVE", 
>> "DATE_JOINED") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
>>
>> Value : (None, None, True, u'superuser', None, None, None, False, True, 
>> u'2015-09-17 12:31:09.562000')
>>
>> ibm_db_dbi::IntegrityError: Statement Execute Failed: [IBM][CLI 
>> Driver][DB2/NT] SQL0407N  Assignment of a NULL value to a NOT NULL column 
>> "TBSPACEID=2, TABLEID=24, COLNO=1" is not allowed.  SQLSTATE=23502\r 
>> SQLCODE=-407
>>
>>
>> Except last_login none of the field are nullable .
>> But still DJango testcase generate insert statement  as above and pass 
>> None as value which fails .
>>
>> Why this happens ?.
>> Why correct non null values are not generated for non null field .
>>
>> Please help .Thanks ,
>> Jose
>>
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/0a3e908b-13ee-43f0-a7d5-57769472c6fb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: DJango 1.8 test case fails with IntegrityError error

2015-09-21 Thread Simon Charette 
Hi Jose,

I looks like ibm_db_django doesn't support Django 1.6+ yet 
.

Simon

Le lundi 21 septembre 2015 07:14:39 UTC-4, Jose Paul a écrit :
>
> I am trying to run DJango 1.8 test cases with DB2
>
> Several insert statement fails 
>
> Here is the insert command generated by test case.
>
> INSERT INTO "AUTH_USER" ("PASSWORD", "LAST_LOGIN", "IS_SUPERUSER", 
> "USERNAME", "FIRST_NAME", "LAST_NAME", "EMAIL", "IS_STAFF", "IS_ACTIVE", 
> "DATE_JOINED") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
>
> Value : (None, None, True, u'superuser', None, None, None, False, True, 
> u'2015-09-17 12:31:09.562000')
>
> ibm_db_dbi::IntegrityError: Statement Execute Failed: [IBM][CLI 
> Driver][DB2/NT] SQL0407N  Assignment of a NULL value to a NOT NULL column 
> "TBSPACEID=2, TABLEID=24, COLNO=1" is not allowed.  SQLSTATE=23502\r 
> SQLCODE=-407
>
>
> Except last_login none of the field are nullable .
> But still DJango testcase generate insert statement  as above and pass 
> None as value which fails .
>
> Why this happens ?.
> Why correct non null values are not generated for non null field .
>
> Please help .Thanks ,
> Jose
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/414d880d-d849-496a-9f96-a03a51d9baae%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: DJango 1.8 test case fails with IntegrityError error

2015-09-21 Thread Jose Paul 


Please see the call stack too ,for one of the error


"C:\Users\IBM_ADMIN\PythonWorkspace\DJangoTestCases\src\DJangoTestCases\tests\admin_filters\tests.py",
 
line 229, in setUp

self.alfred = User.objects.create_user('alfred', 'alf...@example.com')

File "C:\Python27\lib\site-packages\django\contrib\auth\models.py", line 
187, in create_user

**extra_fields)

File "C:\Python27\lib\site-packages\django\contrib\auth\models.py", line 
182, in _create_user

user.save(using=self._db)

File "C:\Python27\lib\site-packages\django\db\models\base.py", line 710, in 
save

force_update=force_update, update_fields=update_fields)

File "C:\Python27\lib\site-packages\django\db\models\base.py", line 738, in 
save_base

updated = self._save_table(raw, cls, force_insert, force_update, using, 
update_fields)

File "C:\Python27\lib\site-packages\django\db\models\base.py", line 822, in 
_save_table

result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)

File "C:\Python27\lib\site-packages\django\db\models\base.py", line 861, in 
_do_insert

using=using, raw=raw)

File "C:\Python27\lib\site-packages\django\db\models\manager.py", line 127, 
in manager_method

return getattr(self.get_queryset(), name)(*args, **kwargs)

File "C:\Python27\lib\site-packages\django\db\models\query.py", line 920, 
in _insert

return query.get_compiler(using=using).execute_sql(return_id)

File "C:\Python27\lib\site-packages\django\db\models\sql\compiler.py", line 
974, in execute_sql

cursor.execute(sql, params)

File "C:\Python27\lib\site-packages\django\db\backends\utils.py", line 67, 
in execute

return self.cursor.execute(sql, params)

File 
"c:\python27\lib\site-packages\ibm_db_django-1.0.7-py2.7.egg\ibm_db_django\pybase.py",
 
line 165, in execute

six.reraise(utils.IntegrityError, utils.IntegrityError( *tuple( six.PY3 and 
e.args or ( e._message, ) ) ), sys.exc_info()[2])

File 
"c:\python27\lib\site-packages\ibm_db_django-1.0.7-py2.7.egg\ibm_db_django\pybase.py",
 
line 161, in execute

return super( DB2CursorWrapper, self ).execute( operation, parameters )

File 
"c:\python27\lib\site-packages\ibm_db-2.0.5.1-py2.7.egg\ibm_db_dbi.py", 
line 1335, in execute

self._execute_helper(parameters)

File 
"c:\python27\lib\site-packages\ibm_db-2.0.5.1-py2.7.egg\ibm_db_dbi.py", 
line 1247, in _execute_helper

raise self.messages[len(self.messages) - 1]

IntegrityError: Statement Execute Failed: [IBM][CLI Driver][DB2/NT] 
SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=2, 
TABLEID=24, COLNO=5" is not allowed. SQLSTATE=23502\r SQLCODE=-407




On Monday, September 21, 2015 at 4:44:39 PM UTC+5:30, Jose Paul wrote:
>
> I am trying to run DJango 1.8 test cases with DB2
>
> Several insert statement fails 
>
> Here is the insert command generated by test case.
>
> INSERT INTO "AUTH_USER" ("PASSWORD", "LAST_LOGIN", "IS_SUPERUSER", 
> "USERNAME", "FIRST_NAME", "LAST_NAME", "EMAIL", "IS_STAFF", "IS_ACTIVE", 
> "DATE_JOINED") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
>
> Value : (None, None, True, u'superuser', None, None, None, False, True, 
> u'2015-09-17 12:31:09.562000')
>
> ibm_db_dbi::IntegrityError: Statement Execute Failed: [IBM][CLI 
> Driver][DB2/NT] SQL0407N  Assignment of a NULL value to a NOT NULL column 
> "TBSPACEID=2, TABLEID=24, COLNO=1" is not allowed.  SQLSTATE=23502\r 
> SQLCODE=-407
>
>
> Except last_login none of the field are nullable .
> But still DJango testcase generate insert statement  as above and pass 
> None as value which fails .
>
> Why this happens ?.
> Why correct non null values are not generated for non null field .
>
> Please help .Thanks ,
> Jose
>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/7d38d707-138b-4acc-baab-089ae089c228%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

DJango 1.8 test case fails with IntegrityError error

2015-09-21 Thread Jose Paul 
I am trying to run DJango 1.8 test cases with DB2

Several insert statement fails 

Here is the insert command generated by test case.

INSERT INTO "AUTH_USER" ("PASSWORD", "LAST_LOGIN", "IS_SUPERUSER", 
"USERNAME", "FIRST_NAME", "LAST_NAME", "EMAIL", "IS_STAFF", "IS_ACTIVE", 
"DATE_JOINED") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)

Value : (None, None, True, u'superuser', None, None, None, False, True, 
u'2015-09-17 12:31:09.562000')

ibm_db_dbi::IntegrityError: Statement Execute Failed: [IBM][CLI 
Driver][DB2/NT] SQL0407N  Assignment of a NULL value to a NOT NULL column 
"TBSPACEID=2, TABLEID=24, COLNO=1" is not allowed.  SQLSTATE=23502\r 
SQLCODE=-407


Except last_login none of the field are nullable .
But still DJango testcase generate insert statement  as above and pass None 
as value which fails .

Why this happens ?.
Why correct non null values are not generated for non null field .

Please help .Thanks ,
Jose

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/c6f5ed39-4084-4a45-9b97-24b680b45ebc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.