Getting random row through SQLAlchemy

by

This is very much a database-specific issue.

I know that PostgreSQL, SQLite, MySQL, and Oracle have the ability to order by a random function, so you can use this in SQLAlchemy:

from  sqlalchemy.sql.expression import func, select

select.order_by(func.random()) # for PostgreSQL, SQLite

select.order_by(func.rand()) # for MySQL

select.order_by('dbms_random.value') # For Oracle

Next, you need to limit the query by the number of records you need (for example using .limit()).

Bear in mind that at least in PostgreSQL, selecting random record has severe perfomance issues; here is good article about it.

More Related Contents:

  1. SQLAlchemy: how to filter date field?
  2. Select NULL Values in SQLAlchemy
  3. How to execute raw SQL in Flask-SQLAlchemy app
  4. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  5. sqlalchemy: how to join several tables by one query?
  6. SQLAlchemy: cascade delete
  7. Python, SQLAlchemy pass parameters in connection.execute
  8. Bulk insert with SQLAlchemy ORM
  9. How can I verify Column data types in the SQLAlchemy ORM?
  10. Complex foreign key constraint in SQLAlchemy
  11. How to see the raw SQL queries Django is running?
  12. How to get rows which match a list of 3-tuples conditions with SQLAlchemy
  13. How to execute “left outer join” in SqlAlchemy
  14. python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?
  15. SQLAlchemy Obtain Primary Key With Autoincrement Before Commit
  16. VALUES clause in SQLAlchemy
  17. using sqlalchemy to load csv file into a database
  18. flask sqlalchemy query with keyword as variable
  19. Shuffling a list of objects
  20. How to put parameterized sql query into variable and then execute in Python?
  21. What is the most pythonic way to pop a random element from a list?
  22. SQLAlchemy create_all() does not create tables
  23. Fast arbitrary distribution random sampling (inverse transform sampling)
  24. Flask sqlalchemy many-to-many insert data
  25. A QuerySet by aggregate field value
  26. SQLAlchemy printing raw SQL from create()
  27. What is your favorite solution for managing database migrations in django? [closed]
  28. How to set connection timeout in SQLAlchemy
  29. SQLAlchemy classes across files
  30. How can I achieve a self-referencing many-to-many relationship on the SQLAlchemy ORM back referencing to the same attribute?

Leave a Comment