columns=[]
columns.append(Column('feature_id', Integer, primary_key=True))
columns.append(Column('path', String(2048)))
- self.xfeatures = Table('xfeatures', metadata, *columns, mysql_engine='InnoDB', mysql_charset='utf8')
+ self.xfeatures = Table('xfeatures', metadata, *columns, mysql_engine='InnoDB')
# place an index on path
Index('idx_features_path', self.xfeatures.c.path)
columns.append(Column('key', Integer, primary_key=True,
autoincrement=False))
columns.append(Column('value', String(255), primary_key=True))
- self.xfeaturevals = Table('xfeaturevals', metadata, *columns, mysql_engine='InnoDB', mysql_charset='utf8')
+ self.xfeaturevals = Table('xfeaturevals', metadata, *columns, mysql_engine='InnoDB')
metadata.create_all(self.engine)
return [inherited]
s = select([self.xfeatures.c.path, self.xfeatures.c.feature_id])
- s = s.where(and_(self.xfeatures.c.path.like(path + '%'),
+ s = s.where(and_(self.xfeatures.c.path.like(self.escape_like(path) + '%', escape='\\'),
self.xfeatures.c.path != path))
s = s.order_by(self.xfeatures.c.path)
r = self.conn.execute(s)