DBMS/main.cpp at master · KJlmfe/DBMS · GitHub

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
#include <string>
#include <iostream>
#include <vector>
#include <fstream>
#include <map>
#include <cstdlib>
#include "Table.h"
#include "DataBase.h"
DataBase data;
#include "Sql.h"
using namespace std;

int main(int argc, char** argv)
{

//        sql_input();
//
    DataBase data;
    vector<Attribute> temp1;
    temp1.push_back(Attribute("name", CHAR, 4));
    temp1.push_back(Attribute("phone", INT, 4));
    data.create_table("person", 1, temp1);

//    vector<Attribute> temp2;
//    temp2.push_back(Attribute("name", CHAR, 4));
//    temp2.push_back(Attribute("id", CHAR, 4));
//    data.create_table("student", 1, temp2);
//        data.read_table();
//    data.show_database();

    vector<string> attri1;
    vector<string> value1;
    attri1.push_back("name");
    attri1.push_back("phone");
    value1.push_back("Toms");
    value1.push_back("1111");

    vector<string> attri2;
    vector<string> value2;
    attri2.push_back("name");
    attri2.push_back("phone");
    value2.push_back("Jack");
    value2.push_back("2222");

    data.tables[0].Insert(attri1, value1);
    data.tables[0].Insert(attri2, value2);
    data.tables[0].show_table();
//    Condition condition("name",">","1111");

    data.tables[0].Delete("phone",'=',"1111");
//    vector<int> a=   data.tables[0].search(Condition("phone",'>',"1111"));
//
//    for (int i = 0;i < a.size();i++)
//    {
//        cout << a[i]<< endl;
//    }
//    cout << "\n";
    data.tables[0].show_table();
//    vector<int> temps;
//    temps.push_back(1);
//    data.Projection(data.tables[0].attributes,temps).show_table();
//    data.tables[0].show_table();


    //    data.tables[1].Insert(attri1, value1);
    //    data.tables[1].Insert(attri2, value2);

    //    vector<int> query;
    //    query.push_back(1);
    //    query.push_back(0);
    //    query.push_back(2);
    //
    //    data.tables[0].show_table();
    //    data.tables[1].show_table();
    //
    //    data.Equi_Join(data.tables[0], data.tables[1], query, query, Attribute("name", CHAR, 4), Attribute("name", CHAR, 4)).show_table();
    //    data.tables[0].name = "temp";
    //
    //    temp2.push_back(Attribute("phone", CHAR, 4));
    //    data.tables[0].attributes = temp2;
    //    data.temp_table.show_table();
    //
    //    data.tables[0].Delete("name", "JKKK");
    //    data.tables[0].update("phone", "1353", "name", "JKKK");
    return 0;
}