Add order criterion to identifier in ORDER BY clause (fixes #89).

1 files changed, 7 insertions, 0 deletions

diff --git a/sqlparse/sql.py b/sqlparse/sql.py
index 6fb99c6..7b495a9 100644
--- a/sqlparse/sql.py
+++ b/sqlparse/sql.py
@@ -495,6 +495,13 @@ class Identifier(TokenList):
             return None
         return unicode(next_)
 
+    def get_ordering(self):
+        """Returns the ordering or ``None`` as uppercase string."""
+        ordering = self.token_next_by_type(0, T.Keyword.Order)
+        if ordering is None:
+            return None
+        return ordering.value.upper()
+
 
 class IdentifierList(TokenList):
     """A list of :class:`~sqlparse.sql.Identifier`\'s."""