Skip to content

Instantly share code, notes, and snippets.

View tygern's full-sized avatar

Tyson Gern tygern

View GitHub Profile
@tygern
tygern / create_sequence.sql
Created August 26, 2015 13:16
Non Sequential ID Generation - create sequence
CREATE SEQUENCE id_seq;
@tygern
tygern / create_function.sql
Created August 26, 2015 13:17
Non Sequential ID Generation - create function
CREATE FUNCTION fetch_id(text) RETURNS bigint AS
'select (9369712273 * nextval($1) + 1365089121) % 999999937;'
LANGUAGE SQL
IMMUTABLE
RETURNS NULL ON NULL INPUT;
@tygern
tygern / create_table.sql
Created August 26, 2015 13:17
Non Sequential ID Generation - create table
CREATE TABLE users
(
id BIGINT NOT NULL DEFAULT fetch_id('id_seq'),
email VARCHAR
);
@tygern
tygern / insert_users.sql
Created August 26, 2015 13:18
Non Sequential ID Generation - insert users
INSERT INTO users (email) VALUES ('[email protected]');
INSERT INTO users (email) VALUES ('[email protected]');
INSERT INTO users (email) VALUES ('[email protected]');
SELECT * FROM USERS;
id | email
-----------+-------------------
734802024 | [email protected]
104514927 | [email protected]
474227767 | [email protected]
@tygern
tygern / fillForm.js
Created August 26, 2015 13:20
Automated User Creation - fill form
var timestamp = (new Date()).getTime();
var username = 'user-' + timestamp;
var users = localStorage.getItem("users");
if (users) {
users = users + "," + username;
} else {
users = username;
}
@tygern
tygern / logIn.js
Created August 26, 2015 13:20
Automated User Creation - log in
var users = localStorage.getItem("users");
if (users) {
username = users.split(",").slice(-1)[0];
document.getElementById('username').value = username;
document.getElementById('password').value = 'testing123';
document.getElementById('submitButton').focus();
}
@tygern
tygern / listUsers.js
Created August 26, 2015 13:21
Automated User Creation - list users
var users = localStorage.getItem("users");
if (users) {
users = users.split(",");
} else {
users = "no users stored";
}
console.log(users);
@tygern
tygern / deleteUsers.js
Created August 26, 2015 13:22
Automated User Creation - delete users
localStorage.removeItem("users");
@tygern
tygern / user_creator.rb
Last active August 27, 2015 16:21
Returning response objects in Ruby - creation service before
class UsersCreator
def create(attributes)
user = UserRepository.new.create(attributes)
if user.nil? || !user.persisted?
return user
end
notification_success = UserNotifier.new(user).send_signup_confirmation
@tygern
tygern / user_creator.rb
Last active August 27, 2015 11:01
Returning response objects in Ruby - creation service after
class UsersCreator
def create(attributes)
repository_response = UserRepository.new.create(attributes)
return repository_response unless repository_response.success
user = repository_response.entity
notifier_response = UserNotifier.new(user).send_signup_confirmation
ServiceResponse.new(
success: notifier_response.success,