Function TestSQLiteIntegration

IceFireDB-SQLite/internal/sqlite/db_test.go:90–174

(t *testing.T)

}

func TestSQLiteIntegration(t *testing.T) {
	// Create a temporary database file
	tmpFile := "/tmp/test_sqlite_" + time.Now().Format("20060102150405") + ".db"
	defer os.Remove(tmpFile)

	// Initialize SQLite database
	ctx := context.Background()
	db := InitSQLite(ctx, tmpFile)
	defer db.Close()

	// Test table creation
	createSQL := "CREATE TABLE IF NOT EXISTS test_users (id INTEGER PRIMARY KEY, name VARCHAR(50), email VARCHAR(100))"
	result, err := Exec(createSQL)
	if err != nil {
		t.Fatalf("Failed to create table: %v", err)
	}

	if result.Status != 2 {
		t.Errorf("Expected status 2 for DML, got %d", result.Status)
	}

	// Test INSERT
	insertSQL := "INSERT INTO test_users (name, email) VALUES ('test_user', 'test@example.com')"
	result, err = Exec(insertSQL)
	if err != nil {
		t.Fatalf("Failed to insert data: %v", err)
	}

	if result.InsertId != 1 {
		t.Errorf("Expected InsertId 1, got %d", result.InsertId)
	}

	if result.AffectedRows != 1 {
		t.Errorf("Expected AffectedRows 1, got %d", result.AffectedRows)
	}

	// Test SELECT
	selectSQL := "SELECT * FROM test_users"
	result, err = Exec(selectSQL)
	if err != nil {
		t.Fatalf("Failed to select data: %v", err)
	}

	if result.Status != 31 {
		t.Errorf("Expected status 31 for SELECT, got %d", result.Status)
	}

	if len(result.Fields) != 3 {
		t.Errorf("Expected 3 fields, got %d", len(result.Fields))
	}

	if result.AffectedRows != 1 {
		t.Errorf("Expected 1 row affected, got %d", result.AffectedRows)
	}

	// Verify field information
	expectedFields := []string{"id", "name", "email"}
	for i, field := range result.Fields {