def test_translate_sql_to_fql_multiple(): sql_query = ( "SELECT users.id, users.name, users.date_joined, users.age, users.finger_count " "FROM users;" "SELECT users.password, users.favorites FROM users") with pytest.raises( exceptions.NotSupportedError, match="Only one SQL statement at a time is currently supported", ): translation.translate_sql_to_fql(sql_query)
def test_translate_sql_to_fql_select(): sql_query = ( "SELECT users.id, users.name, users.date_joined, users.age, users.finger_count " "FROM users") fql_queries = translation.translate_sql_to_fql(sql_query) for fql_query in fql_queries: assert isinstance(fql_query, QueryExpression)
def test_translate_sql_to_fql_create(): sql_query = ( "CREATE TABLE users (id INTEGER NOT NULL, " "name VARCHAR, date_joined DATETIME NOT NULL, " "age INTEGER, finger_count INTEGER, PRIMARY KEY (id), UNIQUE (name))") fql_queries = translation.translate_sql_to_fql(sql_query) for fql_query in fql_queries: assert isinstance(fql_query, QueryExpression)
def test_translate_sql_to_fql_update(): sql_query = "UPDATE users SET users.name = 'Bob'" fql_queries = translation.translate_sql_to_fql(sql_query) for fql_query in fql_queries: assert isinstance(fql_query, QueryExpression)
def test_translate_sql_to_fql_delete(): sql_query = "DELETE FROM users" fql_queries = translation.translate_sql_to_fql(sql_query) for fql_query in fql_queries: assert isinstance(fql_query, QueryExpression)
def test_translate_sql_to_fql_insert(): sql_query = "INSERT INTO users (name, age, finger_count) VALUES ('Bob', 30, 10)" fql_queries = translation.translate_sql_to_fql(sql_query) for fql_query in fql_queries: assert isinstance(fql_query, QueryExpression)
def test_translate_sql_to_fql_drop(): sql_query = "DROP TABLE users" fql_queries = translation.translate_sql_to_fql(sql_query) for fql_query in fql_queries: assert isinstance(fql_query, QueryExpression)