Tag: ”)

Laravel: multi-DB not respecting the HOST attribute

Post author By Full Stack
Post date January 23, 2021
No Comments on Laravel: multi-DB not respecting the HOST attribute

I’m reposting this question because the previous one was closed as being answered by a related post here but it wasn’t. That post is saying how to access the servers using raw commands. My question has to do with how LARAVEL handles it – because I use Eloquent and Laravel relationships to handle all the […]

Tags ''), '127.0.0.1'), '3306'), 'database' => env('DB_DATABASE', 'forge'), 'host' => env('DB_HOST', 'password' => env('DB_PASSWORD', 'port' => env('DB_PORT', 'username' => env('DB_USERNAME', and another DB specifically for user accounts. Here's the snippet on the ENV side: DB_CONNECTION=mysql DB_HOST=APP_SERVER_IP DB_PORT=APP_SE, but the caveat is the title). I'm currently using two databases, etc. So I have a multi-DB setup which I thought was working (well it does, I'm reposting this question because the previous one was closed as being answered by a related post here but it wasn't. That post is saying, one for the actual app we're developing

User Help Web Pro

How to generate the ‘amp_url_signature’ value to update AMP cache

Post author By Q+A Expert
Post date December 30, 2020
No Comments on How to generate the ‘amp_url_signature’ value to update AMP cache

I want to update the AMP cache of my website, and created the private key for my server by following Google’s directions. $ openssl genrsa 2048 > private-key.pem $ openssl rsa -in private-key.pem -pubout >public-key.pem However, I don’t know how to generate the hash of ‘amp_url_signature’ to complete the URL https://example-com.<cache.updateCacheApiDomainSuffix>/update-cache/c/s/example.com/article?amp_action=flush&amp_ts=<ts_val>&amp_url_signature=<sig_val> This is, I do […]

Tags _, ''), '/', '='), $pkeyid, and created the private key for my server by following Google's directions. $ openssl genrsa 2048 > private-key.pem $ openssl rsa -in privat, array, base64_encode($string)); } $timestamp=time(); $signatureUrl = '/update-cache/c/s/amp.mydomain.com/amp/page-url?amp_action=flush&amp_ts='.$tim, I do not know how to obtain I tried with PHP function urlsafe_b64encode($string) { return str_replace(array('+', I don't know how to generate the hash of 'amp_url_signature' to complete the URL https://example-com./upda, I want to update the AMP cache of my website, OPENSSL_ALGO_SHA256); openssl_free_key($pkeyid); $signature = urlsafe_b64encode($signature); echo $signature; But $signature is empty. Is t, signature

Mastering Development

I want to plot multiple variables from a dataframe using matplotlib but the final plot looks so weird

Post author By Full Stack
Post date December 11, 2020
No Comments on I want to plot multiple variables from a dataframe using matplotlib but the final plot looks so weird

I have a dataframe containing stocks of multiple companies and a date column. I want to plot these stocks values on the y axis and date on the x axis in the same plot. Each stock starts from a different value (for example amazon starts from $3103 whereas apple starts from $112) When I do […]

Tags ''), I have a dataframe containing stocks of multiple companies and a date column. I want to plot these stocks values on the y axis and date on th

Mastering Development

php adding blank spaces to mysql result with concat_ws

Post author By Full Stack
Post date December 2, 2020
No Comments on php adding blank spaces to mysql result with concat_ws

I have the following dates set and query: create table test ( id int unsigned not null auto_increment primary key, street1 varchar(32) not null default ”, street2 varchar(32) not null default ”, city varchar(32) not null default ”, state varchar(32) not null default ”, code varchar(32) not null default ”, country varchar(32) not null default […]

Tags '', ''), '')) o_address from test http://sqlfiddle.com/#!9/b919c4/3/0 But somehow PHP is interpreting this string with extra white spaces like b, '10016', 'City'], 'United States'); select concat_ws('\n', "New York", ("NYC", because tested on few MySQL IDE's and the query works fine. 44 Abc St NYC New York 10016 United States Have, city varchar(32) not null default '', Code, code varchar(32) not null default '', country varchar(32) not null default '' ); insert into test (street1, country) values ('44 Abc St', I have the following dates set and query: create table test ( id int unsigned not null auto_increment primary key, NULLIF(city, NULLIF(code, NULLIF(country, NULLIF(state, NULLIF(street1, NULLIF(street2, State, state varchar(32) not null default '', street1 varchar(32) not null default '', street2 varchar(32) not null default '', street2: ''

Mastering Development

How to fix Laravel Illegal mix of collations error?

Post author By Full Stack
Post date November 30, 2020
No Comments on How to fix Laravel Illegal mix of collations error?

I have a cronjob thats saves a data by calling an API. This was never happened before, I already changed the collations into latin1_swedish_ci,IMPLICIT and utf8mb4_unicode_ci,COERCIBLE and vice versa for testing. But still I get this kind of error. The weird thing is that I can insert half of the data when I checked the […]

Tags ''), '127.0.0.1'), '3306'), 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'database' => env('DB_DATABASE', 'engine' => null, 'forge'), 'host' => env('DB_HOST', 'options' => extension_loaded('pdo_mysql') ? array_filter([ PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'), 'password' => env('DB_PASSWORD', 'port' => env('DB_PORT', 'prefix_indexes' => true, 'unix_socket' => env('DB_SOCKET', 'url' => env('DATABASE_URL'), 'username' => env('DB_USERNAME', "D11", ], ]) : [], { strict: false }), \d*((?!\1)){0, COERCIBLE and vice versa for testing. But still I get this kind of error. The weird thing is that I can insert half of the data when I checke, COERCIBLE) for operation '=' (SQL: select count(*) as aggregate from `scraping`.`xp_ecoprop_projectlist` where `projectId` = 9a8d5bceacb54a78, D21 and `latitude` = Singapore and `longitude` = Singapore and `unitsNum` = 660 and `launchDate` = 1605888000000 and `launchDateAltText` = Q4, I already changed the collations into latin1_swedish_ci, I have a cronjob thats saves a data by calling an API. This was never happened before, IMPLICIT) and (utf8mb4_unicode_ci, prefix

Mastering Development

MS SQL Performance in stored procedure

Post author By Full Stack
Post date November 16, 2020
No Comments on MS SQL Performance in stored procedure

I am a newbie within performance optimization in MS SQL. But I have a problem with a stored procedure which takes nearly 2 hours to execute – I think it is a long time. It is about 100000 records it has to iterate through and I have used computed columns. (The computed colums has prefix […]

Tags ' ', ''), '') LIKE '%' + '23747585' + '%') AND (LEN('23747585') > 7) AND vennenr > 0 AND vennenr NOT IN (SELECT FriendID FROM DuplicateForgetFriends WH, '') LIKE '%' + @telefon + '%') AND (LEN(@telefon) > 7) AND (Upper_Email IN (@email)) AND (Upp, '') LIKE '%' + @telefon + '%') AND (LEN(@telefon) > 7) AND vennenr > 0 AND, '') LIKE '%' + @tlf1 + '%') AND (LEN(@tlf1) > 7) AND vennenr > 0 AND, '')) > 0 THEN UPPER(RTRIM(SUBSTRING(ISNULL(Fornavn, ''))))) END AS ShortenFornavn, ''))))) WHEN CHARINDEX(' ', "telefon", [Adresse], [AKeep], [AKeep] [bit] NULL, [Choice] [smallint] NULL, [FriendID] [int] NULL, [SubDubletNo] [int] NULL, [UseAdresse], [UseAdresse] [bit] NULL, [UseBornDate] [bit] NULL ) CREATE CLUSTERED INDEX idxTempTableFriendID ON #tempTable (FriendID) CREATE NONClUSTERED INDEX idxTempTableDublet, [UseBornDate] FROM #tempTable CLOSE Friend_Cursor DEALLOCATE Friend_Cursor UPDATE DuplicateSetup SET IsOrdered = 0, [UseBornDate]) SELECT FriendID, [UseBornDate]) SELECT Vennenr, [UseBornDate]) VALUES (@Vennenr, [UseEfternavn], [UseEfternavn] [bit] NULL, [UseEmail], [UseEmail] [bit] NULL, [UseFornavn], [UseFornavn] [bit] NULL, [UseOrganisation], [UseOrganisation] [bit] NULL, [UsePostCode], [UsePostCode] [bit] NULL, [UseTlf1], [UseTlf1] [bit] NULL, [UseTlf2], [UseTlf2] [bit] NULL, @adresse VARCHAR(max), @done BIT, @efternavn, @efternavn VARCHAR(max), @email --loop på alle venner > 0 WHILE @@FETCH_STATUS = 0 BEGIN -- Check om venner er håndteret før IF (SELECT COUNT(FriendID) FROM #, @email END INSERT INTO DuplicateList (FriendID, @email VARCHAR(MAX), @fornavn, @fornavn VARCHAR(max), @oldTime, @oldTime DATETIME SET @dubletNo = 1 SET @oldtime = current_Timestamp IF (SELECT COUNT(ID) FROM DuplicateSetup) > 0 UPDATE DuplicateSet, @postnr, @postnr VARCHAR(max), @shortenfornavn, @shortenfornavn VARCHAR(MAX), @subDubletNo INT, @telefon VARCHAR(max), @tlf1, @tlf1 VARCHAR(MAX), @Vennenr INT, 0, 0 FROM Medlemsdata LEFT OUTER JOIN Postnumre RIGHT OUTER JOIN MedlemsAdresse ON Postnumre.Pos, 0 FROM Medlemsdata WHERE (Vennenr @Vennenr) AND (Upper_Fornavn_FirstPart IN (@shortenfornavn)) AND (Upper_, 1, 1) SET @subDubletNo = 1; -- Første check IF @done = 0 BEGIN IF EXISTS( SELECT Vennenr, 4) DELETE FROM DuplicateList; CREATE TABLE #tempTable ([DubletNo] [int] NULL, case when CHARINDEX('|', CHARINDEX('(', Choice, current_Timestamp - @oldtime) SET NOCOUNT OFF One of my computed columns look like this: ALTER TABLE Medlemsdata ADD Upper_Fornavn_FirstPa, CurrentLevel = 4 ELSE INSERT INTO DuplicateSetup (IsOrdered, CurrentLevel) VALUES (1, DubletNo, Fornavn) > 0 THEN UPPER(RTRIM(LEFT(Fornavn, Fornavn) = 0 THEN UPPER(Fornavn) WHEN CHARINDEX(' ', Fornavn)))) END PERSISTED I really hope that there is/are basic for performanceoptimization and that someone can give me an, I am a newbie within performance optimization in MS SQL. But I have a problem with a stored procedure which takes nearly 2 hours to execute -, ISNULL(Fornavn, LEN(ISNULL(Fornavn, Michael, OrderDateTime, OrderDateTime = @oldTime, OrderDateTime = null, REPLACE(Telefon, REPLACE(Tlf1, ROW_NUMBER() OVER (ORDER BY Vennenr) + @subDubletNo, så ... IF @subDubletNo = 1 BEGIN DELETE FROM #tempTable WHERE FriendID = @Vennenr END ELSE BEGIN, SubDubletNo, TimeConsumption) VALUES (4, Updated = CURRENT_TIMESTAMP INSERT INTO DuplicateTimeConsumption (ALevel, UPPER((Postnr)), UPPER([E-mail]) FROM Medlemsdata LEFT OUTER JOIN Postnumre RIGHT OUTER JOIN MedlemsAdresse ON Postnumre.Postnummer = MedlemsAdres, UPPER(adresse), UPPER(Efternavn), UPPER(Fornavn), userId: '$userId'

Mastering Development

React Native – Sending FormDate to C# API

Post author By Full Stack
Post date November 14, 2020
No Comments on React Native – Sending FormDate to C# API

I am trying to send two pieces of information from my React Native app to my C# API. I just need to send a UserId along with a picture. If I use form-data on PostMan the information is reaching the API successfully and everything is working perfectly. Sending the data via React Native is where […]

Tags ''), [FromForm(Name = "profilePicture")] IFormFile profilePicture) { Request.Headers.TryGetValue("Requestor", { uri: Platform.OS === 'android' ? profilePicture.uri : profilePicture.ur, }) C# code (snippet): [HttpPatch] [Route("SaveProfilePictureUri")] public async Task SaveProfilePictureUri([F, }) const response = await Api.patch('/User/SaveProfilePictureUri', formData, I am trying to send two pieces of information from my React Native app to my C# API. I just need to send a UserId along with a picture. If I, jwtToken); return await _userService.SaveProfilePictureUri(userId, name.Name ), out var jwtToken); _securityService.CheckAuthentication(userId, out var requester); _securityService.ValidRequester(requester); Request.Headers.TryGetValue("JwtToken", profilePicture); } What other things can I try?, type: 'image/jpg', userId) formData.append('profilePicture'

Mastering Development

Laravel migration could not find driver

Post author By Full Stack
Post date November 10, 2020
No Comments on Laravel migration could not find driver

I have this error when i try to make php artisan migrate Illuminate\Database\QueryException could not find driver (SQL: select * from information_schema.tables where table_schema = lsapp and table_name = migrations and table_type = ‘BASE TABLE’) at vendor/laravel/framework/src/Illuminate/Database/Connection.php:671 667| // If an exception occurs when attempting to run a query, we’ll format the error 668| // […]

Tags ''), '3306'), 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'database' => env('DB_DATABASE', 'engine' => null, 'host' => env('DB_HOST', 'lsapp'), 'options' => extension_loaded('pdo_mysql') ? array_filter([ PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'), 'password' => env('DB_PASSWORD', 'port' => env('DB_PORT', 'prefix_indexes' => true, 'root', 'unix_socket' => env('DB_SOCKET', 'url' => env('DATABASE_URL'), 'username' => env('DB_USERNAME', "strict": true, ] help me solve that problem, ]) : [], $e 673| ); 674| } 675| +34 vendor frames 35 artisan:37 Illuminate\Foundation\Console\Kernel, $this->prepareBindings($bindings), I have this error when i try to make php artisan migrate Illuminate\Database\QueryException could not find driver (SQL: select * from, localhost, Object(Symfony\Component\Console\Output\ConsoleOutput)) I have already create my database on phpmyadmin. here is the configuration of my .en, prefix, we'll format the error 668| // message to include the bindings with SQL, which will make this exception a 669| // lot more helpful to the developer instead of just the database's errors. 670|

Mastering Development

Created this procedure, when I execute I am not getting excepted results

Post author By Full Stack
Post date November 7, 2020
No Comments on Created this procedure, when I execute I am not getting excepted results

I have created this procedure and I am not getting all records out. It should print id, ssn and ValidSSN. ValidSSN should come from case statement where is checking if SSN is valid. Please could you let me know why? Number of other records matches from table I am pulling from but no results for […]

Tags -102], -11, -182, -23, -32, -38, -41, -442, -48, .44, .53, .97], '-', ''), '') SSN ) v LEFT JOIN ##SSN_RangeList sr ON v.Area = CAST(sr.AreaCode AS VARCHAR(3)) join [infoarmor_secure].[subscribers]s on s.ssn = s.ssn, '')) 1 OR Sequence = 0 OR HighGroup = 0 THEN 'Invalid SSN' ELSE CASE WHEN Groupcode % 2 = 1 THEN --odd groupcode, '')))) + REPLACE(@ssn, '#674'], '137', '177', '505', '508', '683', '689', '7:30', 'id', ", "1":66, "14", "14":7, "2":70, "3":14, "334", "335", "4":14, "4":72, "4|1|8"], "4|3|9"], "545", "646", "7":14, "71", ( 531, ( 718, (338, (388, (444, (475, (489, (541, (64, (651, (660, (672, (677, (678, (679, (7+2)=9, (701, (702, (708, (755, [ "103", [ 55, [ 703], [ 75, [ 82, ["4|6|5", [[ 87, [[496., [[566., [109, [132, [148, [151, [56, [690, [762, [764, [767, [GroupCode] [tinyint] NOT NULL ) insert into ##SSN_RangeList values (1, }, 10, 100, 101, 104, 105, 106]]], 107, 108, 110, 111], 112, 113, 114, 115, 116, 117, 118, 119, 12, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 13, 130, 131, 133, 134, 135, 136, 138, 139, 140, 141, 142, 143, 144, 145, 146, 149, 15, 150, 152], 153, 154, 155], 156, 157, 158, 159, 16, 160, 161, 162, 163], 164, 165, 167, 168], 169, 17, 170, 171, 172, 173, 174, 175, 176], 178, 179, 18, 180, 181, 183, 184, 185, 186, 187, 188, 189, 19, 190, 191, 192, 193, 194, 195, 196, 197, 198], 199, 2, 2) HighGroup, 20, 200, 201, 202, 203, 204, 205, 206, 207, 208], 209, 21, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 22, 220, 221, 222]], 223, 224, 225, 226, 227, 228, 229, 230, 231, 232)' } ] }, 234], 235, 236, 237, 238, 239, 24, 240, 241, 242], 243, 244, 245, 246, 247, 248, 249, 25, 250, 251, 252], 253], 254, 255, 256, 257, 258, 259, 26, 260, 261, 262, 263, 264, 265, 266, 267, 268, 269, 27, 271, 272, 273, 274, 275, 276, 277, 278, 279, 28, 280, 281, 282, 283, 284, 285, 286]], 287, 288, 289, 29, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 3, 3) Area, 30, 300, 301), 302], 303, 304, 305, 306, 307, 308, 309, 31, 310, 311, 312, 313, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 33, 330, 331, 332, 333, 336), 337), 339), 34, 340, 341, 342), 343, 344, 345, 346, 347, 348, 349, 35, 350, 351, 352" }, 353, 354, 355, 356, 357, 358, 359, 36, 360, 361, 362, 363, 364, 365, 366), 367, 368, 369, 37, 370, 371, 372, 373, 374, 375, 376, 377, 378" }, 379, 380, 381, 382, 383, 384, 385, 386", 387, 389, 39, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 4, 4) Sequence, 40, 400, 401, 402" }, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 415), 416, 417, 419, 42, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429 ], 43, 430, 431, 432, 433, 434, 435, 436, 437, 438, 440, 441, 443, 445, 446, 447, 448, 449, 45], 450), 451, 452, 453, 454, 455, 456, 457, 458, 459, 46, 460, 461, 462, 463, 464, 466, 467, 468, 469" }, 47, 470, 471 ], 473, 474, 476, 477, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 49, 490, 491, 492, 493, 494, 495, 497, 498, 499), 5, 5:10], 50, 500), 501, 502, 503, 504, 506, 507, 509, 51, 511, 512)), 513, 514, 515, 516, 517, 518, 519, 52, 520, 521, 522, 523, 524, 525, 526, 527], 528, 529, 530, 532", 533, 534, 535, 536, 537, 538]), 539, 54, 540, 542, 543, 544, 546, 547, 548, 549, 550, 551, 552), 553, 554, 555, 556, 557, 558), 559], 560, 561, 562], 563, 564, 565, 567, 568, 569, 57, 570, 571, 572, 573, 574, 575, 576, 577, 578, 579, 58, 580, 581, 582, 583])), 584, 585, 586, 587, 588, 589, 59, 590, 591, 592, 593, 594], 595, 596, 597, 598, 599]]}}, 6, 60, 600, 601, 602, 603, 604, 605, 606, 607, 608, 609, 61, 610, 611, 612, 613, 614, 615, 616, 617, 618, 619, 62, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 63, 630, 631, 632, 633" }, 634, 635, 636, 637, 638" }, 639, 640, 641, 642, 643, 644, 645, 647, 648, 649, 65, 650, 652, 653, 654), 655, 656), 657, 658, 659, 66, 661, 662, 663, 664, 665, 667, 668, 669, 67, 670, 671, 673, 675, 676, 68, 680, 681), 682], 684, 685, 686, 687, 688, 69, 691, 692, 693}]}, 694, 695, 696, 697]]);, 698, 699, 7, 7:57, 7:58, 70], 700, 704, 705, 706), 707, 709, 710, 711" }, 712), 713, 715), 716, 717, 719, 72, 720, 721, 722, 723, 724, 725, 726, 727, 728, 73, 731, 732, 733), 74, 750, 751), 752" }, 753, 754 ], 756), 759, 76, 760, 761" }, 763, 765, 766, 768, 769, 77, 771), 772, 78, 79, 8, 80, 81, 83, 84), 85, 86, 88, 89, 9, 9 - LEN(LTRIM(REPLACE(@ssn, 9 - LEN(REPLACE(@ssn, 90, 91, 92, 93, 94, 94) declare @ValidSSN varchar(50) = null declare @ssn nVARCHAR(50) = null declare @id bigint = null SELECT s.SSN, 95, 96, 98, 99], CASE WHEN ISNUMERIC(REPLACE(s.ssn, I have created this procedure and I am not getting all records out. It should print id, REPLICATE('0', RIGHT(REPLICATE('0', ssn and ValidSSN. ValidSSN should come from case statement where is checking if SSN is valid. Please could you let me know why? Number of oth, SUBSTRING(REPLICATE('0'

Mastering Development

Create a dataframe from a xml file with the paths and the value

Post author By Full Stack
Post date October 21, 2020
No Comments on Create a dataframe from a xml file with the paths and the value

Here is the data from the xml file, <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"> <SOAP-ENV:Header /> <SOAP-ENV:Body> <ADD_LandIndex_001> <CNTROLAREA> <BSR> <status>ADD</status> <NOUN>LandIndex</NOUN> <REVISION>001</REVISION> </BSR> </CNTROLAREA> <DATAAREA> <LandIndex> <reportId>AMI100031</reportId> <requestKey>R3278458</requestKey> <SubmittedBy>EN4871</SubmittedBy> <submittedOn>2015/01/06 4:20:11 PM</submittedOn> <LandIndex> <agreementdetail> <agreementid>001 4860</agreementid> <agreementtype>NATURAL GAS</agreementtype> <currentstatus> <status>ACTIVE</status> <statuseffectivedate>1965/02/18</statuseffectivedate> <termdate>1965/02/18</termdate> </currentstatus> <designatedrepresentative></designatedrepresentative> </agreementdetail> </LandIndex> </LandIndex> </DATAAREA> </ADD_LandIndex_001> </SOAP-ENV:Body> </SOAP-ENV:Envelope I want to save in a dataframe […]

Tags ''), 'rb') as file: root = et.parse(file).getroot() tree = et.ElementTree(root) col_name = ['Path', 'Value' : el.text }, 'Value'] dataF = pd.DataFrame([], <ADD_LandIndex_001, columns = col_name) def traverse(el, d) else: if el.text is not None: d = d.append({'Path': tree.getelementpath(el).replace(namespace, d): if len(list(el)) > 0: for child in el: traverse(child, dataF) print(df) df.to_excel("data_2.xlsx"), Here is the data from the xml file, however I can see by the print(d) in the loop of the function that it takes correctly each elements. I don't really see what is wrong ? Anyon, ignore_index = True) print(d) return d df = traverse(root