File: sqliteconv2.pl

package info (click to toggle)
phpbb3 3.0.7-PL1-4%2Bsqueeze1
  • links: PTS, VCS
  • area: main
  • in suites: squeeze
  • size: 58,756 kB
  • ctags: 28,744
  • sloc: php: 457,643; sql: 9,245; sh: 521; makefile: 59; perl: 32
file content (8 lines) | stat: -rwxr-xr-x 175 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
 
#!/usr/bin/perl
# converts extended SQL inserts to single statements
if (/^(INSERT.+?VALUES.*?)\(/) {
   $a=$1;
   s/\\'\''/'\'\''/g;
   s/\\n/\n/g;
   s/\),\(/\);\n$a\(/g;
}