private int LoadInfoDB(TokenGitHubInfo inf, bool truncate) { DbOper dbo = new DbOper(); if (truncate) { dbo.TruncateTables(); } dbo.LoadRoot(inf.CoinID, inf.Symbol, inf.GitHubRoot, inf.GitHubLeadPrj, inf.ReposNumber, inf.Followers, inf.CreatedAt, inf.UpdatedAt, inf.ErrNum.ToString(), inf.ErrMes, inf.Url); if (dbo.ErrNum > 0) { intErr = dbo.ErrNum; strErr = dbo.ErrMes; dbo.CloseConn(); return(intErr); } if (inf.ErrNum > 0) { return(intErr); } dbo.LoadHithubInfoTable("RepoInfo", "repoinfo.txt"); if (dbo.ErrNum > 0) { intErr = dbo.ErrNum; strErr = dbo.ErrMes; dbo.CloseConn(); return(intErr); } dbo.LoadHithubInfoTable("ContribInfo", "contribinfo.txt"); if (dbo.ErrNum > 0) { intErr = dbo.ErrNum; strErr = dbo.ErrMes; dbo.CloseConn(); return(intErr); } //dbo.CloseConn(); return(intErr); }
private void cmdRepeatCommit_Click(object sender, EventArgs e) { DbOper dbOper = new DbOper(); DataTable dtRepCommits = dbOper.GetCommitsForRepeat(); string coinid = ""; string symbol = ""; string githubroot = ""; string reponame = ""; string repoid = ""; //** Secret Key string strGAuth = ConfigurationManager.AppSettings["gthauth"]; ContribInfoCompiler ctrbListComp = null; ContribCommit cbcCommits = null; StringBuilder sbContribCommits = null; string DL = "|"; foreach (DataRow dr in dtRepCommits.Rows) { coinid = dr[0].ToString(); symbol = dr[1].ToString(); githubroot = dr[2].ToString(); repoid = dr[3].ToString(); reponame = dr[4].ToString(); Repo rpRepo = new Repo(); rpRepo.RepoID = repoid; rpRepo.RepoName = reponame; sbContribCommits = new StringBuilder(); ctrbListComp = new ContribInfoCompiler(strGAuth); ctrbListComp.GetContribCommits(rpRepo, githubroot); for (int k = 0; k < rpRepo.Contribs.Count; k++) { cbcCommits = rpRepo.Contribs[k]; if (cbcCommits == null) { continue; } sbContribCommits.Append(coinid + DL + symbol + DL + rpRepo.RepoID + DL + rpRepo.RepoName + DL + cbcCommits.LoginName + DL + cbcCommits.Additions + DL + cbcCommits.Deletions + DL + cbcCommits.Commits + DL + cbcCommits.CommTime + DL + cbcCommits.ErrNum.ToString() + DL + cbcCommits.ErrMes + DL + cbcCommits.Cnt.ToString() + DL + cbcCommits.Url + "\n"); } if (sbContribCommits.Length > 0) { dbOper.DeleteRepeatCommits(coinid, symbol, reponame); if (dbOper.ErrNum > 0) { intErr = dbOper.ErrNum; strErr = dbOper.ErrMes; } File.WriteAllText("contribinfo.txt", sbContribCommits.ToString()); dbOper.LoadHithubInfoTable("ContribInfo", "contribinfo.txt"); if (dbOper.ErrNum > 0) { intErr = dbOper.ErrNum; strErr = dbOper.ErrMes; } } Thread.Sleep(3000); } MessageBox.Show("Success!"); }
private void cmdRunAll_Click(object sender, EventArgs e) { int smallset = 0; DbOper dbo = new DbOper(); if (chkClean.Checked) { dbo.TruncateTables(); } if (chkSmall.Checked) { smallset = 1; } DataTable dtCoins = dbo.GetCoinsForGitHub(smallset); //** Secret Key string strGAuth = ConfigurationManager.AppSettings["gthauth"]; TokenGitHubInfo inf = null; ProjectInfoBuilder infoBuild = new ProjectInfoBuilder(strGAuth); RepoListCompiler repListComp = new RepoListCompiler(strGAuth); ContribInfoCompiler ctrbListComp = new ContribInfoCompiler(strGAuth); ProjectsLoader ldPrj = new ProjectsLoader(); Repo rpRep = null; List <Repo> lstRepos = null;; string lprj = ""; foreach (DataRow dr in dtCoins.Rows) { lprj = dr[3].ToString().Replace("/", ""); if (lprj.Length > 20) { lprj = "-"; } if (lprj.Equals("")) { lprj = "-"; } inf = infoBuild.GetProjectInfo(dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), lprj); //** Get Repo List repListComp.GetRepoList(inf); lstRepos = inf.RepoList; for (int i = 0; i < lstRepos.Count; i++) { rpRep = lstRepos[i]; ctrbListComp.GetContribCommits(rpRep, inf.GitHubRoot); Thread.Sleep(3000); } ldPrj.LoadGitHubInfo(inf, false); //if (ldPrj.LoadGitHubInfo(inf, false) > 0) //{ // //MessageBox.Show(ldPrj.ErrMes); // //continue; //} Thread.Sleep(2000); } MessageBox.Show("Success!"); }