public function __construct($dbhost, $dbport = '1433', $dbuser, $dbpass, $dbname, $boost = false) { parent::__construct($dbhost, $dbport, $dbuser, $dbpass, $dbname, $boost); ini_set('display_errors', 1); ini_set('mssql.datetimeconvert', 0); $this->odbtype = 'mssql'; }
public function __construct($arguments) { parent::__construct($arguments); // Make sure we can use it for node and term only. if (!in_array($this->entityType, array('node', 'taxonomy_term'))) { throw new Exception('\\SkeletonMigration supports only nodes and terms.'); } $this->description = t('Import @type - @bundle from SQL table', array('@type' => $this->entityType, '@bundle' => $this->bundle)); $this->fields = !empty($this->fields) ? $this->fields : array(); $sql_fields[] = '_unique_id'; if ($this->entityType == 'node') { $this->addFieldMapping('title', '_title'); $class_name = 'MigrateDestinationNode'; $sql_fields[] = '_title'; } elseif ($this->entityType == 'taxonomy_term') { $this->addFieldMapping('name', '_name'); $class_name = 'MigrateDestinationTerm'; $sql_fields[] = '_name'; } // Rebuild the csv columns array. $this->fields = array_merge($sql_fields, $this->fields); // Create a map object for tracking the relationships between source rows $key = array('_unique_id' => array('type' => 'varchar', 'length' => 255, 'not null' => TRUE)); $destination_handler = new MigrateDestinationEntityAPI($this->entityType, $this->bundle); $this->map = new MigrateSQLMap($this->machineName, $key, $destination_handler->getKeySchema($this->entityType)); // Create a MigrateSource object. $sql_table = isset($this->sqlTable) ? '_raw_' . $this->sqlTable : '_raw_' . $this->bundle; $query = db_select($sql_table, 't')->fields('t')->orderBy('__id'); $this->source = new MigrateSourceSQL($query, $this->fields); $this->destination = new $class_name($this->bundle, array('text_format' => 'filtered_html')); }
public function __construct() { parent::__construct(); // Map fields that don't need extra definitions. $field_names = array('id', 'weekday', 'hour_from', 'hour_to', 'cap'); $this->addSimpleMappings($field_names); $this->addFieldMapping('meter_nid', 'meter_nid')->sourceMigration(array('NegawattIecMeterMigrate', 'NegawattModbusMeterMigrate')); $this->description = t('Import @type - from CSV file.', array('@type' => $this->entityType)); // Create a map object for tracking the relationships between source rows $key = array('id' => array('type' => 'int', 'not null' => TRUE)); $destination_handler = new MigrateDestinationEntityAPI($this->entityType, $this->bundle); $this->map = new MigrateSQLMap($this->machineName, $key, $destination_handler->getKeySchema($this->entityType)); // Create a MigrateSource object. $sql_migrate = variable_get('negawatt_migrate_sql', FALSE); if ($sql_migrate) { // SQL migration. $query = db_select('_negawatt_power_cap_analyzer_info_migrate', $this->bundle)->fields($this->bundle, $field_names); $this->source = new MigrateSourceSQL($query); } else { // CSV migration. // Allow using variable to set path other than default. $csv_path = variable_get('negawatt_migrate_csv_path', drupal_get_path('module', 'negawatt_migrate') . '/csv'); $this->source = new MigrateSourceCSV($csv_path . '/normalizer/' . $this->entityType . '.csv', $this->csvColumns, array('header_rows' => 1)); } $this->destination = new MigrateDestinationEntityAPI($this->entityType, $this->bundle); }
public function __construct($arguments) { parent::__construct($arguments); // Source $columns = array(0 => array('id', 'User ID'), 3 => array('fname', 'First Name'), 4 => array('lname', 'Last Name')); $this->source = new MigrateSourceCSV('/path/to/myfile.csv', $columns); // Destination $this->destination = new MigrateDestinationNode('page'); // Key schema $source_key_schema = array('nid' => array('type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE)); $this->map = new MigrateSQLMap($this->machineName, $source_key_schema, MigrateDestinationNode::getKeySchema()); // Mapping $this->addFieldMapping('title', 'title'); }
public function __construct() { parent::__construct(); $this->description = t('Import @bundle terms from CSV file.', array('@bundle' => $this->bundle)); // Map fields that don't need extra definitions. $field_names = array('id', 'name', 'weight', 'description', 'field_icon_categories'); $this->addSimpleMappings($field_names); $this->addFieldMapping('account_id', 'account_id')->sourceMigration('NegawattAccountMigrate'); // Create a map object for tracking the relationships between source rows $key = array('id' => array('type' => 'varchar', 'length' => 255, 'not null' => TRUE)); $destination_handler = new MigrateDestinationEntityAPI('taxonomy_term', $this->bundle); $this->map = new MigrateSQLMap($this->machineName, $key, $destination_handler->getKeySchema('taxonomy_term')); // Create a MigrateSource object. $csv_file = 'taxonomy_term/' . $this->bundle . '.csv'; $this->source = new MigrateSourceCSV(drupal_get_path('module', 'negawatt_migrate') . '/csv/' . $csv_file, $this->csvColumns, array('header_rows' => 1)); $this->destination = new MigrateDestinationTerm($this->bundle); }
public function __construct() { parent::__construct(); $this->description = t('Import users from a CSV file.'); $this->addFieldMapping('name', 'name'); $this->addFieldMapping('pass', 'pass'); $this->addFieldMapping('mail', 'mail'); $this->addFieldMapping('og_user_node', 'account')->sourceMigration('NegawattAccountMigrate')->separator('|'); $this->addFieldMapping('status')->defaultValue(TRUE); // Create a map object for tracking the relationships between source rows $key = array('name' => array('type' => 'varchar', 'length' => 255, 'not null' => TRUE)); $destination_handler = new MigrateDestinationUser(); $this->map = new MigrateSQLMap($this->machineName, $key, $destination_handler->getKeySchema()); // Create a MigrateSource object. $this->source = new MigrateSourceCSV(drupal_get_path('module', 'negawatt_migrate') . '/csv/' . $this->entityType . '/user.csv', $this->csvColumns, array('header_rows' => 1)); $this->destination = new MigrateDestinationUser(); }
public function __construct($arguments = array()) { parent::__construct($arguments); // Make sure we can use it for node and term only. if (!in_array($this->entityType, array('node', 'taxonomy_term'))) { throw new Exception('\\NegawattMigration supports only nodes and terms.'); } $this->description = t('Import @type - @bundle from CSV file.', array('@type' => $this->entityType, '@bundle' => $this->bundle)); $this->csvColumns = !empty($this->csvColumns) ? $this->csvColumns : array(); $csv_cols[] = array('Unique_ID', 'Unique_ID'); if ($this->entityType == 'node') { $this->addFieldMapping('title', 'title'); $class_name = 'MigrateDestinationNode'; $csv_cols[] = array('title', 'Title'); } elseif ($this->entityType == 'taxonomy_term') { $this->addFieldMapping('name', 'name'); $class_name = 'MigrateDestinationTerm'; $csv_cols[] = array('name', 'Name'); } // Rebuild the csv columns array. $this->csvColumns = array_merge($csv_cols, $this->csvColumns); // Create a map object for tracking the relationships between source rows $key = array('Unique_ID' => array('type' => 'varchar', 'length' => 255, 'not null' => TRUE)); $destination_handler = new MigrateDestinationEntityAPI($this->entityType, $this->bundle); $this->map = new MigrateSQLMap($this->machineName, $key, $destination_handler->getKeySchema($this->entityType)); // Create a MigrateSource object. $sql_migrate = variable_get('negawatt_migrate_sql', FALSE); if ($sql_migrate) { // SQL migration. // Prepare sql column names from csvColumns $sqlColumns = array(); foreach ($this->csvColumns as $col) { $sqlColumns[] = $col[0]; } $query = db_select('_negawatt_' . $this->bundle . '_migrate', $this->bundle)->fields($this->bundle, $sqlColumns); $this->source = new MigrateSourceSQL($query); } else { // CSV migration. // Allow using variable to set path other than default. $csv_path = variable_get('negawatt_migrate_csv_path', drupal_get_path('module', 'negawatt_migrate') . '/csv'); $this->source = new MigrateSourceCSV($csv_path . '/' . $this->entityType . '/' . $this->bundle . '.csv', $this->csvColumns, array('header_rows' => 1)); } $this->destination = new $class_name($this->bundle, array('text_format' => 'filtered_html')); }
public function __construct($arguments) { parent::__construct($arguments); $this->description = t('Import users from a CSV file.'); $this->addFieldMapping('og_user_node', '_company')->separator('|')->sourceMigration('SkeletonCompaniesMigrate'); $this->addFieldMapping('name', '_username'); $this->addFieldMapping('pass', '_password'); $this->addFieldMapping('mail', '_email'); $this->addFieldMapping('roles')->defaultValue(DRUPAL_AUTHENTICATED_RID); $this->addFieldMapping('status')->defaultValue(TRUE); // Create a map object for tracking the relationships between source rows $key = array('_unique_id' => array('type' => 'varchar', 'length' => 255, 'not null' => TRUE)); $destination_handler = new MigrateDestinationUser(); $this->map = new MigrateSQLMap($this->machineName, $key, $destination_handler->getKeySchema()); $query = db_select('_raw_user', 't')->fields('t')->orderBy('__id'); $this->source = new MigrateSourceSQL($query, $this->fields); // Create a MigrateSource object. $this->destination = new MigrateDestinationUser(); }
function __construct() { parent::__construct(); $this->new_configs = array('calendar_user_control_data' => array('name' => 'CALENDAR_SETTINGS', 'range' => 'user', 'type' => 'array', 'description' => 'persönliche Einstellungen des Kalenders', 'value' => json_encode(array("view" => "showweek", "start" => 9, "end" => 20, "step_day" => 900, "step_week" => 3600, "type_week" => "LONG", "holidays" => TRUE, "sem_data" => TRUE, "delete" => 0))), 'my_messaging_settings' => array('name' => 'MESSAGING_SETTINGS', 'range' => 'user', 'type' => 'array', 'description' => 'persönliche Einstellungen Nachrichtenbereich', 'value' => json_encode(array("show_only_buddys" => FALSE, "delete_messages_after_logout" => FALSE, "timefilter" => '30d', "opennew" => 1, "logout_markreaded" => FALSE, "openall" => FALSE, "addsignature" => FALSE, "save_snd" => TRUE, "sms_sig" => '', "send_view" => FALSE, "confirm_reading" => 3, "send_as_email" => FALSE, "folder" => array('in' => array('dummy'), 'out' => array('dummy'))))), 'forum' => array('name' => 'FORUM_SETTINGS', 'range' => 'user', 'type' => 'array', 'description' => 'persönliche Einstellungen Forum', 'value' => json_encode(array('neuauf' => false, 'rateallopen' => true, 'showimages' => true, 'sortthemes' => 'last', 'themeview' => 'mixed', 'presetview' => 'mixed', 'shrink' => 7 * 24 * 60 * 60))), 'my_schedule_settings' => array('name' => 'SCHEDULE_SETTINGS', 'range' => 'user', 'type' => 'array', 'description' => 'persönliche Einstellungen Stundenplan', 'value' => json_encode(array("glb_start_time" => 8, "glb_end_time" => 19, "glb_days" => array(1 => 1, 2 => 2, 3 => 3, 4 => 4, 5 => 5, 6 => 6, 0 => 0), "glb_sem" => null, "converted" => true))), 'homepage_cache_own' => array('name' => 'PROFILE_LAST_VISIT', 'range' => 'user', 'type' => 'integer', 'description' => 'Zeitstempel des letzten Besuchs der Profilseite', 'value' => 0), 'CurrentLogin' => array('name' => 'CURRENT_LOGIN_TIMESTAMP', 'range' => 'user', 'type' => 'integer', 'description' => 'Zeitstempel des Logins', 'value' => 0), 'LastLogin' => array('name' => 'LAST_LOGIN_TIMESTAMP', 'range' => 'user', 'type' => 'integer', 'description' => 'Zeitstempel des vorherigen Logins', 'value' => 0), 'my_studip_settings' => array('name' => 'PERSONAL_STARTPAGE', 'range' => 'user', 'type' => 'integer', 'description' => 'Persönliche Startseite', 'value' => 0), '_my_sem_group_field' => array('name' => 'MY_COURSES_GROUPING', 'range' => 'user', 'type' => 'string', 'description' => 'Gruppierung der Veranstaltungsübersicht', 'value' => ''), '_my_sem_open' => array('name' => 'MY_COURSES_OPEN_GROUPS', 'range' => 'user', 'type' => 'array', 'description' => 'geöffnete Gruppen der Veranstaltungsübersicht', 'value' => '[]'), '_my_admin_inst_id' => array('name' => 'MY_INSTITUTES_DEFAULT', 'range' => 'user', 'type' => 'string', 'description' => 'Standard Einrichtung in der Veranstaltungsübersicht für Admins', 'value' => '')); }
public function __construct() { parent::__construct('2.84', '2.85', "ThWboard Development Team", "This migration requires an unmodified database schema based on version 2.84"); }
public function __construct() { parent::__construct('', '2.8', "ThWboard Development Team", "This migration installs the database schema for version 2.8"); }