ian | Ian is a CLI interface to manage your dev environment | Command Line Interface library

import psycopg2
from psycopg2 import sql
import datetime


def connect(conn):
    """ Connect to the PostgreSQL database server """
    # create a cursor
    cur = conn.cursor()

    # https://www.psycopg.org/docs/sql.html

    col_names = sql.SQL(', ').join([
        sql.Identifier('lookup'),
        sql.Identifier('LOL1'),
        sql.Identifier('LOL2'),
        sql.Identifier('identifier1'),
        sql.Identifier('identifier2'),
        sql.Identifier('timestamp_first_entry'),
        sql.Identifier('timestamp_last_entry'),
        sql.Identifier('some_number')
    ]),

    values = sql.SQL(', ').join([
        "hash",
        [  # LOL1
            [[1.0, 2.0],  # list of lists of lists 1.1
             [3.0, 0.5]],
            [[-1.0, -2.0], # list of lists of lists 1.2
             [-3.0, -4.0]]
        ], [  # LOL2
            [[1.0, 2.0],  # list of lists of lists 2.1
             [3.0, 0.5]],
            [[-1.0, -2.0], # list of lists of lists 2.2
             [-3.0, -4.0]]
        ],
        "identifier1",
        "identifier2",
        datetime.datetime(2021, 5, 10),
        datetime.datetime(2021, 5, 12),
        20
    ])

    query_base = sql.SQL("insert into {table_name}({col_names} values ({values}))".format(
        table_name=sql.Identifier("raw_orderbook"),
        col_names=col_names,
        values=values
    ))

    cur.execute(query_base)

    cur.close()


# https://www.psycopg.org/docs/sql.html

if __name__ == '__main__':
    conn = psycopg2.connect(
        host="localhost",
        database="test",
        user="ian",
        password="")

    connect(conn)

first name       Middle Name     Last Name      UperCase
martin           Bell            MARK            N
JACK             IAN             CHAPPEL         Y
PHILIP           JIMMY           DAVID           Y