I had a problem with PostgreSQL pgdump recently. My setval() calls were all set to '1'. I whipped up this quick script to fix things: #!/usr/bin/env python DB_NAME = 'my_db' from subprocess import Popen, PIPE import re exclude = [ 'tablename', 'rows' ] tp = re.compile( '[^a-z_]' ) ts = Popen( [ "/usr/bin/psql", DB_NAME, "-c SELECT tablename FROM pg_tables WHERE tablename NOT LIKE 'pg_%' AND tablename NOT LIKE 'sql_%' ORDER BY tablename" ], stdout=PIPE ).communicate()[ 0 ].split( ' ' ) tables = [] for t in ts: t = tp.sub( '', t ) if len( t ) == 0 or t in exclude: continue tables.append( t ) for t in tables: sql = "SELECT pg_catalog.setval( pg_get_serial_sequence( '%s', 'id' ), ( SELECT MAX( id ) FROM %s ) + 1 );" % ( t, t ) print Popen( [ "/usr/bin/psql", DB_NAME, "-c %s" % sql ], stdout=PIPE ).communicate()[ 0 ]

I thought someone else may need a complete working example, all in one chunk of code: <VirtualHost 127.0.0.1:80> ServerName mysite ErrorLog ${APACHE_LOG_DIR}/error.log CustomLog ${APACHE_LOG_DIR}/mysite.log combined ErrorDocument 404 / DocumentRoot /mysite Alias /robots.txt /mysite/static/robots.txt Alias /favicon.ico /mysite/static/img/favicon.ico Alias /static/ /mysite/static/ WSGIScriptAlias / /mysite/wsgi.py <Directory /mysite> <Files wsgi.py> Require all granted </Files> </Directory> <Directory /mysite/static> Require all granted </Directory> </VirtualHost>
I recently set out to learn more about git, the new content manager for source code. "New", as in much younger than Subversion, and a hell of a lot younger than CVS! No one I know personally uses git yet, but I see the Ruby on Rails community starting to use it a bit, so I decided I had better get up to speed. I didn't really need the full power of git. I just needed a simple setup, somewhere I could commit code over SSH. The initial steps for such a setup were not exactly simple to learn as a first-time git user. Hints were scattered across many different websites. So I'm documenting everything I've learned here in a blog entry, in case other git n00bs like myself might find it useful. First make a new git repo on your remote host: mkdir -p /git/foo cd /git/foo git init git should return something like: Initialized empty Git repository in .git/ Your /git/foo path will likely be different than mine, but it doesn't really matter where you put stuff. I already had an /svn directory wi

# basic .muttrc for use with Gmail # Change the following six lines to match your Gmail account details set imap_user = "username@gmail.com" set imap_pass = "" set smtp_url = "smtp://username@smtp.gmail.com:587/" set smtp_pass = "" set from = "username@gmail.com" set realname = "Firstname Lastname" # # # Change the following line to a different editor you prefer. set editor = 'vim + -c "set textwidth=72" -c "set wrap"'

If you're using a flavor of *nix that has an rc.local file, and then you start using Debian GNU/Linux, you might be wondering where your rc.local file is. Quite simply, it's not there. Here's how to add it. Create a new file named /etc/init.d/local like this: #!/bin/sh # put startup stuff here Make the file executable: chmod 755 /etc/init.d/local Add it to startup: update-rc.d local defaults 80 You should be seeing something like this: Adding system startup for /etc/init.d/local ... /etc/rc0.d/K80local -> ../init.d/local /etc/rc1.d/K80local -> ../init.d/local /etc/rc6.d/K80local -> ../init.d/local /etc/rc2.d/S80local -> ../init.d/local /etc/rc3.d/S80local -> ../init.d/local /etc/rc4.d/S80local -> ../init.d/local /etc/rc5.d/S80local -> ../init.d/local
Here's some command line magic to install lots of games on your Debian box: yes | \ for x in `apt-cache search game \ | sort \ | awk 'BEGIN { FS = " - " } { print $1 }'`; do \ apt-get install $x; \ done
   Recent articles
Web Blackjack in ReactJS
GUI Blackjack in C using the SDL2
How-to build latest Linux kernel from Linus' git repo on Debian
ignore latin1 problem via psql
Convert one m4a file to many mp3s
   Tags
apache (1) apple (1) bash (2) bashrc (1) blackjack (3) c (1) callproof (1) clang (1) console (1) data (1) debian (4) diff (1) django (2) enterprise (1) freebsd (1) games (1) git (3) github (2) gmail (1) go-lang (3) google (1) gourse (1) kernel (3) latin1 (1) linux (4) lottery (1) microsoft (1) module (1) mongodb (1) mp3s (1) mutt (1) patch (1) postgresql (2) powerball (1) psql (1) python (2) raspberrypi (1) reactjs (1) sdl (1) sed (1) stack (1) testing (2) trace (1) typescript (1) ubuntu (2) utf8 (1) virus (1)
   Twitter

Copyright © 2018 · GregDonald.com · All Rights Reserved