index.c

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <stdbool.h> // Añadido para el tipo bool

// Declaraciones de funciones en Database
#ifdef __cplusplus
extern "C" {
#endif

bool createTable(const char* tableName);
bool alterTableAddColumn(const char* tableName, const char* columnName, const char* columnType);
bool insertIntoTable(const char* tableName, const char* values[], int numValues);
bool deleteFromTable(const char* tableName, const char* condition);
bool joinTables(const char* table1, const char* table2, const char* condition);

#ifdef __cplusplus
}
#endif

#define MAX_COMMAND_LENGTH 256

void executeCommand(const char* command) {
    char cmd[MAX_COMMAND_LENGTH];
    strcpy(cmd, command);
    char* token = strtok(cmd, " ");

    if (strcmp(token, "CREATE") == 0) {
        token = strtok(NULL, " ");
        if (strcmp(token, "TABLE") == 0) {
            char* tableName = strtok(NULL, " ");
            if (createTable(tableName)) {
                printf("Table %s created successfully.\n", tableName);
            } else {
                printf("Error: Table %s already exists.\n", tableName);
            }
        }
    } else if (strcmp(token, "ADD") == 0) {
        token = strtok(NULL, " ");
        if (strcmp(token, "COLUMN") == 0) {
            char* tableName = strtok(NULL, " ");
            char* columnName = strtok(NULL, " ");
            char* columnType = strtok(NULL, " ");
            if (alterTableAddColumn(tableName, columnName, columnType)) {
                printf("Column %s added to table %s successfully.\n", columnName, tableName);
            } else {
                printf("Error: Column %s already exists in table %s or table does not exist.\n", columnName, tableName);
            }
        }
    } else if (strcmp(token, "INSERT") == 0) {
        char* tableName = strtok(NULL, " ");
        const char* values[10]; // Suponemos un máximo de 10 valores
        int numValues = 0;
        while ((token = strtok(NULL, " ")) != NULL) {
            values[numValues++] = token;
        }
        if (insertIntoTable(tableName, values, numValues)) {
            printf("Data inserted into table %s successfully.\n", tableName);
        } else {
            printf("Error: Table %s does not exist.\n", tableName);
        }
    } else if (strcmp(token, "DELETE") == 0) {
        char* tableName = strtok(NULL, " ");
        char* condition = strtok(NULL, " ");
        if (deleteFromTable(tableName, condition)) {
            printf("Data deleted from table %s successfully.\n", tableName);
        } else {
            printf("Error: Could not delete data from table %s.\n", tableName);
        }
    } else if (strcmp(token, "JOIN") == 0) {
        char* table1 = strtok(NULL, " ");
        char* table2 = strtok(NULL, " ");
        char* condition = strtok(NULL, " ");
        if (joinTables(table1, table2, condition)) {
            printf("Joined tables %s and %s successfully.\n", table1, table2);
        } else {
            printf("Error: Could not join tables %s and %s.\n", table1, table2);
        }
    } else {
        printf("Unknown command: %s\n", command);
    }
}

int main() {
    char command[MAX_COMMAND_LENGTH];

    printf("Database Terminal\n");
    printf("Enter SQL commands, or type 'exit' to quit.\n");

    while (1) {
        printf("$> ");
        if (fgets(command, MAX_COMMAND_LENGTH, stdin) == NULL) {
            break;
        }
        command[strcspn(command, "\n")] = 0; // Eliminar nueva línea
        if (strcmp(command, "exit") == 0) {
            break;
        }
        executeCommand(command);
    }

    return 0;
}