I am trying to write a shell script that do whatever needs to be done between
sudo apt-get install postgresql python-psycopg
and
manage.py syncdb
for MySql, I use this to generate somehting I can pipe into the CLI:
print """
DROP DATABASE IF EXISTS %(db)s;
CREATE DATABASE %(db)s;
GRANT ALL
ON %(db)s.*
TO %(user)s
IDENTIFIED BY '%(pw)s'
with grant option;
""" % {
'db':settings.DATABASE_NAME,
'user':settings.DATABASE_USER,
'pw':settings.DATABASE_PASSWORD }
pipe that into the MySql CLI.
I can't figure out how to do it with psql without it prompting me for input.
I don't need it that fancy, just a script with everything hard coded would be
fine.
Carl K
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
