예제 #1
0
        /// <summary>
        /// Drops objects in this schema.
        /// </summary>
        /// <param name="connection"></param>
        public static void Drop(OracleConnection connection)
        {
            if (OracleSchemaTools.DetectNodeTable(connection))
            {
                OracleSchemaTools.DropNodeTable(connection);
            }
            if (OracleSchemaTools.DetectNodeTagsTable(connection))
            {
                OracleSchemaTools.DropNodeTagsTable(connection);
            }

            if (OracleSchemaTools.DetectWayTable(connection))
            {
                OracleSchemaTools.DropWayTable(connection);
            }
            if (OracleSchemaTools.DetectWayTagsTable(connection))
            {
                OracleSchemaTools.DropWayTagsTable(connection);
            }
            if (OracleSchemaTools.DetectWayNodesTable(connection))
            {
                OracleSchemaTools.DropWayNodesTable(connection);
            }

            if (OracleSchemaTools.DetectRelationTable(connection))
            {
                OracleSchemaTools.DropRelationTable(connection);
            }
            if (OracleSchemaTools.DetectRelationTagsTable(connection))
            {
                OracleSchemaTools.DropRelationTagsTable(connection);
            }
            if (OracleSchemaTools.DetectRelationMembersTable(connection))
            {
                OracleSchemaTools.DropRelationMembersTable(connection);
            }
        }
예제 #2
0
        /// <summary>
        /// Creates the entire schema but also detects existing tables.
        /// </summary>
        /// <param name="connection"></param>
        public static void CreateAndDetect(OracleConnection connection)
        {
            if (!OracleSchemaTools.DetectNodeTable(connection))
            {
                OracleSchemaTools.CreateNodeTable(connection);
            }
            if (!OracleSchemaTools.DetectNodeTagsTable(connection))
            {
                OracleSchemaTools.CreateNodeTagsTable(connection);
            }

            if (!OracleSchemaTools.DetectWayTable(connection))
            {
                OracleSchemaTools.CreateWayTable(connection);
            }
            if (!OracleSchemaTools.DetectWayTagsTable(connection))
            {
                OracleSchemaTools.CreateWayTagsTable(connection);
            }
            if (!OracleSchemaTools.DetectWayNodesTable(connection))
            {
                OracleSchemaTools.CreateWayNodesTable(connection);
            }

            if (!OracleSchemaTools.DetectRelationTable(connection))
            {
                OracleSchemaTools.CreateRelationTable(connection);
            }
            if (!OracleSchemaTools.DetectRelationTagsTable(connection))
            {
                OracleSchemaTools.CreateRelationTagsTable(connection);
            }
            if (!OracleSchemaTools.DetectRelationMembersTable(connection))
            {
                OracleSchemaTools.CreateRelationMembersTable(connection);
            }
        }