# -*- coding: utf-8 -*-
r"""B142: tìm bảng nguyên liệu (để vẽ biểu đồ giá) + xem gia_nguyen_lieu có gì."""
import sqlite3

b = sqlite3.connect('file:C:/c/deepseek-harness/claw2-db/btchem.db?mode=ro', uri=True)
print('  CÁC BẢNG trong btchem.db:')
for r in b.execute("select name, (select count(*) from sqlite_master m2 where m2.name=m1.name) from sqlite_master m1 where type='table'"):
    pass
bang = [r[0] for r in b.execute("select name from sqlite_master where type='table' order by name")]
print('   ', ' · '.join(bang))
for t in bang:
    if any(k in t.lower() for k in ('nguyen_lieu', 'vat_tu', 'gia')):
        cols = [c[1] for c in b.execute('pragma table_info(%s)' % t)]
        n = b.execute('select count(*) from %s' % t).fetchone()[0]
        print('  %-22s %5d dòng | %s' % (t, n, ', '.join(cols)))

print('\n  gia_nguyen_lieu — theo loại giá:')
for r in b.execute('select loai_gia, count(*), min(ngay), max(ngay) from gia_nguyen_lieu group by 1'):
    print('    ', r)
print('  top nguyên liệu có nhiều bản ghi giá nhất:')
for r in b.execute('select nguyen_lieu_id, count(*), min(ngay), max(ngay) from gia_nguyen_lieu group by 1 order by 2 desc limit 8'):
    print('    ', r)
print('  vài dòng mẫu:')
for r in b.execute('select * from gia_nguyen_lieu order by id desc limit 6'):
    print('    ', r)