Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var ipAddress = '0.0.0.0';
- var userName = 'username';
- var userPassword = 'userpwd';
- var dbName = 'dbname';
- var tableName = "default_table";
- var dbUrl = 'jdbc:mysql://' + ipAddress + '/' + dbName;
- function test(){
- //needs proper database info still
- var range = SpreadsheetApp.getActiveSheet().getRange(1, 1);
- var e = {range:range};
- onEdit(e);
- }
- function onEdit(e){
- var range = e.range;
- var row = range.getRow();
- var col = range.getColumn();
- var activeSheet = SpreadsheetApp.getActiveSheet();
- var sheetName = activeSheet.getName();
- var columnName = activeSheet.getRange(1, col).getValue();
- var updatedValue = activeSheet.getRange(row, col).getValue();
- var tableName = getTableName(sheetName);
- updateRecord(tableName, columnName, row, updatedValue);
- }
- function getTableName(sheetName) {
- return tableName;
- }
- function updateRecord(tableName, columnName, row, updatedValue){
- var conn = Jdbc.getConnection(dbUrl, userName, userPassword);
- var stmt = conn.prepareStatement("UPDATE (tableName) " +
- "SET (columnName)=(updatedValue) " +
- "WHERE index=(row)");
- stmt.setString(1, tableName);
- stmt.setString(2, columnName);
- stmt.setString(3, updatedValue);
- stmt.setString(4, row);
- stmt.execute();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement