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