vertica_python_quickstart_create_table_insert_query_with_dictionary_cursor.py

1import vertica_python
2
3conn_info = {
4    'host': '127.0.0.1',
5    'port': 5433,
6    'user': 'dbadmin',
7    'password': 'password',
8    'database': 'v_test_db',
9    # autocommit is False by default
10    'autocommit': True,
11}
12
13# Connect to the database
14with vertica_python.connect(**conn_info) as connection:
15    cursor = connection.cursor()
16
17    # Create a table and insert data
18    cursor.execute("CREATE TABLE IF NOT EXISTS test (a int, b varchar)")
19    cursor.execute("INSERT INTO test VALUES (1, 'foo')")
20    cursor.execute("INSERT INTO test VALUES (2, 'bar')")
21
22    # Query the data
23    cursor.execute("SELECT * FROM test")
24    
25    # Fetch and print results
26    for row in cursor.iterate():
27        print(row)
28
29    # Clean up
30    cursor.execute("DROP TABLE test")