File size: 674 Bytes
6472aaf
 
 
d9905f8
dfd2a32
d9905f8
dfd2a32
d9905f8
dfd2a32
 
d9905f8
55e545d
d9905f8
 
 
 
 
 
 
d9f2cb7
 
 
 
55e545d
862a2bb
55e545d
 
dfd2a32
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
username = "luismi"
cadena = "SELECT password FROM auth_lessor WHERE username == " + "'"+ username + "'"
print(cadena)
import pandas as pd

file = pd.read_csv("./data/users_dataframe.csv")

print(file.loc(0))

    
from sqlalchemy import URL, create_engine
import resultview as rv
connection_string = URL.create(
    'postgresql',
    username='koyeb-adm',
    password='npg_KHVk3qBon6Yu',
    host='ep-rough-fire-a27dp2i1.eu-central-1.pg.koyeb.app',
    database='koyebdb',
)
engine = create_engine(connection_string)

original_dataframe = pd.read_sql("SELECT * FROM tenants", con=engine)
print(original_dataframe)

tenant_list = rv.algo_start(10001)
print(tenant_list)