Видео

CREATE TABLE xml_table ( xml_data XML ); INSERT INTO xml_table (xml_data) VALUES ( '<toll_data_list> <toll_data> <toll_id>1</toll_id> <vehicle_license_plate state_plate="FL" expiration_date="2024-06">ABC123</vehicle_license_plate> <toll_booth_id>101</toll_booth_id> <toll_amount currency_type="USD" payment_rendered="DEVICE" device_serial="123-4567-89034">5.75</toll_amount> </toll_data> <!-- Add other <toll_data> entries here --> <toll_data> <toll_id>10</toll_id> <vehicle_license_plate state_plate="FL" expiration_date="2024-12">YZA567</vehicle_license_plate> <toll_booth_id>110</toll_booth_id> <toll_amount currency_type="USD" payment_rendered="Cash">5.00</toll_amount> </toll_data> </toll_data_list>' ); from command line psql -U postgres -d postgres -c "COPY (SELECT xml_data FROM xml_table) TO STDOUT WITH (FORMAT text)" > output.xml

@@SoftwareNuggets Thank you so much for your answer!!

Thank you. I have one other video that might be useful: ADD two (Decimal, Hexadecimal, Octal, Binary) using the CARRY Technique. ruclips.net/video/Vd49yfa6DuE/видео.html

In PostgreSQL, working with INTERVAL is usually fast, but how well it performs can depend on how you use it in your queries and data setup.

Hey Luan, Thank you for letting me know the video was useful to you! I'm always excited to hear when content resonates with viewers. Do you have any requests for other videos?

Thanks for asking. I am interested Traits and Closures in Rust.

Hey @LekkyDev, glad to hear this video was useful. Thanks for letting me be a small part of your programming journey.

Very happy to read your comment. Thanks!

@@SoftwareNuggetswelcome! I was wondering if you could help me out with a college project of mine, i m in my last semester and really stuck in an issue. Im willing to pay if you finish the job! 😄

#Sanketjoice. Thanks for reaching out. I am willing to help you with your college project. I am not available for work for hire. If you'd like for me to help, please explain the problem you need help solving. send to my email address: softwareNugget65@gmail.com

Hey @LekkyDev, I will have a video out tonight, however, I could just upload the source to this problem to my github account earlier if you'd like. Please let me know. If no response, I'll just publish video ASAP.

@@SoftwareNuggets That would be great if you could upload the source but videos are always better because you get to see the build up as well. I really struggle to find any tutorial about plpgsql with nodejs. Thanks for reaching back and looking forward to the source and the video.

@LekkyDev, I will upload the video at 7pm tonight. Look forward to hearing comments from you.

@@SoftwareNuggets Wow thanks in advance. Its past 9pm already central euro time. Still waiting.

I reschedule for 6pm.

Thanks

NO. uniqueIdentifier does not have such a function. However, CREATE TABLE UParent ( ParentID UNIQUEIDENTIFIER PRIMARY KEY, ParentName VARCHAR(100) ); -- Create the child table CREATE TABLE UChild ( ChildID UNIQUEIDENTIFIER PRIMARY KEY, ChildName VARCHAR(100), ParentID UNIQUEIDENTIFIER, FOREIGN KEY (ParentID) REFERENCES UParent(ParentID) ); DECLARE @ParentID UNIQUEIDENTIFIER = NEWID(); -- Insert into UParent INSERT INTO UParent (ParentID, ParentName) VALUES (@ParentID, 'Parent Name'); -- Insert multiple children for this parent INSERT INTO UChild (ChildID, ChildName, ParentID) VALUES (NEWID(), 'Child 1', @ParentID), (NEWID(), 'Child 2', @ParentID), (NEWID(), 'Child 3', @ParentID); -- Optionally, you can select the inserted data to verify SELECT * FROM UParent WHERE ParentID = @ParentID; SELECT * FROM UChild WHERE ParentID = @ParentID;

Thanks Mr Harrison, appreciate the "love"

Much appreciated

Appreciate the message

Much appreciated.

Which solution helped you?

@@SoftwareNuggets including function procedure under $$ for creating function

much appreciated

Adding unit test.mock for this app now. I’ll let you know when that is complete.

Hey @WilsonMar1, I created a unit test for: tic_tac_toe_pro.py Please download three files from my github account github.com/softwareNuggets/Python_TKInter_Tic_Tac_Toe 1) tic_tac_toe_pro.py 2) test_tictactoe.py 3) test.bat Please give me back some feedback if this "is" or "is not" what you were looking for. Scott

Hey @paulinaocaranza1154, for sure, this is a great utility to be used from your CMD in Windows.

Hey @Ash-ts6bd, much appreciated.

Thanks, I also have 3 playlist full of videos about PostgreSQL. All simple to follow so you can build skills.

Hey @abdulrehmanjaved-rt8jq, Let me start of by showing you a very simple function that uses the INOUT clause: CREATE OR REPLACE FUNCTION update_value(INOUT num_param INT) AS $$ BEGIN num_param := num_param + 10; -- Increase the value by 10 END; $$ LANGUAGE plpgsql; -- NOTICE there is NOT a return clause on that function. --INOUT means, you send a value into that function (the IN) part, and (the out) part is available to the caller Here is how you call: SELECT * FROM update_value(5) AS result; notice the output of the call: num_param equals 15 Your question was, why do we use this. If you want to call a function, and want to set the behavior of a column to be both input and output, then use INOUT. CREATE TABLE IF NOT EXISTS orders ( id SERIAL PRIMARY KEY, total DECIMAL(10, 2) ); CREATE TABLE IF NOT EXISTS order_items ( id SERIAL PRIMARY KEY, order_id INT REFERENCES orders(id), price DECIMAL(10, 2), quantity INT ); -- Insert sample data INSERT INTO orders (id) VALUES (1), (2); INSERT INTO order_items (order_id, price, quantity) VALUES (1, 10.00, 2), (1, 15.50, 1), (2, 5.75, 3), (2, 20.00, 1); DROP FUNCTION calculate_total_cost(integer) CREATE OR REPLACE FUNCTION calculate_total_cost(inout order_id INT, OUT total_cost DECIMAL) AS $$ BEGIN SELECT SUM(price * quantity) INTO total_cost FROM order_items WHERE order_items.order_id = calculate_total_cost.order_id; -- Update the order with the calculated total UPDATE orders SET total = total_cost WHERE id = order_id; END; $$ LANGUAGE plpgsql; SELECT * FROM calculate_total_cost(1); in the function calculate_total_cost, change order_id from INOUT to IN; run this sql statement: SELECT * FROM calculate_total_cost(1); compare the return columns from the first function code, to the "change INOUT to IN" code results. Hope this helps. Scott

@@SoftwareNuggets Thanks for great explaination, appreciated.

Your welcome

Hey @NirojMeshram, much appreciated.

hey @001KW9, please send the JSON you are using. If you have attempted to create a C# class object, you can send that too, however, I can start from scratch if necessary. send to: softwareNugget65@gmail.com

@@SoftwareNuggets sent

I have not received: softwarenugget65@gmail.com

I got it

@@SoftwareNuggets Will send you the received json content tomorrow

are you trying a deserialize a json file into a c# class?

Much appreciated

Hope it was helpful

Hey @user-xo3cr1re8v, I have a RUclips video, in the first 20 second, I show you where to get this database: ruclips.net/video/9aXD69xBvMs/видео.html Just to download: www.postgresqltutorial.com/postgresql-getting-started/postgresql-sample-database/ Hope this help!

Hey @truthseeker9988, a listbox normally displays one "field". You can put two fields together, and make one field debit | Credit { " $0.00 | $13.56" } or you can use a TreeView control. <code> import tkinter as tk from tkinter import ttk def main(): # Create the main application window root = tk.Tk() root.title("Debit and Credit Columns") root.geometry("400x300") # Create the Treeview widget tree = ttk.Treeview(root, columns=("Debit", "Credit"), show='headings') tree.heading("Debit", text="Debit") tree.heading("Credit", text="Credit") tree.pack(fill=tk.BOTH, expand=True) # Insert sample data into the Treeview data = [ ("100.00", "0.00"), ("0.00", "50.00"), ("200.00", "0.00"), ("0.00", "100.00") ] for item in data: tree.insert("", "end", values=item) # Run the main event loop root.mainloop() if __name__ == "__main__": main() </code>

@@SoftwareNuggets How? Is there a video about this?

I have a video about using a Treeview control, this "may" be helpful. ruclips.net/video/cuIjKMPRn0k/видео.html Tell me some more about your problem? 1) where is the data coming from? (a database, json, mongodb)? 2) why do you want to show debit and credit in a list? -- Copy the code I wrote above in a file called: tree.py; then use IDLE or your favorite editor and run that code.

I appreciate the comment! Thanks.

Thank you for watching several videos and leaving comments. Much appreciated.

@@SoftwareNuggets My pleasure!

Hey @DoctorMGL, I agree with you 100%. Great comment. I've also learned over the years that Observable Collections offer convenience for handling dynamic data, its reliance on events can indeed be a performance bottleneck with large datasets.

Hey @hamzas4117, glad to hear this video was very helpful. Thanks for letting me be part of your learning journey.

Hey @jaibhavsar1, try this: where LOWER(your_column) && LOWER("search_value');

I just checked out your channel. (cool track) To muse means to become lost in thought. ruclips.net/video/L70yH6g3P7s/видео.html

Send me a link so I can hear his voice.

Thank you.

Thanks for taking the time to watch and comment on this video. Truly appreciated.

Glad to hear this video was helpful. Appreciate you leaving a comment.

Hey @khizerhayyat549, thanks for the comment, much appreciated.

Glad you enjoyed it. And thanks for posting a comment.

Hey @jahbyke, thanks for comment. I appreciate the motivation to keep going, and thank you for subscribing to the channel.

Thank you. Glad to hear it was helpful.

Thanks a lot @TheGladiator123, appreciate you taking the time to write a comment, and hope this video was helpful.

@@SoftwareNuggets just if you can I would like to see more implementation of This function in solving more complex/ real world problem Also A Question: Can I use This user defined function to create a new column in the table

@@TheGladiator123 watch these video's I created using the function. I think you'll be impressed, and you'll become the master! --deck of cards (great skill to learn) ruclips.net/video/7U129er3MYQ/видео.html --table valued function ruclips.net/video/9aXD69xBvMs/видео.html --insert stored procedure ruclips.net/video/jOyYhwxMGpg/видео.html --cursor in a function ruclips.net/video/o4blx6Ij5S8/видео.html --how to write a scalar function ruclips.net/video/2DtPEXjnxs4/видео.html --return a rowtype ruclips.net/video/hOe3bi_nUYA/видео.html --convert ip address to big int ruclips.net/video/SVlWmjM4sWk/видео.html

@@TheGladiator123 here is a function to allow you to add a column to a table. CREATE OR REPLACE FUNCTION fn_add_column_to_table(table_name VARCHAR, column_name VARCHAR, the_data_type VARCHAR, size INT) RETURNS VARCHAR AS $$ BEGIN IF size IS NOT NULL THEN EXECUTE format('ALTER TABLE %I ADD COLUMN %I %s(%s)', table_name, column_name, the_data_type, size); ELSE EXECUTE format('ALTER TABLE %I ADD COLUMN %I %s', table_name, column_name, the_data_type); END IF; RETURN 'Column added successfully'; END; $$ LANGUAGE plpgsql;

​@@SoftwareNuggets hey king Just Your Opinion I wa trying to implement what I learned From You But got Stucked At This edge Case Where I let The User pass an arraay OF words To a Colum with The Type VARCHAR(225) I still Got errors and I can't change The Column Defination

Great. Let me know how it goes!

hey @sajali1954 I think this video might help you. ruclips.net/video/oGzRHlnhIFw/видео.html if it doesn't answer your question, I have about 30 shorts videos (less than 1 minute each), all about JSON. Here is a link to the playlist about JSON. ruclips.net/p/PLRU_t-SgTrYgEyj0rCpDX30J0ombkf1kO Please let me know is if you found help, or you still need a solution. Scott

Hey @VishalMax-vv2qf, did you get the source from my github account? Is this the SQL statement you need me to explain: select name, occupation, row_number() over(partition by occupation order by occupation asc, [name] asc ) as num from #occupations

Thanks!

Are you asking, other than LANGUAGE plpgsql, what other languages can you use?

Thanks Alberto

Hey @rodf1021, I want to thank you for taking the time to leave a comment. Your input is greatly appreciated.

Can you send me a little part of your xml?

Send to softwareNugget65@gmail.com

Did you watch this video i created? ruclips.net/video/JTZHPPJKinU/видео.html

@@SoftwareNuggets Thank you for the video, I coped with this, if you are interested in what was wrong with my code, I can additionally write to you

Hey Максим, I sent you an email with how to parse the XML you sent me! Hope that example helps. --scott