SLC 0.3.3

A tool that allows you to connect to and run SQL commands to an SQLite3 database easily.

SQLite Connect (SLC)

SLC allows you to connect to an SQLite3 database file faster than if you just used the SQLite3 module. Connect to a database, write to it, and commit and close it all in one line.

Usage

• Individual argument functions won't be supported in this version because of easy mistakes and unsupported Python issues.

SLC.run([Database_URL], [SQL_COMMAND]) # Connects to Database file and runs SQL code

SLC.run_arg([Database_URL], [SQL_COMMAND], [argument]) # Adds one new argument parameter over the original run command.

SLC.run_args2([Database_URL], [SQL_COMMAND], [argument1], [argument2]) # Lets you input 2 arguments into run function.

SLC.run_args3([Database_URL], [SQL_COMMAND], [argument1], [argument2], [argument3]) # Lets you input 3 arguments into run function.

SLC.run_args4([Database_URL], [SQL_COMMAND], [argument1], [argument2], [argument3], [argument4]) # Lets you input 4 arguments into run function.

SLC.run_args5([Database_URL], [SQL_COMMAND], [argument1], [argument2], [argument3], [argument4], [argument5]) # Lets you input 5 arguments into run function.

Shortcuts

SLshortcuts.dropDB([Database_URL]) # Shortcut for dropping a database file

SLshortcuts.dropTB([Database_URL], [table_name]) # Shortcut for dropping a table within a database file

SLshortcuts.bkDB([Database_URL], [filepath]) # Shortcut for backing up a database file

SLshortcuts.cT([Database_URL], [table_name], [column attr, column attr, etc.]) # Shortcut for creating a table. In the third argument, list column names and their data attribute.

Argument List

• 'fetchall' --> The fetchall argument prints out the retrieved data in Python.
• 'cc' --> CC will commit and close the SQLite3 file after the SQL command is run.
• 'com' --> This will only commit the file automatically after running SQL command.
• 'close' --> Will only close the SQLite3 file after SQL command is done running.
• 'RB' --> Will automatically rollback any SQL command you just ran. IDK why you would need this, but I added it anyway, so it would keep it consistent (and look like I have a lot of args).

Change Log

v0.1.0 (1/6/2020)

• First Release

v0.2.0 (1/6/2020)

• New argument parameter added in SLC.run function. (See the README.md file above)

v0.3.0 (1/6/2020)

• Function bug fixed.

v0.3.1 (1/6/2020)

• Argument selection bug fixed

v0.3.2b1 (Beta 1) (1/8/2020)

• Minor bug fixes
• 4 new arguments for run_arg and run_args -> (See item below)
• New run_args function for multiple arguments.
• New function calling format. Changed from sc.[argument] to SLC.[argument]
• New packages added
• README file fixed.
• Optimized for faster runtimes.
• Drawbacks: Update memory takes up 8kb

v0.3.2b2 (Beta 2) (1/8/2020)

• New bug fixes
• README and CHANGELOG updated.
• URL metadata added

v0.3.2 (1/8/2020)

• Beta bugs fixed
• Stable version
• New download URL
• All OS support
• New drop database function shortcut added
• Drop table function shortcut added
• Backup Database function shortcut added
• Create table function shortcut added.

0.3.3 (1/9/2020）

• SLshortcuts was malfunctioning. The bug is now patched.