ConDict

Check-in [e03a7f02c8]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:fixed bug in command .info
Timelines: family | ancestors | descendants | both | testing
Files: files | file ages | folders
SHA1:e03a7f02c8e52d8f5647d7f3e01909758d52cc91
User & Date: alzay 2012-10-17 11:10:36
Context
2012-12-05
19:11
add spelling, add bug in utf-8 Leaf check-in: 70ae59edca user: zorro tags: testing
2012-10-17
17:54
merge main functionality Leaf check-in: 45df65e986 user: zorro tags: trunk
11:10
fixed bug in command .info check-in: e03a7f02c8 user: alzay tags: testing
2012-10-16
19:10
done ticket #042743641b check-in: 69bd115d2a user: zorro tags: testing
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to condt.py.

735
736
737
738
739
740
741
742
743
744
745
746
747
748
        result = cur.fetchone()
        print("{0}: {1}".format(*result))
        cur.execute("SELECT COUNT(*) FROM `translate` WHERE `user_id`=(?) GROUP BY `user_id`", (self.user_id,))
        result = cur.fetchone()
        print("There are {0} records in user dictionary".format(result[0]))
        cur.execute("SELECT COUNT(*) FROM `test` WHERE `user_id`=(?) GROUP BY `user_id`", (self.user_id,))
        result = cur.fetchone()
        cur.execute("SELECT COUNT(*) FROM `result` LEFT JOIN `test` WHERE `test`.`user_id`=(?) GROUP BY `user_id`", (self.user_id,))
        results = cur.fetchone()
        print("There are {0} tests, with {1} results".format(result[0], results[0]))
        cur.close()
        return 'info'









|






735
736
737
738
739
740
741
742
743
744
745
746
747
748
        result = cur.fetchone()
        print("{0}: {1}".format(*result))
        cur.execute("SELECT COUNT(*) FROM `translate` WHERE `user_id`=(?) GROUP BY `user_id`", (self.user_id,))
        result = cur.fetchone()
        print("There are {0} records in user dictionary".format(result[0]))
        cur.execute("SELECT COUNT(*) FROM `test` WHERE `user_id`=(?) GROUP BY `user_id`", (self.user_id,))
        result = cur.fetchone()
        cur.execute("SELECT COUNT(`result`.`id`) FROM `result` LEFT JOIN `test` ON (`result`.`test_id`=`test`.`id`) WHERE `test`.`user_id`=(?) GROUP BY `test`.`user_id`", (self.user_id,))
        results = cur.fetchone()
        print("There are {0} tests, with {1} results".format(result[0], results[0]))
        cur.close()
        return 'info'


Changes to db.sqlite.

cannot compute difference between binary files