summaryrefslogtreecommitdiff
path: root/tools/migrate_search.py
diff options
context:
space:
mode:
authorroot <root@lalalizard.com>2012-12-21 13:52:25 -0500
committerroot <root@lalalizard.com>2012-12-21 13:52:25 -0500
commitdb1e4fb6a16bec535337916cf5578f2cb0097423 (patch)
tree1cb1efbf6fe70bb176d1a2d58fa8d4d5343d03ad /tools/migrate_search.py
parentabb7bcf38ed21856c2fdadc3f4bccfc37ad8c4c3 (diff)
migration tools fix
Diffstat (limited to 'tools/migrate_search.py')
-rwxr-xr-xtools/migrate_search.py20
1 files changed, 3 insertions, 17 deletions
diff --git a/tools/migrate_search.py b/tools/migrate_search.py
index 93c4070..37ebe10 100755
--- a/tools/migrate_search.py
+++ b/tools/migrate_search.py
@@ -87,39 +87,25 @@ class MigrateDB(DB):
if __name__ == '__main__':
- admin = User.objects.get(username='admin')
-
db = MigrateDB()
db.connect()
# Migrate sj_search_log table
- sj_user = list(db.get_sj_user_table())
- map_user = {}
- for row in sj_user:
- try:
- user = User.objects.get(username=row['username'])
- except User.DoesNotExist:
- print "ERROR in users"
-
- map_user[row['id']] = user.pk
-
sj_search_log = list(db.get_sj_search_log_table())
for row in sj_search_log:
- user = admin
- pk = map_user.get(row['userid'], 0)
- if pk:
- user = User.objects.get(pk=pk)
+ user = User.objects.get(pk=row['userid'])
try:
sjsearch = SJSearch.objects.get(
user=user,
datetime=datetime.fromtimestamp(row['date'])
)
- print 'SJ Search Log Found'
+ print 'searchlog "%d" exist' % row['date']
except SJSearch.DoesNotExist:
sjsearch = SJSearch(
user=user,
datetime=datetime.fromtimestamp(row['date'])
)
+ print 'searchlog "%d" created' % row['date']
sjsearch.settings = dict(
url=row['url'],
count=row['count'],