ReadingTime Database Class

reading-time-database.php

<?php
namespace PublicFunctionOrg\WordPress\ReadingTime;

class Database {
	
	public function __construct(){
		global $wpdb;
		$this->wpdb = $wpdb;
		$this->table = $this->wpdb->prefix."posts_reading_time";
	}
	
	public function set($post_id, $reading_time){
		return $this->wpdb->replace(
			$this->table,
			[
				"post_id" => $post_id,
				"reading_time" => $reading_time,
			],
			[
				"%d",
				"%d",
			]
		);
	}
	
	public function get($post_id){
		return intval($this->wpdb->get_var(
			$this->wpdb->prepare(
				"SELECT reading_time FROM {$this->table} WHERE post_id = %d",
				$post_id
			)	
		));
	}
	
	public function createTables(){
		require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
		\dbDelta("CREATE TABLE IF NOT EXISTS {$this->table}
			(
			 post_id bigint (20) unsigned NOT NULL,
			 reading_time int(3) unsigned NOT NULL,
			 primary key  (post_id),
			 key (reading_time),
			 key post_reading_time (post_id, reading_time)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;");
	}
}

// use register_activation_hook(...) to create tables