public void create_server_with_user_defined_instance_id_and_table_test()
{
using (var server = new MysticMind.PostgresEmbed.PgServer(
"9.5.5.1",
PG_USER,
addLocalUserAccessPermission: ADD_LOCAL_USER_ACCESS_PERMISSION,
instanceId: Guid.NewGuid(),
clearInstanceDirOnStop: true))
{
server.Start();
// assert if instance id drectory exists
Assert.True(Directory.Exists(server.InstanceDir));
// Note: set pooling to false to prevent connecting issues
// https://github.com/npgsql/npgsql/issues/939
string connStr = string.Format(CONN_STR, server.PgPort, PG_USER);
var conn = new Npgsql.NpgsqlConnection(connStr);
var cmd =
new Npgsql.NpgsqlCommand(
"CREATE TABLE table1(ID CHAR(256) CONSTRAINT id PRIMARY KEY, Title CHAR)",
conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
public void create_server_without_using_block()
{
var server = new MysticMind.PostgresEmbed.PgServer(
"9.5.5.1",
PG_USER,
addLocalUserAccessPermission: ADD_LOCAL_USER_ACCESS_PERMISSION,
clearInstanceDirOnStop: true);
try
{
server.Start();
string connStr = string.Format(CONN_STR, server.PgPort, PG_USER);
var conn = new Npgsql.NpgsqlConnection(connStr);
var cmd =
new Npgsql.NpgsqlCommand(
"CREATE TABLE table1(ID CHAR(256) CONSTRAINT id PRIMARY KEY, Title CHAR)",
conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
finally
{
server.Stop();
}
}
static void Main(string[] args)
{
const string PG_USER = "******";
const string CONN_STR = "Server=localhost;Port={0};User Id={1};Password=test;Database=postgres;Pooling=false";
using (var server = new MysticMind.PostgresEmbed.PgServer(
"9.5.5.1",
PG_USER,
addLocalUserAccessPermission: true,
clearInstanceDirOnStop: true))
{
server.Start();
// Note: set pooling to false to prevent connecting issues
// https://github.com/npgsql/npgsql/issues/939
string connStr = string.Format(CONN_STR, server.PgPort, PG_USER);
var conn = new Npgsql.NpgsqlConnection(connStr);
var cmd =
new Npgsql.NpgsqlCommand(
"CREATE TABLE table1(ID CHAR(256) CONSTRAINT id PRIMARY KEY, Title CHAR)",
conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
public void create_server_with_plv8_extension_test()
{
var extensions = new List <PgExtensionConfig>();
// plv8 extension
extensions.Add(new PgExtensionConfig(
"http://www.postgresonline.com/downloads/pg95plv8jsbin_w64.zip",
new List <string> {
"CREATE EXTENSION plv8"
}
));
using (var server = new MysticMind.PostgresEmbed.PgServer(
"9.5.5.1",
PG_USER,
pgExtensions: extensions,
addLocalUserAccessPermission: ADD_LOCAL_USER_ACCESS_PERMISSION))
{
server.Start();
}
}
public void create_server_and_pass_server_params()
{
var serverParams = new Dictionary <string, string>();
// set generic query optimizer to off
serverParams.Add("geqo", "off");
// set timezone as UTC
serverParams.Add("timezone", "UTC");
// switch off synchronous commit
serverParams.Add("synchronous_commit", "off");
// set max connections
serverParams.Add("max_connections", "300");
using (var server = new MysticMind.PostgresEmbed.PgServer(
"9.5.5.1",
PG_USER,
pgServerParams: serverParams,
addLocalUserAccessPermission: ADD_LOCAL_USER_ACCESS_PERMISSION,
clearInstanceDirOnStop: true))
{
server.Start();
// Note: set pooling to false to prevent connecting issues
// https://github.com/npgsql/npgsql/issues/939
string connStr = string.Format(CONN_STR, server.PgPort, PG_USER);
var conn = new Npgsql.NpgsqlConnection(connStr);
var cmd =
new Npgsql.NpgsqlCommand(
"CREATE TABLE table1(ID CHAR(256) CONSTRAINT id PRIMARY KEY, Title CHAR)",
conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
public void create_server_with_postgis_extension_test()
{
var extensions = new List <PgExtensionConfig>();
extensions.Add(new PgExtensionConfig(
"http://download.osgeo.org/postgis/windows/pg96/postgis-bundle-pg96-2.3.2x64.zip",
new List <string>
{
"CREATE EXTENSION postgis",
"CREATE EXTENSION fuzzystrmatch"
}
));
using (var server = new MysticMind.PostgresEmbed.PgServer(
"9.6.2.1",
PG_USER,
pgExtensions: extensions,
addLocalUserAccessPermission: ADD_LOCAL_USER_ACCESS_PERMISSION))
{
server.Start();
}
}
public void create_server_and_table_test()
{
using (var server = new MysticMind.PostgresEmbed.PgServer(
"9.5.5.1",
PG_USER,
addLocalUserAccessPermission: ADD_LOCAL_USER_ACCESS_PERMISSION))
{
server.Start();
// Note: set pooling to false to prevent connecting issues
// https://github.com/npgsql/npgsql/issues/939
string connStr = string.Format(CONN_STR, server.PgPort, PG_USER);
var conn = new Npgsql.NpgsqlConnection(connStr);
var cmd =
new Npgsql.NpgsqlCommand(
"CREATE TABLE table1(ID CHAR(256) CONSTRAINT id PRIMARY KEY, Title CHAR)",
conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}