Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var mysql = require('mysql');
- var connection = mysql.createConnection(
- {
- host : 'hackteams.c6p7kpyzcymg.us-east-1.rds.amazonaws.com',
- user : 'test',
- password : 'password',
- database : 'hackteams'
- }
- );
- // username, hackathon name:
- var user = 'tiger';
- var hackathon = 'Def Hacks() NY';
- function getUserId(callback) {
- connection.query("SELECT id FROM users WHERE username = '" + user + "'", function(err, rows, field) {
- if (err) callback(err, -1, null);
- callback(null, -1, rows[0].id);
- });
- }
- function getHackathonId(in_id, callback) {
- connection.query("SELECT id FROM hackathon WHERE hackathon_name = '" + hackathon + "'", function(err, rows, field) {
- if (err) callback(err, in_id, null);
- callback(null, in_id, rows[0].id);
- });
- }
- function setInterest(user_id, hack_id) {
- var interest = {
- user_id : user_id,
- hackathon_id : hack_id
- };
- connection.query("INSERT INTO user_interest_in_hackathon SET ?", interest, function(err, res) {
- if (err) throw err;
- console.log("success");
- connection.end();
- });
- }
- function processId(err, type, result) {
- console.log(result);
- if (type == -1) {
- getHackathonId(result, processId);
- } else {
- setInterest(type, result);
- }
- }
- getUserId(processId);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement