A single Package for all the database connectivities ( E.g : MySQL, MongoDb, Cassandra)
Project description
database-connect
A single Package for all the database connectivities ( E.g : MySQL, MongoDb, Cassandra)
Release Note - version 0.1.6.1
Support for Mongodb and Cassandra(Datastax Astra) are available. Features available:
- Create database/tables
- Read tables
- Update tables
- Delete records
- Csv/excel data insertion to the available databases.
Upcoming Plan - version 0.1.7
Support for Mysql
How to Use
- in jupyter notebook -
!pip install database-connect
- in command prompt -
pip install database-connect
Database Operations
- import database_connect module
import database_connect as connection
Let's Do The Operations
- For MongoDb Operations
import database_connect as connection
#create the parameters
client_url = 'paste_your_mongodb_connection_url' #should be a string
database = 'your_database_name' #should be a string
collection_name = 'your_collection_name' #should be a string
#let's create the mongo object
mongo = connection.mongo_operation(client_url=client_url,
database=database,
collection_name=collection_name)
- For Cassandra Operations
import database_connect as connection
zip_path = 'paste_the_zip_path' #should be a string
client_id = 'paste_the_client_id' #should be a string
client_secret = 'paste_the_client_secret' #should be a string
keyspace = 'paste_the_keyspace name' #should be a string #note: keyspace should be created manually in datastax cassandra. Keyspaces are not allowed to create from backend.
table_name = 'paste_the_table_name'
cassandra = connection.cassandra_operations(zip_path,
client_id,
client_secret,
keyspace,
table_name)
-
Detailed Documentation: Check Here
-
Creator - Hrisikesh Neogi
For any suggestion, contact me on hrisikesh.neogi@gmail.com.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distributions
Close
Hashes for database_connect-0.1.65-py3.10.egg
Algorithm | Hash digest | |
---|---|---|
SHA256 | bcf9a81bca763529346c5a0e701a46e5d38a83b182c993434320e193ad1e63e3 |
|
MD5 | 4d57d7db317c5ee7c20c381ae78dee94 |
|
BLAKE2b-256 | 127a7ea1c3c22a5a0488edc54b05a85c720372e6caef758a22d8a377abae01c3 |
Close
Hashes for database_connect-0.1.65-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e6a40199716070704ef04ced8ffc102e3ca7f9658b86eedfe7c6cf42bba2eb81 |
|
MD5 | 88d7789fe02be73179d526f9b1886812 |
|
BLAKE2b-256 | fd1947ecbe81b013de4fa3917f90fcae860ccbf5c5c6a85999571e42c2b4249c |