Skip to content

Instantly share code, notes, and snippets.

View gideondsouza's full-sized avatar

Gideon Israel Dsouza gideondsouza

15 followers · 15 following
  • Dransfeld, Germany
View GitHub Profile
@gideondsouza
gideondsouza / Problem14.sql
Created August 31, 2012 11:17
SELECT a.name
FROM casting c JOIN movie m ON
m.id = c.movieid
JOIN actor a ON
a.id = c.actorid AND
c.ord = 1
GROUP BY a.name
Having Count(m.id) >= 30
@gideondsouza
gideondsouza / Problem15.sql
Created August 31, 2012 11:18
SELECT m.title, Count(c.actorid)
FROM casting c JOIN movie m ON
m.id = c.movieid
WHERE m.yr = 1978
GROUP BY m.title
ORDER BY Count(c.actorid) DESC
@gideondsouza
gideondsouza / Problem16.sql
Created August 31, 2012 11:19
SELECT a.name
FROM casting c JOIN actor a ON
a.id = c.actorid
WHERE
a.name <> 'Art Garfunkel' AND
c.movieid
IN (
SELECT m.id
FROM casting c JOIN movie m ON
m.id = c.movieid
@gideondsouza
gideondsouza / Problem1.sql
Created August 31, 2012 11:42
SELECT id, title FROM movie WHERE yr = 1962
@gideondsouza
gideondsouza / Problem2.sql
Created August 31, 2012 11:42
SELECT yr
FROM movie
WHERE title='Citizen Kane'
@gideondsouza
gideondsouza / ScrapeImages.pl
Created December 12, 2012 03:11
Created by www.tryperl.com. Updated on 26-0-113 at 19 hour(s)
#!/usr/bin/perl
#updated on tryperl.com
# Created by Gideon Dsouza on 2012-12-11
use strict;
use warnings;
use WWW::Mechanize;
use HTML::TokeParser;
#create a new instance of mechanize
@gideondsouza
gideondsouza / scrape_snippet.html
Created December 12, 2012 06:16
Html I wanted to scrape
<div class="gallery-img2">
<div class=""></div>
<a href="somelink">
<img src="MY TARGET FILE IS HERE" alt="" width="225" height="225" border="0" />
</a>
</div>
@gideondsouza
gideondsouza / HomeController.cs
Last active June 15, 2016 08:00
Example for this article;www.gideondsouza.com/blog/ajax-upload-files-with-asp.net-mvc-and-uploadify
public class HomeController : Controller
{
public ActionResult Index()
{
return View();
}
public ActionResult Upload()
{
var file = Request.Files["Filedata"];
string savePath = Server.MapPath(@"~\Content\" + file.FileName);
@gideondsouza
gideondsouza / Index.cshtml
Last active June 15, 2016 07:29
Example for this article:www.gideondsouza.com/blog/ajax-upload-files-with-asp.net-mvc-and-uploadify
@{
Layout = null;
}
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width" />
<title>::Uploadify Example::</title>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.7.2.min.js"></script>
<script type="text/javascript" src="@Url.Content("~/Scripts/jquery.uploadify-3.1.min.js")"></script>
@gideondsouza
gideondsouza / gitHublogin.pl
Last active December 10, 2015 08:28
#on the top
my $client_id = "YOUR CLIENT ID HERE";
my $client_secret = "YOUR SECRET ID HERE";
#route to login
get '/login' => sub {
#redirect the user to githubs login/authorize page
#we pass in a silly state (x12) ideally this should be generated
redirect "https://github.com/login/oauth/authorize?&client_id=$client_id&state=x12";
};