From 3a4a6892ae869d29be6b18f7408979f497077227 Mon Sep 17 00:00:00 2001 From: Sofia Papagiannaki Date: Wed, 2 Nov 2011 17:49:45 +0200 Subject: [PATCH] Change path type from blob to varchar Refs #1553 --- pithos/backends/lib/sqlalchemy/node.py | 7 ++----- 1 file changed, 2 insertions(+), 5 deletions(-) diff --git a/pithos/backends/lib/sqlalchemy/node.py b/pithos/backends/lib/sqlalchemy/node.py index e705140..76341c8 100644 --- a/pithos/backends/lib/sqlalchemy/node.py +++ b/pithos/backends/lib/sqlalchemy/node.py @@ -117,11 +117,8 @@ class Node(DBWorker): onupdate='CASCADE'), autoincrement=False)) path_length = 2048 - path_length_in_bytes = path_length * 4 - columns.append(Column('path', Text(path_length_in_bytes), default='', nullable=False)) + columns.append(Column('path', String(path_length), default='', nullable=False)) self.nodes = Table('nodes', metadata, *columns, mysql_engine='InnoDB') - # place an index on path - #Index('idx_nodes_path', self.nodes.c.path) #create policy table columns=[] @@ -184,7 +181,7 @@ class Node(DBWorker): insp = Inspector.from_engine(self.engine) indexes = [elem['name'] for elem in insp.get_indexes('nodes')] if 'idx_nodes_path' not in indexes: - explicit_length = '(%s)' %path_length_in_bytes if self.engine.name == 'mysql' else '' + explicit_length = '(%s)' %path_length if self.engine.name == 'mysql' else '' s = text('CREATE INDEX idx_nodes_path ON nodes (path%s)' %explicit_length) self.conn.execute(s).close() -- 1.7.10.4