DataBase.cpp

#include"DataBase.h"

void DataBase::resize()
{
	capacity *= 2;
	Table* newTbl = new Table[capacity];
	for (size_t i = 0; i < tablesCount; i++) {
		newTbl[i] = tables[i];
	}
	free();
	tables = newTbl;
	newTbl = nullptr;
	delete[] newTbl;
}

void DataBase::free()
{
	delete[] tables;
}

void DataBase::copyFrom(const DataBase& other)
{
	this->capacity = other.getCapacity();
	this->tablesCount = other.getTablesCount();
	for (size_t i = 0; i < tablesCount; i++) {
		this->tables[i] = other[i];
	}
}

void DataBase::createFile() const
{
	std::ofstream file(Catalogue);
	if (!file.is_open()) {
		std::cout << "Error opening the file";
	}
	file.close();
}

DataBase::DataBase()
{
	capacity = 1;
	tablesCount = 1;
	tables = new Table[capacity];
}

DataBase::DataBase(const DataBase& other)
{
	copyFrom(other);
}

size_t DataBase::getCapacity() const
{
	return capacity;
}

size_t DataBase::getTablesCount() const
{
	return tablesCount;
}

void DataBase::changeNameDataBase(const char* name)
{
	this->Catalogue = name;
}

void DataBase::changeNameDataBase(char* name)
{
	this->Catalogue = name;
}

void DataBase::addTable(const Table& other)
{
	tablesCount++;
	if (tablesCount >= capacity) {
		resize();
	}
	tables[tablesCount - 1] = other;
	saveTable(tablesCount - 1);
}

void DataBase::showTables() const
{
	for (size_t i = 0; i < tablesCount; i++) {
		std::cout << takeName(tables[i].getName());
		std::cout << std::endl;
	}
}

void DataBase::import(const char* fileName)
{
	bool has = 0;
	for (size_t i = 0; i < tablesCount; i++) {
		if (strcmp(tables[i].getName(), fileName) == 0) {
			has = 1;
			std::cerr << "There is already such file";
		}
	}
	if (has == 0) {
		Table newTable;
		newTable.setName(fileName);
		newTable.readFromFile(fileName);
		addTable(newTable);
	}
}

void DataBase::describe(char* name) const
{
	for (size_t i = 0; i < tablesCount; i++) {
		if (strcmp(takeName(tables[i].getName()), name) == 0) {
			tables[i].describe();
		}
	}
}

void DataBase::saveTable(size_t index) const
{
	std::ofstream file(Catalogue);
	file.write(takeName(tables[index].getName()), sizeof(takeName(tables[index].getName())));
	file.close();
}

void DataBase::select(size_t col, const char* value, const char* name)const
{
	int br = 0;
	bool found = 0;
	size_t index = 0;
	for (size_t i = 0; i < tablesCount; i++) {
		if (strcmp(takeName(tables[i].getName()), name) == 0) {
			found = 1;
			index = i;
		}
	}
	if (found == 0) {
		std::cerr << "Table not found";
	}
	else {
		bool integ = 1;
		bool doubl = 1;
		for (size_t i = 0; i < strlen(value); i++) {
			if (value[i] != ',' && value[i] < 0 && value[i]>9 /*&& value[i] != '|'*/ && value[i] != '-' && value[i] != '+') {
				integ = 0;
				if (value[i] != '.') {
					doubl = 0;
				}
			}
		}
		int* rows = new int[1000];
		rows = { 0 };
		size_t tp = 0;
		if (strcmp(value, "NULL") == 0) {
			int* indexes = new int[100];
			tp = 0;
			if (tables[index][col]->getType() == tp) {
				for (size_t i = 0; i < tables[index].getSize(); i++) {
					tables[index][i][0].print();
				}
			}
		}
		else if (integ = 1) {
			tp = 1;
			Integer res;
			char* val = new char[strlen(value) + 1];
			strcpy(val, value);
			val[strlen(value) + 1] = '\0';
			int vn = 0;
			if (val[0] == '-') {
				vn++;
				res.changeSign('-', 0);
			}
			res.changeNumber(charToUnsigned(val, vn, strlen(value)), 0);
			Integer taken = tables[index][col];
			if (tables[index][col]->getType() == tp) {
				for (size_t i = 0; i < tables[index].getSize(); i++) {
					
					if (taken.getNumber(i) == res.getNumber(0) && taken.getSign(i) == res.getSign(0)) {
						rows[br] = i;
						br++;
					}
				}
			}
			for (size_t k = 0; k < br; k++) {
				for (size_t i = 0; i < tables[index].getSize(); i++) {
					int j = rows[k];
					taken = tables[index][i];
					std::cout << taken[j];
				}
			}
		}
		else if (doubl = 1) {
			FractionalNumber res;
			char* val = new char[strlen(value) + 1];
			strcpy(val, value);
			val[strlen(value) + 1] = '\0';
			int vn = 0;
			if (val[0] == '-') {
				vn++;
				res.changeSign('-', 0);
			}
			double db = 0;
			size_t i = 0;
			int numbcount = 0;
			if (val[i] >= 0 && val[i] <= 9) {
				numbcount++;
				i++;
			}
			else if (val[i] == '.') {
				db = charToUnsigned(val, i - numbcount, i);
				numbcount = 0;
				i++;
			}
			else {
				db += charToUnsigned(val, i - numbcount, i) * (pow(0.1, sizeOfNumber(charToUnsigned(val, i - numbcount, i))));
				numbcount = 0;
			}
			res.changeNumber(db, 0);
			FractionalNumber taken = tables[index][col];
			if (tables[index][col]->getType() == tp) {
				for (size_t i = 0; i < tables[index].getSize(); i++) {
					
					if (taken.getNumber(i) == res.getNumber(0) && taken.getSign(i) == res.getSign(0)) {
						rows[br] = i;
						br++;
					}
				}
			}
			for (size_t k = 0; k < br; k++) {
				for (size_t i = 0; i < tables[index].getSize(); i++) {
					int j = rows[k];
					taken = tables[index][i];
					std::cout << taken[j];
				}
			}
		}
		else {
			char ch = value[0];
			String taken = tables[index][col];
			if (tables[index][col]->getType() == tp) {
				for (size_t i = 0; i < tables[index].getSize(); i++) {
					if (taken.getStr()[col]== ch) {
						rows[br] = i;
						br++;
					}
				}
			}
			for (size_t k = 0; k < br; k++) {
				for (size_t i = 0; i < tables[index].getSize(); i++) {
					int j = rows[k];
					taken = tables[index][i];
					std::cout<<taken[j] ;
				}
			}
		}
	}
}

void DataBase::rename(char* oldName, char* newName)
{
	bool has = 0, can = 1;
	int numb = 0;
	for (size_t i = 0; i < tablesCount; i++) {
		if (strcmp(tables[i].getName(), oldName) == 0) {
			has = 1; numb = i;
			std::cerr << "There is not such file";
		}
	}
	for (size_t i = 0; i < tablesCount; i++) {
		if (strcmp(tables[i].getName(), newName) == 0) {
			can = 0;
			std::cerr << "There is already such file";
		}
	}
	if (can && has) {
		tables[numb].renameWith(newName);
	}
}

size_t DataBase::count(char* tableName, size_t col, char* value)const
{
	size_t br = 0;
	bool found = 0;
	size_t index = 0;
	for (size_t i = 0; i < tablesCount; i++) {
		if (strcmp(takeName(tables[i].getName()), tableName) == 0) {
			found = 1;
			index = i;
		}
	}
	if (found == 0) {
		std::cerr << "Table not found";
	}
	else {
		bool integ = 1;
		bool doubl = 1;
		for (size_t i = 0; i < strlen(value); i++) {
			if (value[i] != ',' && value[i] < 0 && value[i]>9 /*&& value[i] != '|'*/ && value[i] != '-' && value[i] != '+') {
				integ = 0;
				if (value[i] != '.') {
					doubl = 0;
				}
			}
		}
		size_t tp = 0;
		if (strcmp(value, "NULL") == 0) {
			tp = 0;
			if (tables[index][col]->getType() == tp) {
				br++;
			}
		}
		else if (integ = 1) {
			tp = 1;
			Integer res;
			char* val = new char[strlen(value) + 1];
			strcpy(val, value);
			val[strlen(value) + 1] = '\0';
			int vn = 0;
			if (val[0] == '-') {
				vn++;
				res.changeSign('-', 0);
			}
			res.changeNumber(charToUnsigned(val, vn, strlen(value)), 0);
			if (tables[index][col]->getType() == tp) {
				for (size_t i = 0; i < tables[index].getSize(); i++) {
					Integer taken = tables[index][col];
					if (taken.getNumber(i) == res.getNumber(0) && taken.getSign(i) == res.getSign(0)) {
						br++;
					}
				}
			}
		}
		else if (doubl = 1) {
			FractionalNumber res;
			char* val = new char[strlen(value) + 1];
			strcpy(val, value);
			val[strlen(value) + 1] = '\0';
			int vn = 0;
			if (val[0] == '-') {
				vn++;
				res.changeSign('-', 0);
			}
			double db = 0;
			size_t i = 0;
			int numbcount = 0;
			if (val[i] >= 0 && val[i] <= 9) {
				numbcount++;
				i++;
			}
			else if (val[i] == '.') {
				db = charToUnsigned(val, i - numbcount, i);
				numbcount = 0;
				i++;
			}
			else {
				db += charToUnsigned(val, i - numbcount, i) * (pow(0.1, sizeOfNumber(charToUnsigned(val, i - numbcount, i))));
				numbcount = 0;
			}
			res.changeNumber(db, 0);
			if (tables[index][col]->getType() == tp) {
				for (size_t i = 0; i < tables[index].getSize(); i++) {
					FractionalNumber taken = tables[index][i];
					if (taken.getNumber(i) == res.getNumber(0) && taken.getSign(i) == res.getSign(0)) {
						br++;
					}
				}
			}
		}
		else {
			char ch = value[0];
			if (tables[index][col]->getType() == tp) {
				for (size_t i = 0; i < tables[index].getSize(); i++) {
					String taken = tables[index][i];
					if (taken.getStr()[col] == ch) {
						br++;
					}
				}
			}
		}
	}
	return br;
}

void DataBase::export(const char* name,const char* fileToSave)const {
	bool done = 0;
	for (size_t i = 0; i < tablesCount; i++) {
		if (strcmp(takeName(tables[i].getName()), takeName(fileToSave))==0) {
			std::cerr << "There is already such file. Save cancelled.";
			done = 1;
		}
	}
	if (done == 0) {
		for (size_t i = 0; i < tablesCount; i++) {
			if (strcmp(takeName(tables[i].getName()), name)==0) {
				tables[i].writeInFile(fileToSave);
			}
		}
	}
}
Table& DataBase::operator[](size_t index) const
{
	return tables[index];
}

Table& DataBase::operator[](size_t index)
{
	return tables[index];
}

DataBase& DataBase::operator=(const DataBase& other)
{
	if (this != &other) {
		copyFrom(other);
	}
	return *this;
}

DataBase::~DataBase()
{
	free();
}