74% air-wp-sync

Code Review | Air WP Sync - Airtable to WordPress

WordPress plugin Air WP Sync - Airtable to WordPress scored74%from 54 tests.

About plugin

  • Plugin page: air-wp-sync
  • Plugin version: 2.1.0
  • PHP compatiblity: 7.0+
  • PHP version: 7.4.16
  • WordPress compatibility: 5.7-6.4
  • WordPress version: 6.3.1
  • First release: Jul 22, 2022
  • Latest release: Nov 21, 2023
  • Number of updates: 30
  • Update frequency: every 16.5 days
  • Top authors: wpconnectco (100%)

Code review

54 tests

User reviews

14 reviews

Install metrics

1,000+ active /8,264 total downloads

Benchmarks

Plugin footprint 65% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | It is important to correctly install your plugin, without throwing errors or notices
Install script ran successfully

Server metrics [RAM: ▲2.11MB] [CPU: ▲16.83ms] Passed 4 tests

A check of server-side resources used by Air WP Sync - Airtable to WordPress
This plugin does not affect your website's performance
PageMemory (MB)CPU Time (ms)
Home /5.56 ▲2.0959.22 ▲19.07
Dashboard /wp-admin5.46 ▲2.1562.70 ▲13.36
Posts /wp-admin/edit.php5.51 ▲2.1562.44 ▲15.03
Add New Post /wp-admin/post-new.php7.99 ▲2.10112.95 ▲19.84
Media Library /wp-admin/upload.php5.32 ▲2.0958.42 ▲24.40
Add New /wp-admin/post-new.php?post_type=airwpsync-connection5.5363.72
Scheduled Actions /wp-admin/tools.php?page=action-scheduler5.5556.60
All Connections /wp-admin/edit.php?post_type=airwpsync-connection5.3753.60

Server storage [IO: ▲1.66MB] [DB: ▲0.01MB] Passed 3 tests

Filesystem and database footprint
The plugin installed successfully
Filesystem: 159 new files
Database: 4 new tables, 10 new options
New tables
wp_actionscheduler_claims
wp_actionscheduler_logs
wp_actionscheduler_actions
wp_actionscheduler_groups
New WordPress options
can_compress_scripts
theysaidso_admin_options
widget_theysaidso_widget
schema-ActionScheduler_LoggerSchema
schema-ActionScheduler_StoreSchema
action_scheduler_lock_async-request-runner
widget_recent-posts
action_scheduler_hybrid_store_demarkation
db_upgraded
widget_recent-comments

Browser metrics Passed 4 tests

Air WP Sync - Airtable to WordPress: an overview of browser usage
Normal browser usage
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,849 ▲8714.36 ▲0.041.78 ▲0.0942.85 ▼2.12
Dashboard /wp-admin2,257 ▲805.62 ▼0.0383.58 ▼12.2739.28 ▼0.81
Posts /wp-admin/edit.php2,160 ▲601.98 ▲0.0440.15 ▲2.4634.52 ▼1.38
Add New Post /wp-admin/post-new.php1,554 ▲2523.00 ▼0.38657.99 ▲47.0558.23 ▲6.48
Media Library /wp-admin/upload.php1,466 ▲694.18 ▼0.0295.35 ▼4.3840.91 ▼1.18
Add New /wp-admin/post-new.php?post_type=airwpsync-connection3,3984.57104.5696.98
Scheduled Actions /wp-admin/tools.php?page=action-scheduler1,3071.8127.9931.64
All Connections /wp-admin/edit.php?post_type=airwpsync-connection1,1721.9134.2636.90

Uninstaller [IO: ▲0.00MB] [DB: ▲0.01MB] 50% from 4 tests

🔸 Tests weight: 35 | The uninstall procedure must remove all plugin files and extra database tables
Please fix the following items
  • Zombie tables detected upon uninstall: 4 tables
    • wp_actionscheduler_actions
    • wp_actionscheduler_groups
    • wp_actionscheduler_claims
    • wp_actionscheduler_logs
  • This plugin does not fully uninstall, leaving 10 options in the database
    • schema-ActionScheduler_StoreSchema
    • action_scheduler_lock_async-request-runner
    • action_scheduler_hybrid_store_demarkation
    • can_compress_scripts
    • widget_theysaidso_widget
    • db_upgraded
    • widget_recent-posts
    • widget_recent-comments
    • schema-ActionScheduler_LoggerSchema
    • theysaidso_admin_options

Smoke tests 75% from 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | A smoke test targeting server-side errors
Even though no errors were found, this is by no means an exhaustive test

SRP 50% from 2 tests

🔹 Tests weight: 20 | A shallow check of the single-responsibility principle; PHP files should perform no action - including output of placeholder text - and trigger no errors when accessed directly
Please fix the following items
  • 60× PHP files trigger server errors when accessed directly (only 10 are shown):
    • > PHP Fatal error
      Uncaught Error: Class 'Air_WP_Sync_Free\\Air_WP_Sync_Abstract_Destination' not found in wp-content/plugins/air-wp-sync/modules/user/destinations/class-air-wp-sync-user-destination.php:8
    • > PHP Fatal error
      Uncaught Error: Class 'WP_CLI_Command' not found in wp-content/plugins/air-wp-sync/vendor/woocommerce/action-scheduler/classes/WP_CLI/ActionScheduler_WPCLI_Scheduler_command.php:6
    • > PHP Fatal error
      Uncaught Error: Interface 'ActionScheduler_Schedule' not found in wp-content/plugins/air-wp-sync/vendor/woocommerce/action-scheduler/deprecated/ActionScheduler_Schedule_Deprecated.php:6
    • > PHP Warning
      require_once(AIR_WP_SYNC_PLUGIN_DIRmodules/user/class-air-wp-sync-user-importer.php): failed to open stream: No such file or directory in wp-content/plugins/air-wp-sync/modules/user/class-air-wp-sync-user-module.php on line 5
    • > PHP Fatal error
      Uncaught Error: Class 'ActionScheduler_Action' not found in wp-content/plugins/air-wp-sync/vendor/woocommerce/action-scheduler/classes/actions/ActionScheduler_NullAction.php:6
    • > PHP Fatal error
      Uncaught Error: Class 'ActionScheduler_LogEntry' not found in wp-content/plugins/air-wp-sync/vendor/woocommerce/action-scheduler/classes/ActionScheduler_NullLogEntry.php:6
    • > PHP Fatal error
      require_once(): Failed opening required 'AIR_WP_SYNC_PLUGIN_DIRmodules/post/class-air-wp-sync-post-helpers.php' (include_path='.:/usr/share/php') in wp-content/plugins/air-wp-sync/modules/post/class-air-wp-sync-post-module.php on line 5
    • > PHP Fatal error
      Uncaught Error: Class 'CronExpression_AbstractField' not found in wp-content/plugins/air-wp-sync/vendor/woocommerce/action-scheduler/lib/cron-expression/CronExpression_HoursField.php:8
    • > PHP Fatal error
      Uncaught Error: Class 'ActionScheduler_Abstract_ListTable' not found in wp-content/plugins/air-wp-sync/vendor/woocommerce/action-scheduler/classes/ActionScheduler_ListTable.php:7
    • > PHP Fatal error
      Uncaught Error: Class 'ActionScheduler_Abstract_QueueRunner' not found in wp-content/plugins/air-wp-sync/vendor/woocommerce/action-scheduler/classes/WP_CLI/ActionScheduler_WPCLI_QueueRunner.php:10

User-side errors Passed 1 test

🔹 Test weight: 20 | This is just a short smoke test looking for browser issues
There were no browser issues found

Optimizations

Plugin configuration Passed 29 tests

readme.txt Passed 16 tests

Often overlooked, readme.txt is one of the most important files in your plugin
4 plugin tags: wordpress, wpconnect, api, airtable

air-wp-sync/air-wp-sync.php Passed 13 tests

The principal PHP file in "Air WP Sync - Airtable to WordPress" v. 2.1.0 is loaded by WordPress automatically on each request
48 characters long description:
Swiftly sync Airtable to your WordPress website!

Code Analysis Passed 3 tests

File types Passed 1 test

🔸 Test weight: 35 | Executable files are not allowed as they can serve as attack vectors
Good job! No executable or dangerous file extensions detected13,085 lines of code in 148 files:
LanguageFilesBlank linesComment linesLines of code
PHP1382,6816,68811,564
JavaScript65142570
PO File1192314482
CSS1927415
JSON10049
SVG1005

PHP code Passed 2 tests

Analyzing logical lines of code, cyclomatic complexity, and other code metrics
This plugin has no cyclomatic complexity issues
Cyclomatic complexity
Average complexity per logical line of code0.36
Average class complexity12.94
▷ Minimum class complexity1.00
▷ Maximum class complexity230.00
Average method complexity2.62
▷ Minimum method complexity1.00
▷ Maximum method complexity40.00
Code structure
Namespaces5
Interfaces3
Traits0
Classes117
▷ Abstract classes1916.24%
▷ Concrete classes9883.76%
▷ Final classes00.00%
Methods915
▷ Static methods9510.38%
▷ Public methods62968.74%
▷ Protected methods26128.52%
▷ Private methods252.73%
Functions46
▷ Named functions2043.48%
▷ Anonymous functions2656.52%
Constants40
▷ Global constants615.00%
▷ Class constants3485.00%
▷ Public constants34100.00%

Plugin size Passed 2 tests

Image compression Passed 2 tests

PNG files should be compressed to save space and minimize bandwidth usage
1 PNG file occupies 0.00MB with 0.00MB in potential savings
Potential savings
Compression of 1 random PNG file using pngquant
FileSize - originalSize - compressedSavings
assets/images/logo-wpconnect-v2.png1.87KB0.90KB▼ 51.88%