Connecting Active Record to a Legacy Database with Stored Procedures

Mon Nov 26 19:34:30 -0800 2007

Sometimes you just have to go ahead and do it the hard way.

The last three days was that time for me. I had to write an application that interfaced with an existing MS SQLServer system, and I couldn’t change the schema of any existing table… what to do? Well… I can tell you it was a lesson in the difference between being opinionated software and bigoted software…

I first sat down and looked at the existing schema with it’s lack of documentation it was interesting finding the relationships between the tables and records.

It is a respectable size database with a bunch of tables and hundreds of stored procedures for most anything you needed to do.

Luckily, while ActiveRecord is opinionated about the way it should do things, it is not a Bigot, and with it’s parent Rails, we were able to massage this app into existence.

First step was identifying what it was I actually needed to do and isolating the tables involved, ensuring I wasn’t stepping on any other toes around this quite populated database.

Then, looking through the existing tables and records finding relationships and drawing them out on paper so I could see in 2 dimensions what the original author of the DB meant.

Then, as I had to develop on a Windows box for this, I grabbed a copy of e (nothing compared to Textmate) and populated my temporary Windows system with the One Click Ruby installed, Rails, the Win32 Gem library and some others I like (RSpec et al). Also had to install Cygwin for e to run specs properly.

Next step? Installing a local copy of SQL server and pulling down a copy of the DB to work on.

OK… I was all set.

Now in the editor, I first created a bunch of models, one for each table I had to model in my App. As NONE of these tables were puralized, and NONE of them followed the Rails convention of primary_key being an auto incrementing integer column called :id, I made very good use of the two override methods which override the primary_key value as well as the table_name value, basically making ActiveRecord ignore the convention of a pluralized underscorized classname for the table and id as the primary key.

1
2
3
4
5
6

class MyClassName < ActiveRecord::Base

  set_primary_key => "my_table_primary_id"
  set_table_name  => "new_table_name"

end

There was one of these in EVERY model.

Now, the down side of using the above is that Rails no longer will automagically maintain the :id column, which means you have to set it.

So instead of:



MyTableName.create(:name => "Bob", :age => "10")

You now have to do:



MyTableName.create(:my_table_primary_id => 1, :name => "Bob", :age => "10")

Note, it wants the primary key column set explicitly by name.

OK, so now I had my models in place, I started putting relationships in.

The one to many relationships were easy enough, by using the foreign_key param.



has_many :other_records, :foreign_key => my_special_foreign_key

But it was the has_many through that started causing problems. Here I resorted to using SQL on the exisitng stored procedures to fight my way through the code and get the products I needed.

Additionally, the way you got a unique primary_key_id was a stored procedure. SO that meant running stored procedures in the code.

This stored procedure accepted the table name you wanted a new primary key for as well as an SQL variable to dump the result into. So you had to call it in SQL like this:



exec get_id "my_table_name", @id output

Just running an ActiveRecord.connection.execute(the_aboe_sql_code) did not produce the result of the next ID, because SQL Server would complain that @id didn’t exist (and rightly so, I didn’t declare it…), so instead I had to do something like this:

1
2
3
4
5

sql_query = "set nocount on;\n" +
"declare @id integer;\n" +
"exec get_primary_key 'my_table_name', @id output;\n" +
"select @id;"
result = ActiveRecord.connection.select_value(sql_query)

This then dumped the id into the result variable which we could then whack into the create method. What the “set nocount on” does is tells SQLServer to suppress the output of “1 rows affected” after the execution of the stored procedure.

Leaving that inside the create method was a bit scary, so I moved it into a class method like so:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

class MyClassName < ActiveRecord::Base

  set_primary_key => "my_table_primary_id"
  set_table_name  => "new_table_name"
  
  class << self
  
    def get_next_id
      sql_query = "set nocount on;\n" +
      "declare @id integer;\n" +
      "exec get_id 'my_table_name', @id output;\n" +
      "select @id;"

      ActiveRecord.connection.select_value(sql_query)
    end
    
  end

end

Now I can call MyClassName.get_next_id to get the next unique primary key for the table. This is a bit neater, but not really a solution. What would be cool is being able to set inside a model an override method which tells the class how to get the next primary key. But that is a subject for another post.

blogLater

Mikel

  1. Raictsefsef Says:
    Thu Feb 25 03:32:58 -0800 2010

    MEGAMAN HENTAI
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719963]MEGAMAN HENTAI[/url]
    MEGAMAN HENTAI
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719963 ] MEGAMAN HENTAI [/url]
    FREE PORN PREVIEWS
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719964]FREE PORN PREVIEWS[/url]
    FREE PORN PREVIEWS
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719964 ] FREE PORN PREVIEWS [/url]
    PAULA ABDUL NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719966]PAULA ABDUL NUDE[/url]
    PAULA ABDUL NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719966 ] PAULA ABDUL NUDE [/url]
    FREE WEBCAM SHOWS
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719968]FREE WEBCAM SHOWS[/url]
    FREE WEBCAM SHOWS
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719968 ] FREE WEBCAM SHOWS [/url]
    CRAZY COLLEGE GIRLS
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719969]CRAZY COLLEGE GIRLS[/url]
    CRAZY COLLEGE GIRLS
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719969 ] CRAZY COLLEGE GIRLS [/url]

  2. Nagococky Says:
    Fri Feb 26 02:29:48 -0800 2010

    JAPANESE NUDES
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719971]JAPANESE NUDES[/url]
    JAPANESE NUDES
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719971 ] JAPANESE NUDES [/url]
    FLAT TITS
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719973]FLAT TITS[/url]
    FLAT TITS
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719973 ] FLAT TITS [/url]
    TEEN SUPERMODELS
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719974]TEEN SUPERMODELS[/url]
    TEEN SUPERMODELS
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719974 ] TEEN SUPERMODELS [/url]
    MISS NUDE WORLD
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719975]MISS NUDE WORLD[/url]
    MISS NUDE WORLD
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719975 ] MISS NUDE WORLD [/url]
    AUDIO SEX STORIES
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719976]AUDIO SEX STORIES[/url]
    AUDIO SEX STORIES
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719976 ] AUDIO SEX STORIES [/url]

  3. annodiaAspinc Says:
    Fri Feb 26 11:45:11 -0800 2010

    SEAN KINGSTON BEAUTIFUL GIRL
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719994]SEAN KINGSTON BEAUTIFUL GIRL[/url]
    SEAN KINGSTON BEAUTIFUL GIRL
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719994 ] SEAN KINGSTON BEAUTIFUL GIRL [/url]
    POKEMON YAOI
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719997]POKEMON YAOI[/url]
    POKEMON YAOI
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719997 ] POKEMON YAOI [/url]
    VINTAGE MYSPACE LAYOUTS
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719999]VINTAGE MYSPACE LAYOUTS[/url]
    VINTAGE MYSPACE LAYOUTS
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1719999 ] VINTAGE MYSPACE LAYOUTS [/url]
    BLUE TEENS
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720000]BLUE TEENS[/url]
    BLUE TEENS
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720000 ] BLUE TEENS [/url]
    EROTIC LESBIAN STORIES
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720001]EROTIC LESBIAN STORIES[/url]
    EROTIC LESBIAN STORIES
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720001 ] EROTIC LESBIAN STORIES [/url]

  4. emetheali Says:
    Fri Feb 26 16:16:34 -0800 2010

    FREE BONDAGE VIDEO
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720003]FREE BONDAGE VIDEO[/url]
    FREE BONDAGE VIDEO
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720003 ] FREE BONDAGE VIDEO [/url]
    FREE ADULT DOWNLOAD VIDEO
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720005]FREE ADULT DOWNLOAD VIDEO[/url]
    FREE ADULT DOWNLOAD VIDEO
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720005 ] FREE ADULT DOWNLOAD VIDEO [/url]
    JETSONS PORN
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720007]JETSONS PORN[/url]
    JETSONS PORN
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720007 ] JETSONS PORN [/url]
    DIGITAL DREAM GIRLS
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720008]DIGITAL DREAM GIRLS[/url]
    DIGITAL DREAM GIRLS
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720008 ] DIGITAL DREAM GIRLS [/url]
    NAKED HAIRY MEN
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720010]NAKED HAIRY MEN[/url]
    NAKED HAIRY MEN
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720010 ] NAKED HAIRY MEN [/url]

  5. SadsUnadere Says:
    Mon Mar 01 04:54:20 -0800 2010

    SARAH LARSON NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720120]SARAH LARSON NUDE[/url]
    SARAH LARSON NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720120 ] SARAH LARSON NUDE [/url]
    MELANIA KNAUSS NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720121]MELANIA KNAUSS NUDE[/url]
    MELANIA KNAUSS NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720121 ] MELANIA KNAUSS NUDE [/url]
    DAVEIGH CHASE NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720122]DAVEIGH CHASE NUDE[/url]
    DAVEIGH CHASE NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720122 ] DAVEIGH CHASE NUDE [/url]
    ANGELA LINDVALL NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720124]ANGELA LINDVALL NUDE[/url]
    ANGELA LINDVALL NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720124 ] ANGELA LINDVALL NUDE [/url]
    PAGET BREWSTER NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720125]PAGET BREWSTER NUDE[/url]
    PAGET BREWSTER NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720125 ] PAGET BREWSTER NUDE [/url]

  6. encoggebpagop Says:
    Mon Mar 01 10:54:52 -0800 2010

    REBECCA GAYHEART NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720127]REBECCA GAYHEART NUDE[/url]
    REBECCA GAYHEART NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720127 ] REBECCA GAYHEART NUDE [/url]
    ADRIANNE PALICKI NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720128]ADRIANNE PALICKI NUDE[/url]
    ADRIANNE PALICKI NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720128 ] ADRIANNE PALICKI NUDE [/url]
    MORENA BACCARIN NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720129]MORENA BACCARIN NUDE[/url]
    MORENA BACCARIN NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720129 ] MORENA BACCARIN NUDE [/url]
    MARLA MAPLES NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720130]MARLA MAPLES NUDE[/url]
    MARLA MAPLES NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720130 ] MARLA MAPLES NUDE [/url]
    NICOLE NARAIN NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720132]NICOLE NARAIN NUDE[/url]
    NICOLE NARAIN NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720132 ] NICOLE NARAIN NUDE [/url]

  7. agreebmaw Says:
    Mon Mar 01 18:17:06 -0800 2010

    LARA FLYNN BOYLE NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720134]LARA FLYNN BOYLE NUDE[/url]
    LARA FLYNN BOYLE NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720134 ] LARA FLYNN BOYLE NUDE [/url]
    NATALIE IMBRUGLIA NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720136]NATALIE IMBRUGLIA NUDE[/url]
    NATALIE IMBRUGLIA NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720136 ] NATALIE IMBRUGLIA NUDE [/url]
    STEPHANIE SEYMOUR NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720137]STEPHANIE SEYMOUR NUDE[/url]
    STEPHANIE SEYMOUR NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720137 ] STEPHANIE SEYMOUR NUDE [/url]
    HELENA CHRISTENSEN NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720139]HELENA CHRISTENSEN NUDE[/url]
    HELENA CHRISTENSEN NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720139 ] HELENA CHRISTENSEN NUDE [/url]
    BIJOU PHILLIPS NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720142]BIJOU PHILLIPS NUDE[/url]
    BIJOU PHILLIPS NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720142 ] BIJOU PHILLIPS NUDE [/url]

  8. StaittyGoorry Says:
    Mon Mar 01 23:39:06 -0800 2010

    MACKENZIE ROSMAN NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720143]MACKENZIE ROSMAN NUDE[/url]
    MACKENZIE ROSMAN NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720143 ] MACKENZIE ROSMAN NUDE [/url]
    TONI BRAXTON NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720144]TONI BRAXTON NUDE[/url]
    TONI BRAXTON NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720144 ] TONI BRAXTON NUDE [/url]
    ZOE KRAVITZ NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720145]ZOE KRAVITZ NUDE[/url]
    ZOE KRAVITZ NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720145 ] ZOE KRAVITZ NUDE [/url]
    GINA GERSHON NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720146]GINA GERSHON NUDE[/url]
    GINA GERSHON NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720146 ] GINA GERSHON NUDE [/url]
    ABBIE CORNISH NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720149]ABBIE CORNISH NUDE[/url]
    ABBIE CORNISH NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720149 ] ABBIE CORNISH NUDE [/url]

  9. elizillerge Says:
    Wed Mar 03 04:34:04 -0800 2010

    JOSIE MARAN NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720172]JOSIE MARAN NUDE[/url]
    JOSIE MARAN NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720172 ] JOSIE MARAN NUDE [/url]
    LYDIA HEARST NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720173]LYDIA HEARST NUDE[/url]
    LYDIA HEARST NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720173 ] LYDIA HEARST NUDE [/url]
    ALANIS MORISSETTE NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720174]ALANIS MORISSETTE NUDE[/url]
    ALANIS MORISSETTE NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720174 ] ALANIS MORISSETTE NUDE [/url]
    NEVE CAMPBELL NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720176]NEVE CAMPBELL NUDE[/url]
    NEVE CAMPBELL NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720176 ] NEVE CAMPBELL NUDE [/url]
    PATSY KENSIT NUDE
    [url=http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720177]PATSY KENSIT NUDE[/url]
    PATSY KENSIT NUDE
    [url= http://www.vidilife.com/index.cfm?f=profile.main&intUserAccountID=1720177 ] PATSY KENSIT NUDE [/url]

  10. ideowhene Says:
    Thu Apr 15 19:55:56 -0700 2010

    Hello! present
    BARNEY PORN
    [url=http://www.grannydoesporn.com/?acc=85530987&rev=no][img]http://doras.us/player.gif[/img][/url]
    [url=http://japan.doras.us/][img]http://pics.hqtube.com/gallery/naughty_little_nymphs_5_sc1_1.jpg[/img][/url] [url=http://justmouthfuls.doras.us/][img]http://pics.hqtube.com/gallery/white_panty_chronicles_19_sc1_3.jpg[/img][/url] [url=http://freegranny.doras.us/][img]http://pics.hqtube.com/gallery/anal_xplosion_sc5_2.jpg[/img][/url]
    [url=http://herroundbrownass.doras.us/][img]http://pics.hqtube.com/gallery/my_thick_black_ass_5_sc4_1.jpg[/img][/url] [url=http://herfirsttryout.doras.us/][img]http://pics.hqtube.com/gallery/kelly_the_coed_17_sc1_1.jpg[/img][/url] [url=http://freegranny.doras.us/][img]http://pics.hqtube.com/gallery/autumn_haze_vs_son_of_dong_sc4_1.jpg[/img][/url]
    xxx free granny porn
    minigirlz biz porn
    free porn amuse pornstars
    porn photopost
    porn star hailey paige dead
    tube viedos porn
    porn thumbs movies
    homemade hidden wife porn videos
    nake porn
    indian porn teasers
    itlian porn
    dryhumping soft core porn
    state tropper porn star
    carmine elektra porn
    absouletly free sexy porn vids
    animol porn
    free betty boop nude porn cartoons
    porn with big dildos
    seven dwarfs porn film
    adult porn thumbnail
    [url=http://www.allanimemovies.com/?acc=85530987&rev=no]lesbian hentia porn [/url]
    [url=http://www.japan18movies.com/?acc=85530987&rev=no]relationships destroyed by porn [/url]
    [url=http://www.cheatingwithlatinamaids.com/?acc=85530987&rev=no]earthy gay porn [/url]
    [url=http://www.dvdunlimited.com/?acc=85530987&rev=no]o g porn [/url]
    [url=http://www.bigfatbeauties.com/?acc=85530987&rev=no]twink porn paysite review [/url]
    [url=http://gays.doras.us/]downtown san francisco gay moviehouse [/url]
    [url=http://www.toobigforthatpussy.com/?acc=85530987&rev=no]3gp mobile porn [/url]
    [url=http://www.naughtyfootmodels.com/?acc=85530987&rev=no]stream vids porn [/url]
    [url=http://www.herassgotfucked.com/?acc=85530987&rev=no]kim basinger porn [/url]
    [url=http://www.insanecockgays.com/?acc=85530987&rev=no]celebraty porn [/url]
    [url=http://topadult.doras.us/]margo porn star [/url]
    [url=http://www.naughtylesbiangirlfriends.com/?acc=85530987&rev=no]free porn top rated [/url]
    [url=http://www.naughtyclubbers.com/?acc=85530987&rev=no]bi sexual three somes porn [/url]
    [url=http://www.extremesquirts.com/?acc=85530987&rev=no]free videos of gay latino porn [/url]
    [url=http://www.theygobothways.com/?acc=85530987&rev=no]free daily porn in email [/url]
    [url=http://lesbiangirl.doras.us/]lesbian orgie [/url]
    [url=http://www.hugefuckabletits.com/?acc=85530987&rev=no]u porn serch [/url]
    [url=http://theygobothways.doras.us/]does she like me bisexual [/url]
    [url=http://www.insanebondage.com/?acc=85530987&rev=no]free hentai porn online [/url]
    [url=http://www.hqtube.com/?5736000000/]cartoon porn stories [/url]
    [url=http://wonder.whydoesgascostsomuch.com/php/phpBB2/viewtopic.php?p=16449#16449]shemale porn stars [/url]
    [url=http://wbcyouth.co.uk/content/viewtopic.php?p=92661#92661]raw porn [/url]
    [url=http://www.stickypond.com/tiazac/viewtopic.php?p=511#511]x-ray porn [/url]
    [url=http://www.photharam-food.net/modules.php?name=Forums&file=viewtopic&p=165379#165379]porn screensaver [/url]
    [url=http://www.richwoodasset.com/phpbb/viewtopic.php?p=13151#13151]porn picture galleries [/url]
    [url=http://ourhohenwald.com/phpbb/viewtopic.php?p=106248#106248]free porn thumb [/url]
    [url=http://wnl.cs.nctu.edu.tw/phpBB3/viewtopic.php?f=4&t=15374&p=34297#p34297]dan’s vidoe porn [/url]
    [url=http://www.talesfromthepit.net/phpbb/viewtopic.php?f=3&t=343030&p=546966#p546966]porn video games [/url]
    [url=http://kuacja.org/modules.php?name=Forums&file=viewtopic&p=65244#65244]shakira porn [/url]
    [url=http://www.soldatfan.laa.pl/viewtopic.php?p=13829#13829]porn kolt [/url]
    [url=http://www.mythicway.com/phpBB/viewtopic.php?p=224129#224129]ebony porn gallery [/url]
    [url=http://forum.ogun.eu/viewtopic.php?p=49133#49133]ninja midget porn midgets porn [/url]
    [url=http://www.planetskizz.com/index.php?showtopic=295041&st=0&gopid=477203&#entry477203]underwater porn [/url]
    [url=http://noraaunor.com/modules.php?name=Forums&file=viewtopic&p=1005904#1005904]free hentai porn clips [/url]
    [url=http://www.matadorespr.net/foro/index.php?showtopic=18395&st=0&gopid=29863&#entry29863]vanity porn star [/url]
    [url=http://www.hqtube.com/?5736000000/]HQTUBE – World of FREE streaming porn![/url]

Leave a Reply