Synnefo

from sqlalchemy import Table, Column, String, Integer, MetaData, ForeignKey

from sqlalchemy.sql import select, and_

from sqlalchemy.schema import Index

from sqlalchemy.exc import NoSuchTableError

from dbworker import DBWorker

    columns.append(Column('key', Integer, primary_key=True,

                          autoincrement=False))

    columns.append(Column('value', String(256), primary_key=True))

    metadata.create_all(engine)

    return metadata.sorted_tables

#

#         s = select([self.xfeatures.c.path, self.xfeatures.c.feature_id])

#         s = s.where(self.xfeatures.c.path <= path)

#         s = s.order_by(desc(self.xfeatures.c.path))

#         r = self.conn.execute(s)

#         l = r.fetchall()

    def xfeature_destroy_bulk(self, paths):

        """Destroy features and all their key, value pairs."""

        if not paths:

            return

        s = self.xfeatures.delete().where(self.xfeatures.c.path.in_(paths))