
Research
Security News
The Growing Risk of Malicious Browser Extensions
Socket researchers uncover how browser extensions in trusted stores are used to hijack sessions, redirect traffic, and manipulate user behavior.
This package can be found at https://github.com/aescwork/sqlitemgr.
In the github repository there is sphinx-generated documentation: the main page is docs/index.html.
sqlitemgr -- the SQLite Manager module -- is a wrapper class for basic management of an sqlite database and its tables. It can be used to create and delete database files, tables, create and return a connection to a database file as well as a cursor which is used for executing statements against an sqlite database.
It has two main purposes: 1. to encapsulate all of the basic database management actions in one class, and 2. to create tables with the option of not having to directly enter the structured query language necessary. Specific methods for composing and executing sql statements can be chained together for creating tables (including specifying column names, data types and constraints) in an sqlite database.
There are also a few utility methods for managing data in and getting information about the tables. These can get the number of tables in a database, get the number of rows in a table, or re-index a column which is used for storing numbers.
This module was written as a companion to the sqliteminor module, whose functionality focuses on creating, reading, updating and deleting data in sqlite database columns.
NOTE:
This module requires sqlite3 to be installed prior to use.
After installation of this package is complete, trying to use the module might result in the following error: "ImportError: No module named sqlitemgr" or some other error message.
This probably indicates that the Python interpreter may not be able to locate the module. In this case, the following is recommended:
On Linux:
Locate where the package was installed. In the terminal, navigate to the root directory and execute the following command:
sudo find . -name sqlitemgr.py
This should give a path to the sqlitemgr.py file.
Create a file called "local_python.sh" and put the following text in it:
PYTHONPATH="/usr/local/lib/python*.*/dist-packages/sqlitemgr/":"${PYTHONPATH}"
export PYTHONPATH
To make the module available to all users, place this file in /etc/profile.d. Then place a line to execute this
file somewhere in .bashrc or one of the other bash configuration files in the individual (non-root) user's terminal:
. /etc/profile.d/local_python.sh
This should cause the python interpreter to locate the sqlitemgr.py file in the module.
On MS Windows:
The following was tested on a machine running Windows 10.
(This assumes that Python is installed on the machine.)
Locate where the package was installed. On Windows 10, Look for the Python folder. Its usually right under the C: drive.
The name of the folder probably has the version number in it as well, like "Python27". Look for the sqlitemgr folder: it should
be in "Lib\" and then "site-packages\" folder.
Open up the System Properties Panel. (You can find this by clicking on the "Settings" icon and entering "Environment Variables" in the
search bar. When the panel comes up, Click the "Environment Variables" button. Under "System variables", click "New" and type in the full path to
the sqlitemgr folder.
Test this by opening the command line application and starting the Python interpreter (type the command "python" and press enter).
Now try to import the module and instantiate an sqlitemgr object. Type the following:
>>> import sqlitemgr
>>> sg = sqlitemgr.SQLiteMinor()
>>> sg.result
If everything went well, 'None' should print out on the screen. If there was an "ImportError" or any other error, try importing the
module again and test as follows:
>>> import sqlitemgr.sqlitemgr as sqlitemgr
>>> sg = sqlitemgr.SQLiteMgr()
>>> sg.result
FAQs
A wrapper class for basic setup and management of an SQLite database.
We found that sqlitemgr demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Research
Security News
Socket researchers uncover how browser extensions in trusted stores are used to hijack sessions, redirect traffic, and manipulate user behavior.
Research
Security News
An in-depth analysis of credential stealers, crypto drainers, cryptojackers, and clipboard hijackers abusing open source package registries to compromise Web3 development environments.
Security News
pnpm 10.12.1 introduces a global virtual store for faster installs and new options for managing dependencies with version catalogs.