-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathSYS_Manager.h
120 lines (104 loc) · 3.97 KB
/
SYS_Manager.h
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
#ifndef SYS_MANAGER_H_H
#define SYS_MANAGER_H_H
#include "IX_Manager.h"
#include "PF_Manager.h"
#include "RM_Manager.h"
#include "str.h"
#include "EditArea.h"
#include <string>
#include <map>
#include <cassert>
#include <vector>
#include <set>
#include <algorithm>
#define TABLE_META_NAME "SYSTABLES.xx"
#define COLUMN_META_NAME "SYSCOLUMNS.xx"
#define RM_FILE_SUFFIX ""
#define IX_FILE_SUFFIX ""
//SYSTABLE中记录每一项的长度
#define SIZE_TABLE_NAME 21
#define TABLE_NAME_OFF 0
#define SIZE_ATTR_COUNT 4
#define ATTR_COUNT_OFF (TABLE_NAME_OFF+SIZE_TABLE_NAME)
#define SIZE_SYS_TABLE 25
//SYSCOLUMNS中记录每一项的长度
#define SIZE_ATTR_NAME 21
#define ATTR_NAME_OFF (TABLE_NAME_OFF+SIZE_TABLE_NAME)
#define SIZE_ATTR_TYPE 4
#define ATTR_TYPE_OFF (ATTR_NAME_OFF+SIZE_ATTR_NAME)
#define SIZE_ATTR_LENGTH 4
#define ATTR_LENGTH_OFF (ATTR_TYPE_OFF+SIZE_ATTR_TYPE)
#define SIZE_ATTR_OFFSET 4
#define ATTR_OFFSET_OFF (ATTR_LENGTH_OFF+SIZE_ATTR_LENGTH)
#define SIZE_IX_FLAG 1
#define ATTR_IXFLAG_OFF (ATTR_OFFSET_OFF+SIZE_ATTR_OFFSET)
#define SIZE_INDEX_NAME 21
#define ATTR_INDEX_NAME_OFF (ATTR_IXFLAG_OFF+SIZE_IX_FLAG)
#define SIZE_SYS_COLUMNS 76
#define MAX_CON_LEN 100
typedef struct db_info {
RM_FileHandle sysTables;
RM_FileHandle sysColumns;
int MAXATTRS = 20; //最大属性数量
std::string curDbName; //存放当前DB名称
}DB_INFO;
typedef struct {
AttrType attrType;
int attrLength;
int attrOffset;
bool ix_flag;
std::string indexName;
std::string attrName;
} AttrEntry;
typedef struct {
int attrOffset;
IX_IndexHandle ixIndexHandle;
} IxEntry;
void ExecuteAndMessage(char*, CEditArea*);
bool CanButtonClick();
RC CreateDB(char* dbpath, char* dbname);
RC DropDB(char* dbname);
RC OpenDB(char* dbname);
RC CloseDB();
RC execute(char* sql, CEditArea* editArea);
RC CreateTable(char* relName, int attrCount, AttrInfo* attributes);
RC DropTable(char* relName);
RC CreateIndex(char* indexName, char* relName, char* attrName);
RC DropIndex(char* indexName);
RC Insert(char* relName, int nValues, Value* values);
RC Delete(char* relName, int nConditions, Condition* conditions);
RC Update(char* relName, char* attrName, Value* value, int nConditions, Condition* conditions);
// 一些非接口方法
// SYSTABLES 元数据表操作
RC TableMetaInsert(char* relName, int attrCount);
RC TableMetaDelete(char* relName);
RC TableMetaSearch(char* relName, RM_Record* rmRecord);
RC TableMetaShow();
// SYSCOLUMNS 元数据表操作
RC ColumnSearchAttr(char* relName, char* attrName, RM_Record* rmRecord);
bool attrVaild(int attrCount, AttrInfo* attributes);
RC ToData(char* relName, char* attrName, int attrType,
int attrLength, int attrOffset, bool ixFlag, char* indexName, char* pData);
RC ColumnMetaInsert(char* relName, char* attrName, int attrType,
int attrLength, int attrOffset, bool ixFlag, char* indexName);
RC ColumnMetaDelete(char* relName);
RC ColumnMetaUpdate(char* relName, char* attrName, bool ixFlag, char* indexName);
RC ColumnMetaGet(char* relName, char* attrName, AttrEntry* attribute);
RC ColumnMetaShow(); // 打印出 column 元数据表
// 检查 relName 有效，同上
// 获取的信息保存在 attribute 中
RC ColumnEntryGet(char* relName, int* attrCount,
std::vector<AttrEntry>& attributes); // 通过 table 元数据 和 column 元数据
// 获得一个表的全部属性信息, 便于进行类型检查
// CreateTable 的 逆操作
//封装的RM方法
RC CreateIxFromTable(char* relName, char* indexName, int attrOffset);
RC CreateConFromCondition(char* relName, int nConditons, Condition* conditions, Con* cons);
bool CheckCondition(char* relName, Condition& condition);
bool checkAttr(char* relName, int hsIsAttr, RelAttr& hsAttr, AttrType* attrType);
RC InsertRmAndIx(RM_FileHandle* rmFileHandle, std::vector<IxEntry>& ixEntrys, char* pData);
RC DeleteRmAndIx(RM_FileHandle* rmFileHandle, std::vector<IxEntry>& ixEntrys, RM_Record* delRecord);
RC GetRecordSize(char* relName, int* recordSize);
RC ShowTable(char* relName);
RC ShowIndex(char* relName, char* attrName, bool def, int cutLen);
#endif