detaybey detaybey
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
detaybey
/ LFOutlinedLabel.swift
Created
November 11, 2016 14:15
SKLabelNode with outerline for Swift 3
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // | |
| // LFShadowLabel.swift | |
| // | |
| // Created by Umut Çelenli on 10/11/2016. | |
| // Copyright © 2016 PanelBir. All rights reserved. | |
| // | |
| import Foundation | |
| import SpriteKit |
detaybey
/ PgQuoteRemover
Last active
November 18, 2022 22:06
Removes double quotes from Table and Column names on a PostgreSQL server using Dapper
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /// <summary> | |
| /// Removes double quotes from Table and Column names. | |
| /// By default PgAdmin and other schema generators create names with "Quotes" which is an inconvenience while writing queries. | |
| /// This function scans the db and removes quotes from table and column names. | |
| /// </summary> | |
| public void RemoveDoubleQuotesFromTableAndColumns() | |
| { | |
| // get all the table list | |
| var tables = db.Query<string>("SELECT table_name FROM information_schema.tables WHERE table_schema='public'").ToList(); | |
| foreach (var table in tables) |