public void AssertGoodFullDatabaseQueryDoesntFail()
{
string source = @"
using Npgsql;
namespace Testing
{
public class TestClass
{
public void QueryInConstructor()
{
using var command = new NpgsqlCommand(
@""
SELECT users.id, users.username, users.is_admin, users.created_at, posts.id, posts.title, posts.body, posts.created_at, user_posts.user_id, user_posts.post_id
FROM users
JOIN user_posts ON user_posts.user_id = users.id
JOIN posts ON posts.id = user_posts.post_id;
"");
}
public void QueryAsVariable()
{
string query = @""
SELECT users.id, users.username, users.is_admin, users.created_at, posts.id, posts.title, posts.body, posts.created_at, user_posts.user_id, user_posts.post_id
FROM users
JOIN user_posts ON user_posts.user_id = users.id
JOIN posts ON posts.id = user_posts.post_id;
"";
using var command = new NpgsqlCommand(query);
}
public void QueryAsReDeclaredVariable()
{
string query = ""invalid query syntax"";
query = @""
SELECT users.id, users.username, users.is_admin, users.created_at, posts.id, posts.title, posts.body, posts.created_at, user_posts.user_id, user_posts.post_id
FROM users
JOIN user_posts ON user_posts.user_id = users.id
JOIN posts ON posts.id = user_posts.post_id;
"";
using var command = new NpgsqlCommand(query);
}
}
}
";
using var database = Database.CreateDatabase();
Diagnostics.AnalyzeSourceCode(
source,
new NpgsqlAnalyzer(new Configuration(
new Dictionary <string, string>
{
["CONNECTION_STRING"] = database.ConnectionString,
})));
}