ADO.NET Provider for WordPress

Build 24.0.9060

Plugins

Create, update, delete, and query Plugins.

Table Specific Information

Select

The provider uses the WordPress API to process supported filters. The provider processes other filters client-side within the provider. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data.

  • Plugin supports the '='.
  • Status supports the '='.
  • Context supports the '='.
The following queries are processed server side.
SELECT * FROM Plugins
SELECT * FROM Plugins WHERE Plugin='hello-dolly/hello'
SELECT * FROM Plugins WHERE Status='inactive'
SELECT * FROM Plugins WHERE Context='edit'

Insert

To insert into Plugin, you must specify the Slug column.

INSERT INTO Plugins (Slug, Status) VALUES ('hello-dolly', 'active')

Update

To update the Plugin you must specify the Plugin column.

UPDATE Plugins SET Status = 'inactive' WHERE Plugin = 'hello-dolly/hello'

Delete

To delete a Plugin you must specify the Plugin column.

DELETE FROM Plugins WHERE Plugin = 'hello-dolly/hello'

Columns

Name Type ReadOnly Description
Plugin [KEY] String True

The plugin file.

Name String True

The plugin name.

Author String True

The plugin author.

DescriptionRaw String True

The plugin description.

DescriptionRendered String True

The plugin description.

NetworkOnly Boolean True

Whether the plugin can only be activated network-wide.

RequiresPhp String True

Minimum required version of PHP.

RequiresWp String True

Minimum required version of WordPress.

Status String False

The plugin activation status.

The allowed values are inactive, active.

TextDomain String True

The plugin's text domain.

Version String True

The plugin version number.

AuthorUri String True

Plugin author's website address.

PluginUri String True

The plugin's website address.

Pseudo-Columns

Name Type Description
Slug String

WordPress.org plugin directory slug. This column is required for Insert only and it is not included in the Select response.

Context String

Scope under which the request is made; determines fields present in response.

The allowed values are view, edit, embed.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060