tag:blogger.com,1999:blog-7234216734688094130.post118274491486001297..comments2023-11-01T01:09:06.288-06:00Comments on Volatile Minds: Running SQL scripts in order from C# codeBrandon Perryhttp://www.blogger.com/profile/04227634714412263524noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-7234216734688094130.post-25328713156091186162009-06-09T04:53:31.138-06:002009-06-09T04:53:31.138-06:00Hey Brandon,
unfortunately my Python isn't as...Hey Brandon,<br /><br />unfortunately my Python isn't as good, so I whipped up a Ruby version. The MySQL connector isn't specifically great so I had to create a little helper method. Of course, one wouldn't want to use MySQL because of its lack of DDL transactions, anyway, but that's a different topic ;) So here you go (sorry, Blogger doesn't preserve indention):<br /><br /> require 'rubygems'<br /> require 'mysql'<br /> require 'pathname'<br /><br /> def mysql<br /> c = Mysql.connect('localhost', 'root')<br /> yield(c)<br /> c.close<br /> end<br /><br /> mysql do |c|<br /> c.query('DROP DATABASE IF EXISTS SystemsLogica')<br /> c.query('CREATE DATABASE SystemsLogica')<br /> c.select_db('SystemsLogica')<br /><br /> Pathname.glob('*.sql').sort.each do |sql|<br /> c.query(sql.read)<br /> end<br /> endDerGuteMoritzhttps://www.blogger.com/profile/08481846329831405311noreply@blogger.comtag:blogger.com,1999:blog-7234216734688094130.post-6352780731321584692009-06-02T10:49:33.705-06:002009-06-02T10:49:33.705-06:00Would you mind showing me an example of using Pyth...Would you mind showing me an example of using Python for this? It would be great to shorten this code, and I am sure the ideas behind doing it in Python can carry over.Brandon Perryhttps://www.blogger.com/profile/04227634714412263524noreply@blogger.comtag:blogger.com,1999:blog-7234216734688094130.post-48689317557951984632009-06-02T10:22:02.133-06:002009-06-02T10:22:02.133-06:00Wow, what verbose code for a simple task like that...Wow, what verbose code for a simple task like that ... Try rewriting that in Scheme, Python, Ruby or JavaScript even - you'll be surprised how simple it can be done.DerGuteMoritzhttps://www.blogger.com/profile/08481846329831405311noreply@blogger.com