Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @GrabConfig( systemClassLoader=true )
- @Grab( 'mysql:mysql-connector-java:5.1.38' )
- import groovy.sql.Sql
- class GroovySqlExample1{
- static void main(String[] args) {
- def sql = Sql.newInstance("jdbc:mysql://domovm.local.domo.com:3306/", "user","pass", "com.mysql.jdbc.Driver")
- sql.eachRow("SHOW VARIABLES WHERE Variable_name LIKE 'character\\_set\\_%' OR Variable_name LIKE 'collation%';"){ row ->
- println row.variable_name + " " + row.value
- }
- sql.execute "INSERT domo_dev.buzz_search (message_id, content) VALUES (8, '🖐') ON DUPLICATE KEY UPDATE content='🖐';"
- sql.eachRow("SELECT content FROM domo_dev.buzz_search WHERE message_id=8;"){row->
- println row.content
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement