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
126 Jan 03, 2023
1 Dec 25, 2021
1 Feb 07, 2022
0 Dec 31, 2021
158 Jan 07, 2023
3.6k Jan 03, 2023
522 Jan 01, 2023
6.9k Jan 03, 2023
582 Dec 28, 2022
345 Dec 28, 2022
2.1k Dec 30, 2022
251 Oct 25, 2022
162 Dec 19, 2022
5.5k Jan 08, 2023
13.2k Jan 02, 2023
629 Nov 21, 2022
5 Dec 29, 2022