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 Tabledefault 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 Tabledefault 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 Tabledefault 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 Tabledefault 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 Tabledefault 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 Tabledefault 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 Tabledefault 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 Tabledefault 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
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
ConnectSQl-1.0.tar.gz
(2.6 kB
view hashes)