BUG | Different sorting order for different columns (ASC, DESC)

[v1a0]

Not supporting different sorting order for different columns.

Example log:

expected = self.db.execute('SELECT id, firstName FROM "employee" ORDER BY firstName ASC, surname DESC')

        self.assertEqual(
            expected,
            self.db['employee'].select(
                SELECT=['id', 'firstName'],
                ORDER_BY=['firstName', 'ASC', 'surname', 'DESC']
            )
        )

# sqlite3.OperationalError: no such column: ASC

Generated script

SELECT id, firstName FROM "employee"  ORDER BY firstName, ASC, surname, DESC
                                                        ^             ^
                                                       [!]           [!]

How script have to look like

SELECT id, firstName FROM "employee"  ORDER BY firstName ASC, surname DESC

Version:

sqllex v0.2.0.5

[v1a0]

Fixed since v0.2.0.6