
Research
/Security News
Toptal’s GitHub Organization Hijacked: 10 Malicious Packages Published
Threat actors hijacked Toptal’s GitHub org, publishing npm packages with malicious payloads that steal tokens and attempt to wipe victim systems.
The postgres-helper
library is build on top of psycopg2
. It will be really helpful for running the basic postgresql query in python.
Checkout the official documentation of this library here: postgres-helper.readthedocs.io/
For installation of postgres-helper
, you need to run following command
pip install postgres-helper
Please check the official documentation here: https://postgres-helper.readthedocs.io/.
#Library import
from pg.pg import Pg
# Initialization of library
pg = Db(dbname='postgres', user='postgres', password='admin', host='localhost', port='5432')
# Get the column names of the specific table
pg.get_columns_name(table='pg_table')
# Get values from specific column of table
pg.get_values_from_column(column='pg_table_col', table='pg_table', schema='public')
# Create schema
pg.create_schema(name='schema_name')
# Create column
pg.create_column(column='col_name', table='pg_table', col_datatype='varchar', schema='public')
# Update column
pg.update_column(column='col_name', value='updated_value', table='pg_table', where_column='where_col', where_value="where_val", schema='public')
# Delete table
pg.delete_table(name='pg_table', schema='public')
# Delete values
pg.delete_values(table_name='pg_table', condition='name=value', schema='public')
FAQs
Package for Postgres query on python
We found that postgres-helper 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
Threat actors hijacked Toptal’s GitHub org, publishing npm packages with malicious payloads that steal tokens and attempt to wipe victim systems.
Research
/Security News
Socket researchers investigate 4 malicious npm and PyPI packages with 56,000+ downloads that install surveillance malware.
Security News
The ongoing npm phishing campaign escalates as attackers hijack the popular 'is' package, embedding malware in multiple versions.