# odbms
odbms is a Python package for managing MySQL, MongoDB, SQLite, and PostgreSQL database instances.
## Features
- Supports multiple database management systems (MySQL, MongoDB, SQLite, PostgreSQL)
- Provides a unified interface for database operations across different DBMSs
- Includes an ORM-like model system for easy data manipulation
- Supports table creation, alteration, and basic CRUD operations
## Installation
Install odbms using pip:
```shell
pip install odbms
```
## Usage
```python
from odbms import DBMS
# Initialize with default settings
DBMS.initialize_with_defaults('sqlite', 'database_name')
# Or initialize with custom settings
DBMS.initialize('postgresql', port=5432, username='postgres', password='', database='database_name')
```
```python
from odbms import Model
class User(Model):
TABLE_NAME = 'users'
def init(self, email: str, name: str, password: str, image: str = '', gat: str ='', grt: str ='', created_at=None, updated_at=None, id=None):
super().init(created_at, updated_at, id)
self.email = email
self.name = name
self.password = password
self.image = image
self.gat = gat
self.grt = grt
#Create the table if not mongodb (sqlite, mysql, postgresql)
User.create_table()
```
```python
# Insert a new user
new_user = User('test@user.com', 'Test User', 'MyPassword')
new_user.save()
# Retrieve all users
users = User.all()
# Find a specific user
user = User.find_one({'email': 'test@user.com'})
# Update a user
user.name = 'Updated Name'
user.save()
# Get the json representation of the user
user.json()
# Delete a user
Delete a user
User.remove({'email': 'test@user.com'})
```
Raw data
{
"_id": null,
"home_page": null,
"name": "odbms",
"maintainer": null,
"docs_url": null,
"requires_python": null,
"maintainer_email": null,
"keywords": "python3 runit developer serverless architecture docker sqlite mysql mongodb",
"author": "Amos Amissah",
"author_email": "theonlyamos@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/97/c8/b441dc046a5b56eae712a41f236bc73627be804d7f5aedfb4e22307c3da6/odbms-0.3.7.tar.gz",
"platform": null,
"description": "# odbms\n\nodbms is a Python package for managing MySQL, MongoDB, SQLite, and PostgreSQL database instances.\n\n## Features\n\n- Supports multiple database management systems (MySQL, MongoDB, SQLite, PostgreSQL)\n- Provides a unified interface for database operations across different DBMSs\n- Includes an ORM-like model system for easy data manipulation\n- Supports table creation, alteration, and basic CRUD operations\n\n## Installation\n\nInstall odbms using pip:\n\n```shell\npip install odbms\n```\n\n## Usage\n\n```python\nfrom odbms import DBMS\n\n# Initialize with default settings\nDBMS.initialize_with_defaults('sqlite', 'database_name')\n\n# Or initialize with custom settings\nDBMS.initialize('postgresql', port=5432, username='postgres', password='', database='database_name')\n```\n\n```python\nfrom odbms import Model\n\nclass User(Model):\n TABLE_NAME = 'users'\n\n def init(self, email: str, name: str, password: str, image: str = '', gat: str ='', grt: str ='', created_at=None, updated_at=None, id=None):\n super().init(created_at, updated_at, id)\n\n self.email = email\n self.name = name\n self.password = password\n self.image = image\n self.gat = gat\n self.grt = grt\n\n#Create the table if not mongodb (sqlite, mysql, postgresql)\nUser.create_table()\n```\n\n```python\n# Insert a new user\nnew_user = User('test@user.com', 'Test User', 'MyPassword')\nnew_user.save()\n\n# Retrieve all users\nusers = User.all()\n\n# Find a specific user\nuser = User.find_one({'email': 'test@user.com'})\n\n# Update a user\nuser.name = 'Updated Name'\nuser.save()\n\n# Get the json representation of the user\nuser.json()\n\n# Delete a user\nDelete a user\nUser.remove({'email': 'test@user.com'})\n```\n",
"bugtrack_url": null,
"license": null,
"summary": "Database client for Mysql, MongoDB and Sqlite",
"version": "0.3.7",
"project_urls": {
"Source": "https://github.com/theonlyamos/odbms/",
"Tracker": "https://github.com/theonlyamos/odbms/issues"
},
"split_keywords": [
"python3",
"runit",
"developer",
"serverless",
"architecture",
"docker",
"sqlite",
"mysql",
"mongodb"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "2c7c0deaef89e0aa003054d5a73bbaa54067379d8de186d13e5d66e2adf8824a",
"md5": "befb4e3909bf677e3184624246959f69",
"sha256": "7e9ee478d929d40a253dc0efe4503756a9ff1fa393d5820dc772d89f6c118649"
},
"downloads": -1,
"filename": "odbms-0.3.7-py3-none-any.whl",
"has_sig": false,
"md5_digest": "befb4e3909bf677e3184624246959f69",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 28905,
"upload_time": "2024-09-09T16:32:08",
"upload_time_iso_8601": "2024-09-09T16:32:08.819004Z",
"url": "https://files.pythonhosted.org/packages/2c/7c/0deaef89e0aa003054d5a73bbaa54067379d8de186d13e5d66e2adf8824a/odbms-0.3.7-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "97c8b441dc046a5b56eae712a41f236bc73627be804d7f5aedfb4e22307c3da6",
"md5": "25738327c1f38d30a3b093e90bb14b4a",
"sha256": "704d944cb9dbd13477e5cea0ed885db24efb1df8aefb22f76239ea771f4bf14c"
},
"downloads": -1,
"filename": "odbms-0.3.7.tar.gz",
"has_sig": false,
"md5_digest": "25738327c1f38d30a3b093e90bb14b4a",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 25862,
"upload_time": "2024-09-09T16:32:10",
"upload_time_iso_8601": "2024-09-09T16:32:10.202836Z",
"url": "https://files.pythonhosted.org/packages/97/c8/b441dc046a5b56eae712a41f236bc73627be804d7f5aedfb4e22307c3da6/odbms-0.3.7.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-09-09 16:32:10",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "theonlyamos",
"github_project": "odbms",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "odbms"
}
JSON
