This file contains hidden or 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
| set @schema = 'base_sms'; | |
| set @table = 'bayprofiles'; | |
| -- column name list | |
| select concat('`',COLUMN_NAME,'`,') as columnName from information_schema.COLUMNS where TABLE_SCHEMA=@schema and TABLE_NAME=@table; | |
| /* | |
| `id`, | |
| `profileId`, | |
| `bayWidth`, | |
| `bcolumn`, |
This file contains hidden or 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
| -- replace: | |
| -- `log` with any table | |
| -- `id` with any index column on that table | |
| -- 81272070 with an existing value in the index column | |
| -- in connection #1 | |
| START transaction; | |
| select * from log where id = 81272070 FOR UPDATE; | |
| select sleep(40); | |
| COMMIT; |
This file contains hidden or 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
| Landing Page | |
| Create Design -> Is Logged In For New Design? | |
| Login -> Login Page | |
| Create Account -> Create Account | |
| Is Logged In For New Design? | |
| yes? -> New Design | |
| no? -> Login Page | |
| Login Page |
This file contains hidden or 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
| Quote Listing* | |
| New Quote -> New Quote Wizard | |
| Select Quote -> Estimation View Mode? | |
| Search -> Quote Listing | |
| Estimation View Mode? | |
| is accepted? -> Accepted Quote | |
| is created? -> Created Quote | |
| else -> Draft Quote |
This file contains hidden or 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
| public void ProcessList(List<Input> inputs) | |
| { | |
| var errors = new List<Exception>(); | |
| foreach (var input in inputs) | |
| { | |
| try | |
| { | |
| Process(input); | |
| } | |
| catch (Exception ex) |
This file contains hidden or 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> | |
| /// Search for relativePath with respect to (w.r.t.) the current directory and if it doesn't exist, | |
| /// search w.r.t. the current parent directory, then the grandparent and so on until the path is found | |
| /// or the root it hit. Works for files or directories. | |
| /// </summary> | |
| /// <returns></returns> | |
| public static string FindRelativePathInAncestors(string relativePath, string startDirectory) | |
| { | |
| relativePath = relativePath.TrimStart(Path.DirectorySeparatorChar); | |
| int level = 0; |
This file contains hidden or 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
| using System; | |
| using System.Diagnostics; | |
| using Newtonsoft.Json; | |
| using Shouldly; | |
| using Xunit; | |
| namespace json | |
| { | |
| public class UnitTest1 | |
| { |
This file contains hidden or 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
| using System; | |
| using System.CodeDom; | |
| using System.Collections.Generic; | |
| using System.IO; | |
| using System.Linq; | |
| using System.Net; | |
| using System.Net.Sockets; | |
| using System.Text; | |
| using System.Threading.Tasks; | |
| using Amazon; |
This file contains hidden or 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
| using System.Collections.Generic; | |
| using System.Diagnostics; | |
| using System.IO; | |
| using System.Security.Cryptography; | |
| using Newtonsoft.Json; | |
| using Org.BouncyCastle.Crypto; | |
| using Org.BouncyCastle.Crypto.Parameters; | |
| using Org.BouncyCastle.OpenSsl; | |
| using Org.BouncyCastle.Security; |
This file contains hidden or 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
| const f = (a: any[], b: any[]): any[] => | |
| [].concat(...a.map(a2 => b.map(b2 => [].concat(a2, b2)))); | |
| export const cartesianProduct = (a: any[], b: any[], ...c: any[]) => { | |
| if (!b || b.length === 0) { | |
| return a; | |
| } | |
| const [b2, ...c2] = c; | |
| const fab = f(a, b); | |
| return cartesianProduct(fab, b2, c2); |