/[svn]/linuxsampler/trunk/src/network/lscpserver.cpp
ViewVC logotype

Diff of /linuxsampler/trunk/src/network/lscpserver.cpp

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1135 by iliev, Thu Mar 29 09:40:45 2007 UTC revision 1200 by iliev, Thu May 24 14:04:18 2007 UTC
# Line 24  Line 24 
24  #include "lscpserver.h"  #include "lscpserver.h"
25  #include "lscpresultset.h"  #include "lscpresultset.h"
26  #include "lscpevent.h"  #include "lscpevent.h"
 #include "../common/global.h"  
27    
28  #include <fcntl.h>  #include <fcntl.h>
29    
30  #if HAVE_SQLITE3  #if ! HAVE_SQLITE3
31  # include "sqlite3.h"  #define DOESNT_HAVE_SQLITE3 "No database support. SQLITE3 was not installed when linuxsampler was built."
32  #endif  #endif
33    
34  #include "../engines/EngineFactory.h"  #include "../engines/EngineFactory.h"
# Line 81  LSCPServer::LSCPServer(Sampler* pSampler Line 80  LSCPServer::LSCPServer(Sampler* pSampler
80      LSCPEvent::RegisterEvent(LSCPEvent::event_midi_instr_map_info, "MIDI_INSTRUMENT_MAP_INFO");      LSCPEvent::RegisterEvent(LSCPEvent::event_midi_instr_map_info, "MIDI_INSTRUMENT_MAP_INFO");
81      LSCPEvent::RegisterEvent(LSCPEvent::event_midi_instr_count, "MIDI_INSTRUMENT_COUNT");      LSCPEvent::RegisterEvent(LSCPEvent::event_midi_instr_count, "MIDI_INSTRUMENT_COUNT");
82      LSCPEvent::RegisterEvent(LSCPEvent::event_midi_instr_info, "MIDI_INSTRUMENT_INFO");      LSCPEvent::RegisterEvent(LSCPEvent::event_midi_instr_info, "MIDI_INSTRUMENT_INFO");
83        LSCPEvent::RegisterEvent(LSCPEvent::event_db_instr_dir_count, "DB_INSTRUMENT_DIRECTORY_COUNT");
84        LSCPEvent::RegisterEvent(LSCPEvent::event_db_instr_dir_info, "DB_INSTRUMENT_DIRECTORY_INFO");
85        LSCPEvent::RegisterEvent(LSCPEvent::event_db_instr_count, "DB_INSTRUMENT_COUNT");
86        LSCPEvent::RegisterEvent(LSCPEvent::event_db_instr_info, "DB_INSTRUMENT_INFO");
87        LSCPEvent::RegisterEvent(LSCPEvent::event_db_instrs_job_info, "DB_INSTRUMENTS_JOB_INFO");
88      LSCPEvent::RegisterEvent(LSCPEvent::event_misc, "MISCELLANEOUS");      LSCPEvent::RegisterEvent(LSCPEvent::event_misc, "MISCELLANEOUS");
89      LSCPEvent::RegisterEvent(LSCPEvent::event_total_voice_count, "TOTAL_VOICE_COUNT");      LSCPEvent::RegisterEvent(LSCPEvent::event_total_voice_count, "TOTAL_VOICE_COUNT");
90      LSCPEvent::RegisterEvent(LSCPEvent::event_global_info, "GLOBAL_INFO");      LSCPEvent::RegisterEvent(LSCPEvent::event_global_info, "GLOBAL_INFO");
# Line 139  void LSCPServer::EventHandler::TotalVoic Line 143  void LSCPServer::EventHandler::TotalVoic
143      LSCPServer::SendLSCPNotify(LSCPEvent(LSCPEvent::event_total_voice_count, NewCount));      LSCPServer::SendLSCPNotify(LSCPEvent(LSCPEvent::event_total_voice_count, NewCount));
144  }  }
145    
146    #if HAVE_SQLITE3
147    void LSCPServer::DbInstrumentsEventHandler::DirectoryCountChanged(String Dir) {
148        LSCPServer::SendLSCPNotify(LSCPEvent(LSCPEvent::event_db_instr_dir_count, Dir));
149    }
150    
151    void LSCPServer::DbInstrumentsEventHandler::DirectoryInfoChanged(String Dir) {
152        LSCPServer::SendLSCPNotify(LSCPEvent(LSCPEvent::event_db_instr_dir_info, Dir));
153    }
154    
155    void LSCPServer::DbInstrumentsEventHandler::DirectoryNameChanged(String Dir, String NewName) {
156        Dir = "'" + Dir + "'";
157        NewName = "'" + NewName + "'";
158        LSCPServer::SendLSCPNotify(LSCPEvent(LSCPEvent::event_db_instr_dir_info, "NAME", Dir, NewName));
159    }
160    
161    void LSCPServer::DbInstrumentsEventHandler::InstrumentCountChanged(String Dir) {
162        LSCPServer::SendLSCPNotify(LSCPEvent(LSCPEvent::event_db_instr_count, Dir));
163    }
164    
165    void LSCPServer::DbInstrumentsEventHandler::InstrumentInfoChanged(String Instr) {
166        LSCPServer::SendLSCPNotify(LSCPEvent(LSCPEvent::event_db_instr_info, Instr));
167    }
168    
169    void LSCPServer::DbInstrumentsEventHandler::InstrumentNameChanged(String Instr, String NewName) {
170        Instr = "'" + Instr + "'";
171        NewName = "'" + NewName + "'";
172        LSCPServer::SendLSCPNotify(LSCPEvent(LSCPEvent::event_db_instr_info, "NAME", Instr, NewName));
173    }
174    
175    void LSCPServer::DbInstrumentsEventHandler::JobStatusChanged(int JobId) {
176        LSCPServer::SendLSCPNotify(LSCPEvent(LSCPEvent::event_db_instrs_job_info, JobId));
177    }
178    #endif // HAVE_SQLITE3
179    
180    
181  /**  /**
182   * Blocks the calling thread until the LSCP Server is initialized and   * Blocks the calling thread until the LSCP Server is initialized and
# Line 194  int LSCPServer::Main() { Line 232  int LSCPServer::Main() {
232      MidiInstrumentMapper::AddMidiInstrumentInfoListener(&eventHandler);      MidiInstrumentMapper::AddMidiInstrumentInfoListener(&eventHandler);
233      MidiInstrumentMapper::AddMidiInstrumentMapCountListener(&eventHandler);      MidiInstrumentMapper::AddMidiInstrumentMapCountListener(&eventHandler);
234      MidiInstrumentMapper::AddMidiInstrumentMapInfoListener(&eventHandler);      MidiInstrumentMapper::AddMidiInstrumentMapInfoListener(&eventHandler);
235    #if HAVE_SQLITE3
236        InstrumentsDb::GetInstrumentsDb()->AddInstrumentsDbListener(&dbInstrumentsEventHandler);
237    #endif
238      // now wait for client connections and handle their requests      // now wait for client connections and handle their requests
239      sockaddr_in client;      sockaddr_in client;
240      int length = sizeof(client);      int length = sizeof(client);
# Line 2157  String LSCPServer::GetServerInfo() { Line 2197  String LSCPServer::GetServerInfo() {
2197      result.Add("DESCRIPTION", "LinuxSampler - modular, streaming capable sampler");      result.Add("DESCRIPTION", "LinuxSampler - modular, streaming capable sampler");
2198      result.Add("VERSION", VERSION);      result.Add("VERSION", VERSION);
2199      result.Add("PROTOCOL_VERSION", ToString(LSCP_RELEASE_MAJOR) + "." + ToString(LSCP_RELEASE_MINOR));      result.Add("PROTOCOL_VERSION", ToString(LSCP_RELEASE_MAJOR) + "." + ToString(LSCP_RELEASE_MINOR));
2200    #if HAVE_SQLITE3
2201        result.Add("INSTRUMENTS_DB_SUPPORT", "yes");
2202    #else
2203        result.Add("INSTRUMENTS_DB_SUPPORT", "no");
2204    #endif
2205        
2206      return result.Produce();      return result.Produce();
2207  }  }
2208    
# Line 2224  String LSCPServer::UnsubscribeNotificati Line 2270  String LSCPServer::UnsubscribeNotificati
2270      return result.Produce();      return result.Produce();
2271  }  }
2272    
2273  static int select_callback(void * lscpResultSet, int argc,  String LSCPServer::AddDbInstrumentDirectory(String Dir) {
2274                          char **argv, char **azColName)      dmsg(2,("LSCPServer: AddDbInstrumentDirectory(Dir=%s)\n", Dir.c_str()));
2275  {      LSCPResultSet result;
2276      LSCPResultSet* resultSet = (LSCPResultSet*) lscpResultSet;  #if HAVE_SQLITE3
2277      resultSet->Add(argc, argv);      try {
2278      return 0;          InstrumentsDb::GetInstrumentsDb()->AddDirectory(Dir);
2279        } catch (Exception e) {
2280             result.Error(e);
2281        }
2282    #else
2283        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2284    #endif
2285        return result.Produce();
2286    }
2287    
2288    String LSCPServer::RemoveDbInstrumentDirectory(String Dir, bool Force) {
2289        dmsg(2,("LSCPServer: RemoveDbInstrumentDirectory(Dir=%s,Force=%d)\n", Dir.c_str(), Force));
2290        LSCPResultSet result;
2291    #if HAVE_SQLITE3
2292        try {
2293            InstrumentsDb::GetInstrumentsDb()->RemoveDirectory(Dir, Force);
2294        } catch (Exception e) {
2295             result.Error(e);
2296        }
2297    #else
2298        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2299    #endif
2300        return result.Produce();
2301    }
2302    
2303    String LSCPServer::GetDbInstrumentDirectoryCount(String Dir, bool Recursive) {
2304        dmsg(2,("LSCPServer: GetDbInstrumentDirectoryCount(Dir=%s,Recursive=%d)\n", Dir.c_str(), Recursive));
2305        LSCPResultSet result;
2306    #if HAVE_SQLITE3
2307        try {
2308            result.Add(InstrumentsDb::GetInstrumentsDb()->GetDirectoryCount(Dir, Recursive));
2309        } catch (Exception e) {
2310             result.Error(e);
2311        }
2312    #else
2313        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2314    #endif
2315        return result.Produce();
2316    }
2317    
2318    String LSCPServer::GetDbInstrumentDirectories(String Dir, bool Recursive) {
2319        dmsg(2,("LSCPServer: GetDbInstrumentDirectories(Dir=%s,Recursive=%d)\n", Dir.c_str(), Recursive));
2320        LSCPResultSet result;
2321    #if HAVE_SQLITE3
2322        try {
2323            String list;
2324            StringListPtr dirs = InstrumentsDb::GetInstrumentsDb()->GetDirectories(Dir, Recursive);
2325    
2326            for (int i = 0; i < dirs->size(); i++) {
2327                if (list != "") list += ",";
2328                list += "'" + dirs->at(i) + "'";
2329            }
2330    
2331            result.Add(list);
2332        } catch (Exception e) {
2333             result.Error(e);
2334        }
2335    #else
2336        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2337    #endif
2338        return result.Produce();
2339    }
2340    
2341    String LSCPServer::GetDbInstrumentDirectoryInfo(String Dir) {
2342        dmsg(2,("LSCPServer: GetDbInstrumentDirectoryInfo(Dir=%s)\n", Dir.c_str()));
2343        LSCPResultSet result;
2344    #if HAVE_SQLITE3
2345        try {
2346            DbDirectory info = InstrumentsDb::GetInstrumentsDb()->GetDirectoryInfo(Dir);
2347    
2348            result.Add("DESCRIPTION", info.Description);
2349            result.Add("CREATED", info.Created);
2350            result.Add("MODIFIED", info.Modified);
2351        } catch (Exception e) {
2352             result.Error(e);
2353        }
2354    #else
2355        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2356    #endif
2357        return result.Produce();
2358  }  }
2359    
2360  String LSCPServer::QueryDatabase(String query) {  String LSCPServer::SetDbInstrumentDirectoryName(String Dir, String Name) {
2361        dmsg(2,("LSCPServer: SetDbInstrumentDirectoryName(Dir=%s,Name=%s)\n", Dir.c_str(), Name.c_str()));
2362      LSCPResultSet result;      LSCPResultSet result;
2363  #if HAVE_SQLITE3  #if HAVE_SQLITE3
2364      char* zErrMsg = NULL;      try {
2365      sqlite3 *db;          InstrumentsDb::GetInstrumentsDb()->RenameDirectory(Dir, Name);
2366      String selectStr = "SELECT " + query;      } catch (Exception e) {
2367             result.Error(e);
2368        }
2369    #else
2370        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2371    #endif
2372        return result.Produce();
2373    }
2374    
2375      int rc = sqlite3_open("linuxsampler.db", &db);  String LSCPServer::MoveDbInstrumentDirectory(String Dir, String Dst) {
2376      if (rc == SQLITE_OK)      dmsg(2,("LSCPServer: MoveDbInstrumentDirectory(Dir=%s,Dst=%s)\n", Dir.c_str(), Dst.c_str()));
2377      {      LSCPResultSet result;
2378              rc = sqlite3_exec(db, selectStr.c_str(), select_callback, &result, &zErrMsg);  #if HAVE_SQLITE3
2379        try {
2380            InstrumentsDb::GetInstrumentsDb()->MoveDirectory(Dir, Dst);
2381        } catch (Exception e) {
2382             result.Error(e);
2383      }      }
2384      if ( rc != SQLITE_OK )  #else
2385      {      result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2386              result.Error(String(zErrMsg), rc);  #endif
2387        return result.Produce();
2388    }
2389    
2390    String LSCPServer::CopyDbInstrumentDirectory(String Dir, String Dst) {
2391        dmsg(2,("LSCPServer: CopyDbInstrumentDirectory(Dir=%s,Dst=%s)\n", Dir.c_str(), Dst.c_str()));
2392        LSCPResultSet result;
2393    #if HAVE_SQLITE3
2394        try {
2395            InstrumentsDb::GetInstrumentsDb()->CopyDirectory(Dir, Dst);
2396        } catch (Exception e) {
2397             result.Error(e);
2398      }      }
     sqlite3_close(db);  
2399  #else  #else
2400      result.Error(String("SQLITE3 was not installed when linuxsampler was built. SELECT statement is not available."), 0);      result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2401  #endif  #endif
2402      return result.Produce();      return result.Produce();
2403  }  }
2404    
2405    String LSCPServer::SetDbInstrumentDirectoryDescription(String Dir, String Desc) {
2406        dmsg(2,("LSCPServer: SetDbInstrumentDirectoryDescription(Dir=%s,Desc=%s)\n", Dir.c_str(), Desc.c_str()));
2407        LSCPResultSet result;
2408    #if HAVE_SQLITE3
2409        try {
2410            InstrumentsDb::GetInstrumentsDb()->SetDirectoryDescription(Dir, Desc);
2411        } catch (Exception e) {
2412             result.Error(e);
2413        }
2414    #else
2415        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2416    #endif
2417        return result.Produce();
2418    }
2419    
2420    String LSCPServer::AddDbInstruments(String DbDir, String FilePath, int Index, bool bBackground) {
2421        dmsg(2,("LSCPServer: AddDbInstruments(DbDir=%s,FilePath=%s,Index=%d,bBackground=%d)\n", DbDir.c_str(), FilePath.c_str(), Index, bBackground));
2422        LSCPResultSet result;
2423    #if HAVE_SQLITE3
2424        try {
2425            int id;
2426            InstrumentsDb* db = InstrumentsDb::GetInstrumentsDb();
2427            id = db->AddInstruments(DbDir, FilePath, Index, bBackground);
2428            if (bBackground) result = id;
2429        } catch (Exception e) {
2430             result.Error(e);
2431        }
2432    #else
2433        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2434    #endif
2435        return result.Produce();
2436    }
2437    
2438    String LSCPServer::AddDbInstruments(String ScanMode, String DbDir, String FsDir, bool bBackground) {
2439        dmsg(2,("LSCPServer: AddDbInstruments(ScanMode=%s,DbDir=%s,FsDir=%s,bBackground=%d)\n", ScanMode.c_str(), DbDir.c_str(), FsDir.c_str(), bBackground));
2440        LSCPResultSet result;
2441    #if HAVE_SQLITE3
2442        try {
2443            int id;
2444            InstrumentsDb* db = InstrumentsDb::GetInstrumentsDb();
2445            if (ScanMode.compare("RECURSIVE") == 0) {
2446               id = db->AddInstruments(RECURSIVE, DbDir, FsDir, bBackground);
2447            } else if (ScanMode.compare("NON_RECURSIVE") == 0) {
2448               id = db->AddInstruments(NON_RECURSIVE, DbDir, FsDir, bBackground);
2449            } else if (ScanMode.compare("FLAT") == 0) {
2450               id = db->AddInstruments(FLAT, DbDir, FsDir, bBackground);
2451            } else {
2452                throw Exception("Unknown scan mode: " + ScanMode);
2453            }
2454            
2455            if (bBackground) result = id;
2456        } catch (Exception e) {
2457             result.Error(e);
2458        }
2459    #else
2460        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2461    #endif
2462        return result.Produce();
2463    }
2464    
2465    String LSCPServer::RemoveDbInstrument(String Instr) {
2466        dmsg(2,("LSCPServer: RemoveDbInstrument(Instr=%s)\n", Instr.c_str()));
2467        LSCPResultSet result;
2468    #if HAVE_SQLITE3
2469        try {
2470            InstrumentsDb::GetInstrumentsDb()->RemoveInstrument(Instr);
2471        } catch (Exception e) {
2472             result.Error(e);
2473        }
2474    #else
2475        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2476    #endif
2477        return result.Produce();
2478    }
2479    
2480    String LSCPServer::GetDbInstrumentCount(String Dir, bool Recursive) {
2481        dmsg(2,("LSCPServer: GetDbInstrumentCount(Dir=%s,Recursive=%d)\n", Dir.c_str(), Recursive));
2482        LSCPResultSet result;
2483    #if HAVE_SQLITE3
2484        try {
2485            result.Add(InstrumentsDb::GetInstrumentsDb()->GetInstrumentCount(Dir, Recursive));
2486        } catch (Exception e) {
2487             result.Error(e);
2488        }
2489    #else
2490        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2491    #endif
2492        return result.Produce();
2493    }
2494    
2495    String LSCPServer::GetDbInstruments(String Dir, bool Recursive) {
2496        dmsg(2,("LSCPServer: GetDbInstruments(Dir=%s,Recursive=%d)\n", Dir.c_str(), Recursive));
2497        LSCPResultSet result;
2498    #if HAVE_SQLITE3
2499        try {
2500            String list;
2501            StringListPtr instrs = InstrumentsDb::GetInstrumentsDb()->GetInstruments(Dir, Recursive);
2502    
2503            for (int i = 0; i < instrs->size(); i++) {
2504                if (list != "") list += ",";
2505                list += "'" + instrs->at(i) + "'";
2506            }
2507    
2508            result.Add(list);
2509        } catch (Exception e) {
2510             result.Error(e);
2511        }
2512    #else
2513        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2514    #endif
2515        return result.Produce();
2516    }
2517    
2518    String LSCPServer::GetDbInstrumentInfo(String Instr) {
2519        dmsg(2,("LSCPServer: GetDbInstrumentInfo(Instr=%s)\n", Instr.c_str()));
2520        LSCPResultSet result;
2521    #if HAVE_SQLITE3
2522        try {
2523            DbInstrument info = InstrumentsDb::GetInstrumentsDb()->GetInstrumentInfo(Instr);
2524    
2525            result.Add("INSTRUMENT_FILE", info.InstrFile);
2526            result.Add("INSTRUMENT_NR", info.InstrNr);
2527            result.Add("FORMAT_FAMILY", info.FormatFamily);
2528            result.Add("FORMAT_VERSION", info.FormatVersion);
2529            result.Add("SIZE", (int)info.Size);
2530            result.Add("CREATED", info.Created);
2531            result.Add("MODIFIED", info.Modified);
2532            result.Add("DESCRIPTION", FilterEndlines(info.Description));
2533            result.Add("IS_DRUM", info.IsDrum);
2534            result.Add("PRODUCT", FilterEndlines(info.Product));
2535            result.Add("ARTISTS", FilterEndlines(info.Artists));
2536            result.Add("KEYWORDS", FilterEndlines(info.Keywords));
2537        } catch (Exception e) {
2538             result.Error(e);
2539        }
2540    #else
2541        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2542    #endif
2543        return result.Produce();
2544    }
2545    
2546    String LSCPServer::GetDbInstrumentsJobInfo(int JobId) {
2547        dmsg(2,("LSCPServer: GetDbInstrumentsJobInfo(JobId=%d)\n", JobId));
2548        LSCPResultSet result;
2549    #if HAVE_SQLITE3
2550        try {
2551            ScanJob job = InstrumentsDb::GetInstrumentsDb()->Jobs.GetJobById(JobId);
2552    
2553            result.Add("FILES_TOTAL", job.FilesTotal);
2554            result.Add("FILES_SCANNED", job.FilesScanned);
2555            result.Add("SCANNING", job.Scanning);
2556            result.Add("STATUS", job.Status);
2557        } catch (Exception e) {
2558             result.Error(e);
2559        }
2560    #else
2561        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2562    #endif
2563        return result.Produce();
2564    }
2565    
2566    String LSCPServer::SetDbInstrumentName(String Instr, String Name) {
2567        dmsg(2,("LSCPServer: SetDbInstrumentName(Instr=%s,Name=%s)\n", Instr.c_str(), Name.c_str()));
2568        LSCPResultSet result;
2569    #if HAVE_SQLITE3
2570        try {
2571            InstrumentsDb::GetInstrumentsDb()->RenameInstrument(Instr, Name);
2572        } catch (Exception e) {
2573             result.Error(e);
2574        }
2575    #else
2576        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2577    #endif
2578        return result.Produce();
2579    }
2580    
2581    String LSCPServer::MoveDbInstrument(String Instr, String Dst) {
2582        dmsg(2,("LSCPServer: MoveDbInstrument(Instr=%s,Dst=%s)\n", Instr.c_str(), Dst.c_str()));
2583        LSCPResultSet result;
2584    #if HAVE_SQLITE3
2585        try {
2586            InstrumentsDb::GetInstrumentsDb()->MoveInstrument(Instr, Dst);
2587        } catch (Exception e) {
2588             result.Error(e);
2589        }
2590    #else
2591        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2592    #endif
2593        return result.Produce();
2594    }
2595    
2596    String LSCPServer::CopyDbInstrument(String Instr, String Dst) {
2597        dmsg(2,("LSCPServer: CopyDbInstrument(Instr=%s,Dst=%s)\n", Instr.c_str(), Dst.c_str()));
2598        LSCPResultSet result;
2599    #if HAVE_SQLITE3
2600        try {
2601            InstrumentsDb::GetInstrumentsDb()->CopyInstrument(Instr, Dst);
2602        } catch (Exception e) {
2603             result.Error(e);
2604        }
2605    #else
2606        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2607    #endif
2608        return result.Produce();
2609    }
2610    
2611    String LSCPServer::SetDbInstrumentDescription(String Instr, String Desc) {
2612        dmsg(2,("LSCPServer: SetDbInstrumentDescription(Instr=%s,Desc=%s)\n", Instr.c_str(), Desc.c_str()));
2613        LSCPResultSet result;
2614    #if HAVE_SQLITE3
2615        try {
2616            InstrumentsDb::GetInstrumentsDb()->SetInstrumentDescription(Instr, Desc);
2617        } catch (Exception e) {
2618             result.Error(e);
2619        }
2620    #else
2621        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2622    #endif
2623        return result.Produce();
2624    }
2625    
2626    String LSCPServer::FindDbInstrumentDirectories(String Dir, std::map<String,String> Parameters, bool Recursive) {
2627        dmsg(2,("LSCPServer: FindDbInstrumentDirectories(Dir=%s)\n", Dir.c_str()));
2628        LSCPResultSet result;
2629    #if HAVE_SQLITE3
2630        try {
2631            SearchQuery Query;
2632            std::map<String,String>::iterator iter;
2633            for (iter = Parameters.begin(); iter != Parameters.end(); iter++) {
2634                if (iter->first.compare("NAME") == 0) {
2635                    Query.Name = iter->second;
2636                } else if (iter->first.compare("CREATED") == 0) {
2637                    Query.SetCreated(iter->second);
2638                } else if (iter->first.compare("MODIFIED") == 0) {
2639                    Query.SetModified(iter->second);
2640                } else if (iter->first.compare("DESCRIPTION") == 0) {
2641                    Query.Description = iter->second;
2642                } else {
2643                    throw Exception("Unknown search criteria: " + iter->first);
2644                }
2645            }
2646    
2647            String list;
2648            StringListPtr pDirectories =
2649                InstrumentsDb::GetInstrumentsDb()->FindDirectories(Dir, &Query, Recursive);
2650    
2651            for (int i = 0; i < pDirectories->size(); i++) {
2652                if (list != "") list += ",";
2653                list += "'" + pDirectories->at(i) + "'";
2654            }
2655    
2656            result.Add(list);
2657        } catch (Exception e) {
2658             result.Error(e);
2659        }
2660    #else
2661        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2662    #endif
2663        return result.Produce();
2664    }
2665    
2666    String LSCPServer::FindDbInstruments(String Dir, std::map<String,String> Parameters, bool Recursive) {
2667        dmsg(2,("LSCPServer: FindDbInstruments(Dir=%s)\n", Dir.c_str()));
2668        LSCPResultSet result;
2669    #if HAVE_SQLITE3
2670        try {
2671            SearchQuery Query;
2672            std::map<String,String>::iterator iter;
2673            for (iter = Parameters.begin(); iter != Parameters.end(); iter++) {
2674                if (iter->first.compare("NAME") == 0) {
2675                    Query.Name = iter->second;
2676                } else if (iter->first.compare("FORMAT_FAMILIES") == 0) {
2677                    Query.SetFormatFamilies(iter->second);
2678                } else if (iter->first.compare("SIZE") == 0) {
2679                    Query.SetSize(iter->second);
2680                } else if (iter->first.compare("CREATED") == 0) {
2681                    Query.SetCreated(iter->second);
2682                } else if (iter->first.compare("MODIFIED") == 0) {
2683                    Query.SetModified(iter->second);
2684                } else if (iter->first.compare("DESCRIPTION") == 0) {
2685                    Query.Description = iter->second;
2686                } else if (iter->first.compare("IS_DRUM") == 0) {
2687                    if (!strcasecmp(iter->second.c_str(), "true")) {
2688                        Query.InstrType = SearchQuery::DRUM;
2689                    } else {
2690                        Query.InstrType = SearchQuery::CHROMATIC;
2691                    }
2692                } else if (iter->first.compare("PRODUCT") == 0) {
2693                     Query.Product = iter->second;
2694                } else if (iter->first.compare("ARTISTS") == 0) {
2695                     Query.Artists = iter->second;
2696                } else if (iter->first.compare("KEYWORDS") == 0) {
2697                     Query.Keywords = iter->second;
2698                } else {
2699                    throw Exception("Unknown search criteria: " + iter->first);
2700                }
2701            }
2702    
2703            String list;
2704            StringListPtr pInstruments =
2705                InstrumentsDb::GetInstrumentsDb()->FindInstruments(Dir, &Query, Recursive);
2706    
2707            for (int i = 0; i < pInstruments->size(); i++) {
2708                if (list != "") list += ",";
2709                list += "'" + pInstruments->at(i) + "'";
2710            }
2711    
2712            result.Add(list);
2713        } catch (Exception e) {
2714             result.Error(e);
2715        }
2716    #else
2717        result.Error(String(DOESNT_HAVE_SQLITE3), 0);
2718    #endif
2719        return result.Produce();
2720    }
2721    
2722    
2723  /**  /**
2724   * Will be called by the parser to enable or disable echo mode; if echo   * Will be called by the parser to enable or disable echo mode; if echo
2725   * mode is enabled, all commands from the client will (immediately) be   * mode is enabled, all commands from the client will (immediately) be
# Line 2273  String LSCPServer::SetEcho(yyparse_param Line 2738  String LSCPServer::SetEcho(yyparse_param
2738      }      }
2739      return result.Produce();      return result.Produce();
2740  }  }
2741    
2742    String LSCPServer::FilterEndlines(String s) {
2743        String s2 = s;
2744        for (int i = 0; i < s2.length(); i++) {
2745            if (s2.at(i) == '\r') s2.at(i) = ' ';
2746            else if (s2.at(i) == '\n') s2.at(i) = ' ';
2747        }
2748        
2749        return s2;
2750    }
Legend:
Removed from v.1135  
changed lines
  Added in v.1200
  ViewVC Help
Powered by ViewVC