textSQL icon indicating copy to clipboard operation
textSQL copied to clipboard

[BYOD] support for different SQL dialects (MySQL)

Open alex-sun-kuo opened this issue 1 year ago • 1 comments

Currently, the SQL statements for setting up table and enum metadata, for the language model, are written in PostgreSQL. We want to add support for MySQL as well.

The functions we currently use to generate metadata live in byod/api/app/setup/utils.py. They are named

  • get_type_names()
  • get_table_names()
  • generate_table_metadata()
  • generate_type_metadata()

This was my attempt at generating table and enum metadata. It may be a little hacky. Feel free to give it your best shot.

alex-sun-kuo avatar Apr 15 '23 02:04 alex-sun-kuo

[BYOD] support for different SQL dialects (ORACLE)

zhangbinhui avatar Apr 23 '23 04:04 zhangbinhui