import json
from pathlib import Path

from flows.awal_salesforce import export

THIS_DIR = Path(__file__).parent


def test_gen_create_table_dds():
    filename = THIS_DIR / 'test_opportunities.json'
    desc = json.load(filename.open())
    create_table_sql = export.gen_create_table_dds(desc, table_name='opportunities_table')
    print(create_table_sql)


def test_escape():
    assert export.escape1('Theres') == 'Theres'
    assert export.escape1("There's") == "There\\'s"