summaryrefslogtreecommitdiff
path: root/sphinx/websupport/storage/db.py
diff options
context:
space:
mode:
Diffstat (limited to 'sphinx/websupport/storage/db.py')
-rw-r--r--sphinx/websupport/storage/db.py8
1 files changed, 5 insertions, 3 deletions
diff --git a/sphinx/websupport/storage/db.py b/sphinx/websupport/storage/db.py
index 74a3e2b70..54b16f225 100644
--- a/sphinx/websupport/storage/db.py
+++ b/sphinx/websupport/storage/db.py
@@ -11,6 +11,7 @@
"""
from datetime import datetime
+from uuid import uuid4
from sqlalchemy import Column, Integer, Text, String, Boolean, ForeignKey,\
DateTime
@@ -28,7 +29,7 @@ class Node(Base):
"""Data about a Node in a doctree."""
__tablename__ = db_prefix + 'nodes'
- id = Column(Integer, primary_key=True)
+ id = Column(String(32), primary_key=True)
document = Column(String(256), nullable=False)
line = Column(Integer)
source = Column(Text, nullable=False)
@@ -93,7 +94,8 @@ class Node(Base):
return comments
- def __init__(self, document, line, source):
+ def __init__(self, id, document, line, source):
+ self.id = id
self.document = document
self.line = line
self.source = source
@@ -112,7 +114,7 @@ class Comment(Base):
proposal_diff = Column(Text)
path = Column(String(256), index=True)
- node_id = Column(Integer, ForeignKey(db_prefix + 'nodes.id'))
+ node_id = Column(String, ForeignKey(db_prefix + 'nodes.id'))
node = relation(Node, backref="comments")
def __init__(self, text, displayed, username, rating, time,