lytics.install

<?php

use Drupal\Core\Database\Schema\Blueprint;
use Drupal\Core\Database\Schema\Schema;
use Drupal\Core\Database\Database;

/**
 * Implements hook_schema().
 */
function lytics_schema()
{
  $schema['lytics_widget'] = [
    'description' => 'The base table for Lytics Widgets.',
    'fields' => [
      'id' => [
        'type' => 'serial',
        'not null' => TRUE,
        'description' => 'Primary Key: Unique Widget ID.',
      ],
      'title' => [
        'type' => 'varchar',
        'length' => 255,
        'description' => 'Widget title.',
      ],
      'description' => [
        'type' => 'text',
        'description' => 'Widget description.',
      ],
      'config' => [
        'type' => 'text',
        'description' => 'Widget configuration.',
      ],
      'status' => [
        'type' => 'varchar',
        'length' => 255,
        'description' => 'Widget status.',
      ],
    ],
    'primary key' => ['id'],
  ];

  return $schema;
}

/**
 * Implements hook_update_N().
 *
 * Create the table for the new entity lytics_experience.
 * If the table already exists, ensure it has proper columns.
 */
function lytics_update_9001()
{
  $schema = Database::getConnection()->schema();

  $table_name = 'lytics_experience';

  $table = [
    'description' => 'Table for storing Lytics Experience entities.',
    'fields' => [
      'id' => [
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'description' => 'Primary Key: Unique ID for the Lytics Experience entity.',
      ],
      'title' => [
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'description' => 'Title of the Lytics Experience entity.',
      ],
      'description' => [
        'type' => 'text',
        'size' => 'big',
        'description' => 'Description of the Lytics Experience entity.',
      ],
      'config' => [
        'type' => 'text',
        'size' => 'big',
        'description' => 'Configuration of the Lytics Experience entity.',
      ],
      'status' => [
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => 'draft',
        'description' => 'Status of the Lytics Experience entity.',
      ],
    ],
    'primary key' => ['id'],
  ];

  // Check if the table already exists.
  if ($schema->tableExists($table_name)) {
    foreach ($table['fields'] as $field_name => $field_definition) {
      // If the field does not exist in the existing table, add it.
      if (!$schema->fieldExists($table_name, $field_name)) {
        $schema->addField($table_name, $field_name, $field_definition);
      }
    }
  } else {
    // Create the table if it doesn't exist.
    $schema->createTable($table_name, $table);
  }
}


/**
 * Implements hook_update_N().
 *
 * Rename the existing lytics_experience table to lytics_widget if it exists. In addition, verify that the column definitions are correct. If no table exists, create lytics_widget table.
 */
function lytics_update_9002()
{
  $schema = Database::getConnection()->schema();

  $table_name = 'lytics_widget';

  // Check if the lytics_experience table exists.
  if ($schema->tableExists('lytics_experience')) {
    // If it exists, rename it to lytics_widget.
    $schema->renameTable('lytics_experience', $table_name);
  }

  // Define the schema for the lytics_widget table.
  $table = [
    'description' => 'Table for storing Lytics Widget entities.',
    'fields' => [
      'id' => [
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'description' => 'Primary Key: Unique ID for the Lytics Widget entity.',
      ],
      'title' => [
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'description' => 'Title of the Lytics Widget entity.',
      ],
      'description' => [
        'type' => 'text',
        'size' => 'big',
        'description' => 'Description of the Lytics Widget entity.',
      ],
      'config' => [
        'type' => 'text',
        'size' => 'big',
        'description' => 'Configuration of the Lytics Widget entity.',
      ],
      'status' => [
        'type' => 'varchar',
        'length' => 255,
        'not null' => TRUE,
        'default' => 'draft',
        'description' => 'Status of the Lytics Widget entity.',
      ],
    ],
    'primary key' => ['id'],
  ];

  // Check if the lytics_widget table exists.
  if ($schema->tableExists($table_name)) {
    foreach ($table['fields'] as $field_name => $field_definition) {
      // If the field does not exist in the existing table, add it.
      if (!$schema->fieldExists($table_name, $field_name)) {
        $schema->addField($table_name, $field_name, $field_definition);
      }
    }
  } else {
    // Create the table if it doesn't exist.
    $schema->createTable($table_name, $table);
  }
}