WordPress.org
Get WordPress

Plugin Directory

Changeset 1798256


Ignore:
Timestamp:
01/06/2018 07:20:04 PM (8 years ago)
Author:
eewee
Message:

1.12

  • db version
Location:
eewee-sellsy/tags/1.12
Files:
3 edited

Legend:

Unmodified
Added
Removed

  • eewee-sellsy/tags/1.12/helpers/dbUpdate.php

    r1792772 r1798256  
    1616        {
    1717            global $wpdb;
    18             $result = $wpdb->get_results( 'SELECT * FROM '.EEWEE_SELLSY_PREFIXE_BDD.'version WHERE version_id=1', OBJECT );
    19             return $result[0]->version_value;
     18
     19            // Table not in database. Create new table
     20            $table_name = EEWEE_SELLSY_PREFIXE_BDD."version";
     21            if($wpdb->get_var("SHOW TABLES LIKE '".$table_name."'") != $table_name) {
     22                //$charset_collate = $wpdb->get_charset_collate();
     23
     24//                $sql = "CREATE TABLE  (
     25//                `version_id` int(11) NOT NULL AUTO_INCREMENT,
     26//                `version_value` float(11) NOT NULL,
     27//                PRIMARY KEY (`version_id`)
     28//                ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;";
     29//
     30//                require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
     31//                dbDelta( $sql );
     32
     33                return false;
     34
     35            // Table in db
     36            } else {
     37                $result = $wpdb->get_results( 'SELECT * FROM '.EEWEE_SELLSY_PREFIXE_BDD.'version WHERE version_id=1', OBJECT );
     38                return $result[0]->version_value;
     39            }
    2040        }
    2141

  • eewee-sellsy/tags/1.12/index.php

    r1798229 r1798256  
    109109$a = new controllers\AjaxController();
    110110
    111 // UPDATE DB
    112 if (is_admin()) {
    113     $dbUpdate = new helpers\DbUpdate();
    114     $dbVersion = $dbUpdate->getVersion();
    115     if (EEWEE_VERSION > $dbVersion) { $dbUpdate->updateDb($dbVersion); }
    116 }
    117 
    118111/**
    119112 * Instantiate Class
    … …  
    156149
    157150/**
     151 * UPDATE DB
     152 */
     153if (is_admin()) {
     154    $dbUpdate = new helpers\DbUpdate();
     155    $dbVersion = $dbUpdate->getVersion();
     156    if (EEWEE_VERSION > $dbVersion && $dbVersion !== false) { $dbUpdate->updateDb($dbVersion); die("coucou"); }
     157}
     158
     159/**
    158160 * Debug
    159161 *

  • eewee-sellsy/tags/1.12/phpunit.xml

    r1798229 r1798256  
    2121    </filter>
    2222    <php>
    23         <var name="DB_DSN" value="mysql:dbname=test;host=localhost:8989" />
     23        <var name="DB_DSN" value="mysql:dbname=db_test;host=localhost" />
    2424        <var name="DB_USER" value="root" />
    2525        <var name="DB_PASSWD" value="root" />
    26         <var name="DB_DBNAME" value="test" />
     26        <var name="DB_DBNAME" value="db_test" />
    2727    </php>
    2828</phpunit>
Note: See TracChangeset for help on using the changeset viewer.