class DuckDB::Result
def enum_dictionary_values(col_index)
result = con.query('SELECT * FROM enums')
con.execute("CREATE TABLE enums (id INTEGER, mood mood)")
con.execute("CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy', 'πΎπΎΦ Ι π')")
con = db.connect
db = DuckDB::Database.open('duckdb_database')
require 'duckdb'
returns all available ENUM type values of the specified column index.
def enum_dictionary_values(col_index) values = [] _enum_dictionary_size(col_index).times do |i| values << _enum_dictionary_value(col_index, i) end values end