Creating a python package to convert /transfer excelsheet data to a mysql Database Table

Last update: Jan 07, 2022

Overview

################################################################Sourcecode:##############################################################

import pandas as pd import sys import mysql.connector as mysql from tkinter import * from tkinter import messagebox

class Convert_ExcelSheet_To_MySqlTable: def init(self,username,password,hostname,excel_file,database_name,number_of_columns,sql): self.excel_file=excel_file self.username=username self.password=password self.hostname=hostname self.sql=sql self.database_name=database_name self.number_of_columns=number_of_columns

   def Convert_to_MySqlDatabaseTable(self):
        root = Tk()
        root.withdraw()
        read=pd.read_excel(self.excel_file, engine='openpyxl')
        read_array=read.to_numpy()
        try:
            con=mysql.connect(user=self.username,password=self.password,host=self.hostname)
            messagebox.showinfo("Authentification", "You have Logged into the database successfully")
            for reading in read_array:
                  finalvalues=[]
                  count=0
                  while count

 #######################Instructions you need to followcarefully##############################
 from excelsheet_to_mysqldatabasetable.excel_converter import Convert_ExcelSheet_To_MySqlTable
 excel_file_path=open(r"C:\Users\LAMECK\Desktop\Excel Converter\documentation\db4.xlsx","rb")
 #Enter your table name and the columns you have in your mysql table .Note the columns in the excel sheet and mysql table should be in the same order. #Enter( %s ) according to the number of columns you have .
 sql=" INSERT INTO db4(serialnumber,entrynumber,volumenumber,district,year,user,hospital) VALUES(%s,%s,%s,%s,%s,%s,%s)"
 convert=Convert_ExcelSheet_To_MySqlTable(username="root",password="tangimeko7583",hostname="localhost",excel_file=excel_file_path,database_name="db4",number_of_columns=7,sql=sql) convert.Convert_to_MySqlDatabaseTable()
 found at ( https://pypi.org/project/excelsheet-to-mysqldatabasetable/2.4.0/ )

Creating a python package to convert /transfer excelsheet data to a mysql Database Table

Related tags

Overview

Owner

Odiwuor Lameck

Logica is a logic programming language that compiles to StandardSQL and runs on Google BigQuery.

Async ODM (Object Document Mapper) for MongoDB based on python type hints

MongoX is an async python ODM for MongoDB which is built on top Motor and Pydantic.

Python client for Apache Kafka

Python interface to Oracle Database conforming to the Python DB API 2.0 specification.

SQL queries to collections

MariaDB connector using python and flask

asyncio (PEP 3156) Redis support

Official Python low-level client for Elasticsearch

An extension package of 🤗 Datasets that provides support for executing arbitrary SQL queries on HF datasets

CouchDB client built on top of aiohttp (asyncio)

Estoult - a Python toolkit for data mapping with an integrated query builder for SQL databases

A SQL linter and auto-formatter for Humans

Pony Object Relational Mapper

Monty, Mongo tinified. MongoDB implemented in Python !

A tiny python web application based on Flask to set, get, expire, delete keys of Redis database easily with direct link at the browser.

A simple python package that perform SQL Server Source Control and Auto Deployment.

A Python DB-API and SQLAlchemy dialect to Google Spreasheets

sync/async MongoDB ODM, yes.

Simplest SQL mapper in Python, probably