Siren: dev check list + bug list + footnote

http://192.168.93.21/projects/benchmarking/siren-2.x-dev-pdo_mysql/
http://192.168.93.21/projects/benchmarking/siren-2.x-dev-pdo_pgsql/
http://192.168.93.21/projects/benchmarking/siren-2.x-dev-pdo_oci/ (dev, 95%)
http://192.168.93.21/projects/benchmarking/siren-2.x-dev-pdo_sqlite/ (dev, 70%)
http://192.168.93.21/projects/benchmarking/siren-2.x-dev-pdo_ibm/ (dev, 80%)

http://192.168.0.88/
http://192.168.0.88/phpmyadmin/
http://192.168.0.88/phppgadmin/
http://192.168.0.88:1158/em/
http://192.168.0.88/projects/benchmarking/drupal-7.x-dev/
http://192.168.0.88/projects/benchmarking/siren-2.x-dev/

MySQL flush DB:

DROP DATABASE AL32UTF8;
CREATE DATABASE AL32UTF8;

PostgreSQL flush DB:

su - postgres
dropdb AL32UTF8
createdb -O root AL32UTF8

Oracle flush DB:

DROP USER ROOT CASCADE;

CREATE USER ROOT PROFILE "DEFAULT" IDENTIFIED BY "CHANGE" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
GRANT "AQ_ADMINISTRATOR_ROLE" TO ROOT;
GRANT "AQ_USER_ROLE" TO ROOT;
GRANT "AUTHENTICATEDUSER" TO ROOT;
GRANT "CONNECT" TO ROOT;
GRANT "CTXAPP" TO ROOT;
GRANT "DBA" TO ROOT;
GRANT "DELETE_CATALOG_ROLE" TO ROOT;
GRANT "EJBCLIENT" TO ROOT;
GRANT "EXECUTE_CATALOG_ROLE" TO ROOT;
GRANT "EXP_FULL_DATABASE" TO ROOT;
GRANT "GATHER_SYSTEM_STATISTICS" TO ROOT;

query debug:

<?php
  // TODO: remove debug
  openlog("siren", LOG_PID | LOG_PERROR, LOG_LOCAL0);
  if (preg_match('/[^\[\'{a-z0-9_:]([a-z0-9_{}]{3,})[^\]\'}a-z0-9_]/Ds', $query, $matches) && !preg_match('/[0-9]/', $matches[1])) {
    syslog(LOG_ERR, "No []: " . $query);
  }
  if (preg_match("/'%s'/", $query)) {
    syslog(LOG_ERR, "OLD '%s': " . $query);
  }
  if (preg_match("/!=/", $query)) {
    syslog(LOG_ERR, "OLD !=: " . $query);
  }
  if (preg_match("/[ ,]''[ ,]/", $query)) {
    syslog(LOG_ERR, "EMPTY STRING '': " . $query);
  }
  closelog();
?>

check not null:

<?php
$schema = drupal_get_schema(NULL, TRUE);

foreach ($schema as $table_name => $table) {
  foreach ($table['fields'] as $column_name => $column) {
    if ($column['type'] == 'char' || $column['type'] == 'varchar' || $column['type'] == 'text' || $column['type'] == 'blob') {
      if ((!isset($column['default']) && !empty($column['not null'])) || (isset($column['default']) && $column['default'] == '')){
        print "<code>&lt;pre&gt;&quot;;&#10;        print_r(&quot;$table_name.$column_name&quot;);&#10;        print &quot;&lt;/pre&gt;</code>";
      }
    }
  }
}
?>

edin.no-ip.com

Siren: dev check list + bug list + footnote

Post new comment

Similar entries