Python redirect Exemples

Exemple #1

Fichier : site_manager.py Projet : remarquecal/python_cgi_db_interface

    def sql_login(user, password):
        connect_args = Manager.connect_args_tmp.format('postgres', user,
                                                       password)
        cookie = Manager.cookie

        try:
            connect = psycopg2.connect(connect_args)
            cookie["user"] = user
            cookie["password"] = password
            connect.close()
            print(cookie)
            template.redirect('../cgi-bin/select_db.py')
        except:
            template.redirect('../cgi-bin/user_login_error.py')

Exemple #2

Fichier : users_list_tables_grants_form.py Projet : remarquecal/python_cgi_db_interface

#!/home/mrdiz/anaconda3/bin/python

import sys
sys.path.append("/home/mrdiz/SQL/Lab5(2)")

import cgi
from utils.site_manager import Manager
import utils.site_template as template

form = cgi.FieldStorage()

is_select = form.getfirst('SELECT')
is_insert = form.getfirst('INSERT')
is_update = form.getfirst('UPDATE')
is_delete = form.getfirst('DELETE')

grants_list = (is_select, is_insert, is_update, is_delete)

Manager.sql_set_grants(grants_list)

template.redirect('users_list_tables_grants.py')

Exemple #3

#!/home/mrdiz/anaconda3/bin/python

import sys
sys.path.append("/home/mrdiz/SQL/Lab5(2)")

import cgi
from utils.site_manager import Manager
import utils.site_template as template

form = cgi.FieldStorage()
selected_db = form.getfirst('db_list')

Manager.cookie["database"] = selected_db
print(Manager.cookie)

template.redirect('select_db_tables.py')

Exemple #4

Fichier : table_insert_form.py Projet : remarquecal/python_cgi_db_interface

sys.path.append("/home/mrdiz/SQL/Lab5(2)")

import cgi
import html

from utils.site_manager import Manager
import utils.site_template as template

selected_table = Manager.cookie["table"].value

headers_list = Manager.sql_select(
    'column_name, data_type', 'information_schema.columns',
    "(table_schema='public') AND (table_name='{0}')".format(selected_table))

headers_values = []

form = cgi.FieldStorage()

for item in headers_list:
    value = form.getfirst(item[0])
    type = item[1]
    value = html.escape(value)

    list_item = (value, type)

    headers_values.append(list_item)

Manager.sql_insert(selected_table, headers_values)

template.redirect('table_insert.py')

Exemple #5

#!/home/mrdiz/anaconda3/bin/python

import sys
sys.path.append("/home/mrdiz/SQL/Lab5(2)")

import cgi

from utils.site_manager import Manager
import utils.site_template as template

form = cgi.FieldStorage()
selected_table = form.getfirst('table_list')

Manager.cookie["table"] = selected_table
print(Manager.cookie)

template.redirect('table.py')

Exemple #6

Fichier : table_delete_form.py Projet : remarquecal/python_cgi_db_interface

sys.path.append("/home/mrdiz/SQL/Lab5(2)")

import re
import cgi

from utils.site_manager import Manager
import utils.site_template as template

form = cgi.FieldStorage()

selected_table = Manager.cookie["table"].value
selected_row = form.getfirst('row_delete')

headers_list = Manager.sql_select(
    'column_name, column_default', 'information_schema.columns',
    "(table_schema='public') AND (table_name='{0}')".format(selected_table))

re_match = r"nextval\('.*'::regclass\)"
pk_column = ''

for item in headers_list:
    res = re.search(re_match, str(item[1]))

    if res:
        pk_column = item[0]
        break

Manager.sql_delete(selected_table, pk_column, selected_row)

template.redirect('table_delete.py')