Metadata-Version: 1.1
Name: ConnectSQl
Version: 2.0
Summary: Connect Access & retrieve MYSQl databases.
Home-page: https://github.com/kailash1011/ConnectSQl
Author: Kailash Sharma
Author-email: kailashps.1011@gmail.com
License: MIT
Download-URL: https://github.com/kailash1011/ConnectSQl/releases/tag/2.0
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
Platform: UNKNOWN
Classifier: Programming Language :: Python :: 3.6
