Python random positive bigint - sql datatype

Question

This question might generate be a very simple answer of, "Yep, that's fine". I'm trying to come up with a simple way to generate a random number from between (inclusive)

1 and 9223372036854775807

Should be easy right? I'm doing this and I think it's working correctly.

import random
print (random.randint(1,9223372036854775807))

My concern is that 9223372036854775807 is the upper bound of BIGINT for the SQL datatype. Does randint have an upper bound like the SQL datatype? Is there some other pythonic way I should be approaching this?

randint() works with long integers, so you should be fine.

SamAtWork
– SamAtWork

2018-06-26 14:03:45 +00:00
Commented Jun 26, 2018 at 14:03 — SamAtWork
– SamAtWork, Commented Jun 26, 2018 at 14:03

masan · Accepted Answer · 2018-06-26 14:37:33Z

1

According to docs.python.org , randint returns a random integer N such that a <= N <= b. Alias for randrange(a, b+1). There's nothing about limits.

Also, in Python 3 the plain int type is unbounded.

So, I think it should be fine.

answered Jun 26, 2018 at 14:37

masan

751 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python random positive bigint - sql datatype

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related