Support for BigAutoField

[hongrich]

1.2 added BigIntegerField, but there is still no support for using bigint as auto increment primary key. Could there be an official version of BigAutoField?

Reference of various attempts over the years:

​http://djangosnippets.org/snippets/1244/

​http://code.djangoproject.com/ticket/9625

​http://code.djangoproject.com/ticket/13774

[maaatt]

In the meantime, it suffices to use a standard AutoField and hack the database like so:

In the table in question, alter the field like so: ALTER TABLE [table_name] ALTER COLUMN [field_name] [data_type], where [data_type] is one of the following:

MySQL: bigint AUTO_INCREMENT
Oracle: NUMBER(19)
PostgreSQL: bigserial
SQLite: integer

For every foreign key pointing to your field, you will also need to alter the column, but with these data types:

MySQL: bigint
Oracle: NUMBER(19)
PostgreSQL: bigint
SQLite: integer

This is a pain, but you only need to do it when creating tables, once. On the other hand, users shouldn't have to hack the database for such a simple feature, in my opinion. It would be super-cool if 1.3 included a fully-functional BigAutoField.

[russellm]

Of course, this can be easily handled as an external field definition, but given that BigInteger is in trunk, I suppose it makes sense for there to be a BigAutoField too.

[mmcnickle]

Adds BigAutoField as a new field type, with documentation.

[diabeteman]

Hello guys,

Since 1.4 is to be released soon™, could this feature be integrated into it? I looked in the trunk and did not find it. It shouldn't have much impact on anything.

I could perform the integration of the patch proposed by mmcnickle, but since I'm new here, I'm not sure if I can :)

Thanks!!! Django is a wonderfull piece of software o/

[akaariai]

#18201 asked for tinyint and smallint based AutoFields. If bigint based fields is added in this ticket, it would make sense to add smallint based AutoField, too.

[jacob]

#20001 has an alternate patch.

[jamercee]

BigAutoField patch file.

[jamercee]

This week we upgraded to from 1.3 -> 1.5, and discovered BigAutoField was not yet included in Django. I know this issue has been referenced in a number of tickets over the years. In Django 1.3, we went with the mmcnickle approach discussed in this ticket, but found this difficult to merge into 1.5.

This time, we went with the approach approach suggested by pzinovkin in ticket 56 (https://code.djangoproject.com/attachment/ticket/56/56_bigint.diff). It required tweaking to get it to work cleanly with 1.5

Attached are patches derived from a git clone this morning.

[clintonb]

What needs to be done to move this patch to completion and integration?

[anonymous]

Someone from a big corporation that uses django to request it

[aaugustin]

Judging by the ticket's flags, tests need to be written (at least).

[xsanch@…]

Replying to jamercee:

This week we upgraded to from 1.3 -> 1.5, and discovered BigAutoField was not yet included in Django. I know this issue has been referenced in a number of tickets over the years. In Django 1.3, we went with the mmcnickle approach discussed in this ticket, but found this difficult to merge into 1.5.

This time, we went with the approach approach suggested by pzinovkin in ticket 56 (https://code.djangoproject.com/attachment/ticket/56/56_bigint.diff). It required tweaking to get it to work cleanly with 1.5

Attached are patches derived from a git clone this morning.

I tried to apply the patch to my 1.5 Django release:

patch -p1 --dry-run -r /var/tmp/reject.txt < bigauto.diff
patching file django/db/backends/init.py
Hunk #1 succeeded at 901 (offset -154 lines).
patching file django/db/backends/mysql/creation.py
Hunk #1 FAILED at 7.
1 out of 1 hunk FAILED -- saving rejects to file /var/tmp/reject.txt
patching file django/db/backends/oracle/creation.py
Hunk #1 FAILED at 17.
1 out of 1 hunk FAILED -- saving rejects to file /var/tmp/reject.txt
patching file django/db/backends/postgresql_psycopg2/creation.py
Hunk #1 FAILED at 11.
1 out of 1 hunk FAILED -- saving rejects to file /var/tmp/reject.txt
patching file django/db/backends/sqlite3/base.py
Hunk #1 succeeded at 214 (offset -34 lines).
patching file django/db/backends/sqlite3/creation.py
Hunk #1 FAILED at 9.
1 out of 1 hunk FAILED -- saving rejects to file /var/tmp/reject.txt
patching file django/db/models/fields/init.py
Hunk #1 succeeded at 213 (offset -2 lines).
Hunk #2 succeeded at 240 (offset -2 lines).
Hunk #3 succeeded at 531 (offset -8 lines).
Hunk #4 succeeded at 1158 (offset -8 lines).
Hunk #5 succeeded at 1174 (offset -8 lines).
patching file django/db/models/fields/related.py
Hunk #1 succeeded at 1092 (offset -21 lines).
patching file docs/ref/models/fields.txt
Hunk #1 FAILED at 331.
1 out of 1 hunk FAILED -- saving rejects to file /var/tmp/reject.txt

The version of Django is 1.5.0. Could someone tell me what am I doing wrong ?

Thanks,

Jorge