Watch Diana Scharf's "Inertia.js" talk to gain a deep understanding of using Inertia.js to create modern, single-page applications with a familiar Laravel development experience.
The post Diana Scharf's "Inertia.js" talk from Laracon appeared first on Laravel News.
Join the Laravel Newsletter to get Laravel articles like this directly in your inbox.
---
05 August, 2023
04 August, 2023
How to search all the amazon connect customer profiles using API?
Programing Coderfunda
August 04, 2023
No comments
everyone.
I am struggling with searching all the amazon connect customer profiles at once by using rest API.
I already know the API that retrieve one or more than two customer profiles via specific key name such as profile ID or account ID etc.
However not list all customer profiles.
Here's my javascript code for searching one profile.
session.profileClient.searchProfiles({
"DomainName": "", // required
"KeyName": searchKey, // required
"Values": [searchValue] // required
}).then((res) => {
console.log('Success response: ' + JSON.stringify(res));
}).catch((errorResp) => {
console.log('Error response: ' + JSON.stringify(errorResp));
});
In this code, I have to put 3 parameters(domainName, keyName, value) and get one or two more results but all the results.
Any help in the right direction on how to list all Amazon Connect Customer Profile would be greatly appreciated.
I hope to get all the amazon connect customer profile list.
I hope to get all the amazon connect customer profile list.
03 August, 2023
Laravel Prompts is Now Available in Laravel 10.17
Programing Coderfunda
August 03, 2023
No comments
The Laravel team released v10.17 with Laravel Prompts, a config:show Artisan command, a Collection method to ensure types and more.
The post Laravel Prompts is Now Available in Laravel 10.17 appeared first on Laravel News.
Join the Laravel Newsletter to get Laravel articles like this directly in your inbox.
---
02 August, 2023
Scramble 0.8.0 – Update of Laravel Open API documentation generator
Programing Coderfunda
August 02, 2023
No comments
01 August, 2023
Facing overflow issue with react slick
Programing Coderfunda
August 01, 2023
No comments
I am using react slick for slider and that slider cards contain dropdown that have lot of options. When the dropdown is open half of the dropdown is cropped not able to view the full dropdown
code pen: https://codepen.io/gtm18/pen/YzRdaML (demo with jQuery)
$(document).ready(function(){
$('.carousel').slick({
slidesToShow: 3,
dots:true,
centerMode: true,
});
});
31 July, 2023
How do you get a double-column unique key as foreign key?
Programing Coderfunda
July 31, 2023
No comments
I have the following two tables in MariaDB 11.0.2:
CREATE TABLE `Languages` (
`Name` char(49) DEFAULT NULL,
`ISO_639_1` char(2) NOT NULL,
`Language_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`Main_Flag` varchar(20) DEFAULT NULL,
PRIMARY KEY (`Language_ID`),
UNIQUE KEY `Languages_UN` (`ISO_369_1`,`Main_Flag`)
) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
and
CREATE TABLE `Tests` (
`Test_ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
`Test_Name` varchar(50) DEFAULT NULL,
`ISO_639_1` char(2) NOT NULL,
`Main_Flag` varchar(20) DEFAULT NULL,
PRIMARY KEY (`Test_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
but I cannot assign the double column unique-key to their counterparts:
MariaDB [my_db]> ALTER TABLE Tests ADD CONSTRAINT Test_Language_FK FOREIGN KEY (ISO_639_1, Main_Flag) REFERENCES Languages(ISO_639_1, Main_Flag);
ERROR 1005 (HY000): Can't create table `my_db`.`Tests` (errno: 150 "Foreign key constraint is incorrectly formed")
There are no anomalies in the index of the Test table:
MariaDB [my_db]> show index from Tests;
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| Tests | 0 | PRIMARY | 1 | Test_ID | A | 37 | NULL | NULL | | BTREE | | | NO |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
1 row in set (0,001 sec)
What is holding me back? The data types are the same and the collation and charsets are also a match.
Compare rows from the Sqlserver table with the indexes generated in the Array
Programing Coderfunda
July 31, 2023
No comments
I have a single TBResult table in Sql Server 2014, with 2,500 saved Results per Contest Number, following format:
private Label[] LabelResult = new Label[15]; // dynamically created
I need to compare each new draw generated in the [LabelResult] array with the database records and know the number of hits I would have with 11 numbers, how many hits with 12 numbers, how many hits with 13 numbers, how many hits with 14 numbers and how many hits there would be with 15 numbers.
like a lottery where you choose 15 numbers from 01 to 25 and win the prize according to the number of numbers you hit.
OBSERVATION: the Numbers entered in the array will not be saved in the Database, I only need the comparison with the Results Table.
I need it to appear like this in the EX Labels:
Summary:
You would have scored 11 hits in 250 contests.
You would have scored 12 hits in 55 contests.
You would have scored 13 hits in 6 contests.
You would have made 14 hits in 1 contest.
You wouldn't have done 15 hits.
try this way but got no results
private int NewCount()
{
ContestResult c = new ContestResult();
int response= 0;
DALConexao cx = new DALConexao(DadosDaConexao.StringDaConexao);
cx.Open();
StringBuilder query = new StringBuilder();
query.AppendLine("SELECT _01, _02, _03, _04, _05, _06, _07, _08, _09, _10, _11, _12, _13, _14, _15 form TBResult," );
query.AppendLine("SELECT value FROM " + LabelResult [0].Text + LabelResult [3].Text + LabelResult [2].Text + LabelResult [4].Text + LabelResult [4].Text +
LabelResult [5].Text + LabelResult [6].Text + LabelResult [7].Text + LabelResult [8].Text + LabelResult [9].Text +
LabelResult [10].Text + LabelResult [11].Text + LabelResult [12].Text + LabelResult [13].Text + LabelResult [14].Text );
query.AppendLine(" WITH T AS( SELECT *, MatchCount = (SELECT COUNT(*) FROM(SELECT * FROM(VALUES[_01],[_02], [_03], [_04], [_05],[_06], [_07], [_08], [_09], [_10],[_11], [_12], [_13], [_14], [_15]");
query.AppendLine(")V(V)) T) FROM TBResult) SELECT *, RunningTotalForMatchCount = ROW_NUMBER() OVER(PARTITION BY MatchCount ORDER BY Contest) FROM T ORDER BY Contest");
SqlCommand cmd = new SqlCommand(query.ToString(), cx.ObjetConexao);
cmd.CommandType = System.Data.CommandType.Text;
response= = cmd.ExecuteNonQuery();
cmd.Connection = cx.ObjetConexao;
return response;
}
my Class Generate randoms in order and not repeated.
private void ShowArray()
{
int[] OrganizedNumbers = new int[15];
Array.Sort(OrganizedNumbers);
for (int i = 0; y < 15; i++)
{
LabelResult[i].Text = OrganizedNumbers[i].ToString("D2");
}
}
private void Generator()
{
RandomClass rnd = new RandomClass();
int[] luckyNumbers = rnd.non-repeatingGenerator(15, 1, 25);
Array.Sort(luckyNumbers );
Control[] controls = LabelResult
for (int i = 0; i < controls.Length; i++)
{
int value = (luckyNumbers [i];
controls[i].Text = value.ToString("D2");
}
}`
my button would be like this
private void btnGenerateArray_Click(object sender, EventArgs e)
{
ShowArray();
//int operationsPerformed = NewCount();
//if operationsPerformed == 11)
//{
// lblResult11.Text = operationsPerformed.ToString();
//}
//else if operationsPerformed == 12)
//{
// lblResult12.Text = operationsPerformed.ToString();
//}
//else if operationsPerformed == 13)
//{
// lblResult13.Text = operationsPerformed.ToString();
//}
//else if operationsPerformed == 14)
//{
// lblResult14.Text = operationsPerformed.ToString();
//}
//else if operationsPerformed == 15)
//{
// lblResult15.Text = operationsPerformed.ToString();
//}
}
My model is like this:
public class ContestResult
{
public ContestResult()
{
this.Contest = 0;
this._01 = 0;
this._02 = 0;
this._03 = 0;
...
this._14 = 0;
this._15 = 0;
}
public ContestResult(int Contest, int _01, int _02, int _03, int _04, int _05, int _06, int _07,
int _08, int _09, int _10, int _11, int _12, int _13, int _14, int _15)
{
this.Contest = contest;
this._01 = _01;
this._02 = _02;
this._03 = _03;
...
this._14 = _14;
this._15 = _15;
}
private int contest;
public int Contest
{
get { return this.contest; }
set { this.contest = value; }
}
private int _01;
public int n_01
{
get { return this._01; }
set { this._01 = value; }
}
private int _02;
public int n_02
{
get { return this._02; }
set { this._02 = value; }
}
private int _03;
public int n_03
{
get { return this._03; }
set { this._03 = value; }
}
...
private int _14;
public int n_14
{
get { return this._14; }
set { this._14 = value; }
}
private int _15;
public int n_15
{
get { return this._15; }
set { this._15 = value; }
}
}
I'm new to this topic and I want to learn; I researched a lot and I didn't find something that answers my question.
30 July, 2023
Authentication not granted for service principal token in MS Fabric API using Python
Programing Coderfunda
July 30, 2023
No comments
I am trying to connect to OneLake API in Microsoft Fabric using Python in VScode.
So far I have
* Registered an app in Azure with these API permissions
* Then created a secret for my service principal
* Then I try to get the token with this function, using azure.identity:
from azure.identity import ClientSecretCredential, AuthenticationRequiredError
def get_access_token(app_id, client_secret, directory_id):
try:
# Create the ClientSecretCredential using the provided credentials
credential = ClientSecretCredential(
client_id=app_id,
client_secret=client_secret,
tenant_id=directory_id
#scope="https://storage.azure.com/.default"
)
# Use the credential to get the access token
token = credential.get_token("https://storage.azure.com/.default").token
return token, credential
except AuthenticationRequiredError as e:
print("Authentication failed. Please check your credentials.")
raise e
except Exception as e:
print("An error occurred while getting the access token:")
print(str(e))
raise e
access_token, credential = get_access_token(app_id, client_secret, directory_id)
It seems I get the token fine and all. But there is something wrong with the permissions or scope or access. Because when I run this function to check for connection i get status code 400
def check_connection_with_onelake(access_token):
base_url = "https://onelake.dfs.fabric.microsoft.com/9c3ffd43-b537-4ca2-b9ba-0c59d0094033/Files/sample?resource=file"
token_headers = {
"Authorization": "Bearer " + access_token
}
try:
response = requests.put(base_url, headers=token_headers)
if response.status_code == 200:
print("Connection with OneLake is successful.")
else:
print("Failed to connect with OneLake. Status code:", response.status_code)
except requests.exceptions.RequestException as e:
print("An error occurred while checking the connection:", str(e))
# Assuming 'access_token' is already defined and contains a valid access token
check_connection_with_onelake(access_token)
* I also added the app's service principal to users in the Fabric workspace as an admin
Where am I missing access and how do I grant the correct access?
references:
https://learn.microsoft.com/en-us/fabric/onelake/onelake-access-api
https://amitchandak.medium.com/on-premise-python-code-to-local-sql-server-data-to-microsoft-fabric-lakehouse-using-token-d15b8795e349


