From 8ba28209f3cc008c461b561bbda8830ef565a6fe Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Wed, 11 Mar 2015 15:19:42 -0400 Subject: [PATCH] Save Work IP --- .gitignore | 2 ++ Gruntfile.coffee | 58 ++++++++++++++++++++++++++++++ package.json | 18 ++++++++++ test/dropGlmTables.sql | 11 ++++++ test/test.sql | 44 +++++++++++++++++++++++ wp-config.php | 80 ++++++++++++++++++++++++++++++++++++++++++ 6 files changed, 213 insertions(+) create mode 100644 .gitignore create mode 100644 Gruntfile.coffee create mode 100644 package.json create mode 100644 test/dropGlmTables.sql create mode 100644 test/test.sql create mode 100644 wp-config.php diff --git a/.gitignore b/.gitignore new file mode 100644 index 0000000..8033df1 --- /dev/null +++ b/.gitignore @@ -0,0 +1,2 @@ +mysql-backup-dir/ +node_modules/ diff --git a/Gruntfile.coffee b/Gruntfile.coffee new file mode 100644 index 0000000..992e273 --- /dev/null +++ b/Gruntfile.coffee @@ -0,0 +1,58 @@ +module.exports = (grunt) -> + grunt.initConfig + pkg: grunt.file.readJSON "package.json" + + mysqlrunfile: + options: + connection: + host: "localhost" + user: "grunt" + password: "test555" + database: "grunttestdb" + multipleStatements: true + updatePrefix: + src: ['test/test.sql'] + dropTables: + src: ['test/dropGlmTables.sql'] + + backup4mysql: + options: + user: "grunt" + password: "test555" + host: "localhost" + database: "grunttestdb" + backup: + dir: "mysql-backup-dir" + recovery: + dir: "mysql-backup-dir" + + replace: + prefix: + src: 'wp-config.php' + dest: 'wp-config.php' + replacements: [ + from: /(\$table_prefix)(.*)= '(.*)';/g + to: "$1 = 'glm_';" + ] + + + grunt.loadNpmTasks "grunt-mysql-runfile" + grunt.loadNpmTasks "grunt-mysql-backup" + grunt.loadNpmTasks "grunt-text-replace" + + grunt.registerTask "default", ["sayHello"] + + grunt.registerTask "wpSetup", ["mysqlrunfile:updatePrefix"] + + grunt.registerTask "wpTearDown", ["mysqlrunfile:dropTables"] + + grunt.registerTask "wpBackup", ["backup4mysql:backup"] + + grunt.registerTask "wpRecover", ["backup4mysql:recovery"] + + grunt.registerTask "wpReplace", ["replace:prefix"] + + grunt.registerTask "sayHello", -> + chalk = require('chalk') + grunt.log.writeln(chalk.black.bgWhite.bold 'Hello There!') + grunt.log.writeln('Welcome to our little Grunt script!') diff --git a/package.json b/package.json new file mode 100644 index 0000000..7e7d5ec --- /dev/null +++ b/package.json @@ -0,0 +1,18 @@ +{ + "name": "WP-Sites", + "version": "0.0.1", + "description": "Grunt Project for Running Site Go Live Checklist", + "repository": { + "type": "git", + "url": "git@cvs2:prog/Grunt/WP-Sites.git" + }, + "author": "Steve Sutton ", + "license": "MIT", + "devDependencies": { + "grunt": "~0.4.5", + "grunt-mysql-runfile": "~0.2.1", + "grunt-mysql-backup": "0.0.2", + "grunt-text-replace": "~0.4.0", + "chalk": "~1.0.0" + } +} diff --git a/test/dropGlmTables.sql b/test/dropGlmTables.sql new file mode 100644 index 0000000..cc9036c --- /dev/null +++ b/test/dropGlmTables.sql @@ -0,0 +1,11 @@ +DROP TABLE `glm_commentmeta`; +DROP TABLE `glm_comments`; +DROP TABLE `glm_links`; +DROP TABLE `glm_options`; +DROP TABLE `glm_postmeta`; +DROP TABLE `glm_posts`; +DROP TABLE `glm_term_relationships`; +DROP TABLE `glm_term_taxonomy`; +DROP TABLE `glm_terms`; +DROP TABLE `glm_usermeta`; +DROP TABLE `glm_users`; diff --git a/test/test.sql b/test/test.sql new file mode 100644 index 0000000..15160c2 --- /dev/null +++ b/test/test.sql @@ -0,0 +1,44 @@ +RENAME table `wp_commentmeta` TO `glm_commentmeta`; +RENAME table `wp_comments` TO `glm_comments`; +RENAME table `wp_links` TO `glm_links`; +RENAME table `wp_options` TO `glm_options`; +RENAME table `wp_postmeta` TO `glm_postmeta`; +RENAME table `wp_posts` TO `glm_posts`; +RENAME table `wp_terms` TO `glm_terms`; +RENAME table `wp_term_relationships` TO `glm_term_relationships`; +RENAME table `wp_term_taxonomy` TO `glm_term_taxonomy`; +RENAME table `wp_usermeta` TO `glm_usermeta`; +RENAME table `wp_users` TO `glm_users`; + +INSERT INTO `glm_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES +('cscott', '$P$$P$BJMie6Dwyp.RD6V6lGgh88TuJ/r625.', 'cscott', 'cscott@gaslightmedia.com', '', NOW(), '', 0, 'cscott'), +('jodie', '$P$BzO0XuOIXx8b8x6ztWSKejkiK5lhvd/', 'jodie', 'jodie@gaslightmedia.com', '', NOW(), '', 0, 'jodie'), +('laury', '$P$BUQqo9GDEdRxgPGN3xHgxTAmhZmYUO1', 'laury', 'laury@gaslightmedia.com', '', NOW(), '', 0, 'laury'), +('anthony', '$P$BubULLBz9zOc1k7sQ6gQHkjCI40pOU1', 'anthony', 'anthony@gaslightmedia.com', '', NOW(), '', 0, 'anthony'); + +UPDATE `glm_options` SET `option_name` = 'glm_user_roles' WHERE `option_name` = 'wp_user_roles'; +UPDATE `glm_usermeta` SET `meta_key` = 'glm_capabilities' WHERE `meta_key` = 'wp_capabilities'; +UPDATE `glm_usermeta` SET `meta_key` = 'glm_user_level' WHERE `meta_key` = 'wp_user_level'; + +INSERT INTO `glm_usermeta` (`umeta_id`,`user_id`,`meta_key`,`meta_value`) VALUES +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'cscott'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'), +(NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'cscott'), 'glm_user_level', '10'); + + +INSERT INTO `glm_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'jodie'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'); +INSERT INTO `glm_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'jodie'), 'glm_user_level', '10'); +INSERT INTO `glm_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'jodie'), 'nickname', 'jodie'); + +INSERT INTO `glm_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'laury'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'); +INSERT INTO `glm_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'laury'), 'glm_user_level', '10'); +INSERT INTO `glm_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'laury'), 'nickname', 'laury'); + +INSERT INTO `glm_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'anthony'), 'glm_capabilities', 'a:1:{s:13:"administrator";b:1;}'); +INSERT INTO `glm_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'anthony'), 'glm_user_level', '10'); +INSERT INTO `glm_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (SELECT `ID` FROM `glm_users` WHERE `user_login` = 'anthony'), 'nickname', 'anthony'); + +UPDATE `glm_options` SET `timezone_string` = 'America/Detroit'; +UPDATE `glm_options` SET `start_of_week` = '0'; +UPDATE `glm_options` SET `show_on_front` = 'page'; +UPDATE `glm_options` SET `page_on_front` = '2'; +UPDATE `glm_posts` SET `post_title` = 'Front Page' WHERE `post_type` = 'page'; diff --git a/wp-config.php b/wp-config.php new file mode 100644 index 0000000..aef4cf8 --- /dev/null +++ b/wp-config.php @@ -0,0 +1,80 @@ +C:c'); +define('SECURE_AUTH_KEY', ' t7J,}Rku|.$a/tMn^Da=?^9hJTP;0z|)-SwNB}^C9|oqMV5S=6:}s2:4{!nt*YG'); +define('LOGGED_IN_KEY', '#Kbm|]8w*9f,4%V(cWZnxGBk>U U< K]VQlz(ua&(>`D3RsU{A>#vRmH}.V +:Hi'); +define('NONCE_KEY', '+Rk2^|][>Fyd[$@-dcE7Qnjxj+++,|~`u4P,+m*];_*|3Sb+Xf|s#}U.JQ'); +define('SECURE_AUTH_SALT', 'qgX|TBS,