コード例 #1
0
        private void ResolveJavaConnectionInfo(string connString, out string jdbcValue, out string jdbcDrivers)
        {
            OleDbConnectionStringBuilder sb = new OleDbConnectionStringBuilder(connString);

            string     provider = sb.Provider.ToLower();
            SQLDialect dialect  = SQLDialect.Generic;

            if (provider == "sqloledb")
            {
                dialect = SQLDialect.Mssql;
            }
            else if (provider == "oraoledb" || provider == "msdaora")
            {
                dialect = SQLDialect.Oracle;
            }
            else
            {
                throw new NotSupportedException(string.Format("不支持此数据库", dialect.ToString()));
            }

            string dataSourceValue = sb.DataSource;

            string serverName = "";
            string database   = "";
            int    port       = 1521;

            jdbcValue   = "";
            jdbcDrivers = "";

            string userName = sb["User ID"].ToString();
            string UserPwd  = sb["Password"].ToString();

            if (dialect == SQLDialect.Mssql)
            {
                string initialCatalog = sb["Initial Catalog"].ToString();
                serverName = dataSourceValue;
                database   = initialCatalog;
                port       = 1433;
                jdbcValue  = string.Format(MSSQLJdbcConnStringValueFormat
                                           , serverName
                                           , database
                                           , userName
                                           , UserPwd
                                           , port
                                           );
                jdbcDrivers = MSSQLJdbcDrivers;
            }
            else if (dialect == SQLDialect.Oracle)
            {
                string[] serverInfo1 = dataSourceValue.Split('/');
                string[] serverInfo2 = serverInfo1[0].Split(':');

                serverName = serverInfo2[0];
                database   = serverInfo1[1];
                port       = serverInfo2.Length < 2 || string.IsNullOrEmpty(serverInfo2[1]) ? 1521 : int.Parse(serverInfo2[1]);
                jdbcValue  = string.Format(OracleJdbcConnStringValueFormat
                                           , serverName
                                           , database
                                           , userName
                                           , UserPwd
                                           , port
                                           );
                jdbcDrivers = OracleJdbcDrivers;
            }
        }
コード例 #2
0
        private int OnExecute(CommandLineApplication app)
        {
            if (string.IsNullOrEmpty(SQLDialect) || string.IsNullOrEmpty(Output))
            {
                app.ShowHelp();
                return(0);
            }

            var exitCode = 0;

            switch (SQLDialect.ToLowerInvariant())
            {
            case "mssqlv2":
#pragma warning disable 618
                var mssqlV2Settings = new MsSqlStreamStoreSettings(new SqlConnectionStringBuilder
                {
                    DataSource = "tcp:0.0.0.0,1433"
                }.ConnectionString);
                if (!string.IsNullOrEmpty(Schema))
                {
                    mssqlV2Settings.Schema = Schema;
                }

                if (CreateSchema)
                {
                    var script = string.Join(
                        Environment.NewLine,
                        $@"IF NOT EXISTS (
SELECT  schema_name
FROM    information_schema.schemata
WHERE   schema_name = '{Schema}' ) 

BEGIN
EXEC sp_executesql N'CREATE SCHEMA {Schema}'
END",
                        new MsSqlStreamStore(mssqlV2Settings).GetSchemaCreationScript());
                    File.WriteAllText(Output, script);
                }
                else
                {
                    File.WriteAllText(Output, new MsSqlStreamStore(mssqlV2Settings).GetSchemaCreationScript());
                }
#pragma warning restore 618
                break;

            case "mssqlv3":
                var mssqlV3Settings = new MsSqlStreamStoreV3Settings(new SqlConnectionStringBuilder
                {
                    DataSource = "tcp:0.0.0.0,1433"
                }.ConnectionString);
                if (!string.IsNullOrEmpty(Schema))
                {
                    mssqlV3Settings.Schema = Schema;
                }
                if (CreateSchema)
                {
                    var script = string.Join(
                        Environment.NewLine,
                        $@"IF NOT EXISTS (
SELECT  schema_name
FROM    information_schema.schemata
WHERE   schema_name = '{Schema}' ) 

BEGIN
EXEC sp_executesql N'CREATE SCHEMA {Schema}'
END",
                        new MsSqlStreamStoreV3(mssqlV3Settings).GetSchemaCreationScript());
                    File.WriteAllText(Output, script);
                }
                else
                {
                    File.WriteAllText(Output, new MsSqlStreamStoreV3(mssqlV3Settings).GetSchemaCreationScript());
                }

                break;

            case "mysql":
                var mysqlSettings = new MySqlStreamStoreSettings(new MySqlConnectionStringBuilder
                {
                    Server = "0.0.0.0"
                }.ConnectionString);
                if (!string.IsNullOrEmpty(Schema))
                {
                    Log.Information("The optional database schema does not apply to the mysql dialect and can be omitted: {Schema}", Schema);
                }
                File.WriteAllText(Output, new MySqlStreamStore(mysqlSettings).GetSchemaCreationScript());
                break;

            case "postgres":
                var postgresSettings = new PostgresStreamStoreSettings(new NpgsqlConnectionStringBuilder
                {
                    Host = "0.0.0.0"
                }.ConnectionString);
                if (!string.IsNullOrEmpty(Schema))
                {
                    postgresSettings.Schema = Schema;
                }

                if (CreateSchema)
                {
                    var script = string.Join(
                        Environment.NewLine,
                        $"CREATE SCHEMA IF NOT EXISTS {Schema};",
                        new PostgresStreamStore(postgresSettings).GetSchemaCreationScript()
                        );
                    File.WriteAllText(Output, script);
                }
                else
                {
                    File.WriteAllText(Output, new PostgresStreamStore(postgresSettings).GetSchemaCreationScript());
                }
                break;

            default:
                Log.Error("The SQL dialect was not recognized: {SQLDialect}", SQLDialect);
                exitCode = 1;
                break;
            }

            return(exitCode);
        }
コード例 #3
0
ファイル: SQLMapper.cs プロジェクト: ioxuy/meijing-ui
 public static string GetSqlString(SQLDialect dialect, string defaultValue)
 {
     return(sqlList[(int)dialect] ?? defaultValue);
 }
コード例 #4
0
ファイル: SQLMapper.cs プロジェクト: ioxuy/meijing-ui
 public static string GetSqlString(SQLDialect dialect)
 {
     return(sqlList[(int)dialect]);
 }
コード例 #5
0
ファイル: SQLMapper.cs プロジェクト: Redi0/meijing-ui
 public static string GetSqlString(SQLDialect dialect, string defaultValue)
 {
     return sqlList[(int)dialect] ?? defaultValue;
 }
コード例 #6
0
ファイル: SQLMapper.cs プロジェクト: Redi0/meijing-ui
 public static string GetSqlString(SQLDialect dialect)
 {
     return sqlList[(int)dialect];
 }