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
1.4k Dec 31, 2022
2.1k Dec 30, 2022
95 Jan 05, 2023
7 Jun 04, 2022
1 Nov 19, 2021
3.7k Jan 08, 2023
428 Dec 29, 2022
6.9k Jan 03, 2023
133 Dec 06, 2022
45 Jun 01, 2022
1 Feb 26, 2022
3.6k Jan 03, 2023
0 Dec 28, 2021
3.3k Dec 31, 2022
31 Dec 06, 2022
64 Oct 14, 2022
549 Nov 18, 2022