Example #1
0
    def testTopCommitters(self):
        rows = cursor.execute('select * from git_users;')
        self.assertTrue(len(rows.fetchall()) is 0)
        rows = cursor.execute('select * from git_commits;')
        self.assertTrue(len(rows.fetchall()) is 0)
        rows = cursor.execute('select * from git_repos;')
        self.assertTrue(len(rows.fetchall()) is 0)

        for i in xrange(1, 10):
            cursor.execute("insert into git_users(id,login) values(?,?)",
                           (i, hex(i)))
            cursor.execute("insert into git_repos(id,name) values(?,?)",
                           (i * 100, hex(i * 100)))
            k = (i * 100) / (i + 1)
            for j in xrange(1, k):
                cursor.execute(
                    "insert into git_commits(sha,committer_id,repo_id,datetime) values(?,?,?,?)",
                    (hex(j + i * k), i, i * 100, datetime.now()))
        generate_top_committers_report()

        with open(
                os.path.join(os.environ.get('reports_path'),
                             'top_committers.csv')) as csvreport:
            csvreader = csv.reader(csvreport)
            csvreader.next()
            for row in csvreader:
                original_value = int(row[1], 16)
                computed_value = (original_value * 100 /
                                  (original_value + 1)) - 1
                self.assertTrue(computed_value == int(row[2]))
Example #2
0
  def testTopCommitters(self):
    rows= cursor.execute('select * from git_users;');
    self.assertTrue(len(rows.fetchall()) is 0)
    rows= cursor.execute('select * from git_commits;');
    self.assertTrue(len(rows.fetchall()) is 0)
    rows= cursor.execute('select * from git_repos;');
    self.assertTrue(len(rows.fetchall()) is 0)

    for i in xrange(1,10):
      cursor.execute("insert into git_users(id,login) values(?,?)", (i, hex(i)))
      cursor.execute("insert into git_repos(id,name) values(?,?)", (i*100, hex(i*100)))
      k=(i*100)/(i+1)
      for j in xrange(1,k):
        cursor.execute("insert into git_commits(sha,committer_id,repo_id,datetime) values(?,?,?,?)", (hex(j+i*k),i,i*100,datetime.now()))
    generate_top_committers_report()

    with open(os.path.join(os.environ.get('reports_path'), 'top_committers.csv')) as csvreport:
      csvreader = csv.reader(csvreport)
      csvreader.next()
      for row in csvreader:
        original_value = int(row[1],16)
        computed_value = (original_value*100/(original_value+1)) - 1
        self.assertTrue(computed_value == int(row[2]))
Example #3
0
 def tearDown(self):
   cursor.execute('drop table git_users;')
   cursor.execute('drop table git_repos;')
   cursor.execute('drop table git_commits;')
Example #4
0
 def tearDown(self):
     cursor.execute('drop table git_users;')
     cursor.execute('drop table git_repos;')
     cursor.execute('drop table git_commits;')