| Name | atlas-provider-sqlalchemy JSON |
| Version |
0.4.1
JSON |
| download |
| home_page | None |
| Summary | Load sqlalchemy models into an Atlas project. |
| upload_time | 2025-10-08 08:46:37 |
| maintainer | None |
| docs_url | None |
| author | Your Name |
| requires_python | <4.0,>=3.9 |
| license | None |
| keywords |
|
| VCS |
|
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
# atlas-provider-sqlalchemy
Use [Atlas](https://atlasgo.io/) with [SQLAlchemy](https://www.sqlalchemy.org/) to manage your database schema as code. By connecting your SQLAlchemy models to Atlas,
you can define and edit your schema directly in Python, and Atlas will automatically plan and apply database schema migrations for you, eliminating
the need to write migrations manually.
Atlas brings automated CI/CD workflows to your database, along with built-in support for [testing](https://atlasgo.io/testing/schema), [linting](https://atlasgo.io/versioned/lint),
schema [drift detection](https://atlasgo.io/monitoring/drift-detection), and [schema monitoring](https://atlasgo.io/monitoring). It also allows you to extend SQLAlchemy with
advanced database objects such as triggers, row-level security, and custom functions that are not supported natively.
### Use-cases
1. [**Declarative migrations**](https://atlasgo.io/declarative/apply) - Use the Terraform-like `atlas schema apply --env sqlalchemy` command to apply your SQLAlchemy schema to the database.
2. [**Automatic migration planning**](https://atlasgo.io/versioned/diff) - Use `atlas migrate diff --env sqlalchemy` to automatically plan database schema changes and generate
a migration from the current database version to the desired version defined by your SQLAlchemy schema.
### Installation
Install Atlas from macOS or Linux by running:
```bash
curl -sSf https://atlasgo.sh | sh
```
See [atlasgo.io](https://atlasgo.io/getting-started#installation) for more installation options.
Install the provider by running:
```bash
# The Provider works by importing your SQLAlchemy models and extracting the schema from them.
# Therefore, you will need to run the provider from within your project's Python environment.
pip install atlas-provider-sqlalchemy
```
#### Standalone
If all of your SQLAlchemy models exist in a single package,
you can use the provider directly to load your SQLAlchemy schema into Atlas.
In your project directory, create a new file named `atlas.hcl` with the following contents:
```hcl
data "external_schema" "sqlalchemy" {
program = [
"atlas-provider-sqlalchemy",
"--path", "./path/to/models",
"--dialect", "mysql" // mariadb | postgresql | sqlite | mssql
]
}
env "sqlalchemy" {
src = data.external_schema.sqlalchemy.url
dev = "docker://mysql/8/dev"
migration {
dir = "file://migrations"
}
format {
migrate {
diff = "{{ sql . \" \" }}"
}
}
}
```
#### As Python Script
If you want to use the provider as a python script, you can use the provider as follows:
Create a new file named `load_models.py` with the following contents:
```python
# import all models
from models import User, Task
from atlas_provider_sqlalchemy.ddl import print_ddl
print_ddl("mysql", [User, Task])
```
Next, in your project directory, create a new file named `atlas.hcl` with the following contents:
```hcl
data "external_schema" "sqlalchemy" {
program = [
"python",
"load_models.py"
]
}
env "sqlalchemy" {
src = data.external_schema.sqlalchemy.url
dev = "docker://mysql/8/dev"
migration {
dir = "file://migrations"
}
format {
migrate {
diff = "{{ sql . \" \" }}"
}
}
}
```
### Usage
Once you have the provider installed, you can use it to apply your SQLAlchemy schema to the database:
#### Apply
You can use the `atlas schema apply` command to plan and apply a migration of your database to your current SQLAlchemy schema.
This works by inspecting the target database and comparing it to the SQLAlchemy schema and creating a migration plan.
Atlas will prompt you to confirm the migration plan before applying it to the database.
```bash
atlas schema apply --env sqlalchemy -u "mysql://root:password@localhost:3306/mydb"
```
Where the `-u` flag accepts the [URL](https://atlasgo.io/concepts/url) to the
target database.
#### Diff
Atlas supports a [version migration](https://atlasgo.io/concepts/declarative-vs-versioned#versioned-migrations)
workflow, where each change to the database is versioned and recorded in a migration file. You can use the
`atlas migrate diff` command to automatically generate a migration file that will migrate the database
from its latest revision to the current SQLAlchemy schema.
```bash
atlas migrate diff --env sqlalchemy
````
### Supported Databases
The provider supports the following databases:
* MySQL
* MariaDB
* PostgreSQL
* SQLite
* Microsoft SQL Server
* ClickHouse
### FAQ
#### How to include schema creation in the migration?
Sometimes your tables may not reside in the default schema, and you may want to create the schema as part of the migration.
you can utilize [composite schemas](https://atlasgo.io/atlas-schema/projects#data-source-composite_schema) to add custom DDL in addition to the SQLAlchemy schema.
change your `atlas.hcl` like this:
```hcl
data "external_schema" "sqlalchemy" {
program = [
"atlas-provider-sqlalchemy",
"--path", "./path/to/models",
"--dialect", "postgresql"
]
}
data "composite_schema" "app" {
# Create the test schema first
schema "public" {
url = "file://schema.sql"
}
# Next, load the sqlalchemy models.
schema "public" {
url = data.external_schema.sqlalchemy.url
}
}
env "sqlalchemy" {
src = data.composite_schema.app.url
dev = "docker://postgres/16/dev"
migration {
dir = "file://migrations"
}
format {
migrate {
diff = "{{ sql . \" \" }}"
}
}
}
```
and create a `schema.sql` file with the following contents (change the schema name as needed):
```sql
CREATE SCHEMA IF NOT EXISTS test;
```
### Credit
The code in this repository is based on [noamtamir/atlas-provider-sqlalchemy](https://github.com/noamtamir/atlas-provider-sqlalchemy).
### Issues
Please report any issues or feature requests in the [ariga/atlas](https://github.com/ariga/atlas/issues) repository.
### License
This project is licensed under the [Apache License 2.0](LICENSE).
Raw data
{
"_id": null,
"home_page": null,
"name": "atlas-provider-sqlalchemy",
"maintainer": null,
"docs_url": null,
"requires_python": "<4.0,>=3.9",
"maintainer_email": null,
"keywords": null,
"author": "Your Name",
"author_email": "you@example.com",
"download_url": "https://files.pythonhosted.org/packages/ff/20/0b991daacb58a80a537669c508a907225645c7566a4488941d41d01cf474/atlas_provider_sqlalchemy-0.4.1.tar.gz",
"platform": null,
"description": "# atlas-provider-sqlalchemy\n\nUse [Atlas](https://atlasgo.io/) with [SQLAlchemy](https://www.sqlalchemy.org/) to manage your database schema as code. By connecting your SQLAlchemy models to Atlas,\nyou can define and edit your schema directly in Python, and Atlas will automatically plan and apply database schema migrations for you, eliminating\nthe need to write migrations manually.\n\nAtlas brings automated CI/CD workflows to your database, along with built-in support for [testing](https://atlasgo.io/testing/schema), [linting](https://atlasgo.io/versioned/lint),\nschema [drift detection](https://atlasgo.io/monitoring/drift-detection), and [schema monitoring](https://atlasgo.io/monitoring). It also allows you to extend SQLAlchemy with\nadvanced database objects such as triggers, row-level security, and custom functions that are not supported natively.\n\n### Use-cases\n1. [**Declarative migrations**](https://atlasgo.io/declarative/apply) - Use the Terraform-like `atlas schema apply --env sqlalchemy` command to apply your SQLAlchemy schema to the database.\n2. [**Automatic migration planning**](https://atlasgo.io/versioned/diff) - Use `atlas migrate diff --env sqlalchemy` to automatically plan database schema changes and generate\n a migration from the current database version to the desired version defined by your SQLAlchemy schema.\n\n### Installation\n\nInstall Atlas from macOS or Linux by running:\n```bash\ncurl -sSf https://atlasgo.sh | sh\n```\n\nSee [atlasgo.io](https://atlasgo.io/getting-started#installation) for more installation options.\n\nInstall the provider by running:\n```bash\n# The Provider works by importing your SQLAlchemy models and extracting the schema from them.\n# Therefore, you will need to run the provider from within your project's Python environment.\npip install atlas-provider-sqlalchemy\n```\n\n#### Standalone \n\nIf all of your SQLAlchemy models exist in a single package, \nyou can use the provider directly to load your SQLAlchemy schema into Atlas.\n\nIn your project directory, create a new file named `atlas.hcl` with the following contents:\n\n```hcl\ndata \"external_schema\" \"sqlalchemy\" {\n program = [\n \"atlas-provider-sqlalchemy\",\n \"--path\", \"./path/to/models\",\n \"--dialect\", \"mysql\" // mariadb | postgresql | sqlite | mssql\n ]\n}\n\nenv \"sqlalchemy\" {\n src = data.external_schema.sqlalchemy.url\n dev = \"docker://mysql/8/dev\"\n migration {\n dir = \"file://migrations\"\n }\n format {\n migrate {\n diff = \"{{ sql . \\\" \\\" }}\"\n }\n }\n}\n```\n\n#### As Python Script \n\nIf you want to use the provider as a python script, you can use the provider as follows:\n\nCreate a new file named `load_models.py` with the following contents:\n\n```python\n# import all models\nfrom models import User, Task\nfrom atlas_provider_sqlalchemy.ddl import print_ddl\nprint_ddl(\"mysql\", [User, Task])\n```\n\nNext, in your project directory, create a new file named `atlas.hcl` with the following contents:\n\n```hcl\ndata \"external_schema\" \"sqlalchemy\" {\n program = [\n \"python\",\n \"load_models.py\"\n ]\n}\n\nenv \"sqlalchemy\" {\n src = data.external_schema.sqlalchemy.url\n dev = \"docker://mysql/8/dev\"\n migration {\n dir = \"file://migrations\"\n }\n format {\n migrate {\n diff = \"{{ sql . \\\" \\\" }}\"\n }\n }\n}\n```\n\n### Usage\n\nOnce you have the provider installed, you can use it to apply your SQLAlchemy schema to the database:\n\n#### Apply\n\nYou can use the `atlas schema apply` command to plan and apply a migration of your database to your current SQLAlchemy schema.\nThis works by inspecting the target database and comparing it to the SQLAlchemy schema and creating a migration plan.\nAtlas will prompt you to confirm the migration plan before applying it to the database.\n\n```bash\natlas schema apply --env sqlalchemy -u \"mysql://root:password@localhost:3306/mydb\"\n```\nWhere the `-u` flag accepts the [URL](https://atlasgo.io/concepts/url) to the\ntarget database.\n\n#### Diff\n\nAtlas supports a [version migration](https://atlasgo.io/concepts/declarative-vs-versioned#versioned-migrations) \nworkflow, where each change to the database is versioned and recorded in a migration file. You can use the\n`atlas migrate diff` command to automatically generate a migration file that will migrate the database\nfrom its latest revision to the current SQLAlchemy schema.\n\n```bash\natlas migrate diff --env sqlalchemy \n````\n\n### Supported Databases\n\nThe provider supports the following databases:\n* MySQL\n* MariaDB\n* PostgreSQL\n* SQLite\n* Microsoft SQL Server\n* ClickHouse\n\n### FAQ\n\n#### How to include schema creation in the migration?\n\nSometimes your tables may not reside in the default schema, and you may want to create the schema as part of the migration.\n\nyou can utilize [composite schemas](https://atlasgo.io/atlas-schema/projects#data-source-composite_schema) to add custom DDL in addition to the SQLAlchemy schema.\n\nchange your `atlas.hcl` like this:\n\n```hcl\n\ndata \"external_schema\" \"sqlalchemy\" {\n program = [\n \"atlas-provider-sqlalchemy\",\n \"--path\", \"./path/to/models\",\n \"--dialect\", \"postgresql\"\n ]\n}\n\ndata \"composite_schema\" \"app\" {\n # Create the test schema first\n schema \"public\" {\n url = \"file://schema.sql\"\n }\n # Next, load the sqlalchemy models.\n schema \"public\" {\n url = data.external_schema.sqlalchemy.url\n }\n}\n\nenv \"sqlalchemy\" {\n src = data.composite_schema.app.url\n dev = \"docker://postgres/16/dev\"\n migration {\n dir = \"file://migrations\"\n }\n format {\n migrate {\n diff = \"{{ sql . \\\" \\\" }}\"\n }\n }\n}\n```\n\nand create a `schema.sql` file with the following contents (change the schema name as needed):\n\n```sql\nCREATE SCHEMA IF NOT EXISTS test;\n```\n\n### Credit\n\nThe code in this repository is based on [noamtamir/atlas-provider-sqlalchemy](https://github.com/noamtamir/atlas-provider-sqlalchemy).\n\n### Issues\n\nPlease report any issues or feature requests in the [ariga/atlas](https://github.com/ariga/atlas/issues) repository.\n\n### License\n\nThis project is licensed under the [Apache License 2.0](LICENSE).\n",
"bugtrack_url": null,
"license": null,
"summary": "Load sqlalchemy models into an Atlas project.",
"version": "0.4.1",
"project_urls": null,
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "ca020303858ddd334fa87c032db14266aac8b5a21abb1a9c50dd244b0f53b7d5",
"md5": "9131583ebabd308a570cfe8cba28cdb8",
"sha256": "c1d9e9e6458965b3642d67ce95e71ec51dd2742d348cc0e5349703f2a29a1f6c"
},
"downloads": -1,
"filename": "atlas_provider_sqlalchemy-0.4.1-py3-none-any.whl",
"has_sig": false,
"md5_digest": "9131583ebabd308a570cfe8cba28cdb8",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": "<4.0,>=3.9",
"size": 12016,
"upload_time": "2025-10-08T08:46:36",
"upload_time_iso_8601": "2025-10-08T08:46:36.432874Z",
"url": "https://files.pythonhosted.org/packages/ca/02/0303858ddd334fa87c032db14266aac8b5a21abb1a9c50dd244b0f53b7d5/atlas_provider_sqlalchemy-0.4.1-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "ff200b991daacb58a80a537669c508a907225645c7566a4488941d41d01cf474",
"md5": "44635da6faa4115abe0cf1190fe4f0c6",
"sha256": "a95f06b5edd78b13b99fa00eda4bbf5276c1ac42080248987d24de4b73b10b79"
},
"downloads": -1,
"filename": "atlas_provider_sqlalchemy-0.4.1.tar.gz",
"has_sig": false,
"md5_digest": "44635da6faa4115abe0cf1190fe4f0c6",
"packagetype": "sdist",
"python_version": "source",
"requires_python": "<4.0,>=3.9",
"size": 10068,
"upload_time": "2025-10-08T08:46:37",
"upload_time_iso_8601": "2025-10-08T08:46:37.320076Z",
"url": "https://files.pythonhosted.org/packages/ff/20/0b991daacb58a80a537669c508a907225645c7566a4488941d41d01cf474/atlas_provider_sqlalchemy-0.4.1.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-10-08 08:46:37",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "atlas-provider-sqlalchemy"
}
