What's Changed
- Add show for result by @auxten in #194
# You do not need something like # ret = chdb.query("SELECT 123") # print(ret) # just chdb.query("SELECT 123").show()
- Allow path in dbapi connect by @nevinpuri in #176
from chdb import dbapi conn = dbapi.connect(path=test_state_dir) cur = conn.cursor() cur.execute("CREATE DATABASE e ENGINE = Atomic;") cur.execute( "CREATE TABLE e.hi (a String primary key, b Int32) Engine = MergeTree ORDER BY a;" ) cur.execute("INSERT INTO e.hi (a, b) VALUES (%s, %s);", ["he", 32]) cur.close() conn.close() conn2 = dbapi.connect(path=test_state_dir) cur2 = conn2.cursor() cur2.execute("SELECT * FROM e.hi;") row = cur2.fetchone() self.assertEqual(("he", 32), row)
- Now, SET clause will work through chdb session! by @auxten in #207
from chdb import session as chs se = chs.Session() se.query("SET input_format_csv_skip_first_lines = 1") se.query("SELECT * FROM `some dirty csv`").show()
- Add test cases for materialize view by @auxten in #201
- Fix DB-API test rerun issue by @auxten in #208
New Contributors
- @nevinpuri made their first contribution in #176
Full Changelog: v1.2.1...v1.3.0