Utilities for duplicating tables and creating a table with the results of a query #449
Description
is there a duplicate table functionality? Otherwise, I'd be happy to submit a PR.
In sqlite3 it would look like:
import sqlite3 as sl
con = sl.connect('prompt-tune.db')
def db_duplicate_table(table_name, table_name_new, con=con):
# Duplicates table `table_name` to a new table `table_name_new`.
try:
cur = con.cursor()
cur.execute(f"""CREATE TABLE {table_name_new} AS SELECT * FROM {table_name}""")
except Exception as e:
print(e)
finally:
cur.close()
db_duplicate_table('orig_table', 'new_table')