Posts

Showing posts with the label database

Bank API Data Developer Portal [closed]

Bank API Data Developer Portal [closed] I want to source data from my Capital One bank account as a small project. https://developer.capitalone.com/products/ Questions: Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

I have some data in Firebase and want to retrieve it. Sometimes it can be null. How do I not get an exception for it?

I have some data in Firebase and want to retrieve it. Sometimes it can be null. How do I not get an exception for it? FetchDataMethod private void fetchData() { mDatabaseReference.child("UserData").child(RecieversId).addChildEventListener(new ChildEventListener() { @Override public void onChildAdded(DataSnapshot dataSnapshot, String s) { ImageView Image = (ImageView) findViewById(R.id.imageView); TextView Name = (TextView) findViewById(R.id.name); TextView Status = (TextView) findViewById(R.id.status); TextView Email = (TextView) findViewById(R.id.email); TextView Ph = (TextView) findViewById(R.id.ph); TextView Quote = (TextView) findViewById(R.id.quote); for (DataSnapshot postSnapshot : dataSnapshot.getChildren()) { String image = postSnapshot.child("Image").getValue().toString(); String name = postSnapshot.child("Name")....

How to delay a function returning a value before response from database? [duplicate]

How to delay a function returning a value before response from database? [duplicate] This question already has an answer here: I have a function which modifies a variable as per response from database. function f () { let x = { }; redis.get ("key1").then ( value => x.prop1 = value); redis.get ("key2").then ( value => x.prop2 = value); return x; } This is my code roughly. It is actually in a for loop, using node-redis. I have multiple calls to Redis. I add the data from Redis to a new object and return the object. PROBLEM: function f () is returning an empty object every time I call it. f () How do I wait for all Redis promises to resolve before returning the object? This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question. 1 Answer 1 In your code, you are not waiting f...

In cassandra if i have table per query and i have multiple combinations of filter, do i create a table for each of them?

In cassandra if i have table per query and i have multiple combinations of filter, do i create a table for each of them? I am new to NoSQL and i was trying to get my head around how to model data correctly for an e-commerce site. Amazon has these filters for different type of products, for example if you search for laptops, there are filters like brand, processor, hard disk, graphics card, os and etc. So by what i understand, first the primary key will be partitioned by browse node id (i.e. laptop here), then we can have additional keys as sort key, but the problem is that if there are 6 filters there will be around 64 combinations that can be formed. I can select brand and processor, or maybe brand and graphics card, or maybe processor and graphics card, and this will be exponential with the number of filters, so i assume having a table for each possibility is not feasible. I also doubt that filtering after getting the whole partition data is possible, that would be too slow. So how s...

Electron app with database

Electron app with database I'm creating a web app for ticket reservation. The only problem is the database. I don't want to tell my client to install XAMPP or set a database, etc. Is there any way to package the app with the database? sqlite might be an option – David784 Jun 30 at 23:21 1 Answer 1 SQLite is a good option for a local database that you can ship with your application. It won't require the user to setup or install any extra dependencies. It's certainly not as full featured as a full on server, but it should be good enough for a local desktop app. By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie polic...

Recipe / Bill of Materials MySQL Query

Recipe / Bill of Materials MySQL Query I am writing a Bill of Materials/Recipe App for Minecraft in Node.js, Express, React and MySQL. I have what I think is a good structure for the database with the tables, but I am running into an issue with the Queries I need to run. Here is an example of what I am trying to do with an example output (I know the recipe is not correct MC players). Ingredients Table: RECIPE || INGREDIENT || QTY || TYPE Piston || Redstone || 1 || RM Piston || Iron Ingot || 1 || RM Piston || Wood Planks || 3 || RM Piston || Stone || 4 || RM Sticky Piston || Piston || 2 || CO Sticky Piston || Slimeball || 1 || RM What I want is that when I Query for a Sticky Piston, there is a table returned with all of the required components summed together (on top) and all of the required Raw Materials summed together (below). Example Required Output in Table format or JSON format: INGREDIENT || QTY || TYPE Pis...

Cannot connect to password encrypted MS Access 2016 database using C#

Cannot connect to password encrypted MS Access 2016 database using C# When I try to connect to a MS Access 2016 database, it connects perfectly without password, but when I try to connect to the same database after encrypting it with a password, I get this error: Cannot open the database. It may not be a database that your application recognizes, or the file may be corrupt. I don't know what I should do - my database isn't corrupted, and I have to make it with a password. Is there a way to do it, or am I wrong in something? File extension is .accdb .accdb Screenshots: https://drive.google.com/open?id=1vhp7pID4iQ_zoc6ImWXoJDFQv10qNRRn https://drive.google.com/open?id=18QbuFhDU11YuYS-Pe1jxxIhtLPeff-lC post your connection string here – Sachith Jun 30 at 19:13 @Sachith i don't use connection string i...

Trouble with BCNF decomposition

Trouble with BCNF decomposition I have an exam soon and was wondering if you guys could help me with a concept im having trouble with, mainly how to figure out the candidate keys when dealing with BCNF decomposition. In this example linked below the second column for the decomposition tree the candidate keys are underlined I was wondering how would you determine if the candidate key that needs to be underlined is either A or E? Also not included in the picture is C.K, which for the entire relation are { E, AB, BC} Image in Question Hi. Use text for text, don't use links or images. Google 'stackexchange homework' & show your work following your textbook & explain how you are stuck. Now you are asking us to rewrite your textbook. – philipxy 5 hours ago By ...

Copying specific tables of a MySQL database to a MariaDB database in JDBC

Copying specific tables of a MySQL database to a MariaDB database in JDBC I am trying to create a Java programm that copies specific tables from a MySQL database on one server to a MariaDB on another. I know there is mysqldump but the purpose of the program is to be running on different machines, even if they don't habe mysql installed. What I created seems to work well, as the resulting SQL does look correct and executes for example when I connect to the MariaDB with HeidiSQL. But when I execute the sql using .executeQuery , I get an error as response that there is a problem with my SQL. .executeQuery The code is basically: import java.sql.* public class JdbcTest { Connection conn = null; Connection conn_2 = null; Statement stmt = null; Statement stmt_2 = null; //MySQL Class.forName("com.mysql.cj.jdbc.Driver"); //MariaDB Class.forName("org.mariadb.jdbc.Driver"); System.o...

How can I share access 2013 database between users to fill a form without other accesses? [on hold]

How can I share access 2013 database between users to fill a form without other accesses? [on hold] I am a new in access 2013. I have a database with a simple form to add data to it. I want to share my form between some users to add data to it in local. I mean I want users just can fill my form without accessing other parts of program and data that they entered in my form save in my database just like a form in a site. If it is possible, how can I do it? Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question. Welcome to Stack Overflow! This is a site where programmers write their own code and share issues with a specific problem after trying to solve it on their own. If, after doing more research , y...

[PDO]collect data from database

[PDO]collect data from database I was follow this Guide to collect Questions from database after I reach the last question it keep repeat the same last question instead of displaying massage here is my code //////// Collected from databse /////// $question_id=$question_id+1; $no_questions = $dbo->query("select count(question) from questions left join servey_question on questions.question_id = servey_question.question_id where servey_id = 'serv01' ")->fetchColumn(); if($question_id > $no_questions){ $next='F'; // Flag is set to display thank you message }else{ $next='T'; // Flag is set to display next question $count=$dbo->prepare("select * from questions where question_id=$question_id"); if($count->execute()){ $row = $count->fetch(PDO::FETCH_OBJ); } } $main= array("data"=>array("q1"=>"$row->question","opt1"=>"$row->opt1","opt...