Skip to main content

Connect Access & retrieve MYSQl databases.

Project description

Help on ConnectSql in module Connect object:

class ConnectSql(builtins.object)
ConnectSql(Username, Password)

ConnectSQL is a very useful & perfectly designed module to Connect to SQL database & retrieve data.

Methods defined here:

__init__(self, Username, Password)
Initialize some values before Starting.
Parameters:
Username: Enter Your Username.
Password: Enter your Password.
By default host is Local Host as per your machine’s IP Address.
Recommendation:
We Recommend setting the default value of the table which will help you in skipping parameters.
Method: <Object>.default_table(self).

alter(self, table=None, modify=None, change=None, add_column=None, add_key=None, drop_column=None, drop_key=None)
Alter the Table.
Parameters:
table: Name of the Table
default is None (Applicable only when you set default value for table).
modify: Modify the table.
Do not type the complete Query.
Just type in required format after modify clause as per SQL syntax.
change: Change the name/Positions of the table.
Do not type the complete Query.
Just type in required format after change clause as per SQL syntax.
add_column: Add a column to your Database.
Do not type the complete Query.
Just type in required format after Add clause as per SQL syntax.
add_key: Add a key to the database.
Do not type the complete Query.
Just type in required format after Add clause as per SQL syntax.
drop_column: Drop a Column from any Database.
Do not type the complete Query.
Just type in required format after modify clause as per SQL syntax.
Do not type Column keyword, We’ll do it for you.
drop_key: Drop a key from any table.
Do not type the complete Query.
Just type in required format after modify clause as per SQL syntax.
Do not type Key keyword, We’ll do it for you.

create_db(self, dbname)
Create Database Method.
Parameters:
dbname: Name of the database.
Just type name of the database & Create it.
Its Simple. Isn’t it ?

create_table(self, query)
Create a table within Minutes.
Parameters:
query: Type the complete query required for creating a database.

default_table(self, table)
Most Exclusive.
Parameters:
table: Set the default value for table.
This will help you in skipping Parameters.
We Recommend this Method before starting to work.

delete(self, query=None, complete=None)
Delete any rows.
Parameters:
query: Type the complete query required for deleting from a database.
complete: Delete all records from a database.
default is None (Applicable only when you set default value for table).

desc(self, table=None)
Describe a table.
Parameters:
table: Name of the Table
default is None (Applicable only when you set default value for table).

disp_table(self, table=None)
Display All Records of a table.
Parameters:
table: Name of the Table
default is None (Applicable only when you set default value for table).

drop(self, table=None, column=None, key=None)
Another alternative for dropping keys etc. from Table.
Parameters:
table: Name of the Table
default is None (Applicable only when you set default value for table).
column: Just write the name of the Column to be dropped.
key: Just write the name of key to be Dropped.

insert_values(self, values, columns=None, table=None)
This Method insert values in the table.
Parameters:
table: Name of the Table
default is None (Applicable only when you set default value for table).
values: Use Single Query String for Values Parameter.
columns: Columns must be set of all logical columns in the table.

query(self, query, table=None)
For Complex Queries use this Method.
Parameters:
query: Type the Complete Query to retrieve data.
table: Name of the Table
default is None (Applicable only when you set default value for table).

select(self, query, table=None)
Select & Retrieve data from Mysql.
Parameters:
query: Type the complete query as per your needs.
table: Name of the Table
default is None (Applicable only when you set default value for table).

show_db(self)
This methods helps you show all the database stored in your Machine.

show_result(self, data, table=None)
Not for Users. Only for Developers.

show_tables(self)
Shows all the tables after in a Given database.

update(self, set, where, table=None)
Update the values in a table.
Parameters:
table: Name of the Table
default is None (Applicable only when you set default value for table).
set: Conditions for Set Clause.
Type as per SQL Syntax.
where: Conditions after where clause.
Type as per SQL Syntax.

use(self, database)
Use the required Database.
AS per SQL Syntax use database clause is necessary.
This method helps you in using the database.
Parameters:
database: Name of database to be set.

———————————————————————-
Data descriptors defined here:

__dict__
dictionary for instance variables (if defined)

__weakref__
list of weak references to the object (if defined)

Process finished with exit code 0

So Guys!!! Just move on for installing this awesome SQLConnect pack.

Developer: Kailash Sharma

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for ConnectSQl, version 2.0
Filename, size File type Python version Upload date Hashes
Filename, size ConnectSQl-2.0.tar.gz (2.6 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page