scbc_repos/CTSManager/CTSManager/table.h

#ifndef __TABLE_20201102__
#define __TABLE_20201102__

#pragma once

#include <string>

// 机芯方案商表;
typedef struct {
	std::string name;						// 机芯名称（唯一键值）;
	std::string provider;					// 供应商名称
	std::string note;						// 供应商备注;
}STSOC, * pSTSOC;
#define INSER_SOC _T("INSERT INTO `soc` (`name`,`provider`,`note`) VALUES ('%s', '%s', '%s');")
#define DEL_SOC _T("DELETE FROM `soc` WHERE `name` = '%s';")
#define MOD_SOC _T("UPDATE `soc` SET `name`='%s', `provider`='%s', `note`='%s' WHERE `name`='%s';")
#define QUERY_SOC _T("SELECT `name`, `provider`, `note` FROM `soc`;")

// 季度表;
typedef struct {
	std::string name;						// 季度名称;
	std::string scp;						// SecurityPatch;
	std::string note;						// 季度备注;
	// 实际开始和结束时间;
}STQuarter, *pSTQuarter;
#define INSER_QUARTER _T("INSERT INTO `quarter` (`name`,`scp`,`note`) VALUES ('%s', '%s', '%s');")
#define DEL_QUARTER _T("DELETE FROM `quarter` where `name` = '%s';")
#define MOD_QUARTER _T("UPDATE `quarter` SET `name`='%s', `scp` = '%s' ,`note`='%s' WHERE `name`='%s';")
#define QUERY_QUARTER _T("SELECT `name`,`scp`, `note` FROM `quarter`;")

// 品牌表;
typedef struct {
	std::string name;						// 品牌名称;
	std::string note;						// 品牌备注;
	void* pLogo = NULL;						// 最新的logo;
	std::string fav_cfg;
	std::string local_cfg;
	std::string apps_cfg;
}STBrand, *pSTBrand;
#define INSER_BRAND _T("INSERT INTO `brand` (`name`, `fav_cfg`, `local_cfg`, `apps_cfg`, `note`) VALUES ('%s', '%s', '%s', '%s', '%s');")
#define DEL_BRAND _T("DELETE FROM `brand` WHERE `name` = '%s';")
#define MOD_BRAND _T("UPDATE `brand` SET `name`='%s',`fav_cfg`='%s',`local_cfg`='%s',`apps_cfg`='%s',`note`='%s' WHERE `name`='%s';")
#define QUERY_BRAND _T("SELECT `name`, `fav_cfg`, `local_cfg`, `apps_cfg`, `note` FROM `brand`;")

// 季度品牌表;
typedef struct {
	std::string soc;						// 机芯;
	std::string brand;						// 季度品牌名称;
	std::string quarter;					// 季度;
	std::string whitelist;					// 白名单状态;
	std::string version;						// 软件版本号;
	std::string oemkey;						// oem key;
	std::string approved;					// 认证状态;
	std::string approveddate;				// 认证通过日期;
	// 图片不在此显示;
	void* pLogo = NULL;							// logo;
	void* pPic1 = NULL;
	void* pPic2 = NULL;
	std::string fav_cfg;
	std::string apps_cfg;
	std::string local_cfg;
	std::string pre_apk;
	std::string fingerprint;				// 该季度品牌fingerprint;
	std::string builddate;					// 编译日期;
	std::string gtvs;						// gtvs版本;
	std::string ftpdir;						// ftp下载路径;
	std::string codedir;					// 代码路径，只对admin可见;
	std::string note;						// 备注;
	std::string status;						// 状态：提醒要修改脚本;
}STQbrand, * pSTQbrand;
#define INSER_QBRAND _T("INSERT INTO `qbrand` \
(`soc`,`brand`,`quarter`,`whitelist`,`version`,`oemkey`,`approved`,`approveddate`,`fingerprint`,`builddate`,`gtvs`,`ftpdir`,`codedir`,`note`, `status`)\
 VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s');")
#define DEL_QBRAND _T("DELETE FROM `qbrand` where `soc` = '%s' and `brand`='%s' and`quarter`='%s';")
#define MOD_QBRAND _T("UPDATE qbrand SET soc='%s', `quarter` = '%s', brand = '%s', whitelist = '%s', version = '%s', approved = '%s', oemkey = '%s', approveddate = '%s', fingerprint = '%s', builddate = '%s', gtvs = '%s', note = '%s', apps_cfg = '%s', fav_cfg = '%s', local_cfg = '%s', ftpdir = '%s', codedir = '%s', `status` = '%s' FROM qbrand WHERE `brand` = '%s'")
#define QUERY_QBRAND _T("SELECT soc, `quarter`, brand, whitelist, version, oemkey, approved, approveddate, fingerprint, builddate, gtvs, note, apps_cfg, fav_cfg, local_cfg, ftpdir, codedir, `status` FROM qbrand;")

// 用户表（权限表）;
typedef struct {
	std::string user;						// 用户账号;
	std::string password;					// 用户密码;
	std::string permission;					// 用户权限;
}STUser, * pSTUser;
#define INSER_USER _T("INSERT INTO `user` (`user`,`password`,`permission`) VALUES ('%s', '%s', '%s');")
#define DEL_USER _T("DELETE FROM `user` where `user` = '%s';")
#define MOD_USER _T("UPDATE `user` SET `user`='%s', `password` = '%s', `permission`='%s' WHERE `user`='%s';")
#define QUERY_USER _T("SELECT `user`, `password`, `permission` FROM `user`;")

// 日志表;
typedef struct {
	int id;									// 自增id;
	std::string datetime;					// 发生时间;
	std::string user;						// 操作用户;
	std::string content;					// 操作内容;
}STLog, * pSTLog;
#define INSER_LOG _T("INSERT INTO `log` (`user`,`datetime`,`content`) VALUES ('%s', 'datetime', '%s');")
#define DEL_LOG _T("DELETE FROM `log` where `id` = '%s';")
#define QUERY_LOG _T("SELECT `id`, `user`,`content`,`datetime` FROM `log`;")

// 服务器表;
typedef struct {
	std::string name;						// 服务器名称;
	std::string ip;							// 服务器IP;
	std::string type;						// 服务器类型：ftp、ssh2;
	std::string user;						// 服务器用户;
	std::string password;					// 服务器用户密码;
	std::string note;						// 服务器备注;
}STServer, *pSTServer;
#define INSER_SERVER _T("INSERT INTO `server` (`name`,`ip`,`type`,`user`,`password`,`note`) VALUES ('%s', '%s', '%s', '%s', '%s', '%s');")
#define DEL_SERVER _T("DELETE FROM `server` where `name` = '%s';")
#define MOD_SERVER _T("UPDATE `server` SET `name`='%s', `ip` = '%s', `type`='%s', `user`='%s', `password`='%s', `note`='%s' WHERE `name`='%s';")
#define QUERY_SERVER _T("SELECT `name`, `ip`, `type`, `user`, `password`, `note` FROM `server`;")

// 分支表;
typedef struct {
	std::string name;						// 分支名称;
	std::string quarter;					// 分支所属季度;
	std::string address;					// 分支gerrit地址;
	std::string provider;					// 分支供应商;
	std::string chip;						// 分支机芯;
	std::string type;						// 分支类型：主干、CTS、量产、ODF
	std::string status;						// 分支状态：在线、停用;
	std::string note;						// 分支备注;
}STBranch, *pSTBranch;
#define INSER_BRANCH _T("INSERT INTO `branch` (`name` ,`quarter`,`address`,`provider`,`chip`,`type`,`status`,`note`) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s');")
#define DEL_BRANCH _T("DELETE FROM `brach` where `name` = '%s';")
#define MOD_BRANCH _T("UPDATE `branch` SET `quater`='%s', `address`='%s', `provider`='%s', `chip`='%s', `type`='%s', `status`='%s', `note`='%s' WHERE `name`='%s';")
#define QUERY_BRANCH _T("SELECT `name`, `quarter`, `address`, `provider`, `chip`, `type`, `status`, `note` FROM `branch`;")

#endif