constant.h

Sqlite_Class 的C++类库

#pragma once

/************************************************************************/
/* 操作用户订阅列表数据库的一些语句      
	表rsslist															*/
/************************************************************************/

static char* createRssListTable = "CREATE TABLE [rsslist]"
"([rssid] INTEGER PRIMARY KEY ,"
"[url] [char] (512)  NULL ,"
"[link] [char] (512)  NULL ,"
"[title] [char] (128) NULL ,"
"[deleted] [int] NULL ,"
"[type] [char] (32)  NULL ,"
"[count] [int] NULL ,"
"[position] [int] NULL ,"
"[updatetime] [datetime] NULL);";

static char* deleteRssListTable = "drop table [rsslist] ";

static char* insertRssListTable = "insert into [rsslist] "
"(url,link,title,type,deleted,"
"count,position,updatetime) "
"values(?,?,?,?,?,?,?,?);";

static char* getMaxRssKey = "select MAX(rssid) from [rsslist];";//查找最大的rssid
static char* updateRssListByUrl2 = "update [rsslist] set"
"[count] = ?,[updatetime] = ? where [url] = ?;";

static char* updateRssListRecover = "update [rsslist] set"
"[count] = ?,[updatetime] = ?,[deleted] = ? where [url] = ?;";

static char* getRssListByTypeName = "select * from [rsslist] where type = ? and [deleted] = 0;";

static char* updateTypeNameInRssList = "update [rsslist] set type = ? where type = ?;";

static char* deleteTypeNameInRssList = "delete from [rsslist] where type = ?;";

static char* getTypeName = "select [type] from [rsslist] order by [type];";

static char* deleteRssByUrl = "delete from [rsslist] where url = ?;";

static char* getRssInfoByRssId = "select * from [rsslist] where rssid = ?;";
//deleteRssByUrl
static char* setDeletedTrueByUrl = "update [rsslist] set [deleted] = 1 where [url] = ?;";

static char* setDeletedFalseByUrl = "update [rsslist] set [deleted] = 0 where [url] = ?;";

static char* getAllRssListHistory = "select * from [rsslist] order by [type];";
 
static char* getRssListHistoryByTypeName = "select * from [rsslist] where type = ?;";

static char* setDeleteByRssId = "update [rsslist] set [deleted] = ? where rssid = ?;";

static char* setTitleByUrl = "update [rsslist] set [title] = ? where [url] = ?;";

static char* getUrlByTitle = "select [title] where [url] = ?";

static char* getAllRssList = "select * from [rsslist];";

static char* getTitleByUrl = "select [title] from [rsslist] where [url] = ?;";

static char* isTableExist = "select count(*) from sqlite_master where name = ?;";