SQL error raised when SQL keywords are used in collection or field name

[pekeq]

SQL error raised when SQL keywords are used in collection or field name.

import unittest
import nosqlite

class Test(unittest.TestCase):
    def setUp(self):
        self.client = nosqlite.Client('.')
        self.database = self.client.memory
        self.collection = self.database.index

    def test_keyword_escape(self):
        collection = self.database.index

        data = {'index':'index'}

        # insert
        collection.insert(data)

        # find
        self.assertDictEqual(data, collection.find_one(index='index'))
        self.assertDictEqual(data, collection.find_one(index='index', fields=["index"]))

        # update
        collection.update(data, index='index')

        # rename
        collection.rename('table')
        collection.rename('index')

        # copy
        collection.copy('create')

        # delete
        collection.delete(index='index')
        collection.delete()