-
Sometimes I need to build a small script to delete a huge set of tables of a schema.
In Oracle is easy to do it, using the meta tables "all_tables", "all_views", and "all_sequences":
select 'drop table ' || table_name || ' cascade constraints;'
from all_tables where owner='protoss' and table_name not like 'BIN%';
select 'drop view ' || view_name || ' ;'
from all_views where owner='zerg' ;
select 'drop sequence ' || sequence_name || ' ;'
from all_sequences where sequence_owner='spacemarine' ;The "BIN%" table are special temp tables of oracle.
Read More -
Use the sed -i command
sed -i.BAK 's|foo|bar|g' files # -i does in-place replacement perl -pi.bak -e 's|foo|bar|g' files # or perl -pi.bak -e 's|foo|bar|g' `find /pathname -name "filespec"`
Perl is the preferred way, but on some production system you must use the old good sed. For some tips on sed take a look to its faq. Another very powerful command is xargs. Xargs is a rapid way to process files containing spaces, using a combo with find:
Read More -
Hi dear spammers, I am an announce.
I love you so much I have decided to auto delete spam comments not already published.
As you know, dear spammers, the anti spam on this site (called Blue Dragon) is able to shutup your nasty posts.
Now blue dragon can also delete them from our big database, because it is so easy to isolate spam from true comments.
I will not keep a record of this spam, sorry
Read More -
I am very happy to publish a first look of my trip to Ravenna and Ferrara.
I went there with two friends (Andrea and Paola) in April.
We enjoy a lot the trip (we also took a bike at Ferrara).
Ferrara is bigger then Ravenna and need about two days to see all the things.
Read More -
Hi dear spammers!
I have just finished tuning the latest version of my anti spam-blogging-software, and all the spam have been removed. I am glad to see you loosing your time tring to get some poor bucks from your bogous activity. I hope do you click on my google adverties sometimes, as true friends of mine?
Read More -
Is it amazing things you can do with a simple Bourne Again Shell (bash).
I have just discovered you can open socket using a small redirection syntax, and emulate small checks you normally do with curl or wget.
The bash shell manual is always poor about examples, and this is very very sad.
Read More -
1public static final String convertToString(HttpServletRequest request) { 2 StringBuffer msg = new StringBuffer(); 3 try { 4 5 msg.append("*RequestURI:" + request.getRequestURI() + "\n"); 6 msg.append("*ContentType:" + request.getContentType() + "\n"); 7 8 msg.append("== Request Header\n"); 9 Enumeration headers = request.getHeaderNames(); 10 while (headers.hasMoreElements()) { 11 String headerName = "" + headers.nextElement(); 12 msg.append(headerName + ":" + request.getHeader(headerName) + "\n"); 13 } 14 msg.append("\n"); 15 16 Enumeration attr = request.getParameterNames(); 17 18 ArrayList l = new ArrayList(); 19 String att; 20 while (attr.hasMoreElements()) { 21 att = (String) attr.nextElement(); 22 l.add(att + " -> " + request.getParameter(att)); 23 } 24 25 msg.append("=== Request ( " + l.size() + " ) ===\n"); 26 Object a[] = l.toArray(); 27 Arrays.sort(a); 28 for (int i = 0; i < a.length; i++) { 29 msg.append((String) a[i]); 30 msg.append("\n"); 31 } 32 msg.append("=== === ===\n"); 33 34 // Process the Session 35 HttpSession session = request.getSession(); 36 // msg.append("\n"); 37 38 Enumeration e = session.getAttributeNames(); 39 40 TreeMap t = new TreeMap(); 41 String k; 42 while (e.hasMoreElements()) { 43 k = (String) e.nextElement(); 44 Object oggetto; 45 try { 46 oggetto = session.getAttribute(k); 47 } catch (Throwable notSerializableException) { 48 oggetto = "NON DESERIALIZZABILE. Chiave:" + k; 49 50 } 51 t.put(k, oggetto); 52 } 53 54 Object orderedKeys[] = t.keySet().toArray(); 55 msg.append("=== Session ( " + orderedKeys.length + " " + (usertempz != null ? "+ 1UT" : " NO UT!") + " )===\n"); 56 Object elem; 57 58 for (int i = 0; i < orderedKeys.length; i++) { 59 elem = t.get(orderedKeys[i]); 60 msg.append(orderedKeys[i]); 61 62 msg.append("\t-> "); 63 if (elem != null) { 64 nicePrintSessionObj(msg, elem); 65 } else { 66 msg.append("null"); 67 } 68 msg.append("\n"); 69 } 70 return msg.toString(); 71 } catch (RuntimeException e) { 72 return msg + "\nERR: Cannot print session/request!!" + e.getMessage(); 73 } 74 } -
My first webcam video....
See and have fun: http://www.youtube.com/watch?v=53CIgqpD0S8The Story
I have just bought a new fantastic Mac computer. So I tried my webcam, and in the same evening a friend of mine give me a cigarette (I don't smoke so I tried it in front of my webcam).
Read More -
(First published on 2007-01-20)
Hi all, ObjectsRoot now has correct story ordering ontags view!
I am happy to announce I have just installed tinymce on my site.
TinyMCE is a very nice javascript editor, also used in Drupal. What makes tinymce very nice in my humble own opinion, is its easy installation. You do not need complex init procedure: you just tell tiny you want to edit well textareas, and it will do all for you. Because django (my web framework for the site) has a bit complex way for handling administration pages, this is good news for objectsroot.com.
Read More -
Hi blog readers! Your trip master has just come back from a win trip done in the swap of the year. We have been in Modena in December and in Padova, this month. We have done one-day-trips, fast and furious as usual. I have done about 6 photos to Modena. I liked a bit more Padova, which needs at least two days to be seen. Padova has a lot of beautiful and nice churches to see. Consider only the Scrovengi’s Chapel, very well known.
Read More -
I think ajax is a very new technology, but with too much hype on it. I think we’d try to do simple things with it, avoiding too much bloated interfaces.
I have found a good ibm article with shows “In-place editing” avery easy way to get a more responsible site. Finally the same article points to Prototype window, a very easy to use windowing system.
Happy hacking!
Read More -
I am very proud to present an Italian comedy called Vampata D'amore (Love's Flush) written by my cusin, Alessandro Bonvini.
It is a "beautiful-like" comedy, very nice done indeed.
This is the part 1 and here you can find the rest of the storyLeave your comments below!
-
I have surfed today and I have found two sites worth to see: <a href=“http://www.rocketboom.com/"
RocketBoom is a nice video blog and <a href=“http://www.googlewhack.com/" GoogleWhack is a Google-game related site.
-
The trends of this october are about some upcoming products. A clear analisys of QuarkXPress failure is sketched in roughlydrafted site. I do not think the same consideration can be applied to Vista.
As Joel said, M$ can throw away much money before only starting to see its market reduced.
Read More
