Changeset 204

Timestamp:

10/29/06 20:39:56 (2 years ago)

Author:

ug

Message:

Implemented libkombiloAPI#Playerlist.

Files:

• 06/libkombilo/search.cc (modified) (3 diffs)
• 06/libkombilo/search.h (modified) (5 diffs)
• 06/libkombilo/testsearch.py (modified) (1 diff)

06/libkombilo/search.cc

@@ -3489 +3489 @@
-  if (rc) throw DBError();
-
- // those two we need in any case
+
-  sql += format1;
-  sql += " from games order by ";
@@ -3502 +3502 @@
-  // SQLITE_ERROR may occur since table might not yet exist
-  
+  readPlayersList();
+
-  if (rc == SQLITE_OK && !readDBs) {
-    for(unsigned int a=0; a < 20*boardsizes.size(); a++) {
@@ -3926 +3928 @@
-  pl.continuations = new Continuation[pattern.sizeX*pattern.sizeY];
-  delete searchOptions;
+}
+
+
+int GameList::plSize() {
+  return pl.size();
+}
+
+string GameList::plEntry(int i) {
+  if (i < 0 || i >= pl.size()) return "";
+  else return pl[i];
+}
+
+int rpl_callback(void *pl, int argc, char **argv, char **azColName) {
+  if (!argc) return 1;
+  ((vector<string>*)pl)->push_back(string(argv[0]));
+  return 0;
+}
+
+void GameList::readPlayersList() throw(DBError) {
+  if (pl.size()) pl = vector<string>();
+  int rc = sqlite3_exec(db, "select p from (select pw p from games union select pb p from games) order by lower(p)", rpl_callback, &pl, 0);
+  if (rc != SQLITE_OK) throw DBError();
-}
-

06/libkombilo/search.h

@@ -584 +584 @@
-    Continuation* continuations;
-
+    // ----------------------------------------------------------------------------
-    // the following methods provide the user interface
-
+    // ------- constructor --------------------------------------------------------
-    // p_options will be copied by GameList, so the caller has to free the pointer
-    GameList(char* DBNAME, std::string ORDERBY="", std::string FORMAT="", ProcessOptions* p_options=0) throw(DBError);
-
+    // ------- processing SGF games (to populate the db) --------------------------
-    void start_processing(int PROCESSVARIATIONS=-1) throw(DBError);
-    int process(const char* sgf, const char* path, const char* fn, const char* DBTREE = 0) throw(SGFError,DBError);
-    void finalize_processing() throw(DBError);
-    
+    // ------- pattern search -----------------------------------------------------
-    // options is copied in the search method (if != 0), so the caller has to free the pointer
-    void search(Pattern& pattern, SearchOptions* options = 0) throw(DBError);
@@ -598 +602 @@
-    Continuation lookupContinuation(char x, char y);
-
+    // ------- game info search ---------------------------------------------------
-    void gisearch(char* sql, int complete=0) throw(DBError);
-
+    // ------- tagging ------------------------------------------------------------
-    void tagsearch(int tag) throw(DBError);
-    void setTag(int tag, int start=0, int end=0) throw(DBError);
@@ -605 +611 @@
-    std::vector<int> getTags(int i, int tag=0) throw(DBError); // note the order of arguments!
-
+    // ------- misc ---------------------------------------------------------------
-    void reset(); // reset currentList to all
-    void resetFormat(std::string ORDERBY="", std::string FORMAT="");
@@ -615 +622 @@
-    std::string getCurrentProperty(int i, std::string tag) throw (DBError);
-
+    // ------- list of all players -------------------------------------------------
+    int plSize();
+    std::string plEntry(int i);
+
+    // -----------------------------------------------------------------------------
-    // internal methods (called from the algorithm classes)
-    ~GameList();
@@ -642 +654 @@
-    std::vector<std::string>* SGFtags;
-    std::string sql_ins_rnp; // sql string to insert root node properties
+    std::vector<std::string> pl; // list of all players
+    void readPlayersList() throw(DBError);
-};
-

06/libkombilo/testsearch.py

@@ -53 +53 @@
-print gl.currentEntryAsString(gl.size()-1)
-print gl.getCurrentProperty(gl.size()-1, 'PW'),  gl.getSGF(gl.size()-1)
+
-gl.reset()
+gl.tagsearch(HANDI_TAG)
+print gl.size(), 'handicap games'
-
+print gl.plSize(), 'players in the whole database.'
+for i in range(100,110):
+    print 'Player %d: %s' % (i, gl.plEntry(i))
+