Generatore nomi casuale in MySql

It often happens to prepare demo for customers with a fully populated database. The preparation of vanilla db frequently start from an old production archive where you must change first and last names of real customers. These sql procedures help us to solve the problem. Random generation of italian first names:

1
2
3
4
DROP FUNCTION IF EXISTS generate_fst_name_it;
DELIMITER $$ CREATE FUNCTION generate_fst_name_it ()
RETURNS VARCHAR(255) BEGIN RETURN ELT(FLOOR(1 + (RAND() * (100-1))), "FRANCESCO","ALESSANDRO","ANDREA","LORENZO","MATTEO","GABRIELE","MATTIA","LEONARDO","DAVIDE","RICCARDO","FEDERICO","LUCA","GIUSEPPE","MARCO","TOMMASO","ANTONIO","SIMONE","SAMUELE","GIOVANNI","PIETRO","CHRISTIAN","ALESSIO","EDOARDO","DIEGO","FILIPPO","EMANUELE","DANIELE","MICHELE","CRISTIAN","SOFIA","GIULIA","MARTINA","GIORGIA","SARA","EMMA","DEBORA","AURORA","CHIARA","ALICE","ALESSIA","GAIA","ANNA","FRANCESCA","NOEMI","VIOLA","GRETA","ELISA","MATILDE","GIADA","ELENA","GINEVRA","BEATRICE","VITTORIA","NICOLE","ARIANNA","MARTA","ANGELICA","ASIA","LUDOVICA","GIULIO","MARIO","FABIO","ROBERTA","ROBERTO","STEFANO","GIORGIO","PINO","SONIA","MARINA","MARIA","MARA","INES","CARLO","FEDERICA","PAOLA","PAOLO","LUCIA","LUCIO","ELEONORA","NICOLA","ATTILIO","BARBARA","DANIELA","PATRIZIO","PATRIZIA", "PIERO","PIERA","ANTONIO","SABRINA","LARA","SERENA","LUIGI","GAETANO","ARGENTINO","LORENA","GIULIANO","BRUNO","BRUNA","AZZURRA","FELICE");
END$$ DELIMITER ;

Random generation of italian last names:

1
2
3
DROP FUNCTION IF EXISTS generate_lst_name_it;
DELIMITER $$ CREATE FUNCTION generate_lst_name_it () RETURNS VARCHAR(255) BEGIN RETURN ELT(FLOOR(1 + (RAND() * (100-1))), "ROSSI","RUSSO","FERRARI","ESPOSITO","BIANCHI","ROMANO","COLOMBO","RICCI","MARINO","GRECO","BRUNO","GALLO","CONTI","DE LUCA","MANCINI","COSTA","GIORDANO","RIZZO","LOMBARDI","MORETTI","BARBIERI","FONTANA","SANTORO","MARIANI","RINALDI","CARUSO","FERRARA","GALLI","MARTINI","LEONE","LONGO","GENTILE","MARTINELLI","VITALE","LOMBARDO","SERRA","COPPOLA","DE SANTIS","ISERNIA","MARCHETTI","PARISI","VILLA","CONTE","FERRARO","FERRI","FABBRI","BIANCO","MARINI","GRASSO","VALENTINI","MESSINA","SALA","DE ANGELIS","GATTI","PELLEGRINI","PALUMBO","SANNA","FARINA","RIZZI","MONTI","CATTANEO","MORELLI","AMATO","SILVESTRI","MAZZA","TESTA","GRASSI","PELLEGRINO","CARBONE","GIULIANI","BENEDETTI","BARONE","ROSSETTI","CAPUTO","MONTANARI","GUERRA","PALMIERI","BERNARDI","MARTINO","FIORE","DE ROSA","FERRETTI","BELLINI","BASILE","RIVA","DONATI","PIRAS","VITALI","BATTAGLIA","SARTORI","NERI","COSTANTINI","MILANI","PAGANO","RUGGIERO","SORRENTINO","TOTTI","ORLANDO","PLAPPLA","NEGRI");
END$$ DELIMITER ;

Random generation of english first names:

1
2
3
4
5
DROP FUNCTION IF EXISTS generate_fst_name_en;
DELIMITER $$
CREATE FUNCTION generate_fst_name_en ()
RETURNS VARCHAR(255) BEGIN RETURN ELT(FLOOR(1 + (RAND() * (100-1))), "SOPHIA","ISABELLA","EMMA","OLIVIA","AVA","EMILY","ABIGAIL","MADISON","MIA","CHLOE","ELIZABETH","ELLA","ADDISON","NATALIE","LILY","GRACE","SAMANTHA","AVERY","SOFIA","AUBREY","BROOKLYN","LILLIAN","VICTORIA","EVELYN","HANNAH","ALEXIS","CHARLOTTE","ZOEY","LEAH","AMELIA","ZOE","HAILEY","LAYLA","GABRIELLA","NEVAEH","KAYLEE","ALYSSA","ANNA","SARAH","ALLISON","SAVANNAH","ASHLEY","AUDREY","TAYLOR","BRIANNA","AALIYAH","RILEY","CAMILA","KHLOE","CLAIRE","SOPHIE","ARIANNA","JACOB","MASON","WILLIAM","JAYDEN","NOAH","MICHAEL","ETHAN","ALEXANDER","AIDEN","DANIEL","ANTHONY","MATTHEW","ELIJAH","JOSHUA","LIAM","ANDREW","JAMES","DAVID","BENJAMIN","LOGAN","CHRISTOPHER","JOSEPH","JACKSON","GABRIEL","RYAN","SAMUEL","JOHN","NATHAN","LUCAS","CHRISTIAN","JONATHAN","CALEB","DYLAN","LANDON","ISAAC","GAVIN","BRAYDEN","TYLER","LUKE","EVAN","CARTER","NICHOLAS","ISAIAH","OWEN","JACK","JORDAN","BRANDON","WYATT");
END$$ DELIMITER ;

Random generation of english last names:

1
2
3
4
DROP FUNCTION IF EXISTS generate_lst_name_en;
DELIMITER $$ CREATE FUNCTION generate_lst_name_en ()
RETURNS VARCHAR(255) BEGIN RETURN ELT(FLOOR(1 + (RAND() * (100-1))), "SMITH","JOHNSON","WILLIAMS","JONES","BROWN","DAVIS","MILLER","WILSON","MOORE","TAYLOR","ANDERSON","THOMAS","JACKSON","WHITE","HARRIS","MARTIN","THOMPSON","GARCIA","MARTINEZ","ROBINSON","CLARK","RODRIGUEZ","LEWIS","LEE","WALKER","HALL","ALLEN","YOUNG","HERNANDEZ","KING","WRIGHT","LOPEZ","HILL","SCOTT","GREEN","ADAMS","BAKER","GONZALEZ","NELSON","CARTER","MITCHELL","PEREZ","ROBERTS","TURNER","PHILLIPS","CAMPBELL","PARKER","EVANS","EDWARDS","COLLINS","STEWART","SANCHEZ","MORRIS","ROGERS","REED","COOK","MORGAN","BELL","MURPHY","BAILEY","RIVERA","COOPER","RICHARDSON","COX","HOWARD","WARD","TORRES","PETERSON","GRAY","RAMIREZ","JAMES","WATSON","BROOKS","KELLY","SANDERS","PRICE","BENNETT","WOOD","BARNES","ROSS","HENDERSON","COLEMAN","JENKINS","PERRY","POWELL","LONG","PATTERSON","HUGHES","FLORES","WASHINGTON","BUTLER","SIMMONS","FOSTER","GONZALES","BRYANT","ALEXANDER","RUSSELL","GRIFFIN","DIAZ","HAYES");
END$$ DELIMITER ;

test

1
2
SELECT generate_fst_name_it() AS FirstName, generate_lst_name_it() AS LastName;
SELECT generate_fst_name_en() AS FirstName, generate_lst_name_en() AS LastName;

Enjoy!

Continue Reading
Continue Reading

Gnome 3 su Ubuntu 11.10

New version of Ubuntu 11.10, Oneiric Ocelot, avalaible on line. I still have to test it, but what I had to do was immediately enable the gnome desktop.
I don’t know why once again gnome is not in the initial repository, I can’t understand how you can use Unity¬† ….. Let’s see how is possible to install Gnome in few steps.

We begin as usual to update the repositories:

sudo apt-get update
sudo apt-get upgrade

o se ancora non avete fatto l’avanzamento alla nuova versione

sudo apt-get -f dist-upgrade

and now the gnome packet

sudo apt-get install gnome-shell

Once the installation is finished you don’t must reboot Ubuntu, just restart the session. At this point in the login box,in the boot options you’ll also be able to choose the Gnome shell.

 

 

Continue Reading
Continue Reading