rexql/install.php at main · FriendsOfREDAXO/rexql · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
<?php

/**
 * Installation of the rexQL addon
 *
 * @var rex_addon $this
 */

$error = '';

// Check if graphql-php is available
if (!class_exists('GraphQL\\GraphQL')) {
  $error = 'Dependencies not installed. Run "composer install" in the addon directory.';
}

rex_dir::copy($this->getPath('data'), $this->getDataPath());


// Create database structure
if (!$error) {
  // API Keys table
  rex_sql_table::get(rex::getTable('rexql_api_keys'))
    ->ensurePrimaryIdColumn()
    ->ensureColumn(new rex_sql_column('name', 'varchar(255)', false))
    ->ensureColumn(new rex_sql_column('api_key', 'varchar(64)', false))
    ->ensureColumn(new rex_sql_column('permissions', 'text', false))
    ->ensureColumn(new rex_sql_column('rate_limit', 'int(10) unsigned', false, '100'))
    ->ensureColumn(new rex_sql_column('last_used', 'datetime'))
    ->ensureColumn(new rex_sql_column('usage_count', 'int(10) unsigned', false, '0'))
    ->ensureColumn(new rex_sql_column('active', 'tinyint(1)', false, '1'))
    ->ensureColumn(new rex_sql_column('created_by', 'varchar(255)', false))
    ->ensureColumn(new rex_sql_column('createdate', 'datetime', false))
    ->ensureColumn(new rex_sql_column('updatedate', 'datetime', false))
    // Public/Private Key fields
    ->ensureColumn(new rex_sql_column('public_key', 'varchar(64)'))
    ->ensureColumn(new rex_sql_column('private_key', 'varchar(64)'))
    // Domain/IP Restriction fields
    ->ensureColumn(new rex_sql_column('allowed_domains', 'text'))
    ->ensureColumn(new rex_sql_column('allowed_ips', 'text'))
    ->ensureColumn(new rex_sql_column('https_only', 'tinyint(1)', false, '0'))
    ->ensureColumn(new rex_sql_column('key_type', 'varchar(50)', false, 'standard'))
    ->ensureIndex(new rex_sql_index('api_key', ['api_key'], rex_sql_index::UNIQUE))
    ->ensureIndex(new rex_sql_index('active', ['active']))
    ->ensure();

  // Query Logs table
  rex_sql_table::get(rex::getTable('rexql_query_log'))
    ->ensurePrimaryIdColumn()
    ->ensureColumn(new rex_sql_column('api_key_id', 'int(10) unsigned', true)) // nullable for SET_NULL foreign key
    ->ensureColumn(new rex_sql_column('query', 'text', false))
    ->ensureColumn(new rex_sql_column('variables', 'text', true)) // nullable
    ->ensureColumn(new rex_sql_column('execution_time', 'decimal(8,3)', false))
    ->ensureColumn(new rex_sql_column('memory_usage', 'int(10) unsigned', false))
    ->ensureColumn(new rex_sql_column('success', 'tinyint(1)', false))
    ->ensureColumn(new rex_sql_column('error_message', 'text', true)) // nullable
    ->ensureColumn(new rex_sql_column('ip_address', 'varchar(45)', false))
    ->ensureColumn(new rex_sql_column('user_agent', 'text', true)) // nullable
    ->ensureColumn(new rex_sql_column('from_cache', 'tinyint(1)', false, '0'))
    ->ensureColumn(new rex_sql_column('createdate', 'datetime', false))
    ->ensureIndex(new rex_sql_index('api_key_id', ['api_key_id']))
    ->ensureIndex(new rex_sql_index('createdate', ['createdate']))
    ->ensureIndex(new rex_sql_index('success', ['success']))
    ->ensureForeignKey(new rex_sql_foreign_key('fk_rexql_query_log_api_key', rex::getTable('rexql_api_keys'), ['api_key_id' => 'id'], rex_sql_foreign_key::SET_NULL))
    ->ensure();

  // Webhooks table
  rex_sql_table::get(rex::getTable('rexql_webhook'))
    ->ensurePrimaryIdColumn()
    ->ensureColumn(new rex_sql_column('name', 'varchar(255)', false))
    ->ensureColumn(new rex_sql_column('url', 'varchar(500)', false))
    ->ensureColumn(new rex_sql_column('secret', 'varchar(255)', false))
    ->ensureColumn(new rex_sql_column('active', 'tinyint(1)', false, '1'))
    ->ensureColumn(new rex_sql_column('timeout', 'int(10)', false, '30'))
    ->ensureColumn(new rex_sql_column('retry_attempts', 'int(3)', false, '3'))
    ->ensureColumn(new rex_sql_column('last_called', 'datetime', true))
    ->ensureColumn(new rex_sql_column('last_status', 'varchar(50)', true))
    ->ensureColumn(new rex_sql_column('last_error', 'text', true))
    ->ensureColumn(new rex_sql_column('call_count', 'int(10)', false, '0'))
    ->ensureColumn(new rex_sql_column('created_by', 'varchar(255)', false))
    ->ensureColumn(new rex_sql_column('createdate', 'datetime', false))
    ->ensureColumn(new rex_sql_column('updatedate', 'datetime', false))
    ->ensureIndex(new rex_sql_index('active', ['active']))
    ->ensure();
}

if ($error) {
  throw new rex_functional_exception($error);
}