feat: add schema conversions when adding new rows to a table and schema conversion when creating a new table

[alex-senger]

Closes #404
Closes #322
Closes #127
This Pull request merges the issues #322 and #127.

Summary of Changes

[Marsmaennchen221]

I don't have an idea how to cover the abstract initializer of Columntype for CodeCoverage. We cannot simply remove the initializer, as it is needed for the Linter in the merge_multiple_schemas method.

Currently every abstract method we have has a docstring block instead of a pass. Try this to satisfy CodeCoverage. @alex-senger

[Marsmaennchen221]

It seems like we do not use the SchemaMismatchError anymore. If we want to keep this error because we might need it in the future, we have to add a test like this:

import pytest

from safeds.exceptions import SchemaMismatchError


def test_should_raise_schema_mismatch_error() -> None:
    with pytest.raises(SchemaMismatchError, match=r"Failed because at least two schemas didn't match."):
        raise SchemaMismatchError()

@lars-reimann Do we want to keep this error?

[lars-reimann]

It seems like we do not use the SchemaMismatchError anymore. If we want to keep this error because we might need it in the future, we have to add a test like this:

import pytest

from safeds.exceptions import SchemaMismatchError


def test_should_raise_schema_mismatch_error() -> None:
    with pytest.raises(SchemaMismatchError, match=r"Failed because at least two schemas didn't match."):
        raise SchemaMismatchError()

@lars-reimann Do we want to keep this error?

If we don't use it at the moment, let's remove it. We can add it again if we ever need it.

[Marsmaennchen221]

[Marsmaennchen221]

If you accept these changed a Series with Integer and NANs will be considered as an Integer? ColumnType. Before this would be a RealNumber?. With this changes we also convert RealNumber ColumnTypes into Integer ColumnTypes if they have no decimal places (if they end on .0) as we will not loose any information with this convertion

[lars-reimann]

🎉 This PR is included in version 0.15.0 🎉

The release is available on:

• v0.15.0
• GitHub release

Your semantic-release bot 📦🚀