U++ forum: Welcome to the forum

void vegadb::SetPairingNumbers(int n, int arr_N[], Vector<int> ids) { int i, id, idp, np=1; Sql sqlteam(sqliteVT); Sql sqlplayer(sqliteVT); Sql sqlp(sqliteVT); for(i=0; i<n; i++) { id = arr_N[i]; sqlteam.Execute("update TEAMS set N=? where ID=?", i+1, ids[i]); sqlplayer.Execute("SELECT ID FROM PLAYERS WHERE TEAM_ID=? ORDER BY BOARD ASC", id); //retrieve players of team id by boards while (sqlplayer.Fetch()) { idp = (int) (sqlplayer[0]); sqlp.Execute("update PLAYERS set N=? where ID=?", np++, idp); //set pairing number to the player idp } } }

for(i=0; i<n; i++) { id = arr_N[i]; { TIMING("team-update"); sqlteam.Execute("update TEAMS set N=? where ID=?", i+1, ids[i]); } { TIMING("player-select"); sqlplayer.Execute("SELECT ID FROM PLAYERS WHERE TEAM_ID=? ORDER BY BOARD ASC", id); }//retrieve players of team id by boards while (sqlplayer.Fetch()) { idp = (int) (sqlplayer[0]); TIMING("player-update"); sqlp.Execute("update PLAYERS set N=? where ID=?", np++, idp); //set pairing number to the player idp } }

TABLE_(TEAMS) INT (ID) PRIMARY_KEY AUTO_INCREMENT INT_ (N) STRING_ (NAMET, 30) STRING_ (ORIG, 30) STRING_ (REGION, 30) STRING_ (FED, 3) INT_ (RTG) INT_ (STATUS) END_TABLE TABLE_(PLAYERS) INT (ID) PRIMARY_KEY AUTO_INCREMENT INT_ (TEAM_ID) INDEX INT_ (BOARD) INT (N) STRING (NAME, 30) STRING (FED, 30) STRING_ (BDAY, 10) STRING_ (SEX, 1) STRING_ (CAT, 5) INT_ (IDFIDE) INT_ (RTGFIDE) STRING_ (IDNAT,10) INT_ (RTGNAT) INT_ (K) END_TABLE

void vegadb::SetDatabase(String dbname) { if (sqliteVT.IsOpen()) sqliteVT.Close(); if (!FileExists(dbname)) { if(!sqliteVT.Open( dbname )) { Exclamation("Can't create or open database file"); return; } SQL = sqliteVT; // sqliteVT.SetTrace(); SqlSchema sch(SQLITE3); All_Tables(sch); Sqlite3PerformScript(sch.Upgrade()); Sqlite3PerformScript(sch.Attributes()); } else { if(!sqliteVT.Open( dbname )) { Exclamation("Can't create or open database file"); return; } SQL = sqliteVT; // sqliteVT.SetTrace(); SqlSchema sch(SQLITE3); } SQL.ClearError(); }

String teams = "update TEAMS set N = case ID"; for(i=0; i<n; i++) { teams += Format(" when %i then %i", ids[i], i+1); {TIMING("player-select"); sqlplayer.Execute("SELECT ID FROM PLAYERS WHERE TEAM_ID=? ORDER BY BOARD ASC", arr_N[i]);} String players = "update PLAYERS set N = case ID"; while (sqlplayer.Fetch()) { idp = (int) (sqlplayer[0]); players += Format(" when %i then %i", idp, np++); } {TIMING("players-update"); sqlp.Execute(players); } } {TIMING("teams"); sqlteam.Execute(teams);}

String teams = "update TEAMS set N = case "; for(i=0; i<n; i++) { teams += Format(" when ID=%i then %i", ids[i], i+1 ); {TIMING("player-select"); sqlplayer.Execute("SELECT ID FROM PLAYERS WHERE TEAM_ID=? ORDER BY BOARD ASC", arr_N[i]); } String players = "update PLAYERS set N = case "; while (sqlplayer.Fetch()) { idp = (int) (sqlplayer[0]); players += Format(" when ID=%i then %i", idp, np++); } players += " else N end "; {TIMING("players-update"); sqlp.Execute(players); } } teams += " else N end "; {TIMING("teams");sqlteam.Execute(teams);}

String teams = "update TEAMS set N = case "; String players = "update PLAYERS set N = case "; for(i=0; i<n; i++) { teams += Format(" when ID=%i then %i", ids[i], i+1 ); {TIMING("player-select"); sqlplayer.Execute("SELECT ID FROM PLAYERS WHERE TEAM_ID=? ORDER BY BOARD ASC", arr_N[i]); } while (sqlplayer.Fetch()) { idp = (int) (sqlplayer[0]); players += Format(" when ID=%i then %i", idp, np++); } } players += " else N end "; {TIMING("players-update"); sqlp.Execute(players); } teams += " else N end "; {TIMING("teams");sqlteam.Execute(teams);}

  for (i=0; i<pairs.GetCount(); i++) {
      for (int j=0; j<TD.MaxBoards+2; j++) {t1[j]=0; t2[j]=0;}
      idw = pairs[i].idw;
      idb = pairs[i].idb;
      played =1; //regular game (default)
      if (idb==0 || idw==0) played = 0; //byed game       
	  {RTIMING("save-team"); SQL.Execute("INSERT INTO TEAMROUND (ROUND,BOARD,NW,NB, PLAYED) VALUES(?,?,?,?, ?)", round, i+1, idw, idb, played); }
      Team& team1 = VTeam.Get( idw );
      Team& team2 = VTeam.Get( idb );   
      if (idw) team1.GetPlayerTeam(t1); //get the white players
      if (idb) team2.GetPlayerTeam(t2); //get the white players
      int idTEAMROUND = SQL.GetInsertedId();   
      //save the player pairing
      for (b=1; b<=TD.NBoards; b++) {                
          gameplayed =1; //regular game (default)
          if (t2[b]==0 || t1[b]==0) gameplayed = 0; //byed game       
	      {RTIMING("save-player"); SQL.Execute("INSERT INTO PLAYERROUND (TEAMROUND_ID, ROUND,BOARD,NW,NB,PLAYED) VALUES(?,?,?,?,?, ?)", 
	      				idTEAMROUND, round, b, t1[b], t2[b], gameplayed); }
      }     
  }

  String teamround = "INSERT INTO PLAYERROUND (TEAMROUND_ID, ROUND,BOARD,NW,NB,PLAYED) select 0 as TEAMROUND_ID, 0 as ROUND, 0 as BOARD, 0 as NW, 0 as NB,0 as PLAYED ";
  int npair = pairs.GetCount();  
  for (i=0; i<pairs.GetCount(); i++) {
      for (int j=0; j<TD.MaxBoards+2; j++) {t1[j]=0; t2[j]=0;}
      idw = pairs[i].idw;
      idb = pairs[i].idb;
      played =1; //regular game (default)
      if (idb==0 || idw==0) played = 0; //byed game       
	  SQL.Execute("INSERT INTO TEAMROUND (ROUND,BOARD,NW,NB, PLAYED) VALUES(?,?,?,?, ?)", round, i+1, idw, idb, played);
      Team& team1 = VTeam.Get( idw );
      Team& team2 = VTeam.Get( idb );   
      if (idw) team1.GetPlayerTeam(t1); //get the white players
      if (idb) team2.GetPlayerTeam(t2); //get the white players
      int idTEAMROUND = SQL.GetInsertedId();   
      //save the player pairing
      for (b=1; b<=TD.NBoards; b++) {                
          gameplayed =1; //regular game (default)
          if (t2[b]==0 || t1[b]==0) gameplayed = 0; //byed game       	      				
	  teamround += Format("UNION SELECT %d,%d,%d,%d,%d,%d ", idTEAMROUND, round, b, t1[b], t2[b], gameplayed); 
      }     
  }
  SQL.Execute(teamround);