sbLocalDatabaseSQL.h

Go to the documentation of this file.

#ifndef SBLOCALDATABASESQL_H_
#define SBLOCALDATABASESQL_H_

/*
//
// BEGIN SONGBIRD GPL
//
// This file is part of the Songbird web player.
//
// Copyright(c) 2005-2008 POTI, Inc.
// http://songbirdnest.com
//
// This file may be licensed under the terms of of the
// GNU General Public License Version 2 (the "GPL").
//
// Software distributed under the License is distributed
// on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either
// express or implied. See the GPL for the specific language
// governing rights and limitations.
//
// You should have received a copy of the GPL along with this
// program. If not, go to http://www.gnu.org/licenses/gpl.html
// or write to the Free Software Foundation, Inc.,
// 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
//
// END SONGBIRD GPL
//
*/

#include <nsStringAPI.h>
#include <nsTArray.h>

class sbLocalDatabaseSQL
{
public:
  nsString MediaItemSelect();
  static nsString SecondaryPropertySelect();
  static nsString MediaItemsFtsAllDelete();
  static nsString MediaItemsFtsAllInsert();
  static nsString LibraryMediaItemsPropertiesSelect();
  nsString LibraryMediaItemSelect();
  static nsString PropertiesTableInsert();
  static nsString PropertiesSelect();
  static nsString PropertiesInsert();
  static nsString PropertiesDelete();

  // These are the number of "IN" bind variables for statements which use them.
  // They are tuned to optimize performance.
  static const int MediaItemBindCount = 50;
  static const int SecondaryPropertyBindCount = 50;

private:
  nsString mMediaItemColumns;
  nsString mMediaItemColumnsWithID;
  nsString mLibraryMediaItemSelect;

  nsString MediaItemColumns(PRBool aIncludeMediaItem);
};

#endif /* SBLOCALDATABASEPRIMARYPROPERTYSELECT_H_ */