Before you proceed, make sure you know Some real SQL, before looking at the code, otherwise you probably won't understand anything.
Installation
pip install EasierSQL
EasySQLite code examples -:
import EasierSQLite
database = EasierSQLite.easierSQLite("dataBaseName")
# Creating a table
created_Table = database.create_Table('table_Name','userName TEXT NOT NULL, userID INT PRIMARY KEY')
"""
The second argument is where you write the Column names, their Datatypes and constraints!
Also there is an optional third argument called 'check_if_exists' by default it is True.
"""
print(created_Table) # Returns the result.
# Inserting values into a table.
insert = database.insert_values('table_Name','columns_names','values_here')
print(insert) # Returns the result.
# Getting values from a table
selected_value = database.select_values('table_Name', columnNames='column_Names',limit='1000',clauses='here')
"""
Most of the arguemnts here, have default values for example,
If you leave columnNames blank it will get all the values from the rows by default.
If you leave limit blank, it will get 100 rows max from the table by default.
In the clauses argument you can add your where clause, cases etc. If left none it won't affect anything.
"""
print(selected_value) # Returns the list of values (or an error).
To compensate for no documentation at the moment, here are all the functions.
database.create_Table()
database.select_values()
database.insert_values()
database.delete_table()
database.create_new_column()
database.delete_row()
database.rename_Table()
database.rename_Column()
database.attach_database()
database.detach_database()
database.execute_custom_query() # Returns the database, so you can execute Your own query, if the module doesn't support that type.
Example of execute_custom_query()
import EasierSQLite
database = EasierSQLite.easierSQLite("dataBaseName")
tempDB = database.execute_custom_query()
cursor = tempDB.cursor()
cursor.execute("SQL_QUERY")
# tempDB.commit() COMMIT IF NECESSARY
tempDB.close() # Close database after done with it for good practice.
EasyMySQL Code example -:
import EasierMySQL
database = EasierMySQL.easierMySQL(
userName = 'userNAME',
passwrd = 'password',
host = 'host'
database = 'database'
)
# Creating a table
created_Table = database.create_Table('table_Name','userName VARCHAR(20) NOT NULL, userID INT PRIMARY KEY')
print(created_Table) # Returns the result.
# Inserting values into a table.
insert = database.insert_values('table_Name','columns_names','values_here')
print(insert) # Returns the result.
# Getting values from a table
selected_value = database.select_values('table_Name', columnNames='column_Names',limit='1000',clauses='here')
print(selected_value) # Returns the list of values (or an error).
Here are all the functions but for EasierMYSQL.
database.create_Table()
database.select_values()
database.insert_values()
database.delete_table()
database.create_new_column()
database.delete_row()
database.rename_Table()
database.rename_Column()
database.attach_database()
database.detach_database()
database.delete_column()
database.show_tables()
database.execute_custom_query() # Returns the database, so you can execute Your own query, if the module doesn't support that type.
The execute_custom_query is as same as the One in EasierSQLLite.
4 Apr 4, 2022
4 Dec 1, 2021
19 Dec 15, 2022
6 Oct 31, 2022
2.2k Dec 25, 2022
1.5k Jan 3, 2023
462 Dec 24, 2022
12 Jan 01, 2023
6 May 30, 2022
3 Nov 04, 2022
5 Dec 29, 2022
9.7k Dec 30, 2022
0 Jul 06, 2022
1 Jan 10, 2022
8 Dec 12, 2022
993 Jan 03, 2023
582 Dec 28, 2022
4 Jul 12, 2021
171 Dec 18, 2022
64 Oct 14, 2022
35 Dec 23, 2022
1 Nov 09, 2021
5 Jun 24, 2021
6.9k Jan 07, 2023
1 Feb 08, 2022