ParseTableName

Resumen

Parses a table name into its components (database, owner, table) depending on the workspace. ParseTableName returns a string containing the parsed table name, with the database name, owner name, and table name separated by commas. This workspace must be a personal, file, or ArcSDE geodatabase.

Sintaxis

ParseTableName (name, {workspace})
ParámetroExplicaciónTipo de datos
name

Specifies which table will be parsed.

String
workspace

Specifies the workspace for fully qualifying the table name. The workspace must be a personal, file, or ArcSDE geodatabase.

String
Valor de retorno
Tipo de datosExplicación
String

Returns the table name parsed into its components (owner name, database name, table name) separated by commas.

Ejemplo de código

ParseTableName example

Parse a table name into its components.

import arcpy
from arcpy import env
import os

# Get the full name of the feature class and
#   set the workspace for parsing the name.
#
fc = arcpy.GetParameterAsText(0)
env.workspace = os.path.dirname(fc)

# Parse the feature class name into its components
#
fullName = arcpy.ParseTableName(os.path.basename(fc))
nameList = fullName.split(",")
databaseName = nameList[0]
ownerName = nameList[1]
fcName = nameList[2]

# Qualify the name of the feature class that will be appended to and set 
# the workspace using the administrator's connection.
#
env.workspace = "Database Connections/Trans_admin.sde"
appendFCName = arcpy.ValidateTableName("common", "roads")

try:
    if ownerName == "grace":
        arcpy.CalculateField(fullName, "AppendedBy", ownerName)
        arcpy.Append_management(fullName, appendFCName)
    elif ownerName == "reed":
        arcpy.CalculateField(fullName, "AppendedBy", ownerName)
        arcpy.Append_management(fullName, appendFCName)
    else:
        arcpy.AddError("Unknown owner of feature class.  Not appended.")
except:
    arcpy.AddError(arcpy.GetMessages(2))

Temas relacionados


7/10/2012